Allocating Payments in Sage 50 UK

This task will attempt to allocate transactions in Sage. If you provide an input XML file, the task will perform the allocations listed in the file. If you don't provide an input file, the task will allocate automatically based on your chosen allocation settings. In both cases, it will produce a list of successfully allocated transactions in Zynk XML format.

Settings

Allow Partial Allocations

Required
If True will check the outstanding gross amount of splits match before allocating. This setting won't take effect when specifying allocations manually via the Input File setting.

Automatically Allocate Credit Notes

Required
If True will include Credit Note transactions when trying to allocate payments. This setting won't take effect when specifying allocations manually via the Input File setting.

Date From

Required
Used with Date To, allows you to only attempt to allocate transactions created between the specified time frame. This setting won't take effect when specifying allocations manually via the Input File setting.

Date To

Required
Used with Date From, allows you to only attempt to allocate transactions created between the specified time frame. This setting won't take effect when specifying allocations manually via the Input File setting.

Ledger Type

Required
Choose the ledger type to allocate, either Sales or Purchase. This setting won't take effect when specifying allocations manually via the Input File setting.

Match Transaction Amount

Required
If True will check the gross amount of the transactions match before allocating. This setting won't take effect when specifying allocations manually via the Input File setting.

Match Transaction Reference

Required
If True will only allocate transactions which have a matching reference. This setting won't take effect when specifying allocations manually via the Input File setting.

Only Check Zero Balance Accounts

Required
If True will only allocate transactions that are associated with accounts with a zero balance. This setting won't take effect when specifying allocations manually via the Input File setting.

Skip Accounts with Unallocated Credits

Required
If True will ignore accounts that have unallocated transactions. This setting won't take effect when specifying allocations manually via the Input File setting.

Sage 50 Connection

Required
The connection to Sage 50 UK to use. See the Connecting to Sage 50 UK article if you require more information on how to create/manage connections.

Fail File

Required
The file to save the list of transactions that could not be allocated to.

Input File

Optional
The file containing the list of allocations to perform. If not specified, the task will auto allocate transactions based on the settings above.

Success File

Required
The file to save the list of successfully allocated transactions to.

Zynk Settings

See Common Task Settings

Examples

A sample input file is shown below. For full documentation, see Sage 50 UK Payment Allocation XML.

<?xml version="1.0"?>
<Company>
  <PaymentAllocations>
    <PaymentAllocation>
      <CreditNumber>21</CreditNumber>
      <InvoiceNumber>20</InvoiceNumber>
      <Amount>14.80</Amount>
    </PaymentAllocation>
    <PaymentAllocation>
      <CreditNumber>18</CreditNumber>
      <InvoiceNumber>17</InvoiceNumber>
      <Amount>90.60</Amount>
    </PaymentAllocation>
    <PaymentAllocation>
      <CreditNumber>22</CreditNumber>
      <InvoiceNumber>17</InvoiceNumber>
      <Amount>62.60</Amount>
    </PaymentAllocation>
  </PaymentAllocations>
</Company>

A sample success file is shown below, which shows the SA transaction with reference 24 was allocated to the SI transaction with reference 24.

<?xml version="1.0"?>
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Transactions>
    <Transaction>
      <TransactionType>SalesInvoice</TransactionType>
      <AccountReference>JOE001</AccountReference>
      <TransactionDate>2016-01-27T00:00:00</TransactionDate>
      <PostedDate xsi:nil="true" />
      <AnalysisCode />
      <NominalCode />
      <Reference>24</Reference>
      <Details />
      <NetAmount>170.21</NetAmount>
      <TaxRate xsi:nil="true" />
      <TaxCode xsi:nil="true" />
      <TaxAmount>29.79</TaxAmount>
      <ElectronicTransaction xsi:nil="true" />
      <OutstandingAmount>0</OutstandingAmount>
      <TransactionNumber>14</TransactionNumber>
      <BankReference />
      <Discount xsi:nil="true" />
      <ExchangeRate xsi:nil="true" />
      <VatInclusive xsi:nil="true" />
      <AllocatedAmount>200</AllocatedAmount>
    </Transaction>
    <Transaction>
      <TransactionType>SalesReceiptOnAccount</TransactionType>
      <AccountReference>JOE001</AccountReference>
      <TransactionDate>2016-02-03T00:00:00</TransactionDate>
      <PostedDate xsi:nil="true" />
      <AnalysisCode />
      <NominalCode />
      <Reference>24</Reference>
      <Details />
      <NetAmount>-200</NetAmount>
      <TaxRate xsi:nil="true" />
      <TaxCode xsi:nil="true" />
      <TaxAmount>0</TaxAmount>
      <ElectronicTransaction xsi:nil="true" />
      <OutstandingAmount>0</OutstandingAmount>
      <TransactionNumber>15</TransactionNumber>
      <BankReference />
      <Discount xsi:nil="true" />
      <ExchangeRate xsi:nil="true" />
      <VatInclusive xsi:nil="true" />
      <AllocatedAmount>200</AllocatedAmount>
    </Transaction>
  </Transactions>
</Company>