transactions.getTransactionsDataForDay
Description
Get all transactions data for the specified date.

Parameters
date string (in format "yyyy-mm-dd")

Return value
data 2D array

Example
-- get transactions data for 3rd June 2023
local cells = transactions.getTransactionsDataForDay("2023-06-03")

-- display the data
ui.showGridViewerDialog("Transactions", cells)

Comments
Data is returned as one transaction per line/row (y).

Columns (x)indexes are:
0: transactionID
1: transactionNumber
2: transactionLocationID
3: transactionDate
4: transactionTime
5: transactionAmount
6: transactionPaymentMethods (comma separated) (e.g. "Cash" or "Cash, Debit Card")
7: transactionPaymentAmounts (comma separated) (e.g. "12.50" or "12.50, 10.00, 0.50")
8: transactionInvoiceIDs (comma separated) (e.g. "1234" or "1234, 5678, 9012")
9: transactionAddressID

See also

Back
Generated on the 26 June 2024 at 22:01:29 (UK Time)