Report for collections from customer accounts

[JTRTech]

I put together a debtors/creditors ledger type table for work period report here;

Work Period Adjustment for Including Customer Accounts as Debtor Accounts

Needed to specify an AS… [Ticket Payments:2, 1] @{REPORT SQL DETAILS: SELECT a.[Name] AS [AccountList] FROM [Accounts] a LEFT JOIN [AccountTypes] t ON a.[AccountTypeId] = t.[Id] WHERE t.[Name]='Payment Accounts':F.AccountList::{0}:,} $1|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PT=$1) && (Payment.Amount > 0)} Account|{ACCOUNT TRANSACTION DEBIT TOTAL:Customer Account Transaction} >Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0} [image]

Note though that BF/CF will only be valid at time of printing - if reprinting a past report these balances will be current not relavent to the date of the report.