INVOICE & DISPATCH
Upload latest data
Update the tracker and invoice contents in two separate steps.
Checking connection…
Invoice tracker
Printed slips, dispatch ticks, Type, notes and signed paperwork for VRG01 and VRG02.
Required columns & accepted layouts
Your existing Excel workbook: keep the sheet names counter sales, A account, S account and D account. Upload one or all of these sheets. Other sheets are listed as skipped.
| Information | Counter sales · row 1 headers | A / S / D · row 2 headers |
|---|---|---|
| Invoice number / date / Type | H / G / I | G / F / H |
| VRG01 printed / dispatched / collected date | A / B / C | A / B / C |
| VRG01 status / remarks / signed slip | D / F / P | D / E / O |
| VRG02 printed / dispatched / collected date | J / K / L | I / J / K |
| VRG02 status / remarks / signed slip | O / N / Q | L / M / N |
Keep the original headers. The A-account “Time Printed” column is retained as a date only; it does not prove a print time. Final Check is calculated by Modev.
Standard CSV required headings:
invoice_number, invoice_date, type, vrg01_printed, vrg01_dispatched, vrg02_printed, vrg02_dispatched
Invoice number is required on each row. Date and Type may be blank for an expected invoice. Tick values: TRUE/FALSE, YES/NO, 1/0 or blank. Dates: DD/MM/YYYY or YYYY-MM-DD.
Optional: vrg01_collection_date, vrg02_collection_date, vrg01_status, vrg02_status, vrg01_remarks, vrg02_remarks, vrg01_slip_received, vrg02_slip_received, account_group (A, S, D or Counter sales). Omitted optional columns retain saved values.
Invoice item data
Invoice dates, item codes, descriptions, quantities and warehouses. Links to the full invoice number.
Required columns
| Your export heading | Also accepted |
|---|---|
| TxDate | invoice_date |
| Reference | invoice_number |
| Code | item_code |
| ItemDescription | item_description |
| Sum of ActQty | quantity |
| WarehouseCode | warehouse_code |
All six headings are required on row 1; descriptions may be blank. One total per invoice + item code + warehouse. Use positive quantities with a decimal point. Keep full invoice references and leading zeros.
Credits beginning VRG_CRN are counted and skipped. Warehouse codes route items to VRG01 or VRG02. Unknown warehouses need review.
Excel .xlsx and CSV · up to 30 MB · large files are processed in batches. Upload the tracker first, then the complete item export. Files refresh saved evidence; they do not establish physical stock balances.
Review upload
Recent uploads
Open a saved review to see its result or resume an interrupted save. A file still being prepared can be selected again.