Entering Opening Inventory Balances

dburke

Hi,

Anyone suggest the best way to enter Opening Inventory Count? The items are already setup with a Unit Cost in the item table. but if I enter the on hand quantities in the Item Journal as positive adjustments, the cost does not populate, so count gets posted at zero cost which is not correct for valuation.

Any suggestions would be appreciated

Savatage

Are you transfering from a different system to Navision?

We exported our data to a CSV File

Created a dataport to the (Item Journal Line) Table

Where we imported (Item No.) (Quanitity) (Unit Cost).

We named the "Document No" DATALOAD.

Then pen the Item Journal - Checked It Was OK & Posted.

You could always do a small block of items in a test database to see if you get the results you need.

**So Basically the point was - you should enter the costs in the journal - I do not know how many items you have but manually entering them was not an option for us.

RobertMo

In your case you can try to copy "Unit Cost" to "Last Direct Cost" for each Item, because this is actually the field where Item Journal picks the Unit Cost.