Demo · synthetic data (YOUR COMPANY PTY LTD) · not connected to any real business · Reload

Item Demand Forecast Tool

Upload item ledger entries to generate demand forecasts (v2.1 — Assembly Support — Demo)

Business Central connection

The demo runs on pre-loaded synthetic data — no login required.

Not connected
Or upload files manually...

Upload Item Ledger Entries

Drag & drop or click to upload Excel file (.xlsx) — supports Sales & Assembly Consumption

Upload Item List (Orders)

Excel with "No.", "Qty. on Sales Order" and "Qty. on Purch. Order"

Update Vendor Mapping (Optional)

Upload to update vendor/item data (Excel with "No." and "Vendor No." columns)

No Data Loaded

Upload an Item Ledger Entries Excel file to generate forecasts

Note on assembly-consumed items. The items listed below are consumed during in-house assembly, so their forecast method is different from a standard sales-usage forecast — the tool consolidates their ledger movements under the assembled item code. To see them, filter or search by the following item numbers:
ITEMNO1229, ITEMNO1230, ITEMNO1231, ITEMNO1232, ITEMNO1233, ITEMNO1234, ITEMNO1235, ITEMNO1236, ITEMNO1237, ITEMNO1238, ITEMNO1694, ITEMNO1695, ITEMNO1696, ITEMNO1697, ITEMNO1698, ITEMNO1699, ITEMNO1700, ITEMNO1701, ITEMNO1702, ITEMNO1703, ITEMNO6517, ITEMNO6518, ITEMNO6519, ITEMNO6520, ITEMNO6521, ITEMNO6522, ITEMNO6523, ITEMNO6524, ITEMNO6525, ITEMNO6526, ITEMNO6527, ITEMNO6528, ITEMNO6529, ITEMNO6530, ITEMNO6531, ITEMNO6532, ITEMNO6533, ITEMNO6893, ITEMNO6894, ITEMNO6896, ITEMNO6897, ITEMNO6898, ITEMNO6899, ITEMNO6900, ITEMNO6901, ITEMNO6902, ITEMNO6903, ITEMNO6904, ITEMNO6905

Container Planning (65 CBM per container)

Method:

Container Forecast Settings



To see the Container Planning table below, pick one of the following vendor numbers in the Vendor search box above — each has active items in the ledger:
VN01, VN02, VN03, VN04, VN05, VN06, VN07, VN08, VN09, VN10, VN11, VN12, VN13, VN14, VN15, VN16, VN20, VN23, VN24, VN25, VN26, VN27, VN28, VN29, VN30, VN31, VN32, VN33, VN34, VN35, VN36, VN37, VN38, VN39, VN40, VN41, VN42, VN43, VN45, VN47, VN49, VN50, VN51, VN52, VN53, VN54, VN55, VN56, VN57, VN58, VN59, VN60, VN62, VN63, VN64, VN66, VN67, VN68, VN69, VN71, VN72, VN73, VN74, VN76, VN77, VN78, VN79, VN80, VN81, VN82, VN83, VN86, VN87, VN88, VN89, VN92, VN93, VN94, VN96, VN102, VN104, VN108, VN111, VN122, VN126, VN127, VN128

Confirm Column Mapping

We detected the following columns. Please verify or adjust before processing.
Processing data... This may take a moment for large files.