Pick up new 860 files
On a set schedule, the flow lists the FTP/SFTP folder where trading partners drop EDI files and downloads each new file. The business sets the folder path.
About this template
What This Workflow Does
Buyers send EDI 860 change requests to an FTP/SFTP folder, and someone has to read each one and edit the NetSuite sales order before it ships. This template picks up each 860 on a schedule, finds the NetSuite sales order by purchase order reference, applies the change if the order status still allows it, and alerts a Microsoft Teams user when it does not.
Key benefits
- Changes applied before fulfillment — Eligible 860 requests update the NetSuite sales order, so the warehouse works from the current version.
- Status checked first — Orders that have moved past the point of change are left untouched.
- Late changes reach a person — A Microsoft Teams message flags requests that arrive too late to apply.
- No rekeying — Requested changes are applied to the order without retyping the 860.
Inside the flow
How the template works
On each scheduled run, the flow downloads new EDI 860 files from FTP/SFTP and finds the NetSuite sales order by purchase order reference. It updates the order if its status allows the change, or messages a designated Microsoft Teams user if it does not.
Parse the change request
Each EDI 860 is read, and the purchase order reference and requested changes are extracted.
Retrieve the sales order
The flow fetches the matching NetSuite sales order with its line items and address.
Check the order status
The sales order status decides whether the change can still be applied.
Update the sales order
If the order is still eligible, the NetSuite sales order is updated with the buyer's changes.
Alert on late changes
If the order has moved past the point of change, it is left untouched and a Microsoft Teams message goes to a designated user. The business sets the recipient.
Business Benefits
What changes when EDI 860 requests update NetSuite sales orders automatically
01
Change requests acted on, not left in a folder
Scheduled pickup means every 860 is read and processed without someone checking the FTP/SFTP site by hand.
02
Fewer over shipments and refused deliveries
Orders are corrected in NetSuite before fulfillment, so you ship what the buyer now wants instead of absorbing freight and inventory losses on refused goods.
03
In-progress orders protected
The status check stops a late request from overwriting an order that is already moving on the floor.
04
Late changes reach a person in time
A Microsoft Teams alert puts the request in front of your team while there is still a chance to intervene.
05
Order desk capacity that scales with your partners
Growing EDI change volume is handled by the flow, not by adding people to read files and edit orders.
01
Change requests acted on, not left in a folder
Scheduled pickup means every 860 is read and processed without someone checking the FTP/SFTP site by hand.
02
Fewer over shipments and refused deliveries
Orders are corrected in NetSuite before fulfillment, so you ship what the buyer now wants instead of absorbing freight and inventory losses on refused goods.
03
In-progress orders protected
The status check stops a late request from overwriting an order that is already moving on the floor.
04
Late changes reach a person in time
A Microsoft Teams alert puts the request in front of your team while there is still a chance to intervene.
05
Order desk capacity that scales with your partners
Growing EDI change volume is handled by the flow, not by adding people to read files and edit orders.
Keep exploring
More templates for creativity
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Build Your Own Version of This Workflow
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.
No triggers for FTP/SFTP.
Questions & answers
Frequently asked questions
Everything you need to know about this template before you deploy it.
How does EDI 860 to NetSuite sales order update work?
On a schedule, appse ai downloads new EDI 860 files from FTP/SFTP, parses each change request and fetches the matching NetSuite sales order. If the order status allows it, the order is updated; if not, a Microsoft Teams user is alerted.
How is the 860 matched to a NetSuite sales order?
What happens if the order is already being fulfilled?
Can I choose the folder and the Teams recipient?
What needs to be in place before it runs?
Why businesses love appse ai
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Their quick updates and improvements have boosted our productivity, allowing us to focus on making better products. Highly recommend for any manufacturer seeking efficiency.
Hans Engstrom
Operations Manager, Christiana Bikes
appse ai enabled us to automate processes and achieve real-time efficiency with their ready-to-use solution. Their responsive support and customizations were exactly what we needed.
Peter Grueterich
President, Bernardo 1946
Rapidly growing companies, to get to that level of establishment, you need a solution like appse ai to bridge the connections between disparate systems.
Robert Donnelly
CEO and Co-Founder, Nine Line
The platform syncs data between our applications and it simply just works. This saved us a lot of time we used to spend manually synchronizing data from one system to another.
Sankar Thiagasamudram
Founder and CEO
Their quick updates and improvements have boosted our productivity, allowing us to focus on making better products. Highly recommend for any manufacturer seeking efficiency.
Hans Engstrom
Operations Manager, Christiana Bikes
appse ai enabled us to automate processes and achieve real-time efficiency with their ready-to-use solution. Their responsive support and customizations were exactly what we needed.
Peter Grueterich
President, Bernardo 1946
Rapidly growing companies, to get to that level of establishment, you need a solution like appse ai to bridge the connections between disparate systems.
Robert Donnelly
CEO and Co-Founder, Nine Line
The platform syncs data between our applications and it simply just works. This saved us a lot of time we used to spend manually synchronizing data from one system to another.
Sankar Thiagasamudram
Founder and CEO
appse ai helped us to manage our inventory and invoices in SAP and WooCommerce. With appse ai our job is much easy as everything is automated and we have better control on our inventory.
Kaywan Pour
Niagara Warenhandels GmbH
appse ai is making our operations easy! They make the customer experience much better. It costs us less human effort to proceed our orders.
Ramez Tacrity
Technical Sales Specialist, Digitech
I was impressed by how easy appse ai is to use and their ability to customize the platform to meet our clients specific requirements.
Vainick Oliveri
Golden Toys
appse ai transformed our business by automating the sync between SAP Business One and WooCommerce. What used to be a time-consuming, manual process is now seamless. We add products in SAP, and everything syncs automatically to the website.
Maher Ataya
Founder, Italparts SRL & Italparts LLC
appse ai helped us to manage our inventory and invoices in SAP and WooCommerce. With appse ai our job is much easy as everything is automated and we have better control on our inventory.
Kaywan Pour
Niagara Warenhandels GmbH
appse ai is making our operations easy! They make the customer experience much better. It costs us less human effort to proceed our orders.
Ramez Tacrity
Technical Sales Specialist, Digitech
I was impressed by how easy appse ai is to use and their ability to customize the platform to meet our clients specific requirements.
Vainick Oliveri
Golden Toys
appse ai transformed our business by automating the sync between SAP Business One and WooCommerce. What used to be a time-consuming, manual process is now seamless. We add products in SAP, and everything syncs automatically to the website.
Maher Ataya
Founder, Italparts SRL & Italparts LLC
appse ai truly helped us transform our business processes. Now with the integration, it has become really smooth, everything just flows better. It really helped our team save time, streamline processes and honestly boost productivity more than we expected.
Jason Mitchell
MD, All Marine Spares
Since we started using appse ai as our middleware, everything has been way smoother. It saved us about 10-20 hours a week, which is huge. The team is super responsive and easy to work with.
Dan Gerber
CEO, Designer Boys
appse ai truly understood our needs and delivered a seamless integration between SAP and Shopify. Their team is highly knowledgeable and capable, ensuring the solution perfectly aligned with our requirements.
Columb McCluskey
Sales Director, Trimwel
appse ai is fantastic, it works really well and is easy to use! Its visual interface makes it simple to see what is happening, and I especially liked the visual mapping of process flows. The teams professionalism also really impressed me.
Richard Grew
Renegade Brewery
appse ai truly helped us transform our business processes. Now with the integration, it has become really smooth, everything just flows better. It really helped our team save time, streamline processes and honestly boost productivity more than we expected.
Jason Mitchell
MD, All Marine Spares
Since we started using appse ai as our middleware, everything has been way smoother. It saved us about 10-20 hours a week, which is huge. The team is super responsive and easy to work with.
Dan Gerber
CEO, Designer Boys
appse ai truly understood our needs and delivered a seamless integration between SAP and Shopify. Their team is highly knowledgeable and capable, ensuring the solution perfectly aligned with our requirements.
Columb McCluskey
Sales Director, Trimwel
appse ai is fantastic, it works really well and is easy to use! Its visual interface makes it simple to see what is happening, and I especially liked the visual mapping of process flows. The teams professionalism also really impressed me.
Richard Grew
Renegade Brewery
Deploy this workflow in minutes
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.
SOC 2
SAP Certified Partner
ISO/IEC 27001
GDPR