Business Central Imports and Exports
Imports
Payments:
Handle Payments for multiple invoices:
The integration with Business Central handles import of one Payment for multiple AP Invoices.Payment Terms:
Payment terms mapping from BC to Workbench uses Business Central Payment Due Calculation:
Exports
AP Invoice/Credit:
Workbench exports the Amount including Tax and TaxCode to BC, BC calculates the Tax Amount for each line based on the GST Posting Setup - VAT % for the combination of the Vendor’s VAT Bus. Posting Group and the TaxCode from WB (VAT Prod Posting Group). Total VAT: It is not the value from Workbench. This is automatically calculated in Business Central based on the account’s tax code/percentage on the lines
On Hold AP Invoices:
When the OnHold field of an AP Invoice is unchecked and released from this hold, and there are no payments linked to this invoice, the OnHold field in BC will be set to blank, releasing the invoice for payment.
AR Invoice/Credit:
Workbench exports the Amount including Tax and TaxCode to BC, BC calculates the Tax Amount for each line based on the GST Posting Setup - VAT % for the combination of the Customer’s VAT Bus. Posting Group and the TaxCode from Workbench (VAT Prod Posting Group). Total VAT: It is not the value from Workbench. This is automatically calculated in Business Central based on the account’s tax code/percentage on the lines
Next Steps:
Once configuration is complete, data export from Workbench to Business Central is initiated for the respective batch types from Export Control.