REFERENCE Field is now missing for API for ACCPAY invoices
REFERENCE Field is now missing from API calls for ACCPAY (Accounts Payable) as per attached examples, change seems to have happened on the 4th June 2020
Hi Terry,
The Reference field is only for ACCREC Invoices.
For ACCPAY Invoices, the value that is displayed in the UI as ‘Reference’ is returned in the InvoiceNumber field.
So we can support you better in future, please raise these kind of issues with support (api@xero.com) rather than UserVoice.
Thanks,
Adam
-
Terry commented
<Status>OK</Status>
<ProviderName>Xero API Previewer</ProviderName>
<DateTimeUTC>2020-06-10T13:57:03.386757Z</DateTimeUTC>
<Invoices>
<Invoice>
<Contact>
<ContactID>0739f68c-f633-4d38-8c26-ef4fb52622ed</ContactID>
<ContactStatus>ACTIVE</ContactStatus>
<Name>WesTrac Pty Ltd</Name>
<emailaddress>remittances@westrac.com.au</EmailAddress>
<BankAccountDetails>036000000961279</BankAccountDetails>
<TaxNumber>009362572</TaxNumber>
<AccountsPayableTaxType>INPUT</AccountsPayableTaxType>
<Addresses>
<Address>
<AddressType>STREET</AddressType>
</Address>
<Address>
<AddressType>POBOX</AddressType>
<AddressLine1>Locked Bag 9</AddressLine1>
<City>Midland</City>
<Region>WA</Region>
<PostalCode>6936</PostalCode>
<AttentionTo>Accounts Receivable</AttentionTo>
</Address>
</Addresses>
<Phones>
<Phone>
<PhoneType>DEFAULT</PhoneType>
</Phone>
<Phone>
<PhoneType>DDI</PhoneType>
</Phone>
<Phone>
<PhoneType>FAX</PhoneType>
</Phone>
<Phone>
<PhoneType>MOBILE</PhoneType>
</Phone>
</Phones>
<UpdatedDateUTC>2019-04-15T15:16:02.65</UpdatedDateUTC>
<IsSupplier>true</IsSupplier>
<IsCustomer>false</IsCustomer>
<DefaultCurrency>AUD</DefaultCurrency>
<BatchPayments>
<BankAccountNumber>036000000961279</BankAccountNumber>
<BankAccountName>WesTrac Pty Ltd</BankAccountName>
<Details>N029795 AusReman</Details>
</BatchPayments>
<PaymentTerms>
<Bills>
<Day>30</Day>
<Type>OFFOLLOWINGMONTH</Type>
</Bills>
</PaymentTerms>
</Contact>
<Date>2020-06-03T00:00:00</Date>
<DueDate>2020-07-30T00:00:00</DueDate>
<Status>DRAFT</Status>
<LineAmountTypes>Exclusive</LineAmountTypes>
<LineItems>
<LineItem>
<Description>ORDER: 13841</Description>
<LineItemID>3cd00c88-c398-4d3b-8aa7-d88b7f8153c8</LineItemID>
</LineItem>
<LineItem>
<Description>38657D LOCTITE GASKT MKER</Description>
<UnitAmount>23.78</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>2.38</TaxAmount>
<LineAmount>23.78</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>1.0000</Quantity>
<LineItemID>def6944d-e363-46c1-9eae-b7d1a71a3dbd</LineItemID>
</LineItem>
</LineItems>
<SubTotal>23.78</SubTotal>
<TotalTax>2.38</TotalTax>
<Total>26.16</Total>
<UpdatedDateUTC>2020-06-03T23:04:44.783</UpdatedDateUTC>
<CurrencyCode>AUD</CurrencyCode>
<Type>ACCPAY</Type>
<InvoiceID>d6a4743a-3425-4760-8aa8-a5b96ed0d9ff</InvoiceID>
<InvoiceNumber>PI 4649643</InvoiceNumber>
<Reference>13841</Reference>
<AmountDue>26.16</AmountDue>
<AmountPaid>0.00</AmountPaid>
<SentToContact>false</SentToContact>
<CurrencyRate>1.000000</CurrencyRate>
<HasAttachments>false</HasAttachments>
<HasErrors>false</HasErrors>
</Invoice>
</Invoices>
</Response> -
Terry commented
<Status>OK</Status>
<ProviderName>Xero API Previewer</ProviderName>
<DateTimeUTC>2020-06-10T13:40:14.0750308Z</DateTimeUTC>
<Invoices>
<Invoice>
<Contact>
<ContactID>0739f68c-f633-4d38-8c26-ef4fb52622ed</ContactID>
<ContactStatus>ACTIVE</ContactStatus>
<Name>WesTrac Pty Ltd</Name>
<emailaddress>remittances@westrac.com.au</EmailAddress>
<BankAccountDetails>036000000961279</BankAccountDetails>
<TaxNumber>009362572</TaxNumber>
<AccountsPayableTaxType>INPUT</AccountsPayableTaxType>
<Addresses>
<Address>
<AddressType>STREET</AddressType>
</Address>
<Address>
<AddressType>POBOX</AddressType>
<AddressLine1>Locked Bag 9</AddressLine1>
<City>Midland</City>
<Region>WA</Region>
<PostalCode>6936</PostalCode>
<AttentionTo>Accounts Receivable</AttentionTo>
</Address>
</Addresses>
<Phones>
<Phone>
<PhoneType>DEFAULT</PhoneType>
</Phone>
<Phone>
<PhoneType>DDI</PhoneType>
</Phone>
<Phone>
<PhoneType>FAX</PhoneType>
</Phone>
<Phone>
<PhoneType>MOBILE</PhoneType>
</Phone>
</Phones>
<UpdatedDateUTC>2019-04-15T15:16:02.65</UpdatedDateUTC>
<IsSupplier>true</IsSupplier>
<IsCustomer>false</IsCustomer>
<DefaultCurrency>AUD</DefaultCurrency>
<BatchPayments>
<BankAccountNumber>036000000961279</BankAccountNumber>
<BankAccountName>WesTrac Pty Ltd</BankAccountName>
<Details>N029795 AusReman</Details>
</BatchPayments>
<PaymentTerms>
<Bills>
<Day>30</Day>
<Type>OFFOLLOWINGMONTH</Type>
</Bills>
</PaymentTerms>
</Contact>
<Date>2020-06-05T00:00:00</Date>
<DueDate>2020-07-30T00:00:00</DueDate>
<Status>DRAFT</Status>
<LineAmountTypes>Exclusive</LineAmountTypes>
<LineItems>
<LineItem>
<Description>ORDER: 13864</Description>
<LineItemID>f487373b-d350-4933-b1f5-b5f945a47857</LineItemID>
</LineItem>
<LineItem>
<Description>0S-1594 CAP SCREW</Description>
<UnitAmount>0.61</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>1.83</TaxAmount>
<LineAmount>18.30</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>30.0000</Quantity>
<LineItemID>20d21efb-2250-4186-b6b7-5394b8aa2356</LineItemID>
</LineItem>
<LineItem>
<Description>3K-0360 SEAL</Description>
<UnitAmount>1.69</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>2.54</TaxAmount>
<LineAmount>25.35</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>15.0000</Quantity>
<LineItemID>5267960c-b837-4526-acf6-c9f84cd4b9b5</LineItemID>
</LineItem>
<LineItem>
<Description>6V-8398 SEAL O RING</Description>
<UnitAmount>1.56</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>2.34</TaxAmount>
<LineAmount>23.40</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>15.0000</Quantity>
<LineItemID>625b3091-be65-4eab-8aee-f4fd8e87e520</LineItemID>
</LineItem>
<LineItem>
<Description>3J-1907 SEAL</Description>
<UnitAmount>1.49</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>2.24</TaxAmount>
<LineAmount>22.35</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>15.0000</Quantity>
<LineItemID>e5d95ab1-b287-4458-afbf-058512babf50</LineItemID>
</LineItem>
<LineItem>
<Description>2M-9780 SEAL O RING</Description>
<UnitAmount>1.86</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>1.86</TaxAmount>
<LineAmount>18.60</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>10.0000</Quantity>
<LineItemID>cfd06f34-4857-49fc-80e7-749f27a6cb6e</LineItemID>
</LineItem>
<LineItem>
<Description>3D-2824 SEAL O RING</Description>
<UnitAmount>2.33</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>2.33</TaxAmount>
<LineAmount>23.30</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>10.0000</Quantity>
<LineItemID>4aa5d599-1d68-4c80-b9dc-b98b97c504a4</LineItemID>
</LineItem>
<LineItem>
<Description>4J-0525 SEAL O RING</Description>
<UnitAmount>4.06</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>4.06</TaxAmount>
<LineAmount>40.60</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>10.0000</Quantity>
<LineItemID>56e4c0b2-deec-4958-8755-1221159d8759</LineItemID>
</LineItem>
<LineItem>
<Description>5P-8245 WASHER-HARD</Description>
<UnitAmount>0.96</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>3.84</TaxAmount>
<LineAmount>38.40</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>40.0000</Quantity>
<LineItemID>bd554540-846d-44d5-bd7e-e47624d5f506</LineItemID>
</LineItem>
<LineItem>
<Description>5M-2894 WASHER</Description>
<UnitAmount>0.51</UnitAmount>
<TaxType>INPUT</TaxType>
<TaxAmount>2.04</TaxAmount>
<LineAmount>20.40</LineAmount>
<AccountCode>330</AccountCode>
<Quantity>40.0000</Quantity>
<LineItemID>e6714fbd-385f-405f-9d07-026f5f77b865</LineItemID>
</LineItem>
</LineItems>
<SubTotal>230.70</SubTotal>
<TotalTax>23.08</TotalTax>
<Total>253.78</Total>
<UpdatedDateUTC>2020-06-10T13:30:48.63</UpdatedDateUTC>
<CurrencyCode>AUD</CurrencyCode>
<Type>ACCPAY</Type>
<InvoiceID>00c9c2a9-70d2-4072-9156-9570fad993fc</InvoiceID>
<InvoiceNumber>PI 4661569</InvoiceNumber>
<AmountDue>253.78</AmountDue>
<AmountPaid>0.00</AmountPaid>
<SentToContact>false</SentToContact>
<CurrencyRate>1.000000</CurrencyRate>
<HasAttachments>false</HasAttachments>
<HasErrors>false</HasErrors>
</Invoice>
</Invoices>
</Response> -
Terry commented
Attached are the 2 examples of ACCPAY accounts payable invoices with and without the REFERENCE field, can someone please help us understand what has happened here