Question

Slowness in closing Shop Orders with Weighted Average

  • 3 July 2021
  • 3 replies
  • 181 views

Userlevel 1
Badge +1

Hi,

A customer having standard costing changed over to Weighted Average and now shop order closing is having a slowness. Is there a patch or anything for this performance issue? Kindly advise.

The below error is coming when trying to close

“"The update could not be performed since the Shop Order record is currently locked. Please retry operation."

 

 


This topic has been closed for comments

3 replies

Userlevel 7
Badge +20

Hi @XitUdeshJ ,

This type of error occurs when two transactions are simultaneously trying to access the same record, in this case the shop order header.That’s where quantities and status are maintained, likely the data trying to be updated.

User will need to re-submit after a few seconds unless there locked sessions in database, which needs to be cleared.

Userlevel 4
Badge +7

Hi @XitUdeshJ ,

 

Once you change Inventory valuation method from Standard cost to weighted average and try to close a shop order, all the closed shop orders are been reopened and closed by the system automatically. Hence, a slowness can occur. There is no any known APP10 patch. Anyway, let me know your UPD level (I’ll further check).

However, the error message that occurred is due to a different shop order close process. it seems multiple shop orders are been tried to close.

If you have a huge set of shop orders with the same part number, single shop order closing can take minutes.

As @Xavier Fernando mentioned please wait for some time and try to close.

if you get same error after hours, please send a case/ticket to IFS Support.

 

Thanks,

Jagath  

Userlevel 5
Badge +8

Hi @XitUdeshJ,

While agreeing to both @Xavier Fernando and @Jagath Dharmakeethi, you may use the screen, “Transaction Revaluation Events” screen and search using the field, ‘Triggered by Shop Order’ to get an idea bout the number of transactions updated when the shop order was closed. If the number is high, the you should expect more time to complete the job.


There will be a background job for this and using the BJ, you can track the affected shop orders as well. 

 

regards,

/Vibhu