Hi ​@Komaly,

This error is normally happening when the inventory part is configured with Supplier Invoice Consideration = ‘Transaction Based’. If this is the case then, when Supplier Invoice is matched against a receipt, system triggers an invoice revaluation in case the cost of the part is changed. So then,  all transactions made for the part after the receipt that triggers the update will be updated with the actual cost. Which means when an invoice is matched the actual supplier invoice will update all transactions for the part (receipt and onwards). Table Inventory_Part_Unit_Cost is locked in this process, which means that no additional transactions can be done (like Register Direct Delivery) during this process.

You can get more detail regarding this process in Online Documentation, under ‘Cascade Update of Cost on Inventory Transactions” section.

Regards,

Pilar

Hi ​@Pilar Franco,

Thanks for the update. I’ve checked that but unable to find because it is automatic process, where once the intercompany order lines is closed, matching demand order line should also get delivered and closed with issued invoice. As its automatic process, supplier invoice is not related to it. 

I can deliver the order lines manually by going to register direct delivery. I’ve found 3 parts which are common in 6 different sites, also the same issue has happened thrice a week and it’s hampering the work.

Hi ​@Komaly,

If the direct delivery automatic process is run at the same time that a revaluation is being done in corresponding inventory part of receiving site, then you will get this error. This doesn’t mean that the supplier invoice was matched against your purchase order, but with any other for the same part. As said, during this process, the table Inventory_Part_Unit_Cost is locked for this specific part, so then, no new transactions can be generated, like the ones triggered in your automatic process. Then, your incoming delivery notifications are stopped because the automatic process couldn’t be completed as the inventory transaction couldn’t be generated.

Regards,

Pilar

Hi ​@Pilar Franco,

Thanks for the update. I’ve checked the inventory part is configured with Supplier Invoice Consideration = ‘Transaction Based’. Can you please let me know what can per permanent resolution? so that I don’t need to do this manually all the time. 

Hi ​@Komaly ,

That’s a tricky question. If your current setup imposes to trigger a revaluation each time the cost is changed for the part when the supplier invoice is matched, then:

1. First check in the system how long takes this revaluation process and if there are many inventory transactions for a part from the receipt until the invoice matching is done. Perhaps, that’s the reason why the part cost table could be locked for a long time, as many inventory transactions must be modified with the new calculated cost. If that’s the case, then review if invoice matching could be done earlier.
2. Check how many parts are configured with Supplier Invoice Consideration = ‘Transaction Based’, as you may have this problem whenever any matching is done for them (specially, if they are also configured with Inventory Valuation Method = ‘Weighted Average’, so cost calculation is always triggered and updated when matching invoice).
3. Once you know how long it takes the revaluation, try to run the invoice matching for these parts and later revaluation in a different time range of the automated direct delivery process, to avoid it to be stopped due to this error.

I hope this help!

Regards,

Pilar