You can enquire about the past sales and purchases of a particular product or product range. The Product Enquiry operates in a similar manner to the Account Enquiry, to which you should refer for a complete discussion.
To make a sales enquiry for a particular product:
- Choose Enquiries>;Product Sales or press Ctrl-7/⌘-7
The Product Enquiry window will be displayed.
- For an enquiry on a single product, enter the product code and press enter (or click Calculate Now); for an enquiry on more than one product use the Select menu
This works in a similar manner to the Accounts Select menu.
The sales information, including margins if available, will be displayed for the product on a period by period basis. If you want to see the effect of any unposted transactions, click in the Include Unposted check box.
If you type in an incorrect code the product choices window will be displayed. Double-click on the product required to enter it.
You can drill down to see the transactions for a particular period by holding the mouse over the row for the period and clicking.
Viewing Product Purchases
The same screen can be used for either sales or purchases.
- Change the Sales pop-up menu to Purchases
The purchases for the product will be displayed.
Graphing Product Sales or Purchases
To graph the information on the enquiry screen:
- Click the Graph tab
A graph of the product sales/purchases is shown.
- Choose the data to graph from the Graph of pop-up menu
You can graph quantity, cost, net sales in dollars, the dollar margin and the percent margin for sales. For purchases you can graph the quantity or the cost. You can drill down to see the transactions behind a data point on the graph by clicking on it.
Showing Product Transactions
- Click the Movements tab
A list of all transactions for the product will be displayed.
You can print, sort, sum, and rearrange this list in the normal manner. To adjust the period range, use the from and to pop-up menus.
Showing Backorders for the Product (Gold only)
- Click the Orders Tab
Any incomplete orders for the product will be listed—the Qty is the backorder quantity (i.e. ordered but not shipped).