Cost Adjustment Loading Time

(0) Share

Report

Posted on by LXT

Hi all,

I have a client that we have migrated from NAV to BC with all the historical data. They did not use inventory or the manufacturing module in NAV and would like to use it in BC.

The issue I am facing now is that it took 36 hours to load their inventory opening balance as I had to zerorise their stock on hand since they weren't using inventory and had a lot of negative quantities, to then bring in the inventory opening balance. However, whenever we post an SO it takes a very long time for it to load. It took me 7 hours to post 6 SO.

I suspect this issue is caused by the cost adjustment as when it loads it kept showing cost adjustment. Is this because they had negative inventory on hand and cost adjustment could not be performed? So now that I am bringing in all the inventory it's adjusting all my historical transactions? If that's the case are there any methods to fix this as 7 hours submitting 6 SO is too long. They have approximately 100 SOs a day.

Best Regards,

XT.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

XT,

Wow this is painful. I would recommend taking the PROD and creating a Sandbox and ask your programmer to debug the issue. Normal posting of a Sales Order should not take anytime. Have you run Adjust Cost/Item Entries? You can also turn off the Automatic Cost Posting and run this as a Job Queue nightly so it runs and posts.

Thanks,

Steve

Was this reply helpful? Yes No
LXT 30 on at

Like (0)

Report

Hi Steve,

Thank you!

Was this reply helpful? Yes No