Consumption report for a period with Variance Cost (batches and transfers)

Consumption_report_for_a_period_with_Variance_Cost__batches_and_transfer__-_icon.PNG

This report shows product consumption across a single period with separate columns for adjustments, batches, and transfers.

  • 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
    • 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
    • Batch - the movement of any batches processed
    • Transfers - any transfers of the product
    • 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).
  • Rolling stock will be displayed with a red asterisk (*)
  • 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, exporting to Excel, PDF, Word, and a print function.

more_reports_options_1.PNG

Consumption_report_for_a_period_with_Variance_Cost__batches_and_transfer__-_table.PNG

Have more questions? Submit a request

0 Comments

Article is closed for comments.