Consumption report between two periods

Consumption_report_between_two_periods_header.PNG

This is a useful report if you'd like to check consumption details over a larger period than the usual single period.

  • Use the drop-down menus to select the Section/Category/Group and periods you wish to view consumption figures for.

  • Click the View report button.
  • A table with the following columns will be displayed:
    • Product - the name of the product
    • Category - the Category and Group the product is located in
    • Pack-Size - the pack size of that product
    • Unit - the selected stock count unit for the product
    • Op Stock - the opening stock of the item
    • Purchase - the purchases of the item
    • Adj - the adjustments of the item
    • Clo Stock - the closing stock of the item
    • Actual Cons - the actual consumption of the item according to stock movement
    • EPoS - the theoretical consumption of the stock according to EPoS data and STO recipes
    • (+/-) - the variance between the actual and theoretical consumption
    • Cost - the cost of the variance between actual and theoretical consumption
  • All data in the table is shown following the unit value.
  • Negative values will be bracketed and highlighted in (red).
  • Sub-totals are displayed in GREY beneath each Group.
  • Totals for Categories are displayed in GREEN.
  • The report header contains:
    • Location
    • Report title and Period selection details
    • Period No. & Status. Username, date, and time stamp
  • The report options bar contains paging-navigation, refresh, searching, and zoom options, as well as exporting to Excel, PDF, and Word, and a print function.

more_reports_options_1.PNG

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.