Posting inventory balance in item journal FIFO

(0) Share

Report

Posted on by Navanalys

Hi!

We have just changed ERP system to NAV 2016 and we are now going to import inventory balance throught the Item journal. We are using FIFO on our Items but I am not sure if the value (cost) of the item should be filled in the collumn "Unit amount" or "Unit cost"? and what is the difference?

If i have posted in the wrong field, can I correct it?

Thank you for your help

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

azelaya59 2,807 on at

Like (2)

Report

Lauren

If you are using the "Item Journal" to import the inventory, the "Unit Amount" and "Unit Cost" are tied to each other. They actually affect different portions of the Item card.

The "Unit Amount" will over-write the "Last Direct Unit Cost" if you pick an entry type of "Purchase". If you pick an entry type of "Positive Adjustment", only the "Unit Cost" will be used. Though both fields will have the same value.

Since this is the initial inventory upload, it doesn't matter which field you picked. They will both populate with the same value. I suggest using the "RapidStart" - "Configuration Package" functionality to make things easier.

Good Luck!

Was this reply helpful? Yes No
Navanalys 82 on at

Like (0)

Report

Thanks a lot Alfredo!!

Was this reply helpful? Yes No