Once you have imported or created inventory items in Dynamics GP you will need to populate the beginning inventory quantities and costs. The easiest way to accomplish this is to enter or import an inventory adjustment transaction. The following are the fields needed for an inventory adjustment import:
Field |
Notes |
---|---|
Transaction Date |
This should be the date of the physical inventory count or cut off. Dates can be formatted regularly, with slashes, for example: 06/30/2010. |
Item Number |
This must be an Item Number that already exists in Dynamics GP. |
Unit of Measure |
This must be a Unit of Measure that already exists in Dynamics GP and is assigned to the item. |
Site ID |
Site ID must already exist in Dynamics GP. If you are entering items at one site only you can hard code this during the import mapping. |
Quantity |
Quantity in the unit of measure specified. If using decimal places, make sure not to use more decimals than what the item is set up to have. |
... |