Report Menu
Overview of Report Menu
The Report menu provides a collection of analytical and financial reports related to consignment sales, stock balances, payment status, and operational performance within the VMI (Vendor Managed Inventory) system. Users can quickly review sales figures, stock movement, payment information, and branch performance in a centralized location.
All reports support Export to Excel (.xlsx) for further analysis outside the system.
📊 Report Menu List
1
Credit Inventory
Displays current consignment stock balance per branch
2
Credit Inventory (Old Version)
Legacy version of stock balance report
3
Sale By Month
Shows monthly consignment sales summary
4
Sale By Month (Old Version)
Legacy version of monthly sales report
5
Sale By Date
Daily sales report by selected date range
6
Sale By Date (Old Version)
Legacy version of daily sales report
7
Payment
Shows payment transactions from Villa Market to the supplier
8
Billing Detail
Displays detailed billing documents for each settlement cycle
9
Contract / Invoice
Shows contract information and linked invoices
10
Promotion Contract Sales
Reports sales based on promotion contracts
11
QR Code Promotion Sales
Displays sales results from QR Code promotions
12
Payment Suspend List
Shows documents temporarily suspended from payment
13
DC PO Monitor
Monitors Purchase Order (PO) status issued by Distribution Center (DC)
14
DC SO Monitor
Monitors Sales Order (SO) status issued by Distribution Center (DC)
15
Store Delete Summary
Summary of deleted sales transactions at branch level
16
Service Level
Displays service level performance of each branch
💡 Usage Recommendations
Choose a short date range when possible to improve report loading speed
Use Export to Excel for deep analysis and pivot tables
Refresh the report before exporting to ensure real-time accuracy
Combine with Input Consign data for full stock + sales monitoring
📘 Summary
The Report menu serves as a centralized dashboard for all analytical data in the VMI system. Suppliers and Villa Market teams can review stock levels, sales performance, payment status, and service efficiency all in one place.
✔ Suitable for accounting teams ✔ Suitable for purchasing and replenishment planning ✔ Useful for supplier audits and monthly settlement ✔ Exportable data for business analysis
Last updated