AR Invoices

This integration provides bidirectional AR invoice synchronization between Sage Intacct and Zudello, supporting both data retrieval for transaction history and invoice creation for accounts receivable processing.

Inbound (Sage Intacct → Zudello)

📥 Direction: Sage Intacct → Zudello

AR invoice data flows from Sage Intacct to Zudello to provide a complete history of accounts receivable transactions.

Header Field Mappings

Zudello Field	Sage Intacct Field	Notes
Customer	CUSTOMERID	Links to the customer record.
Company Name	CUSTOMERNAME	The name of the customer.
Document Number	RECORDID	The AR invoice number from Sage Intacct.
Reference	DOCNUMBER	The customer's reference number.
Description	DESCRIPTION	The description of the invoice.
Date Issued	WHENCREATED	The date the invoice was created.
Date Posted	WHENPOSTED	The date the invoice was posted.
Date Due	WHENDUE	The payment due date.
Subtotal	SUBTOTAL	The net amount before tax.
Tax	TAXTOTAL	The total tax amount.
Total	TOTAL	The total amount including tax.
Currency	CURRENCY	The currency of the invoice.
Status	STATE	The status of the invoice (e.g., Open, Paid).
Payment Status	PAYMENTSTATUS	The payment processing status.

Line Item Field Mappings

Zudello Field	Sage Intacct Field	Notes
Description	ENTRYDESCRIPTION	The description of the line item.
Line Number	LINE_NUM	The line sequence number.
Quantity	QUANTITY	The quantity on the invoice line.
Unit Price	PRICE	The unit price, excluding tax.
Total Exclusive	TRXAMOUNT	The line total, excluding tax.
Tax	TAXAMOUNT	The tax amount for the line.
Total	TOTALAMOUNT	The line total, including tax.
Item	ITEMID	Links to the item record.
Account	ACCOUNTNO	Links to the GL account.
Location	LOCATIONID	Links to the location.
Department	DEPARTMENTID	Links to the department.
Project	PROJECTID	Links to the project.
Cost Centre	CLASSID	Links to the cost centre.
Tax Rate	TAXTYPE	Links to the tax rate.

Key Behaviours (Inbound)

• Incremental Sync: To save time, the integration only syncs invoices that are new or have been updated since the last check.
• Payment Status Tracking: The integration syncs the payment status of invoices, allowing for accurate tracking of open, paid, and partially paid invoices.
• Full Detail Sync: Invoices are synced with all their line items and dimensional data.

Outbound (Zudello → Sage Intacct)

📤 Direction: Zudello → Sage Intacct

AR invoices are created in Sage Intacct from Zudello to process accounts receivable invoices.

Header Field Mappings

Intacct Field	Zudello Field	Notes
CUSTOMERID	customer.code	The customer's unique code.
WHENCREATED	date_issued	The date the invoice was issued.
WHENPOSTED	date_posted	The date the invoice is posted.
WHENDUE	date_due	The due date for the invoice.
RECORDID	document_number	The invoice document number.
DOCNUMBER	reference	The reference number for the invoice.
DESCRIPTION	-	A link back to the document in Zudello.
CURRENCY	currency.code	The currency of the invoice.
TAXSOLUTIONID	-	A fixed tax solution is used (e.g., "Australia - GST").

Line Item Mappings

Intacct Field	Zudello Field	Notes
ACCOUNTNO	account.code	The revenue account for the line item.
TRXAMOUNT	total_exclusive	The line amount, excluding tax.
TAXAMOUNT	tax_amount	The tax amount for the line.
ENTRYDESCRIPTION	description	The description for the line item.
LOCATIONID	location.code	The location for the line item.
DEPARTMENTID	department.code	The department for the line item.
PROJECTID	project.code	The project for the line item.
CLASSID	cost_centre.code	The cost centre for the line item.
ITEMID	item.code	The item code for the line item.
TAXTYPE	tax_rate.code	The tax rate for the line item.

Key Behaviours (Outbound)

• Customer Focused: The integration validates the customer and applies customer-specific settings like credit limits and payment terms.
• Dimensional Tracking: The integration supports full tracking across dimensions like locations, departments, projects, and cost centres.
• File Attachments: If the invoice has a file attached in Zudello, it will be attached to the AR invoice in Sage Intacct.
• Fixed Tax Solution: A standard tax solution (e.g., "Australia - GST") is used for consistency.

Related Documentation

• AR Adjustments
• AR Payments
• Customers
• Items
• Accounts
• AR Terms
• Tax Rates
• Cost Centres
• Projects
• Locations
• Customer Categories