Hello All, Currently we are having a client who has been using Navision since 1999.Unfortunately inventory is totaly messed up.Only quantity part is ok, G/L is really in disarray.AUTOMATIC COST POSTING was on for some time and off for some time during the course of time.This people never ever ran the batch job “Adjust Cost- item entries”.'Cause of this Inventory related Accounts show figures in Billions(negative).Now when we try to run it now it runs for 9-10 days…and closes down giving all sortof possible errors.Now we have to come conclusion that we’ll scrap all previous entries and start using this batch job a fresh.For this to take place my plan of action is to Change all Item -Application entries till today so that they wont be considered in batch job. i.e. change field “Output Is Adjusted”.For Account we are planning to make sort of Opening entries adjustment.What do you think , whether it will work or not? Plase give me some advise.Databse size is 48Gb. Thank in advance. Regards, Rajesh
I wouldn’t do this unless you have signed documents from your customer and know exactly what you are doing…There are some major issues doing this. The best bet is to get this job to run. Can you set filters and run it in chunks? FYI Automatic Cost Posting does not have anything to do with this. It will effect the Post Inventory Cost to G/L job rather than the adjust cost job.
Hi, This seems to be an interesting case. Rajesh, Can you run the post cost to G/L in batches ( 20-25 items at a time- Mainly A class ones?) Also, Try to do this on a back up database. Regards, DD
One question… Does the customer deal with decimal quantities?
Thanks for all replies. Customer is agreed , he just want to start using it fresh if previous entries are causing problem. Yes our customer do have quantities in decimal. Ideally , when u make automatic cost posting on, there shld not be any need of running Post Cost to G/l batch Job, which is also happening i.e. a soon as consuption is made G/L is getting affected but when U do output G/L is not getting affected.Its only get affected when u run adjust Item - Cost entries. Regards, Rajesh
You are correct that Invoicing Entries (G/L Entries) are not automatically created for Output entries. If you use the Expected Cost Posting (Version 3+), you will get the estimate posted to the G/L until the Actual cost is determined.
Check out those items with billion dollar inventory values. I ran into the same problem where the quantity is displayed as 0, however, the value was in the zillions… The problem was that the quantity was not actually 0, but 0.0000000001. Navision only displays 5 decimal places by default. So if the unit cost was $13.00 / 0.0xxxxx well… you get the idea…