Return all Invoices of Sub-Customers based on its Parent Customer in Print Checks and Forms > Invoices
Published on
October 31, 2023 at 8:12:55 AM PDT October 31, 2023 at 8:12:55 AM PDTst, October 31, 2023 at 8:12:55 AM PDT
Scenario
User needs to pull all invoices for a customer and its sub customer, however theCustomerfilter is not available in aOne World Account.
Solution
- Create a custom Transaction Body Field that will copy the customer's name and apply it on the Invoice:
- Navigate toCustomization>Lists, Records, & Fields>Transaction Body Fields>New
- Label: Enter preferredLabel
- Type: SelectFree-Form Text
- Store Value:set tounchecked
- Click theApplies Tosubtab
- Sale: Enter checkmark
- Click theValidation and Defaultingsubtab
- Default Value:{entity}
- ClickSave
- Add the field created above as a filter to the list under Print Invoices:
- Navigate toTransactions>Management>Print Checks and Forms>Invoices
- Click theCustomizebutton
- Click theAdditional Filterssubtab
- Add the newly created custom transaction body field as a filter
- ClickSave