1-866-278-6243
How do you Import?
How do you Import?
All Orders 3.X
All Orders 2.X
Inventory Parts and Bills of Materials can be imported into NumberCruncher. When NumberCruncher was installed, two Microsoft Excel spreadsheets (BOM.xls and InventoryItems.xls) were placed in the application folder. By default the application folder is "C:\Program Files\NumberCruncher Work Orders" Inventory Items should be imported before Bills of Materials so the Items are available as Components for the BOMs.
Note: Make a copy of the blank spreadsheet files for later use. This way there will be a record of imported Items.
IMPORTANT! DO NOT CHANGE THE NAMES OF THE FILES, COLUMN HEADINGS, WORKSHEET NAMES OR ANYTHING ELSE IN THE FILE OR IMPORTING WILL NOT WORK!
Before importing Items, ensure that default accounts are entered in Preferences. Also, note the abbreviations used for the Units of Measure. For example, for Items listed as "Each", enter "EA".
The only required field is the FullName field. If no accounts are specified, then the default accounts will be used. All blank numeric data will be changed to 0, and blank UOMs will be set up as "EA" (for "each").
All fields except "Descrip" must be filled in the BOM spreadsheet. If the QtyPer column is 0, that Component will be skipped.
6/2/2003
More questions?
Call to speak with a NumberCruncher Solutions Consultant at:
