AR Adjustment XML

In this guide, we'll walk you through the process of importing AR adjustment information into Sage Intacct using XML format. This comprehensive guide provides you with all the necessary information and examples to ensure a smooth integration.

Note

Zynk only supports the creation of AR adjustments. Existing AR adjustments can't be updated.

Matching

Before importing AR adjustments, it's essential to understand the different matching methods available in Sage Intacct:

Record ID

You can provide the Record ID, which is the unique identifier for an AR adjustment. If it already exists in Sage Intacct, the record won't be imported into Sage Intacct.

<RECORDID>134518</RECORDID>

External ID

You can include the External ID within your XML structure. This value is stored in Zynk's internal database and serves as a unique identifier to match the AR adjustment record. If the external ID has been seen before, the record won't be imported into Sage Intacct.

<EXTERNALID>9876881</EXTERNALID>

Adjustment Number

If you need to match an existing AR adjustment in Sage Intacct but lack the specific Record ID, you can utilize the Adjustment Number element to lookup the AR adjustment in Sage Intacct. If the adjustment number already exists in Sage Intacct, the record won't be imported into Sage Intacct.

<ADJUSTMENTNUMBER>2</ADJUSTMENTNUMBER>

XML

You can use the mapping outlined in the table below to set fields on the AR adjustment header.

Intacct Field	XML Field	Example	Field Type	Required?	Notes
Date	WHENCREATED	2024-03-05	datetime	-	If you do not provide this element, the date will default to the current day.
GL posting date	WHENDUE	2024-03-28	datetime	-	-
State	ACTION	Submit	enum	-	Valid values: `Draft`, `Submit`
Adjustment number	ADJUSTMENTNUMBER	ARADJ0005	string	-	-
Reference invoice number	DOCNUMBER	IN0014	string	-	-
Description	DESCRIPTION	Faulty goods	string	-	-
-	BASECURR	USD	string	-	-
-	DONOTPOSTTOGL	false	bool	-	-
-	EXCHRATEDATE	2024-03-05	datetime	-	-
-	EXCHRATETYPE	Intacct Daily Rate	string	-	Do not use if `EXCHRATE` is set. Leave blank to use Intacct Daily Rate.
-	EXCHRATE	1.231726	decimal	-	Do not use if `EXCHRATETYPE` is set.

Customer

When importing an AR adjustment, you must link it to an existing Customer in Sage Intacct or create a new one. You can use the mapping outlined below to set the Customer.

Intacct Field	XML Field	Example	Field Type	Required?	Notes
-	CUSTOMERID	10310	string	-	When matching to an existing customer, you can provide the `Customer ID` element, which acts as the unique identifier for the record.
-	EXTERNALID	87575	string	-	You can provide the `External Id` element to create a new customer or match to a record that has previously been imported by Zynk.
Name	NAME	Joe's Music Emporium	string	-	-

In conjunction with the Auto Create Customers task setting, you can provide full customer information at this location. Subsequently, this will create a new customer with the given details or update the existing record.

For Customer XML documentation, please see here.

Entries

When creating an AR adjustment, you must provide at least one item. You can use the mapping below to set the item entries.

Intacct Field	XML Field	Example	Field Type	Required?	Notes
Account	ACCOUNTLABEL	Revenue - Accessories	string	Dependant	Required if not using `ACCOUNTNO`
Account	ACCOUNTNO	40300	string	Dependant	Required if not using `ACCOUNTLABEL`
Amount	AMOUNT	-10	decimal	Yes	-
Department	DEPARTMENTID	100	string	-	-
Location	LOCATIONID	100	string	-	-
Memo	MEMO	Faulty goods	string	-	-
AR account	OFFSETGLACCOUNTNO	40200	string	-	-
Employee	EMPLOYEEID	100	string	-	-
Channel	CLASSID	100	string	-	-
Item	ITEMID	100	string	-	-
Customer	CUSTOMERID	10310	string	-	-
Project	PROJECTID	100	string	-	-
Vendor	VENDORID	100	string	-	-
Warehouse	WAREHOUEID	100	string	-	-
-	TOTALPAID	0	decimal	-	-
-	TRX_AMOUNT	-10	decimal	-	-

Item ID

When importing a AR adjustment line, you can link it to an existing Item or create a new one. You can use the mapping outlined below to set the Item.

Intacct Field	XML Field	Example	Field Type	Required?	Notes
Item ID	ITEMID	SCISSORS	string	-	When matching to an existing item, you can provide the `Item ID` element, which acts as the unique identifier for the record.
Item ID	ITEMIDENTIFIER	SCISSORS	string	-	When creating a new item, or matching to an existing one, you can provide the `Item Identifier` element.
-	EXTERNALID	5487841	string	-	You can provide the `External Id` element to create a new item or match to a record that has previously been imported by Zynk.
Print as	PRINTAS	Lennon, John	string	-	-

