We are using AX 2012 R3 CU9. We have a requirement to perform product receipt of Purchase Orders in a batch job. When we set the batch job, it runs the first time & generates product receipt, but it never picks up new orders to generate product receipt.
For sales order invoice, we have an option of late selection, which resolves this issue. It allows to select orders based on criteria at run time. But we couldn’t find such option for Product Receipt.
Is there a way to enable late selection for it? Or a way to run product receipt in batch job?
I am pretty sure the answer is no. The product receipt is a reaction to what is happening, so you could have 10 purchase orders due for receipt today and 10 come in, but only 7 of them were due today, one came early and two were backorders. You cannot run this on batch without 100% accurate delivery schedule on date line and quantity. The difference with the sales invoice is you are in control, you are saying everything shipped today will be invoiced on batch tomorrow, so it has a set criteria to look at - the product receipt does not because of the process, you could try and generate this of the registered quantities and using the arrival overview look at the product receipt ready journals, but i dont believe you can do this as standard, you can batch receipt, but on a selection each time where you define the purchase orders you want to receive on batch, not with a late selection to pull the same query tomorrow which is date based.
What are you defining as your criteria for the repeated selection?
Our process is - We create purchase orders, item arrival journal is created for it & posted when the item arrives. This generates a pallet transport, which is completed by warehouse personnel. Once this is completed, product receipt generation is required to change the status of inventory transactions from Registered to Received. Product receipt is just an additional step, which is required to be performed as soon as the pallet transport is completed, as we cannot generate invoice without it. Currently, we are dependent on a user to complete product receipt to generate invoice. But want to automate the process.
Considering this, the selection criteria will be - Update : Registered Quantity, Stopped : no, Status : Open Order.
We are not going to modify the standard code as it might cause unknown issues. We wrote a custom class to pickup relevant PO lines & to generate product receipt for them. Ran it in a batch & it serves the purpose. Thank you [mention:713992e2cc394574827989c4d4af9bbb:e9ed411860ed4f2ba0265705b8793d05] & [mention:d16d1631a7404018a8e6312528e48961:e9ed411860ed4f2ba0265705b8793d05]
yes it will not generate product receipt number for that it will need some more modification , i understood your requirement is to only skip product receipt step by change the status by product receipt .
if you need product receipt number for business need then will suggest go for your custom class as then modifications in standard class will be more lengthy then create new element.
Yes, the primary purpose is to change the status by product receipt. But as journal is created for it, it will not be ideal to leave it without a product receipt number, in case we require to refer to it in future. So I will go with custom code. Thanks for your help Kunal.