Stock Group Sales (#126)

This report lists total sales by stock group for a transaction number or date range.

Stock Groups

Select to sort the report by stock groups. Click on the Stock Groups button to include or exclude groups.

Supplier Groups

Select to sort the report by supplier groups. Click on the Supplier Groups button to include or exclude groups.

The groups that are included on this report are determined by the stock or supplier groups selected. You must click on the buttons marked Stock Groups or Supplier Groups and tick the groups you wish to include on this report.

Stock items that are not assigned to stock groups and non-stock item sales are NOT listed on this report as part of any particular group. They are shown separately at the end of the report.

Calculate On Mark-up

By default, the percentage profit calculation is displayed as a mark-up based on total costs (including any applicable taxes). Leave this selected if you wish to show the percentage calculation in this format.

Calculate On Margin

Select this option to base the percentage profit calculation on the profit margin.

Include Tax

By default, the tax portion of the transaction is not included as part of the sales or cost totals. Tick to include tax in the sales and cost figures on the report.

Account Type

Select the account type from the drop down list. The default is "regular", which includes all standard, cash and credit card accounts.

Hints & Tips

• The "TOTAL" column is the total sales less returns/credits.

• The "RETURNS" column represents sales less than zero. These may be stock returns, credits, etc.

• The "COSTS" column includes any applicable sales or service taxes if the Include Tax option is ticked.

• Projected income from lay-bys and cash orders are shown on this report. However, the report does not estimate cash order costs. Cash order costs are picked up as delivery transactions are created.

Other Sales

The other sales summary refers to:

• Billed items that do not have product codes.

• Stock items no longer found in the stock file.

• Stock items assigned to stock (or supplier) group codes that do not match existing stock (or supplier) groups.

• Stock items belonging to groups not marked for inclusion on the report.