AR Adjustments
Overview
📥 Direction: Sage Intacct → Zudello
AR adjustment data flows from Sage Intacct to Zudello to provide a complete history of accounts receivable adjustments.
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 adjustment number from Sage Intacct. |
| Reference | DOCNUMBER | The adjustment reference number. |
| Description | DESCRIPTION | The description of the adjustment. |
| Date Issued | WHENCREATED | The date the adjustment was created. |
| Date Posted | WHENPOSTED | The date the adjustment was posted. |
| Subtotal | SUBTOTAL | The net adjustment amount before tax. |
| Tax | TAXTOTAL | The total tax adjustment amount. |
| Total | TOTAL | The total adjustment amount including tax. |
| Currency | CURRENCY | The currency of the adjustment. |
| Status | STATE | The status of the adjustment. |
| Adjustment Type | ADJTYPE | The type of adjustment (e.g., Credit, Debit). |
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 adjustment 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
- Full Sync: Due to the complexity of adjustments, this integration performs a full sync, refreshing the entire list of AR adjustments with each run to ensure a complete history.
- Full Detail Sync: Adjustments are synced with all their line items and dimensional data.