I need some help in how to break out (multiple) payments applied and discounts taken in the Sales subject area.
I want to have a query/structure like this:
Invoice 123 $100.00 due
Payment "A" Ck 987 - Paid 50.00 0.00 discount taken 01/01/13
Payment "B" Ck 543 - Paid $45.00 - took $5.00 discount 01/12/13 (fully paid)
Something tells me it may be in the Linked Transactions system, but for now I am stumped.
In QQube Version 7.1 Build 471 we introduced the following column values to assist with measures for paid/open transaction status and applied/taken discounts:
Choose a location