Product Return Report

Product Return Report

The Return menu is used to review all products that have been returned from Villa Market back to the Supplier. This usually occurs when the product cannot be sold—for example:

• Expired products

• Damaged items

• Packaging defects

• Supplier requests product removal

• Product recalled or discontinued

This module helps suppliers track return progress and download official documents for accounting and inventory purposes.

---

🔹 Purpose of the Return Menu

• View all consignment product return records

• Check the status of each return (Pending return / Completed return)

• Print return documents for verification

• Export return history for accounting or internal analysis

• Track cross-department workflow between Supplier and Villa Market

---

🔹 How to Access the Return Report

1. Log in to the VMI System

2. Navigate to: Print Form → Return

3. The Return Report screen will appear

Steps to view return records:

1. Select Start Date – End Date (Filter the period you want to review)

2. Select Supplier

3. Sort data using the Sort By dropdown:

   • Date

   • Branch

   • Return Document No.

4. Select Status:

   • 🟡 Pending Return – The return process is not completed yet

   • 🟢 Completed – Villa Market has finished the return process

5. Click Query to show all matching records

---

🔹 Additional Functions

🖨️ Print

Download and print the official return form for record-keeping.

📤 Export to Excel

Export all return records in .xlsx format for further analysis or accounting usage.

---

🔹 Table Column Descriptions

Column	Description
No. / Select / Branch	Displays branch code where the return request was created
Branch Name	Full branch name
Return No.	Reference number of the return document
Return Date	Date Villa Market confirmed the return
Full Return Date	Date the entire return process was completed
Returned / Printed	Shows processing status and whether the document has been printed
PO No.	Purchase Order number linked to the return

---

🔹 Benefits of the Return Menu

✅ Suppliers can easily track all return operations ✅ Reduces errors in monitoring product return status ✅ All return documents are clearly stored and accessible ✅ Helps analyze product return trends and improve product quality ✅ Supports accounting and audit processes

---

💡 Notes

• Selecting a very long date range may slow down data loading

• It is recommended to limit search periods for faster results

• Only authorized suppliers can view return records related to their products

---