Stock & Analysis Reports

21 | Cost Movements Report

This article covers an overview of the Cost Movements Report which allows for analysis of changes in Cost Price over a period of time.

This article covers an overview of the Cost Movements Report which allows for analysis of changes in Cost Price over a period of time.

Prerequisites
  • For an Operator to be able to access and run an Analysis Report within BackOffice, the Allow Analysis Reports flag within the  Reporting tab of Operator Maintenance  must first be enabled
  • If this flag is not enabled, an Operator cannot access ROIs, Cost Movements, and Other Reports


Cost Movements Accessing Cost Movements Reports
  • Complete the following steps to access ROI Reports:
    1. Log in to BackOffice
    2. From the side menu, Select "Analysis Reports" to expand the list of Available Reports
    3. Select Cost Movements Report which will open a new Cost Movements Window

Reporting Options 
  • Venue 
    • Sets the Venue for which the Cost Movements Report is generated 
  • Display Period
    • Sets the time period for which report will be generated 
      • The time can be selected either by choosing a specific Period or by choosing a particular shift
  • Suppliers
    • Sets a particular Supplier for the report 
  • Displays Products 
    • Will show the Products attached to the Individual Suppliers
  • Ignore Bonus Stock 
    • Ignores the bonus stock received while calculating price change
Report View Options 

'_Products' View 

  • This is a standard view that displays the Cost Movement from the product perspective 
  • The report contains the following fields 
 

Field

Description

Name
  • This gives the name of the Supplier
    • If 'Display Product'  is flagged on, it will list the product names instead 
Item Volume
  • This shows the volume of the product
First Cost
  • This shows the cost at which the product was bought before
Last Cost
  • This shows the new cost of the product
Cost Change Percent
  • This shows the percent change in last cost and current cost
Total Purchased Cost
  • This shows the total cost in which the product was purchased 
Purchased at Different Cost
  • This the total cost in which the product was purchased in the new transaction
Purchased Difference due to Cost Changes
  • This shows the difference in purchase cost
Supplier Code
  • This lists the Supplier Code of different suppliers

 

'_Suppliers' View 

  • This type of view displays the Cost movements from the Suppliers perspective 
  • The report contains the following fields 
 

Field

Description

Name
  • This gives the name of the Supplier
    • If 'Display Product'  is flagged on, it will list the product names instead
Cost Change Percent
  • This shows the percent change in last cost and current cost
Total Purchased Cost
  • This shows the total cost in which the product was purchased 
Purchased at Different Cost
  • This the total cost in which the product was purchased in the new transaction
Purchased Difference due to Cost Changes
  • This shows the difference in purchase cost
  • Operators can also create  Views by click on the 'View' button located in the Reporting Options