Importing an Item Adjustment to Adjust Inventory to Zero
Big Business includes the ability to import Item Adjustment transactions. Using this feature it is easy to zero you entire inventory (or a selection of Items) then repopulate the inventory with another import. (5570)
To Import an Item Adjustment which Adjusts Inventory to Zero:
1. On the Maintenance toolbar, select the Import tool.
2. Select your tab-delimited text Import File.
3. Map the first target field, Item Code.
4. If you have a header row in your import file, click the, "Don't Import Header" option.
5. Click the OK button to begin processing.
This technique leaves Adjust, New Quantity, and Unit Cost without mapped entries. Big Business calculates the New Quantity to be zero (0) and fills in the Adjust to zero the Qty On Hand. For Unit Cost, the current Average Cost is used.
When the import is finished processing, you should have a complete Item Adjustment which can be edited and Saved.
Related: