RMA Stock Ledger - Period-To-Date for Merchandise Category

Query Query: 0RMA_MP01_Q0005

This report provides RMA results using Merchandise category without VAT for Period-to-Date. The report displays key figures, subtotals, and totals for all relevant-inventory related transactions for Week-to-Date (WTD in report), Month-to-Date (MTD in report), Quarter-to-Date (QTD in report), and Year-to-Date (YTD in report). All the key figures, subtotals, and totals can be seen in the chart. The report also displays calculated key ratios using the key figures and specified formulas.

Variables
Name	Technical Name
Fine RMA Fiscal Year Variant	`0P_RMA_PTDVARNT`

Name	Technical Name	Value Restriction/Calculation
Unplanned Rebates and Allowances	`0RMA_MP01_RK_0070`	`0RMA_MP01_CK_0002` (Cost value) restricted to `UPREB`
Planned Rebate Variances	`0RMA_MP01_RK_0071`	`0RMA_MP01_CK_0002` (Cost value) restricted to `PLREB`
Price Differences	`0RMA_MP01_RK_0072`	`0RMA_MP01_CK_0002` (Cost value) restricted to `PRDIFF`
Gross Cost of Goods Sold	`0RMA_MP01_CK_0065`	`0RMA_MP01_CK_0166` (Cost complement % (excluding VAT)) * `0RMA_MP01_CK_0019` (Total Retail Reductions/ excluding VAT) / 100
Other Cost of Goods Sold	`0RMA_MP01_RK_0073`	`0RMA_MP01_CK_0002` (Cost value) restricted to `OCOGS`
Available for Sale Inventory	`0RMA_MP01_CK_0017`	Beginning Inventory + Reclassifications + Net Goods Receipts + Net Stock Transfers + Manual Adjustments + Markups + Price Differences – Planned Rebate Variances – Unplanned Rebates and Allowances
Cost of Goods Sold	`0RMA_MP01_CK_002`0	Gross Cost of Goods Sold – Other Cost of Goods Sold