Skip to main content
Report Business Value: Store Closing report helps you see the available quantities for each item in each warehouse on the selected date of the report. Extracting the store closing report usually happens after successful store settlement in order to see the available quantities in each store and their value. How it works? Reports → BO → Inventory → Store Closing
  1. Select the date you would like to see the store closing for.
  2. Optional: you can run the report for 1 or more of your stores, otherwise the report will return all of your stores.
  3. Optional: you can run the report for certain items, leaving it blank will run the report for all your items in the selected stores.
  4. Choose the Export option you desire i.e. Excel “XLS / XLSX / ODS” or PDF.
Report Column Outcome: This report groups your items per store listed ascendingly according to their serial number. Under each store, your items are grouped according to their item group i.e. Vegetables, Canned Goods etc.
  • Item: returns the items under a certain item group and store with each item’s serial number.
  • Unit: each item has its own store unit which is represented under this column i.e. KG, Packet, Each etc.
  • Price: the price for each item based on the last entry happened for this item from the purchasing cycle “from Purchase Orders & Receiving Orders”
  • Qty “Quantity”: represents the available quantity for each item for the selected date of the report.
  • Value: represents the value of the total quantity for each item “Price * Quantity = Value”
At the end of each item group is the sum of the values of all items belonging to a certain item group. For each store there is a total summing up all values of all item groups under it to know the current money value available for each store on the report’s selected date. A Grand Total at the end of the report represents the total of all item values from all groups and stores. N.B: The default currency for this report would follow the base currency of your system.