Return all Invoices of Sub-Customers based on its Parent Customer in Print Checks and Forms > Invoices

Written by
Pattranit Lakhan
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

  1. Create a custom Transaction Body Field that will copy the customer's name and apply it on the Invoice:

    1. Navigate toCustomization>Lists, Records, & Fields>Transaction Body Fields>New
    2. Label: Enter preferredLabel
    3. Type: SelectFree-Form Text
    4. Store Value:set tounchecked
    5. Click theApplies Tosubtab
    6. Sale: Enter checkmark
    7. Click theValidation and Defaultingsubtab
    8. Default Value:{entity}
    9. ClickSave

    Note:The name of the child customer should always be preceded by the parent customer's name


  2. Add the field created above as a filter to the list under Print Invoices:

    1. Navigate toTransactions>Management>Print Checks and Forms>Invoices
    2. Click theCustomizebutton
    3. Click theAdditional Filterssubtab
    4. Add the newly created custom transaction body field as a filter
    5. ClickSave