Budget Report
BUDGET_REPORT
| ACTUAL_SALES_YTD | ACTUAL_MARGIN_YTD | ACTUAL_QUANTITY_YTD | ItemName | FILTER_DATE | ITEM_LEVEL_1 | ITEM_LEVEL_2 | ITEM_LEVEL_3 | ITEM_LEVEL_4 | ITEM_LEVEL_5 | ITEM_LEVEL_6 | PartyledgerName | ACTUAL_SALES_MTD | ACTUAL_QUANTITY_MTD | ACTUAL_MARGIN_MTD | monthly_multiplication | yearly_multiplication | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 11,250.00 | 582.00 | 25.00 | Canarcel 165V N | 13-05-2024 | Primary | Sample Item | Canarcel 165V N | None | None | None | Maxima Solutions | 11,250.00 | 25.00 | 582.00 | 0.42 | 0.37 |
| 1 | 225,000.00 | 11,640.00 | 500.00 | Canarcel 165V N | 14-05-2024 | Primary | Sample Item | Canarcel 165V N | None | None | None | Cheryl Laboratories Pvt Ltd | 225,000.00 | 500.00 | 11,640.00 | 0.45 | 0.37 |
| 2 | 81,250.00 | 37,500.00 | 125.00 | Innogel-9500 N | 05-06-2024 | Primary | Sample Item | Innogel-9500 N | None | None | None | Maxima Solutions | 81,250.00 | 125.00 | 37,500.00 | 0.17 | 0.43 |
| 3 | 268,750.00 | 137,500.00 | 375.00 | Innogel-9500 N | 10-06-2024 | Primary | Sample Item | Innogel-9500 N | None | None | None | Maxima Solutions | 268,750.00 | 375.00 | 137,500.00 | 0.33 | 0.44 |
| 4 | 242.00 | 242.00 | 2.00 | Sample_item_1 | 01-01-2019 | Primary | Sample_item_1 | None | None | None | None | Sales_ledger | 242.00 | 2.00 | 242.00 | 0.03 | 0.00 |
| 5 | 7,487.00 | 6,452.00 | 87.00 | Sample_item_1 | 01-04-2019 | Primary | Sample_item_1 | None | None | None | None | Sales_ledger | 1,800.00 | 40.00 | 1,800.00 | 0.03 | 0.25 |
| 6 | 7,262.00 | 6,227.00 | 82.00 | Sample_item_1 | 01-07-2019 | Primary | Sample_item_1 | None | None | None | None | Sales_ledger | -225.00 | -5.00 | -225.00 | 0.03 | 0.50 |
| 7 | 5,687.00 | 4,652.00 | 47.00 | Sample_item_1 | 31-01-2019 | Primary | Sample_item_1 | None | None | None | None | Sales_ledger | 5,687.00 | 47.00 | 4,652.00 | 1.00 | 0.08 |
| 8 | 8,107.00 | 6,566.00 | 67.00 | Sample_item_1 | 31-01-2019 | Primary | Sample_item_1 | None | None | None | None | Sundry_debtors_new2 | 8,107.00 | 67.00 | 6,566.00 | 1.00 | 0.08 |
| 9 | 234.00 | 66.00 | 3.00 | Sample_item_batch | 01-04-2019 | Master | Sample_item_batch | None | None | None | None | Sales_ledger | 234.00 | 3.00 | 66.00 | 0.03 | 0.25 |
| 10 | 624.00 | 330.00 | 8.00 | Sample_item_batch | 01-07-2019 | Master | Sample_item_batch | None | None | None | None | Sundry Creditor Purchase | 624.00 | 8.00 | 330.00 | 0.03 | 0.50 |