Invoice and Credit Note Field Mapping Between Sage Intacct and Re-Leased

  • Updated

This article provides comprehensive information about how invoices, credit notes, and their related data sync between Sage Intacct and Re-Leased. Understanding this mapping is essential for ensuring data integrity and accuracy across both platforms.

Customer and Contact Mapping

Customers/Vendors to Contacts

When a customer or vendor syncs from Sage Intacct to Re-Leased, the following fields map:

Sage IntacctRe-Leased
Customer/Vendor Id + NameName
NameCorrespondence Name

Primary Contact Details

The Primary Contact in Sage Intacct syncs to the Contact record in Re-Leased:

Sage IntacctRe-Leased
First NameFirst Name
Email AddressEmail
Last NameLast Name
Primary PhoneTelephone
FaxFax
Mobile PhoneMobile

Shipping Address

Important: If the Ship-To Contact is populated in Sage Intacct, the shipping details will sync from that contact. Otherwise, the Primary Contact address is used.

Sage IntacctRe-Leased
Address Line 1Postal Address
Address Line 2Suburb
CityTown/City
State or TerritoryRegion/State
Zip or Postal CodePost/Zip Code
CountryCountry

Billing Address

Important: If the Bill-To Contact is populated in Sage Intacct, the billing details will sync from that contact. Otherwise, the Primary Contact address is used.

Sage IntacctRe-Leased
Address Line 1Street Address
Address Line 2Suburb
CityTown/City
State or TerritoryRegion/State
Zip or Postal CodePost/Zip Code
CountryCountry

AR Invoices

Accounts Receivable invoices from Sage Intacct sync as Income Invoices in Re-Leased:

Sage IntacctRe-Leased
Invoice NumberInvoice Number
GL DateIssue Date (Due Date if setting on)
Invoice DateIssue Date
Due DateDue Date
CustomerTo (Contact)
Reference NumberReference

AP Invoices

Accounts Payable invoices from Sage Intacct sync as Expense Invoices in Re-Leased:

Sage IntacctRe-Leased
Bill NumberInvoice Number
Payment PriorityPayment Priority
GL DateIssue Date (Due Date if setting on)
Invoice DateIssue Date
Due DateDue Date
VendorFrom (Contact)
Reference NumberReference

AR/AP Adjustments

Adjustments in Sage Intacct sync as Credit Notes in Re-Leased:

Sage IntacctRe-Leased
Adjustment NumberInvoice Number
DateIssue Date
Due DateDue Date
Customer/VendorTo/From (Contact)
Reference NumberReference

Order Entry/Purchasing Invoices

Order Entry and Purchasing invoices sync as Income/Expense Invoices with line items in Re-Leased:

Sage IntacctRe-Leased
Transaction Type + Document NumberInvoice Number
GL DateIssue Date (Due Date if setting on)
Transaction Definition/TypeOE/PO Transaction Definition
The source Sales Order Document Number*Source Document Number
Revenue Recognition Template (Line Level) (OE Only)Revenue Recognition Template
Rev Rec Start Date (Line Level) (OE Only)Rev Rec Start Date
Rev Rec End Date (Line Level) (OE Only)Rev Rec End Date
Invoice DateIssue Date
Due DateDue Date
Customer/VendorTo/From (Contact)
Reference NumberReference

*This is the Sales Order/Revenue Activation Document that the Order Entry Invoice is converted from.

Order Entry/Purchasing Adjustments

Order Entry and Purchasing adjustments sync as Credit Notes with items in Re-Leased:

Sage IntacctRe-Leased
Transaction Type + Document NumberInvoice Number
Transaction Definition/TypeOE/PO Transaction Definition
DateIssue Date
Due DateDue Date
Customer/VendorTo/From (Contact)
Reference NumberReference

Line Item Mapping

AR/AP Invoice Lines

For standard AR/AP invoices, line items map as follows:

Sage IntacctRe-Leased
MemoDescription
AccountAccount
Transaction AmountUnit Price
Tax DetailTax Type

Order Entry/Purchasing Invoice Lines

For Order Entry and Purchasing invoices, line items include quantity and pricing:

Sage IntacctRe-Leased
MemoDescription
Item IDAccount
QuantityQuantity
PriceUnit Price

Line Dimensions and Tracking Categories

Line level dimensions and other line item fields in Sage Intacct sync to Re-Leased as Tracking Categories. This allows for detailed reporting and analysis. The following Sage Intacct line item fields sync as tracking categories:

  • Department
  • Location
  • Project
  • Customer
  • Employee
  • Item
  • Class
  • Contract
  • Task
  • Warehouse
  • Vendor/Supplier

These tracking categories enable you to maintain the same level of detailed categorization in Re-Leased that you have configured in Sage Intacct, ensuring consistent reporting across both platforms.

Understanding the Sync

The field mapping described above ensures that:

  • Data Integrity: Financial information remains consistent across both platforms
  • Approval Status: Posted invoices in Sage Intacct appear as approved in Re-Leased
  • Comprehensive Details: All relevant invoice information, including line items, taxes, and dimensional data, syncs accurately
  • Flexible Addressing: The system intelligently uses either specific contact addresses or falls back to primary contact details

Understanding this mapping helps you maintain accurate accounting records and ensures your invoicing process runs smoothly between Sage Intacct and Re-Leased.

Was this article helpful?