Small and medium business | Business Central, N...

Cost Adjm item entries taking to long

(0) Share

Report

Posted on by DareDeil

There are a lot of posts and questions asked about Cost adjm item entries but could not find something that may by helpful for my case scenario.

The business on the manufacture and direct sales industry so logically the operation are almost 24/7 and there is no time avaliable to run the cost adjm there are only 6h on weeknd and dayli 2h when they change the shifts.

Do any of you have any expreeicne with this type of bussnes and any tips to make it faster?

Version: Version W1 13.1

SQL: Standard 2016

Costing Method: AVG

Avg cost type: Item

Avg cost peroid: Week

Automatic Cost Adj: Never

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

Many years ago I was in the same environment. We had 3 options:

1) Turn on Automatic Cost Adj which increased the posting time and slow the system down.

2) Switch to daily period which cause faster run in each run.

3) Run it through Job Queue and schedule it to run on downtime. We had 5 hours maintenance time on weekend and we schedule Job Queue to run it during that time. Does job cost takes longer than 2 hours? I mean can you schedule it to run between shift?

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

I agree with MahGah about running the adjust cost in a job queue. The more often you run adjust cost the quicker it runs. If you can run in your 2 hour shift change daily that would be best. Month-end may present the biggest issue because you need to run adjust cost before accounting begins inventory reconciliation. If you are still closing production runs several days into the new month, adjust cost must be run with date ranges that allows updating costs into the previous month. Best Practice is to close your production orders on the last dayof the month or early on the first day of the new month. Inventory to GL Reconciliation should happen the first day of the month even though accounting will state that not all the vendor invoices are processed. With expected cost posting turned on, reconciliation can happen without all vendor invoices posted.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

In addition to what others are saying here i would also recommend you to upgrade your solution to a newer version. There are done quite some improvement on the cost adjustment procedures in later versions.

There can be so many reasons for the cost adjustment running slow. Everything from missing indexes to insufficient hardware on your sql server can have a sever effect. Have you done any performance analysis together with your partner?

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi

A related note.

We were on version 19.0 and I did some performance benchmarking on posting of single line Sales Order.

A batch of 50 posted between 4mins and 6mins.

This was with Automatic Cost Adjustment turned on.

Once I turned that off, the same batch posted in less than 30secs.

Was this reply helpful? Yes No
Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I don't think around 5 seconds for posting one order including cost adjustment is that bad. When you turn it off you still have to post the cost adjustment at a later stage so the big question is if you save any posting time with turning auto. cost adj. off.

And if you do background posting then the posting time will not really affect the user who initiates the posting.

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

NorthW suggestion for background posting with Automatic Cost Adjust might be a good option to test. I'm not a fan of turning off Automatic Cost Adjust as I feel this just makes the Adjust Cost Routine run longer.

Was this reply helpful? Yes No
Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I totally agree with Kim Dallefeld . Turning off the automatic cost adjustment is always the last option on my list.

Was this reply helpful? Yes No
DareDeil 5 on at

Like (0)

Report

Thank you for your reply Kim & MahGah.

The most important thing I still forgot to mention in my question for 2 of our competent(raw material for production) we do Purchase Receipt during the month (20-40) purchase receipt per month and only one first day of the month we have an invoice thats' includes all te receipts.

Only at the end of the month, we know the real cost of a raw material because the direct cost will be defined based on the results of some chemical components.

Even we do daily do not have sense.

What is terrifying me I'm testing an item which we produce with 40-50 transitions and it's going around +9h to finish. During the ACIE itstart over and over again. (it's not on loop i tested with some items with less trx it's finishes)

Inge M. Bruvik (NorthW) there are done some performance testing on SQL and Win part ant it's look there is nothing suspicious, also while there is an item be bought and sell with around 90K TRX and ACIE it's done on ~10min

Was this reply helpful? Yes No
Linda Hart 5 on at

Like (0)

Report

I'm going to suggest a slightly different track...have you tried performance tuning the SQL DB.

I would analyze the plan cache's query plan for that query and see if there is anything you can do to optimize it. How are your statistics - when was the last time you updated indexes and statistics? Check out the execution plan and see if there are a lot of key lookups or inefficient table scans. If you have a dedicated DBA talk to him/her and ask them to take a look at that query - if not, read up on performance tuning and see if you can tackle it from that side. One bad cached plan can SEVERLY affect a query...

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

Any way to work with your vendor and get weekly invoices? This might also help.

Was this reply helpful? Yes No