The Sales and Prime Cost Category Report shows sales and cost of goods sold (COGS) by GL special category. It contains actual and budgeted amounts for each location, business date, and category.
Column reference
| Column | Type | Description |
|---|---|---|
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| location_id | VARCHAR | Location identifier the GL activity or budget is attributed to |
| business_date | DATE | GL transaction date for actual amounts, or budget date for budget amounts |
| operational_year | NUMBER(4,0) | Fiscal year from the 4-4-5 calendar |
| operational_period | NUMBER(2,0) | Fiscal period number (1-12) from the 4-4-5 calendar |
| operational_week | NUMBER(17,0) | Fiscal week number from the 4-4-5 calendar |
| category_name | VARCHAR | GL special category name without the "Sales - " or "COGS - " prefix, for example Food, Liquor, Beer, Wine, N/A Beverage, Retail/Other, or General |
| sales_category_number | NUMBER(38,0) | GL special category number of the sales side (1010-1075). Blank when the row has no actual sales. Rows that carry only a budget have no number. |
| cogs_category_number | NUMBER(38,0) | GL special category number of the COGS side (710-750). Blank when the row has no actual COGS. Rows that carry only a budget have no number. |
| sales | NUMBER(38,2) | Actual sales: credits minus debits on GL special categories 1010-1075 |
| cogs | NUMBER(38,4) | Actual COGS: debits minus credits on GL special categories 710-750 |
| sales_budget | NUMBER(38,2) | Budgeted sales from the reporting budget (GL special categories 1010, 1015, 1020, 1025, 1030, 1035, 1050, and 1075): credits minus debits. Zero for tenants without budget migration enabled. |
| cogs_budget | NUMBER(38,2) | Budgeted COGS from the reporting budget (GL special categories 710-750): debits minus credits. Zero for tenants without budget migration enabled. |