In conjunction with the Auto Create Items task setting, you can provide item contact information at this location. Subsequently, this will create a new item with the given details or update the existing record.

For Item XML documentation, please see here.

Example

<?xml version="1.0" encoding="utf-8"?>
<ARADJUSTMENTS>
    <ARADJUSTMENT>
        <RECORDID>ARADJ0005</RECORDID>
        <EXTERNALID>125416</EXTERNALID>
        <ADJUSTMENTNUMBER>ARADJ0005</ADJUSTMENTNUMBER>
        <CUSTOMERID>10310</CUSTOMERID>
        <CUSTOMERNAME>Joe's Music Emporium</CUSTOMERNAME>
        <DOCNUMBER>IN0014</DOCNUMBER>
        <DESCRIPTION>Just a test</DESCRIPTION>
        <WHENCREATED>2025-10-29</WHENCREATED>
        <WHENPOSTED>2025-10-29</WHENPOSTED>
        <BASECURR>USD</BASECURR>
        <PRBATCHKEY>1289</PRBATCHKEY>
        <EXCHRATEDATE>2025-10-29</EXCHRATEDATE>
        <EXCHRATETYPE>Intacct Daily Rate</EXCHRATETYPE>
        <EXCHRATE>1.231726</EXCHRATE>
        <ACTION>Submit</ACTION>
        <DONOTPOSTTOGL>false</DONOTPOSTTOGL>
        <ARADJUSTMENTITEMS>
            <aradjustmentitem>
                <ACCOUNTLABEL>Revenue - Accessories</ACCOUNTLABEL>
                <ACCOUNTNO>40300</ACCOUNTNO>
                <AMOUNT>-10</AMOUNT>
                <DEPARTMENTID>100</DEPARTMENTID>
                <LOCATIONID>100</LOCATIONID>
                <MEMO>Faulty goods</MEMO>
                <OFFSETGLACCOUNTNO>40200</OFFSETGLACCOUNTNO>
                <EMPLOYEEID>100</EMPLOYEEID>
                <CLASSID>100</CLASSID>
                <ITEMID>100</ITEMID>
                <CUSTOMERID>10310</CUSTOMERID>
                <PROJECTID>100</PROJECTID>
                <VENDORID>100</VENDORID>
                <WAREHOUSEID>100</WAREHOUSEID>
                <TOTALPAID>0</TOTALPAID>
                <TRX_AMOUNT>-10</TRX_AMOUNT>
                <ITEM>
                    <EXTERNALID>765543</EXTERNALID>
                    <ITEMIDENTIFIER>Polo Shirt</ITEMIDENTIFIER>
                    <NAME>Polo Shirt</NAME>
                    <BASEPRICE>10.99</BASEPRICE>
                    <NOTE>Non-perishable</NOTE>
                    <PODESCRIPTION>Large Polo Shirt</PODESCRIPTION>
                    <SODESCRIPTION>Large Polo Shirt</SODESCRIPTION>
                    <SHIP_WEIGHT>0.4</SHIP_WEIGHT>
                    <STANDARDCOST>5.49</STANDARDCOST>
                    <TAXABLE>true</TAXABLE>
                    <UOMGRP>Each</UOMGRP>
                    <UPC>POLO0001</UPC>
                </ITEM>
            </aradjustmentitem>
        </ARADJUSTMENTITEMS>
        <CUSTOMER>
            <EXTERNALID>87575</EXTERNALID>
            <NAME>Joe's Music Emporium</NAME>
            <PRINTAS>Joe's Music Emporium</PRINTAS>
            <DISPLAYCONTACT>
                <EXTERNALID>44690</EXTERNALID>
                <CONTACTNAME>Joe Harrison</CONTACTNAME>
            </DISPLAYCONTACT>
            <BILLTO>
                <EXTERNALID>44690</EXTERNALID>
                <CONTACTNAME>Joe Harrison</CONTACTNAME>
            </BILLTO>
            <SHIPTO>
                <EXTERNALID>44691</EXTERNALID>
                <CONTACTNAME>Adam McCrory</CONTACTNAME>
            </SHIPTO>
        </CUSTOMER>
    </ARADJUSTMENT>
</ARADJUSTMENTS>

Tasks

This XML model can be applied on the following tasks within the Zynk Sage Intacct library.

Import AR Adjustments

Import AR Adjustments