Sage 50 US Payment XML

Tasks

• Exporting Payments from Sage 50 US
• Importing Payments into Sage 50 US

XML

Any Sage fields not documented below are not supported with our imports, if there are additional fields you need contact us at [email protected].

Sample file for creating a payment:-

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfPayment>
  <Payment xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <ExternalId>93275</ExternalId>
    <ReferenceNumber>P2141</ReferenceNumber>
    <Date>2016-03-09T00:00:00</Date>
    <AccountReference>10200-00</AccountReference>
    <VendorReference>HUBBARD</VendorReference>
    <MainAddress>
      <Name>Hubbard Wholesale</Name>
      <Address>
        <Address1>1500 Pavilion Place</Address1>
        <Address2 />
        <City>Norcross</City>
        <State>GA</State>
        <Zip>30093</Zip>
        <Country>USA</Country>
        <SalesTaxCode />
      </Address>
    </MainAddress>
    <Memo>99-KH-01</Memo>
    <PaymentMethod>Check</PaymentMethod>
    <PaymentExpenseLines>
      <PaymentExpenseLine>
        <AccountReference>75500-00</AccountReference>
        <Description>Supplies Expense</Description>
        <InventoryItemReference>TR4300</InventoryItemReference>
        <JobReference>J10001</JobReference>
        <Quantity>1.00</Quantity>
        <UnitPrice>10.00</UnitPrice>
      </PaymentExpenseLine>
    </PaymentExpenseLines>
    <PaymentInvoiceLines>
      <PaymentInvoiceLine>
        <AccountReference>75500-00</AccountReference>
        <AmountPaid>10.00</AmountPaid>
        <Description>Supplies Expense</Description>
        <DiscountAmount>0.00</DiscountAmount>
        <InvoiceReference>129066</InvoiceReference>
        <JobReference>J10001</JobReference>
      </PaymentInvoiceLine>
    </PaymentInvoiceLines>
  </Payment>
</ArrayOfPayment>