How to View & Manage Product Sales in Perfect Inventory Manager

2025-06-30

๐Ÿ›’ Product Sales Management Page

โ€œTrack and manage all sales of physical products โ€” accurately and efficiently.โ€


โš ๏ธ Important Clarification

The Product Sales Management Page is a management and reporting page only .

You do not create new sales here. All actual product sales must be made from the Point of Sale (POS) Page . This page is strictly for reviewing, analyzing, exporting, printing, and following up on past sales.


๐Ÿงพ What Is Tracked as a Product Sale?

  • Medicines sold to walk-in patients
  • Over-the-counter retail product purchases
  • Any item from your inventory that was sold via POS
  • Partial or unpaid sales (e.g., part paid by insurance)
  • Cash, card, or third-party payment sales

๐Ÿ” Filters and Search Options

The dropdown filter allows you to refine your view for efficient reporting:

  • Item Filter (Default): Focus on sales records for a specific product. Selecting this activates an autocomplete search box, and the summary recalculates to show only activity for that product.
  • Customer Filter: View sales linked to a specific patient or customer. Helpful for tracking balances or purchases made by frequent buyers.
  • Date Filter: Limit results to Today, This Week, Last Month, or custom date ranges.
  • Status Filter: Show only Paid, Unpaid, or Partially Paid records.

โœ… The Summary Inventory Panel dynamically updates based on the active filters.


๐Ÿงญ What Can You Do On This Page?

Feature Description
๐Ÿ” Search Bar Search by customer name, product, or description
๐Ÿ“… Date Filters Filter sales by day, week, or month
๐Ÿงพ Balance Indicator Instantly see paid vs unpaid sales
๐Ÿ‘ค Customer Summary Track which customers owe money or have completed payments
๐Ÿ–จ๏ธ Print Bills Print or reprint past sale receipts
๐Ÿ“ค Export CSV/JSON Export for accounting, analysis, or external reports
๐Ÿ“„ Open Bill View See the full transaction including items, quantity, price, and payments

๐Ÿ“Š Summary Inventory Panel for Sales

Just like with the Income page, a summary dashboard appears when no bill is selected. In sale mode, it shows:

Metric Meaning
Number of Sales Total number of transactions within the filter range
Total Amount Sold Total value of products sold
Total Paid How much cash or card was collected
Outstanding Balances Unpaid or partially paid amounts (e.g., insurance or pending payments)

๐Ÿงฐ Example Use Case: Weekly Sales Overview

  1. Filter by: โ€œThis Weekโ€
  2. View total sales: $9,500
  3. Paid: $7,600
  4. Balance: $1,900
  5. Click a specific unpaid sale to open the full detail

๐Ÿ” Handling Returns, Barcode Scanning, and Detailed Bill Actions

๐Ÿ“ฆ 1. Returning a Previous Sale

When you open a specific sale record, the embedded page-bill component allows you to initiate returns โ€” either partially or fully.

โœ… What You Can Do:

  • Select individual items from the original sale
  • Click Return for each
  • Enter quantity being returned
  • System updates inventory automatically
  • Return appears in Timeline and Refunds section

๐Ÿงฐ Example Workflow:

  1. A patient bought 10 face masks but returns 4 because they were the wrong type.
  2. Open the Product Sales Management Page
  3. Search and click the relevant sale
  4. In the bill component, click Return on the โ€œFace Maskโ€ line
  5. Enter quantity: 4
  6. Confirm return
  7. Inventory is adjusted (+4 units)
  8. The return is logged under Refunds

๐Ÿ“ท 4. Barcode Scanning to Recall a Sale

If you have a receipt with a barcode:

  • Scan it directly in the Product Sales Management Page
  • The original sale loads instantly
  • You can view all details, process returns, or reprint/email the receipt

โœ… Perfect for high-volume pharmacies or retail environments.


๐Ÿง  Best Practices

  • Always use the return button in the bill view โ€” avoid manual stock edits
  • Use barcode scanning to speed up lookups and avoid errors
  • Run unpaid filters weekly for proactive billing follow-up
  • Add comments in the Timeline for transparency during audits