The Waste report contains only the 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 Waste 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.
- Amount: The amount of write-offs by items. The amount of write-offs data is grouped by the Material Code (External Number) and Clocation values and calculated by the following formula:
- Item Text: The report line's alias. The default value for the Waste report is CR_Waste.
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.
, where:
- Cost: Cost of item write-offs for the reported period.
- Quantity: The number of items in write-offs for the reported period.
