Invoice custom group example

When you select PayablesInvoice, you build your condition from the field contained in the PayablesInvoice business class, that is, the invoice fields.

Suppose you want to create a custom group that consists of all the invoices for vendor 1012, who is a vendor for financial group 9100 and vendor group CORP.

  1. On the first line, select FinanceGroup (left column), is equal to (center column), Literal 9100 (right column), and click the plus (+) button.
  2. On the first line, select Vendor.VendorGroup (left column), is equal to (center column), Literal CORP (right column), and click the plus (+) button.
  3. On the first line, select Vendor (left column), is equal to (center column), Literal 1012 (right column), and click Save.

    The resulting condition is:

    (FinanceGroup = "9100" and Vendor.VendorGroup = "CORP" and Vendor = "1012")
  4. To preview the invoices currently in the system for this vendor, click the Preview button.
  5. You can modify the condition in the text. For example, you could modify the custom group to pull invoices from more than one vendor:
    (FinanceGroup = "9100" and Vendor.VendorGroup = "CORP" and (Vendor = "1012" or Vendor = "1023"))