Autoconfirm the load status from Open to Shipped

(2) Share

Report

Posted on by RG_070889

146

Hi,

We have business scenario, PO created Manually with 3PL warehosue and Load will be created manually with open status, we need to send all open loads having confirmed receipt dates updated on PO. Based on confirmed receipt date should pick all the loads from Today date to next than 7 days i.e., 18-JUN to 24-JUN, change the load status to 'Shipped 'from 'Open'. This will be a triiger point to send the information 3PL to make the receiving process at 3PL warehouse (Customization). After receiving process done in 3PL will receive a inbound file from 3PL with all received information related to PO's, in FO will make PO registration and product receipt through customization will create auto registration and product receipt.

So requirement is to make load auto confirm the inbound shipment based on confimred receipt date, load status changes from Open to Shipped. It is possible to achieve this in FO?

Note: No warehouse app is used and no work created for this process.

Looking forward for answers at the earliest.

Thanks in Advance!!

Thanks

Categories:

Dynamics 365 Supply Chain Management

I have the same question (0)

All responses (5)

Answers (1)

Laurens vd Tang 4,018 Super User 2025 Season 2 on at

Like (0)

Report

Good day RK,

Do you mean that the load status should automatically change to "Received" when the confirmed receipt date is equal to today's date?

Best regards,
Laurens van der Tang

Was this reply helpful? Yes No
RG_070889 146 on at

Like (0)

Report

No, Actually our requirement is to pick all open loads based on confirmed receipt date mentioned on PO from Today to next 7 days on the date i.e., T+7 days should change the load status to 'Shipped'. So need a batch job to run this process in standard FO is it possible or not looking for answers on this.

Was this reply helpful? Yes No
Verified answer

Laurens vd Tang 4,018 Super User 2025 Season 2 on at

Like (1)

Report

Good day RK,

My advice is to try it with the batch 'Receiving completed'

Via the filter you can make a join to the purchase order lines and configure a query that validates the confirmed receipt date for the upcoming 7 days and the load status open

The link for more advanced query options: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options

Best regagrds,

Laurens van der Tang

Was this reply helpful? Yes No
RG_070889 146 on at

Like (1)

Report

Hi Laurens van der Tang,

Thank you for the reposnes!!

But i can't see this form in FO, can u tell me which version are you using? I am using 10.0.42 version.

Thanks,

RK

Was this reply helpful? Yes No
Suggested answer

RG_070889 146 on at

Like (1)

Report

Hi Laurens van der Tang,

I have done it through this batch job used for confirm shipment with your answer mentioned so useful and helped a lot to avoid customization. Below is the criteria used for batch job to auto confirm the load from 'Open' to 'Shipped' .

Thank you so much for quick responses!!

Was this reply helpful? Yes No