The S3 - Product from Invoices panel in Customer Consolidated Inquiries (ibis_su45) displays product sales from invoices for the date range entered on this panel for the customer entered in the Header Section.

The following list defines every field on the Product from Invoices panel:

  • Sales Since - enter or select from the query the starting date for the date range required. The default date is 365 days less then the current system date.

  • Sales Until - enter or select from the query the ending date for the date range required. The default date is current system date.

    • Note: The Sales until date must be greater than the sales since date.

  • Once the sales since and sales until dates are entered, click on Start (hover over the word Start). The list box populates with product information that matches the date range entered.

  • You can start the list box with a specific product by entering the product number into the Start at Product field located in the right hand corner of the list box.

  • The list box displays all product sales from invoices in the date range selected for the current customer. There are 5 columns of information:

    • Product
    • Description
    • Unit Sales
    • Dollar Sales (for the product on all invoices in the range)
    • Last Purchase