Detect the released order
appse ai picks up a sales order released to the 3PL warehouse in Business Central and filters it.
Send EDI 940 warehouse shipping orders from Dynamics 365 Business Central to a 3PL over SFTP and post sales shipments from returned EDI 945 files, with Microsoft Teams alerts for short shipments
Apps used in this template
About this template
Teams working with a 3PL re-key shipping orders and confirmations, which delays invoicing and hides short shipments. This template sends an EDI 940 from Dynamics 365 Business Central to the 3PL SFTP folder when an order is released, then reads the returned EDI 945 files on a schedule and posts the sales shipment, adjusting quantities and alerting in Microsoft Teams on short shipments.
Key benefits
Inside the flow
An outbound flow starts when a sales order is released to the 3PL and uploads an EDI 940 by SFTP. An inbound flow checks the 3PL folder on a schedule, parses each EDI 945, compares it to the order and posts the full or adjusted shipment.
appse ai picks up a sales order released to the 3PL warehouse in Business Central and filters it.
OpenAI structures the pick details, the payload is converted to an EDI 940 and uploaded to the 3PL SFTP directory.
On a schedule, the flow fetches and downloads new EDI files from the 3PL folder.
Each EDI 945 is parsed and shipped quantities are checked against the sales order.
Full matches post a sales shipment. Short shipments post with adjusted quantities.
The inventory manager and sales team get a Microsoft Teams message about the gap.
Keep ERP shipments in step with what the 3PL actually sent
01
Shipments post as soon as the 945 arrives, so billing can start sooner.
02
Shipments are posted from confirmed 3PL quantities, not planned ones.
03
Short shipments reach the inventory manager the same day.
04
Business Central reflects what left the 3PL warehouse.
01
Shipments post as soon as the 945 arrives, so billing can start sooner.
02
Shipments are posted from confirmed 3PL quantities, not planned ones.
03
Short shipments reach the inventory manager the same day.
04
Business Central reflects what left the 3PL warehouse.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Every trigger and action this template uses is available in the appse ai builder, so the same flow can be rebuilt with your own routing, thresholds and destinations.
Questions & answers
Everything you need to know about this template before you deploy it.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.