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

[Lori McElroy]

We recently had to turn off our automatic cost posting for one day and was instructed to run the Post Inventory Cost to GL for that specific day. This seemed to have work, however, we also ran it wide open for the month to make sure we weren’t missing anything and found many transactions for days throughout the month that showed up on this report and they all look to be direct costing items.  Is this normal? We do not want to post these entries if they have in fact already been accounted for. We were instructed to run these for only the days we knew we had the automatic cost posting turned off so we are a bit concerned why these other transactions on other days are showing up.  Any help is greatly appreciated!

——————————
Lori McElroy
The Sporn Company
Burlington VT
——————————

[Ian Ray]

I’m not sure I totally understand, but I’ll give this a shot…

What is your setting on Automatic Cost Adjustment? If not “always,” there may be adjustments that need to be made where time elapsed beyond the setting.

Even if “always,” there can be instances where an item is sold before all of the costs are known. For these cases, it is good practice to run “Adjust Cost – Item Entries” and “Post Inventory Cost to G/L.” I would recommend running these reports even if you have automatic cost posting enabled as it can’t hurt. In the case that you didn’t need to, running the report will take <5 seconds. In the case that you do have costs to post, running the report will set your values straight.

I would also recommend looking to “job queues” to run these reports.

https://msdn.microsoft.com/en-us/library/hh879427(v=nav.90).aspx

One pitfall of job queues is it will error out if your posting date is not within the range which will inevitably happen if the people responsible for setting these values are not at work every day. Even  if this posting dates are set again, the job queue will still be in an error state until someone manually sets it to ready. There is a known way to get around this with code as detailed here:

http://www.dynamicsnavconsultant.com/2014/04/restarting-job-queue-hits-error-dynamics-nav-2013/

——————————
Ian Ray
Cypress Grove
Arcata CA
——————————
——————————————-

[Don Saito]

We recommend running Adjust Cost – Item Entries/Posting Inventory Cost to G/L regardless of the Automatic Cost Posting setting.  This will pick up entries that the automatic cost posting does not.  The Adjust Cost – Item Entries process will not create duplicate postings and in fact not running this will lead to incorrect inventory costs regardless of your costing method.  It is vital to run and we recommend running it daily on the job queue.   

The only caution is paying attention to your allow from/to posting dates or inventory periods if you are using them when running this.  Otherwise, you may have entries post into prior periods you do not wish.   This article from Microsoft gives great examples of the posting dates and how they work: 

https://msdn.microsoft.com/en-us/library/dn948192(v=nav.90).aspx

——————————
Don Saito
ERP Efficiency Experts, LLC
West Hills CA
don@erpefficiency.com
http://www.erpefficiency.com
——————————
——————————————-

[Dave Cintron]

If you are on NAV 2013 or earlier and using Manufacturing, automatic cost posting may not pick up costs from Finished Production Orders. You have to run Adjust Costs.

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-