Filter by payment status. Use 'All' for all balances, 'Paid' for fully paid balances, or 'Unpaid' for outstanding balances.
columnsstring
Column types to be shown in the report. Supported Values: bill_addr, create_by, create_date, vend_bill_email, vend_comp_name, vend_msg, vend_phone_other, vend_tel, vend_name, deliv_addr, doc_num*, due_date*, last_mod_by, last_mod_date, memo*, vendor_sent_state, ship_addr, ship_d…
sort_bystring
The column type used in sorting report rows. Specify a column type as defined with the columns query parameter.
term_idsarray
One or more comma separated term IDs. Filters report contents based on term or terms supplied.
date_macrostring
Predefined date range. Use if you want the report to cover a standard report date range; otherwise, use the start_date and end_date to cover an explicit report date range.
sort_orderstring
The sort order.
vendor_idsarray
One or more comma separated vendor IDs. Filters report contents to include information for specified vendors.
end_duedatestring
The range of dates over which receivables are due, in the format YYYY-MM-DD. start_duedate must be less than end_duedate. If not specified, all data is returned.
num_periodsinteger
Number of aging periods to display in the report. Each period represents a time bucket for aging calculations (e.g., 0-30 days, 31-60 days).
report_datestring
Start date to use for the report, in the format YYYY-MM-DD.
aging_methodstring
Method for calculating age of payables. 'Report_Date' calculates age based on the report date, while 'Current' calculates age based on the current date.
aging_periodinteger
Number of days per aging period. Default is typically 30 days. For example, setting this to 30 creates buckets like 0-30, 31-60, 61-90 days.
Observable output
data
Required
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulboolean
Required
Whether or not the action execution was successful or not