Questions and Answers
Q: This knowledgebase article explains about the Bill of Material (BOM) Import Format for Comma Separated Value (CSV).
A: The Product Entry module allows the importation of Bills of Materials (BOMs) from external sources. One of these is the CSV (Comma Separated Value). Currently the documentation describing this import format is incomplete. The proper format is listed as follows:
bomno C(15)
lineno C(06)
bqtyusd C(10)
item C(15)
Example of the test data as listed below:
TEST06, 10, 5, RAW_1
TEST06, 20, 6, RAW_2
TEST06, 30, 2, RAW_3
TEST06, 40, 11, RAW_A
The following are required for this format to function correctly.
- The location of the file must be known. Please note that this location must be typed, so a simpler location is a better one.
- The file name can be anything, but the option grid defaults to an extension of .CSV
- In the above format the item should be a pre-existing ITEM in Inventory Control, as well as the bomno if it is desired to enter the assembly onto an order.
© Copyright Sage Software
