How Financial Data Syncs Between Re-Leased and Dynamics 365 Business Central

  • Updated

When you connect Re-Leased to Microsoft Dynamics 365 Business Central, financial data flows automatically between both systems. This article explains which entities sync, in which direction, and how the key fields map between Re-Leased and Business Central - so you know exactly what to expect when data moves between systems.

Sync Directions

Data can flow in different directions depending on the entity type:

  • Two-way sync - data flows between Re-Leased and Business Central in both directions. Changes made in either system are reflected in the other.
  • One-way sync (Business Central → Re-Leased) - data is created or updated in Business Central and imported into Re-Leased. Changes made in Re-Leased for these entities do not push back to Business Central.
MS Dynamics Sync Diagram.png

Sync Entity Direction Table

Re-Leased EntityBusiness Central EntitySync Direction
Income InvoicesSales InvoicesTwo-way
Expense InvoicesPurchase InvoicesTwo-way
Income Credit NotesSales Credit MemosTwo-way
Expense Credit NotesPurchase Credit MemosTwo-way
Contacts (Income/Expense)Customers / VendorsTwo-way
Income Payments (Receipts)Customer PaymentsBusiness Central → Re-Leased only
Expense Payments (Remittances)Vendor PaymentsBusiness Central → Re-Leased only
Credit Note AllocationsApply Credit MemoBusiness Central → Re-Leased only
Tracking CategoriesDimensionsBusiness Central → Re-Leased only
Tax TypesTax Area / Tax GroupsBusiness Central → Re-Leased only
Chart of AccountsChart of Accounts (G/L Accounts)Business Central → Re-Leased only
Bank AccountsBank AccountsBusiness Central → Re-Leased only

Invoices and Credit Notes

Invoices and credit notes are the core of the financial sync. Both income (customer-facing) and expense (supplier) documents are supported with two-way sync.

Income Invoices

Income Invoices in Re-Leased sync with Sales Invoices in Business Central. The following header fields are synced:

Re-Leased FieldBusiness Central FieldNotes
Invoice NumberNo.
ReferenceYour ReferenceExternal document number
Issue DateDocument Date / Posting Date
Due DateDue Date
ContactSell-to Customer No.The customer must already be synced to Business Central
Subtotal (excl. tax)Amount Excl. VAT
Tax TotalVAT Amount
Total (incl. tax)Amount Incl. VAT
Line Amount TypePrices Including VATWhether prices are tax-inclusive or tax-exclusive
StatusStatusSee Status Mapping below

Each invoice line syncs the following fields:

Re-Leased FieldBusiness Central FieldNotes
DescriptionDescriptionMaximum 100 characters
QuantityQuantity
Unit PriceUnit PriceTax-exclusive
Line Amount (excl. tax)Line Amount
Line Amount (incl. tax)Amount Including VAT
Tax AmountVAT Amount
Account / ItemNo. (Item or G/L Account)Links to your synced Chart of Accounts or Items
Tracking CategoriesDimension Set IDMaps to Dimensions in Business Central

Expense Invoices

Expense Invoices in Re-Leased sync with Purchase Invoices in Business Central. The header and line fields are equivalent to income invoices, with these differences:

Re-Leased FieldBusiness Central FieldNotes
ContactBuy-from Vendor No.The vendor must already be synced to Business Central
ReferenceVendor Invoice No.Required for posting in Business Central
Unit PriceDirect Unit Cost

Income Credit Notes

Income Credit Notes in Re-Leased sync with Sales Credit Memos in Business Central. The fields are the same as Income Invoices, with the following difference:

Re-Leased FieldBusiness Central FieldNotes
Credit Note NumberNo.
ReferenceYour ReferenceExternal document number
Issue DateDocument Date / Posting Date
ContactSell-to Customer No.

Expense Credit Notes

Expense Credit Notes in Re-Leased sync with Purchase Credit Memos in Business Central. The fields are the same as Expense Invoices, with the following difference:

Re-Leased FieldBusiness Central FieldNotes
Credit Note NumberNo.
ReferenceVendor Cr. Memo No.Vendor's credit memo reference
Issue DateDocument Date / Posting Date
ContactBuy-from Vendor No.

Payments

Payments sync in one direction only - from Business Central into Re-Leased. Payments you record in Re-Leased are not pushed back to Business Central.

Income Payments (Receipts)

Customer Payments in Business Central sync into Re-Leased as Receipts:

Business Central FieldRe-Leased FieldNotes
Document No.Receipt Number
Posting DatePayment Date
External Document No.Reference
Customer No.Paid By ContactLinked via contact sync
AmountAmount PaidCalculated from applied entries
Applied to Document No.Invoice ReferenceLinks the payment to the relevant invoice
Applied AmountAmount AppliedAmount applied to each invoice

If a payment in Business Central has unapplied funds remaining, Re-Leased will create an overpayment record to track the unallocated balance.

Expense Payments (Remittances)

Vendor Payments in Business Central sync into Re-Leased as Remittances:

Business Central FieldRe-Leased FieldNotes
Document No.Remittance Number
Posting DatePayment Date
External Document No.Reference
Vendor No.Paid To ContactLinked via contact sync
AmountAmount PaidCalculated from applied entries
Applied to Document No.Bill ReferenceLinks the payment to the relevant bill
Applied AmountAmount AppliedAmount applied to each bill

Contacts

Customers and Vendors in Business Central sync two-ways with Contacts in Re-Leased. Income contacts (debtors) map to Customers in Business Central, and expense contacts (creditors) map to Vendors.

Re-Leased FieldBusiness Central FieldNotes
Contact NameName
Street AddressAddress
SuburbAddress 2
Town/CityCity
State/RegionCounty
PostcodePost Code
CountryCountry/Region CodeConverted between country name and ISO country code
PhonePhone No.
EmailE-Mail
Tax NumberVAT Registration No.
Contact CategoryContact TypeCompany or Person

Invoice Status Mapping

Invoice and credit note statuses map between the two systems as follows:

Business Central StatusRe-Leased StatusNotes
DraftAwaiting ApprovalNot yet posted
In ReviewAwaiting ApprovalUnder review in Business Central
OpenApprovedPosted and awaiting payment
PaidApprovedFully paid
CanceledVoidedCancelled document
CorrectiveApprovedCorrection has been applied

Tracking Categories (Dimensions)

Dimensions in Business Central sync into Re-Leased as Tracking Categories and their values as Tracking Options. This sync is one-way - dimensions are managed in Business Central and used in Re-Leased to categorise invoice lines.

When invoice or credit note lines sync, any dimension assignments on those lines are carried across and reflected as Tracking Category selections in Re-Leased.

Tax, Accounts, and Bank Accounts

The following reference data syncs from Business Central into Re-Leased and is used when creating invoices and matching transactions:

  • Tax Types - Tax Groups from Business Central sync into Re-Leased. Because Business Central handles tax calculation automatically, tax types are imported as system-defined references. The actual tax calculation is performed by Business Central.
  • Chart of Accounts - G/L Accounts from Business Central sync into Re-Leased and appear as account options on invoice lines.
  • Bank Accounts - Bank Accounts from Business Central sync into Re-Leased for use in payment matching and reconciliation.

Was this article helpful?