Customer Accounts Payment

[JTRTech]

Youll need to change wp report to include some form of ledger balance/monements/payments.

Something like this for ideas

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]