As there is no option to convert the Amount columns to be per Month on a standard A/P Payment History by Payment report, users may opt to use a saved search.
--- Go to Lists > Search > Saved Searches > New > Transactions
--- Provide a name for the search
Criteria:
Type= is Bill Payment
Account Type= is Accounts Payable
Results:
Date > Summary Type : Group > Function : Month
Name > Summary Type : Group
Document Number
Amount
Formula (Currency) > Summary Type : Sum > Formula : case when (to_char({trandate}, 'YYYY-MM')) like '%01' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%02' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%3' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%4' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%5' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%6' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%7' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%8' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%9' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%10' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%11' then {amount} end
Formula (Currency) > Summary Type : Sum > Formula :case when (to_char({trandate}, 'YYYY-MM')) like '%12' then {amount} end
--- Enter a Custom Label for each Formula (Currency) field. (i.e. Jan, Feb, etc.)
Available Filters:
Date > Show in Filter Region : Yes
--- Save & Run
JCurve Solutions Support Hub
Looking for something else? Search here...