The system is unable to provide a batch job that is capable of updating all Registered PO line transactions to Received without going through all historical POs that are invoiced, inevitably degrading the performance of the job with time and without excluding the Approved POs, making all of them automatically Confirmed (“Update product receipt” seems to do it with all POs it updates). To be able to filter on "Purchase order status" and "Approval status", table “Inventory transactions” needs to be joined to the query, this leads to the job being unable to process mixed LP received lines (with exceptions).
I hope you see the issue: If receiving in a certain way you either do not have a way to automate the update or the performance will degrade over time and the job will automatically confirm Approved POs.
The specific idea is to make "Update product receipt" work for PO lines that are registered using "Mixed license plates receiving" even when "Inventory transactions" is in query scope. LCS issues about it for reference: 456559, 523686, 768657.
The overall idea is to have a batch job that is capable of updating all Registered PO line transactions to Received and of having good filtering options for which POs to include. Maybe even easier to enhance the classic "Posting product receipt" to be able to automatically use e.g. PO number + current date and time as "Product receipt" number instead of changing this already complicated job, which uses inbound "Load ID" as "Product receipt".
Administrator on 2/5/2024 1:51:10 PM
Thank you for your feedback. We released this feature as part of the functionality in Automatically update documents when receiving purchase orders.
Please refer to the following link for more information:
https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave2/finance-supply-chain/dynamics365-supply-chain-management/automatically-update-documents-when-receiving-purchase-orders
Sincerely,
Per Lynnerup
PM, Microsoft