XERO querydb

repeatinginvoices

Fields:

- Schedule

-- StartDate (Schedule.StartDate)

Date Fields in queries

- DateTime(YYYY, MM, DD)

EG

- DateTime(2022, 01, 01)

Example

querydb repeatinginvoices Schedule.StartDate >= DateTime(2022, 01, 01) AND Schedule.StartDate <= DateTime(2022, 12, 31)

CONTAINS EXAMPLE

jscript "var somestring = 'Reference.Contains(\'sap\')'; return somestring;"

querydb invoices Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)

To get the xero invoice pdf files

querydb invoices "Date >= DateTime(2022, 01, 01) AND Date <= DateTime(2022, 01, 31)" FILES

Note:

For Repeating Invoices and Invoices we are creating a line for each line item.

So when you run an update you should use the unique value which will be the Line Item ID and not the Invoice Number or Reference.

EG

>push repeatinginvoices u "LineItems_LineItemID" "XERO Repeating Invoices"