Stock Rounding

atesas

We have a problem with the Navision Inventory. If you sell all the goods on your stock there is still a value for this item.
The customer has FIFO installed. Even if you do all the Batch jobs there is no change to remove the value or set it to zero which is supposed to be the correct value.

Pls. help

Thanks

Alexander Tesas

John_Tegelaar

Did you run the "Adjust Cost - Item entries" batch from General Ledger, Periodic Activities? This batch should balance out differences in cost-price.

John

atesas

Yes we did all that periodic stuff. But the Article has still a value on stock

John_Tegelaar

Did you do Navigate and drilldown on the item to get the overview of Item Ledger Entries? This should give you insight on which entry isn't balanced. Then you should make a journal entry to correct the value.

John

atesas

Is there no other possibility? This affects 10.000 articles!
I do not understand, why the item still has a value on stock.

John_Tegelaar

Did you trace back *why* the items have a left over value? Is it a signficant amount? Can it be rounding differences only? Has somebody changed code (the posting routines?) perhaps? Something must have been done off standard, otherwise there would not be a remainder amount.

John

atesas

I suggested the same!
The problem is the rounding differences (not only but mostly).
But I found no possibility to adjust the rounding correctly.
The chief accountant changed the posting groups one time without asking for the consequences. But that only affects the General Ledger not the Item Granule.

John_Tegelaar

Well, if it concerns a few cents rounding differences per item only, I would suggest for now to make a one-time batch report that takes the remainder amount and then creates an item-journal line to balance it off against the "rounding differences G/L acount".

To prevent future troubles, you will have to analyze the methods of posting used by the customer and get the real cause of the differences to surface.

John