Continuous Shipment Tracking Scan
Monitors the designated FTP/SFTP directory every minute for newly uploaded EDI 214 shipment status files from logistics carriers.
About this template
Automate EDI 214 Shipment Status Tracking into SAP Business One with Real-Time Teams Exception Alerts
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 module in this template is fully customisable. Add triggers, swap actions, or extend the logic using appse ai's no-code visual builder.
No triggers for Ftp-Sftp.
Inside the flow
appse ai runs this workflow end to end for Ftp-Sftp — automatically, every single day. Here is exactly what happens when this template runs.
Monitors the designated FTP/SFTP directory every minute for newly uploaded EDI 214 shipment status files from logistics carriers.
Automatically downloads the raw EDI 214 payload for immediate processing upon detection.
Extracts carrier tracking numbers (PRO), purchase order references, current location data, transit timestamps, and delivery or status codes from the file.
Queries SAP Business One using the purchase order reference to locate the exact internal sales order linked to the carrier update.
A conditional decision node checks the parsed payload for critical transit disruptions - weather delays, carrier exceptions, or transit damage - and routes accordingly.
If a transit exception is detected, an immediate notification is sent to the dedicated Microsoft Teams channel with full exception details for proactive customer management.
Normal shipments have their PRO numbers, status codes, location data, and delivery confirmation flags written directly into SAP Business One sales order records.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.