Tuesday, October 2, 2018

List of Payments made by the Parent Customer to the Child Customers Invoices


Here are the steps to generate a report that will show Payments made by Parent Customer to Child Customers Invoices:
 
1. Navigate to Transactions > Management > Saved Searches > New
2. Pull up Transactions Search
3. On the Criteria tab > Standard sub tab, add:
      Type = Invoice
      Applying Transaction: Type = Payment
      Formula (Numeric) -------- is 0 ------------- DECODE({name}, {applyingtransaction.name}, 1,0)
4. On the Results tab click Remove all and add:
      Number
      Name
      Amount
      Applying Transaction
      Applying Transaction: Name
      Formula (Numeric) -------------------------- DECODE({name}, {applyingtransaction.name}, 1,0)
5. Put a name on the search
6. Hit Save and Run

No comments:

Post a Comment