Unit of Measure

Malas · 2017-02-02

Hi,

I have an item (Item A) which was setup incorrectly in terms of uom.

ITEMA 1 KG - Base Unit of Measure
ITEMA 1 GR - this is where the problem starts as it was supposed to be 0,001

Sales and purchases have already been posted and obviously the cost is now quite messed up.

Is there a way to fix this, like a reconcile or adjust cost function, or some type of function where I can fix the UOM and run it, which will in turn fix the costs?
If not, could someone kindly advise me on possible solutions?

Thanks all.

vijay_g · 2017-02-02

you can post credit memo for those posted invoices and post undo which are not invoiced. obviously, your inventory is messed up too with cost? again this is not straight forward solution you may have to look into each entry and choose to fix either through credit memo or revaluation journal.

also, it depend on amount of data that is incorrectly posted. after closing all open entries create new UOM with correct qty per.

RockWithNAV · 2017-02-02

Malas,

Check this link, it will help you for sure

http://www.archerpoint.com/blog/Posts/revaluing-inventory-microsoft-dynamics-nav-revaluation-journal

Malas · 2017-02-03

Thank you for your responses.

The problem I have with credit memos is that for some reason, its not reversing the items at the cost it was invoiced out at. I've checked my setups in terms of Exact Cost Reversin etc.

I am looking at the Revaluation as well, never done it before.

Unit of Measure

Comments

Categories