SAP Business One → Zoho Books
Apps Required
The workflow runs every 10 minutes to check for SAP Business One invoices that are marked for sync and not yet pushed to Zoho Books.
Fetches one invoice at a time where U_InvoiceSyncFlag is Y and U_DocNum is empty or null.
Splits SAP invoice document lines so each line item can be processed and mapped correctly.
Looks up item master details by ItemCode to retrieve the mapped web item ID needed for Zoho Books.
Retrieves the business partner data using CardCode and fetches the linked Zoho customer ID.
Creates the invoice in Zoho Books using due date, line items, customer ID, and SAP DocEntry as reference number.
Updates the SAP invoice with the Zoho invoice ID in U_DocNum and marks U_InvoiceSyncFlag as T after successful sync.
| Modules | Trigger |
|---|---|
| Business partners updated | Triggered when a business partner is updated in the SAP B1 |
| New returns created | Triggered when a new return request is created in the SAP B1 |
| New quotations created | Triggered when a new quotation is created in the SAP B1 |
| New AR invoices created | Triggered when a new AR invoice is created in the SAP B1 |
| New business partners created | Triggered when a new business partner is created in the SAP B1 |
| New service calls created | Triggered when a new service call is created in the SAP B1 |
| New incoming payments created | Triggered when a new incoming payment is created in the SAP B1 |
| New orders created | Triggered when a new order is created in the SAP Business One |
| New Credit Note created | Triggered when a new AR credit note is created in the SAP B1 |
| Items price updated | Triggered when a existing item prices are updated in the SAP B1 |
| New items created | Triggered when a new item is created in the SAP B1 |
| New deliverynotes created | Triggered when a new delivery note is created in SAP Business One. |
| Items updated | Triggered when a existing item is updated in the SAP B1 |
| New activities created | Trigger when new activities are created in SAP Business One. |
Automatically pushes new SAP Business One invoices to Zoho Books without manual intervention.
1
2
Stores Zoho invoice IDs back in SAP Business One for clear traceability and reconciliation.
Eliminates repetitive invoice creation tasks and improves finance team efficiency.
3
1
Automatically pushes new SAP Business One invoices to Zoho Books without manual intervention.
2
Stores Zoho invoice IDs back in SAP Business One for clear traceability and reconciliation.
3
Eliminates repetitive invoice creation tasks and improves finance team efficiency.
Common questions about this automation template.
Automate smarter with an AI-native platform designed for the way mid-market businesses really work.