Settings and activity
1 result found
-
1 vote
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,
AdamAn error occurred while saving the comment An error occurred while saving the comment
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>An error occurred while saving the comment
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
Terry
shared this idea
·
<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>