About Net Sale Calculations

In reports, net sales are calculated as follows:

• Count for net sales is the number of items sold, minus the number of items returned.

• Amount calculation is Gross Sales minus Tax, and minus Returns. Any Markdowns (discounts) are also excluded.

There are several SystemConfiguration.xml parameters that determine how Net Sales are calculated:

• <ExcludeVatFromNetSales dtype="Boolean">true</ExcludeVatFromNetSales>

  When true, VAT is excluded from Net Sales.

• <BookAsSaleOnSetup dtype="Boolean">false</BookAsSaleOnSetup>

  There are two flags, one for Layaway and one for Special Order. This is used to determine if a sale of this type is booked as a Sale during Setup or Pickup. When false, the sale is booked at pickup.

The following database flag is checked for net sale calculations:

• itm_item_options.exclude_from_net_sales_flag

  When true, Non-Merchandise items are excluded from Net Sales calculations.