About Transcepta
Transcepta revolutionizes your accounts payable process with a fully automated, AI-powered solution, seamlessly integrated with SAP Business One (on Premise). From eliminating errors to streamlining workflows, our ready-to-deploy integration delivers clarity, control, and efficiency—even for the most complex AP challenges.
Purpose of This Document
The purpose of this document is to explain how Transcepta integrates with SAP Business One (on Premise) and the steps you will need to take to go-live with the integration.
How It Works
Transcepta’s integration with SAP Business One (on Premise) ensures secure data exchange using sFTP and Windows scripts, seamlessly syncing key Accounts Payable data such as invoices, vendors, general ledger accounts, purchase orders, and receipts across both systems. Please note, the SAP Business One (on Premise) must be using a SQL database for this integration.
Components of Integration – Accounts Payable Data
- Vendors: Keep your vendor list up to date by syncing data from SAP Business One to Transcepta.
- General Ledger Accounts: Efficiently code invoices with synched GL account data from SAP Business One to Transcepta. Apply GL coding to each line item, with data passed from Transcepta to SAP Business One.
- Purchase Orders & Receipts: Match up purchase orders and receipt lines between SAP Business One and Transcepta, enabling seamless 2-way or 3-way match.
- Invoices: Transcepta's AI-powered data extraction captures key invoice details and posts them to SAP Business One. See Appendix A for supported invoice fields.
- Invoice Image Posting (PDF): The original invoice image is posted from Transcepta to SAP Business One for easy reference.
What You Need to Do
To set up Transcepta’s ready-to-use integration with SAP Business One (on Premise), please review the checklist below. Your assigned Customer Success Manager will review each item with you and guide you through every step of the process. Once all listed requirements are completed, Transcepta will begin syncing your key Accounts Payable data.
Quick Checklist
- Create Remote Desktop User
- Share Credentials
- Enable Permissions
- Share Database Details
- Create SAP Business One User
- Share Credentials
- Enable Permissions
SAP Business One Access & Tools for AP Automation Checklist
Please note, below are several requests that require credential sharing. If you have a secure method of sharing credentials in accordance with your company’s practices, please feel free to use it. Alternatively, if you’d prefer another secure option, we recommend reaching out to your Customer Success Manager to learn more about using 1Password. Learn more here.
Remote Desktop User
Please provide Remote Desktop Access to a Windows server within your network.
Recommendation: contact your IT department for assistance.
Step 1: Remote Desktop Credentials
- Username: [To be provided to Transcepta]
- Password: [To be provided to Transcepta]
Step 2: Remote Desktop Permissions
Please ensure the Remote Desktop User has the following permissions:
SQL Database Read Access:- SAP Business One TEST Environment
- SAP Business One PRODUCTION Environment
- Note: This allows scheduled data syncs to run automatically, without requiring manual intervention. See the image example attached.
Step 3: SQL Database Details
Provide Test & Production environment server & database details for SAP Business One. Image example below.
SAP Business One TEST Environment- Server Name: [To be provided to Transcepta]
- Database Name: [To be provided to Transcepta]
- Server Name: [To be provided to Transcepta]
- Database Name: [To be provided to Transcepta]
SAP Business One User
To proceed, please set up a designated user account in your SAP Business One environment with the credentials and permissions outlined below. This account will allow Transcepta to log in and perform necessary integration tasks for exporting PO, Vendor and GL Account data.
Recommendation: contact your SAP Business One Account Manager for assistance.
Step 1: SAP Business One User Credentials
Assign or create a licensed SAP Business One account for Transcepta.
- Username: [To be provided to Transcepta]
- Password: [To be provided to Transcepta]
Step 2: SAP Business One User Permissions
Please ensure the SAP Business One User has the following permissions:
- Access to SAP Business One Test & Production Environments.
- Remote Desktop Access.
- Access to AP Data Transfer Workbench.
-
- Note: if you do not have the AP Data Transfer Workbench installed, you will need to install it and then provide access. Link: To learn more.
CONGRATULATIONS! You have completed all SAP Business One checklist items for AP Automation with Transcepta.
Appendix A – Supported Invoice Fields
A. Supported SAPB1 Header Fields to ⮕ Transcepta Header Fields:- Inv # ⮕ Invoice Number
- Document Date ⮕ Invoice Date
- Balance Due ⮕ Invoice Amount
- Vendor ⮕ Vendor Number
- Remarks ⮕ Comments
- Freight ⮕ Shipping Charges
- Discount ⮕Product Discount Amount
- Description ⮕ Item Description
- G/L Account ⮕ GL Account
- Tax Code ⮕ Tax Rate
- Total (LC) ⮕ Line Item Net Total
- Description ⮕ Item Description
- Quantity ⮕ Quantity
- Unit Price ⮕ Unit Price
- UoM Code ⮕ Unit of Measure
- Total (LC) ⮕ Line-Item Net Total
- Item No. ⮕ Item No.
- Tax Code ⮕ Tax Rate
- Quantity Description ⮕ Item Description
- G/L Account ⮕ GL Account
- Tax Code ⮕ Tax
- G/L Account ⮕ GL Account
- Tax Code ⮕ Tax Rate
Note: SAP Business One supports tax rate values with up to three decimal places (e.g., %00.000) and requires tax codes for invoice ingestion.