The Sales Reports window is loaded with many rich functions even while it is easy to use and navigate.  Use the buttons on the bottom panels. It is a good practice to generate sales reports during the off-peak period or after business hours when the database is not in use by sale counters.

Some of the reports available:

• Sale performances - sale vs stock based either on vendor, barcode, description or department.
• Chose to include or exclude items with:
  • zero stock (prevent old stock from showing up)
  • items manually entered (no record in inventory during sale)
• Find quickly the balance stock of an item based on barcode using the "Balance" button. Use wildcard search by entering an asterisk before/behind a search string to report balance of similar products.
• Find quantity sold for a product in ascending/descending order by QuantitySold, Barcode or Description
• In all of the above the period - either for All Time or date-to-date - can be selected by user
• Report only on low stock items - less than a certain balance quantity specified by the user.  Chose to include or exclude manually entered sales
• Sale summary of vendors - average margin, average price, discounts, quantity sold ...
• Sale details showing rows of sold items, description, quantity sold, retail price ...
  • ordered by barcode
  • ordered by department and showing the totals of each department
  • ordered by customer no.
• Fast generate consecutive daily detailed reports ordered by aforesaid criteria
• Sale summary of the day or any previous date similar to the sale summary on pos window except there is an additional table showing the amount collected for each sale receipt and whether it has been cancelled midway or refunded. Types of payment - cash, credit card type, voucher ... - used for each and every sale are also shown.
• Search sale instances by barcode or description when a particular item was sold

This Sales Reports window had been built with multiple outlets in mind.  It is able to show all the aforesaid information for all outlets or a selected outlet by selecting either 'All Outlets' or a single outlet name from either of the the 'Outlet' drop boxes. After that just click the respective function button to generate the reports.

Such multi-outlet reporting requires the use of a central database remotely serving the outlets.  Alternatively sale and inventory data from the databases of individual outlets can be consolidated into a special database for this reporting purpose. These two capabilities are available in POSI.

 

By selecting a year from "Year" field and a quarter or month from "Quarter" field on the bottom left panel, and then using the "Submit Co." button, you can produce periodic reports that present a statistical trend on the performance of each and every item in your inventory.  This information also comes in handy for your accountant who may require an "Aging Inventory Report" for the purpose of calculating the depreciation or for writing off the value of old and un-saleable merchandise.