Sales and customer
      Back to home
      1. MYOB Acumatica Knowledge Base
      2. Sales and customer

      Setting up customer balances generic inquiry

      This knowledge base article guides you through the process of creating a generic inquiry to report back customer balances. The screen shot below lists the tables required.

      Image

      Within the relations tab you need to specify the table relations (joins) as shown below.

      Image

      You can specify conditions, parameters and sort order if required and also the fields that the generic inquiry will report back on in the results grid tab.

      Image

      Below is the result set of the generic inquiry.

      Image