Import Sales Credit Notes to Sage Business Cloud Accounting

The Import Sales Credit Notes task will create new and update existing sales credit notes in Sage Business Cloud Accounting. The sales credit note data must be provided in the Sage Accounting Sales Credit Note XML format.

Settings

Sage Business Cloud Accounting Connection

Required
The connection to Sage Business Cloud Accounting to use. See Connecting To Sage Business Cloud Accounting if you require more information on how to create/manage connections.

Fail File

Required
The name of a file for "failed" imports to be sent to.

Input File

Required
The source file that you want to import in Sage Business Cloud Accounting XML format.

Success File

Required
The name of a file for "successful" imports to be sent to.

Check References

Required
Set to true to prevent records being imported if another record already exists in Sage with the same type and reference.

Prevent Reprocessing

Required
Set to true to prevent the same record being processed more than once. This will only work where an external_id is provided for a record in the input XML file.

Zynk Settings

See Common Task Settings

Example

A sample input file is shown below. See Sage Accounting Sales Credit Note XML for full documentation of the XML format.

<?xml version="1.0" encoding="utf-8"?>
<sage_one_company>
    <sales_credit_notes>
        <sales_credit_note>
            <!--555480-->
            <contact>
                <reference>EXA001</reference>
            </contact>
            <credit_note_number>555480</credit_note_number>
            <date>2023-02-03</date>
            <due_date>2023-02-03</due_date>
            <reference>555480</reference>
            <main_address>
                <address_line_1>Zynk Software</address_line_1>
                <address_line_2>6-8 Charlotte Square</address_line_2>
                <city>Newcastle upon Tyne</city>
                <region>Tyne &amp; Wear</region>
                <postal_code>NE1 4XF</postal_code>
                <country>
                <id>GB</id>
                </country>
            </main_address>
            <credit_note_lines>
                <credit_note_line>
                    <description>Revenue</description>
                    <product>
                        <item_code>PROD001</item_code>
                    </product>
                    <ledger_account>
                        <nominal_code>4000</nominal_code>
                    </ledger_account>
                    <quantity>1</quantity>
                    <unit_price>270</unit_price>
                    <tax_rate>
                        <name>Standard 20.00%</name>
                    </tax_rate>
                </credit_note_line>
            </credit_note_lines>
        </sales_credit_note>
    </sales_credit_notes>
</sage_one_company>