/
Upload BOM

Upload BOM

Owned by l (Unlicensed)
Last updated: 2016-Oct-13 by Jessie Ju (Unlicensed)

Menu Path: Inventory > Bill of Materials > Upload BOM

  1. Save in .csv file 
    M.Excel : CSV (Comma Delimited)

    Open Office: CSV file filter settings:
    1) Field Delimiter: |
    2) Text Qualifier: blank
    (Use the | character to separate columns).
  2. Go to Inventory > Bill of Materials > Upload BOM > Select files... > Upload the worksheet in CSV format
    Delimiter : Other , fill in: |
    Text Qualifier: ''
  3. 'Submit'


Definition
NoField NameData Type
1CHILD_ITEM_CODEString with Maximum (50) Characters

Compulsory.

  • Child item usually is attached with the Parent item. Example, iPhone 6 plus is the parent item, charger/cover/screen-protector is the child item.
2PARENT_DISPLAY_LOGICString with Maximum (20) Characters

Compulsory, DISPLAY_PARENT / DISPLAY_CHILD_ONLY / DETAILS/ PACKING/ CONVERSION/ COMPONENT

  • If Display Option is DISPLAY_PARENT and Pricing Logic is PARENT_ITEM_PRICING_SCHEME then individual item price will not display below
3PARENT_ITEM_CODEString with Maximum (50) Characters

Compulsory

  • Parent Item use to attach together with the child item. Example, iPhone 6 plus is the parent item, charger/cover/screen-protector is the child item.
4PRICING_LOGICString with Maximum (100) CharactersCompulsory, CHILD_ITEM_TOTAL/ PARENT_ITEM_PRICING_SCHEME
5CHILD_DISPLAY_LOGICString with Maximum (100) Characters

RPL_TXT/ DISPLAY_ROW/ HIDE_ROW

  • RPL = REPLACE TEXT, mean that this text will replace the item name when create invoice. Example : Christmas Promotion Package
6PACKING1_NAMEString with Maximum (20) CharactersPacking Name 1
7PACKING1_RATIOFloating Point NumberVolume/Quantity Ratio 1
8PACKING2_NAMEString with Maximum (20) CharactersPacking Name 2
9PACKING2_RATIOFloating Point NumberVolume/Quantity Ratio 2
10PACKING3_NAMEString with Maximum (20) CharactersPacking Name 3
11PACKING3_RATIOFloating Point NumberVolume/Quantity Ratio 3
12PACKING4_NAMEString with Maximum (20) CharactersPacking Name 4
13PACKING4_RATIOFloating Point NumberVolume/Quantity Ratio 4
14PRICE_DISC1Floating Point NumberDiscount Price 1
15PRICE_DISC2Floating Point NumberDiscount Price 2
16PRICE_DISC3Floating Point NumberDiscount Price 3
17PRICE_LISTFloating Point NumberList Price (Retail Price)
18PRICE_MINFloating Point NumberMinimum Selling Price
19PRICE_SALEFloating Point NumberSales/Wholesale/Dealer Price
20REMARKSTextRemarks. For example : Christmas Promotion Item.

Private & Confidential