The Sales report contains only items for which the following conditions are met:
- The item is either assigned to the item tag from the Global SubCategory root tag or included into the category where the GL # field is populated with the material code value.
- The material code value is configured properly.
For more information on how to configure material codes for GSAP reports, see Configuring Material Code Settings.
The taxes are calculated in the report only if the following conditions are met:
- NCR Radiant cash register is used at the location
- Taxes settings are configured properly in the Itemizer Bit Tax Table of the Radiant CR settings. For more information, see Configuring Additional Taxes Settings for NCR Radiant CR.
The Sales report contains the following data:
- Date: Business date from the shift.
- Clocation: CStoreOffice® location name.
- Sold To: The number of the company to which the location belongs.
- Ship To: The location's GL#1.
- Category ID: The category number.
- Category Name: The name of the category.
- Global Subcategory: The number of the Global SubCategory tag. Root tag to use will be a configurable parameter of the report.
- Material Code: The External Number field's value of the Global SubCategory tag or the GL # field's value of the corresponding category. For more information on how to configure material codes for GSAP reports, see Configuring Material Code Settings.
- Net Sales: Sales by items taken from shifts The sales data is grouped by the Material Code (External Number) and Clocation values. The Total Sales - incl tax value is calculated by the following formula:
- Tax Amount: Sales taxes by items, taken from POS Journal documents (PJRs). The sales taxes data is grouped by the Material Code and Clocation values. The Tax Amount value is calculated by the following formula:
- Item Text: The report line's alias. The default value for the Sales report is CR_Sales.
You can check the company number in the company form. From the CStoreOffice® main page, go to Settings > Tags > Companies > select your company > click Edit. The example of the Demo LLC company's number is displayed in the image below.
You can check the category number and name in the category form. From the CStoreOffice® main page, go to Price Book > Categories > select your category > click View. The example of the Juices category's number and name is displayed in the image below.
