Automated SFTP Directory Polling
Initiates every 10 minutes, scanning the FTP/SFTP directory for newly arrived UN/EDIFACT ORDERS files from trading partners.
About this template
Automate UN/EDIFACT B2B Order Ingestion into SAP Business One with AI Discrepancy Detection and CONTRL Responses
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.
Initiates every 10 minutes, scanning the FTP/SFTP directory for newly arrived UN/EDIFACT ORDERS files from trading partners.
Screens directory contents to isolate valid EDI files, ignoring subdirectories and passing only raw transaction data forward for processing.
Downloads the EDI file and converts it to Base64 format for secure cross-cloud processing.
Decodes the inbound payload through EDI integration automation, extracting PO numbers, SAP customer IDs, material codes, quantities, and prices into structured JSON.
Submits parsed order data to SAP Business One as a test quotation to verify customer status, pricing, and item configurations - without creating a permanent ledger entry.
Cross-references the UN/EDIFACT file against the SAP quotation to confirm all line items, stock codes, and prices align exactly.
Verified orders are promoted to a SAP Sales Order; discrepancies route to AI-generated exception handling.
OpenAI builds an 'Accepted' or 'Rejected' UN/EDIFACT CONTRL response with precise error mapping for failures.
Acknowledgements are uploaded to the partner's FTP/SFTP into /Accepted/ or /Rejected/ folders, closing the compliance loop.
Rejected orders trigger an immediate Teams notification with buyer ID, failing PO number, and the exact item code causing the error.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.