New orders created
Triggered when a new order is created in the SAP Business One
FinanceEDIFACTCash Application
EDIFACT REMADV Remittance Automation for SAP Business One — European Remittance, Applied Automatically
For trading partners that remit in UN/EDIFACT: appse ai scans your FTP/SFTP directory for REMADV messages, parses the DOC and MOA segments into structured data, matches each line to open invoices in SAP Business One, maps approved adjustments to GL, and posts the cash receipt — escalating only unexplained short-pays.
Apps used in this template
About this template
What this workflow does
European and international trading partners send remittance in UN/EDIFACT REMADV, not ANSI X12 — and its DOC and MOA segment structures are just as slow to decode by hand. This template automates the full cycle. appse ai scans your FTP/SFTP directory for inbound REMADV messages, translates the UN/EDIFACT into structured data, iterates every payment line and adjustment, verifies each against open invoices in SAP Business One, and posts the cash receipt with approved adjustments written to the correct GL accounts. Unrecognised short-pays are parked and escalated to A/R.
Key benefits
- No manual UN/EDIFACT decoding — REMADV messages are parsed, matched, and posted without rekeying.
- Adjustments mapped to GL — Approved REMADV codes post to the correct accounts automatically.
- Faster cash, lower DSO — Lump-sum payments clear to invoice lines in seconds.
- Short-pays never lost — Unrecognised adjustments are parked and escalated to A/R.
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
Triggers & Actions
Every module in this template is fully customisable. Add triggers, swap actions, or extend the logic using appse ai's no-code visual builder.
Inside the flow
How the Template Works
appse ai runs this workflow end to end on your schedule — from an inbound REMADV message to posted cash in SAP Business One. Here is exactly what happens.
Scheduled FTP/SFTP directory scanning
On a set schedule, appse ai monitors your designated FTP/SFTP directory for newly deposited EDIFACT REMADV files from trading partners — no manual monitoring, so no message is missed or delayed.
Secure REMADV file download
When a relevant REMADV is detected and filtered, appse ai downloads the raw document securely for processing — fully automated, with no local file management and no double-processing.
EDIFACT data extraction and translation
An intelligent parser translates the raw UN/EDIFACT REMADV into structured data, extracting the payment total, invoice references from the DOC and MOA segments, and every buyer adjustment code — removing the manual decode of EDIFACT remittance structures.
Line-item iteration across all remittance details
A splitter breaks the REMADV into individual payment lines and adjustment codes, processing each in isolation against your A/R records — complete coverage regardless of how many detail segments the message contains.
SAP B1 open-invoice verification
For each line, appse ai queries SAP Business One for the matching open invoices and cross-references the remitted amount against the outstanding balance — match, partial cover, or deviation.
Payment matching and decision routing
A decision engine routes each remittance line: a clean clearance (including approved EDIFACT adjustment codes) or an unexplained short-pay that needs A/R intervention before cash is applied.
Automated cash application in SAP B1
For valid matches, appse ai creates a targeted Journal Entry mapping approved adjustments — early-pay discounts, promotional allowances — to the correct GL accounts, then posts the Incoming Cash Receipt in SAP B1 in seconds.
Exception alerting for unrecognised short-pays
When an unrecognised adjustment code or unexplained short-pay is detected, the unmatched amount is parked unapplied and an instant alert is sent to the A/R Manager via Microsoft Teams or Slack — so every exception is actioned, not buried.
Business Benefits
Real-world impact and measurable results
01
Eliminate manual EDIFACT REMADV translation and data entry
REMADV messages are parsed, matched, and posted to SAP B1 automatically — removing the hours spent deciphering UN/EDIFACT remittance structures and rekeying payment details. Every line is processed accurately without human intervention.
02
Reconcile the ledger across every invoice automatically
appse ai iterates every remittance line and matches it to the corresponding open invoice in SAP B1, so reconciliation is complete and accurate the moment the REMADV arrives.
03
Map adjustments to GL without accounting intervention
Standard buyer adjustments in REMADV — early-payment discounts, marketing allowances, freight chargebacks — are identified from UN/EDIFACT reason codes and written to the correct GL accounts automatically.
04
Accelerate cash application and reduce DSO
Lump-sum wire transfers are broken into perfectly applied cash receipts in SAP B1 within seconds of the REMADV being processed — earlier revenue recognition and a measurable DSO reduction.
05
Manage short-pays and disputes proactively
Unrecognised adjustments and short-pays are parked automatically and flagged to A/R managers via Teams or Slack in real time — surfaced within minutes, while the resolution window is still open.
06
Keep ERP records audit-ready
By creating Cash Receipts and Journal Entries directly from validated REMADV data, the workflow removes manual-posting errors — keeping SAP B1 records clean, complete, and audit-ready.
01
Eliminate manual EDIFACT REMADV translation and data entry
REMADV messages are parsed, matched, and posted to SAP B1 automatically — removing the hours spent deciphering UN/EDIFACT remittance structures and rekeying payment details. Every line is processed accurately without human intervention.
02
Reconcile the ledger across every invoice automatically
appse ai iterates every remittance line and matches it to the corresponding open invoice in SAP B1, so reconciliation is complete and accurate the moment the REMADV arrives.
03
Map adjustments to GL without accounting intervention
Standard buyer adjustments in REMADV — early-payment discounts, marketing allowances, freight chargebacks — are identified from UN/EDIFACT reason codes and written to the correct GL accounts automatically.
04
Accelerate cash application and reduce DSO
Lump-sum wire transfers are broken into perfectly applied cash receipts in SAP B1 within seconds of the REMADV being processed — earlier revenue recognition and a measurable DSO reduction.
05
Manage short-pays and disputes proactively
Unrecognised adjustments and short-pays are parked automatically and flagged to A/R managers via Teams or Slack in real time — surfaced within minutes, while the resolution window is still open.
06
Keep ERP records audit-ready
By creating Cash Receipts and Journal Entries directly from validated REMADV data, the workflow removes manual-posting errors — keeping SAP B1 records clean, complete, and audit-ready.
Questions & answers
Frequently asked questions
Everything you need to know about this template before you deploy it.
What is EDIFACT REMADV?
REMADV is the UN/EDIFACT Remittance Advice message — the European and international equivalent of the ANSI X12 EDI 820 — in which a buyer details which invoices are being paid and any adjustments. This template ingests inbound REMADV messages and applies the cash in SAP Business One.
How is this different from the EDI 820 template?
What does this SAP Business One REMADV template do?
How does it handle buyer adjustments and reason codes?
What happens with an unexplained short-pay?
Which systems does this template connect?
How long does it take to go live?
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