Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Matt Kress]

Hello all. 

When I am manually running the Adjust Cost – Item Entries function, Posting Inventory to GL, or simply running an inventory report, my AR team is unable to post invoices to NAV 2015.

Any ideas on what might be causing this?

Thanks all.

——————————
Matt Kress
Controller, Rupp Seeds Inc.
Wauseon OH
——————————

[Aaron Brown]

Hi, Matt,

As a workaround to that and other problems, we perform the adjust cost item entry (ACIE) procedure while everyone is locked out for month-end. 

Another option is to enable automatic cost posting, eliminating the need to perform ACIE manually in a batch.  See:  link

However, this option won’t work if you have negative inventory.  

Good luck!
Aaron

——————————
Aaron Brown
Director of Finance
Oregon Ice Cream
Camas WA
——————————
——————————————-

[Franz Kalchmair]

best you run that at weekend.

——————————
Franz Kalchmair
Microsoft MVP
Senior Consultant
Vienna, Austria, Europe
——————————
——————————————-

[Ted Johnston]

Adjust cost and post cost will definitely lock out users as both these processes create entries in the system.

A normal report that just reads and reports on data should not lock out users. If it does, and you don’t expect it to update data, you should look into that individual report to see why it locks the tables. (Is it really locking tables or is it just putting such a demand on the system that it slows everything down and now users are seeing extended locks from other users, not from you?)

?Depending on your hours of operation, you may be able to run adjust cost and post cost after hours. We are on an old version of NAV and have normal retail business hours so I have the option to run those processes overnight. Using Automatic Cost Posting extends the duration of every inventory posting causing many more locking issues, so we opt to not use this, but run the batch processes overnight.

——————————
Ted Johnston
IT Director
Streicher’s
Minneapolis MN
——————————
——————————————-

[Meenakshi Singh]

HI Matt,
 we deal with issue almost on daily basis where adjust cost locks down the system for any postings even when we run it for a selected batch of items. We run our adjust cost on the weekends for all items. We used to be able to run it every night at 3am but with 5am production run, I can’t do that anymore as it locks NAV down for production. 

So, the solution is to run it during off hours when everyone is out, you can schedule it using job queue to run it at odd hours. We run it over the weekend and then case by case basis during weekdays as needed.

Hope it helps!
Meenakshi

——————————
Meenakshi Singh
Manager of Business Applications
Home Market Foods, Inc.
Norwood MA
——————————
——————————————-