openerp-bom — BOM Query

CRITICAL: Read

../openerp-shared/SKILL.md

first before starting (Authentication, exit codes, and output contracts are there).

When to Use

• Check sub-items of a certain BOM (materials used, numerator/denominator of usage, scrap rate, make/buy identifier).
• Check BOM document details.
• As input for cost calculation (materials used × price list).

Commands

openerp bom view --number "<BOM Number>"

--number

"1.30.67.0132 VA0"

openerp bom list --material "<Parent Material Code>"

--material

--top N

bom list

FNumerator

FDenominator

FScrapRate

FErpClsID

Examples

openerp bom view --number "1.30.67.0132 VA0"
openerp bom list --material "1.30.67.0132" --top 100
openerp bom list --material "1.30.67.0132" --format table   # Human-readable table

Fallback: Use General query to Check Any Form

query

# Purchase Price List (Verification anchor: Material 4.50.20.1549 price≈9.318584 / tax-inclusive 10.53 / tax rate 13%)
openerp query --form-id PUR_PriceCategory \
  --fields "FMaterialId.FNumber,FPrice,FTaxPrice,FTaxRate,FDocumentStatus" \
  --filter "FMaterialId.FNumber='4.50.20.1549'" --jq '.data'

Routing Tips

• Material price/purchase price query →

  query --form-id PUR_PriceCategory

  (not a BOM command).
• Authentication/network/parameter errors → Check exit codes and

  hint

  first, run

  openerp doctor

  (see

  openerp-shared

  ).