HansaManuals Home   >> Standard ERP   >> Stock   >> Reports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.1  

Cost Price Analysis

If the Cost Price of an Item changes, there may be circumstances where you need to change the value of the examples of that Item that you hold in stock. If so, you can run the Cost Price Analysis report to see which Items are affected, before using the 'Cost Price Analysis Revaluation' Maintenance function to create a record in the Stock Revaluation register to implement the change in value. If you print the report to screen, you can activate the Maintenance function by clicking (Windows/Mac OS X) or tapping (iOS/Android) the [Stock Revaluation] text link at the top of the report. The specifications that you used when running the report will be copied to the specification window for the Maintenance function..

Item No.
Paste Special    Item register

Range Reporting    Alpha
If you need a particular Item to be included in the report, enter its Item Number here. You can also enter a range of Item Numbers separated by a colon (:). Only Stocked Items in the range will be included in the report.

Group

Paste Special    Item Group register, Sales Ledger

If you need Items belonging to a particular Item Group to be included in the report, specify that Item Group here.

%

By default, an Item will be included in the report if its Last Purchase Cost or Weighted Average (as specified below) is different to its Cost Price. If you need this difference to be at least as much as a particular percentage of the Cost Price, enter that percentage here.

The sign of the difference will be ignored. For example, if you enter "10" in this field, an Item will be included in the report if its Last Purchase Cost or the Weighted Average is 10% higher than its Cost Price or 10% lower than its Cost Price.

Comparison

To determine whether an Item will be included in the report, its Last Purchase Cost (incl. extras), its Weighted Average or its Last Purchase Cost (excl. extras) will be compared with its Cost Price to see if there is a difference. Use these options to specify which of these figures will be compared with the Cost Price.

Only with Balance

Select this option if you only need Items that are in stock to be included in the report.

For each Item, the report will display the Item Number and Name, the quantity in stock, the Cost Price, the Last Purchase Cost or Weighted Average value, the difference between the Cost Price and the Last Purchase Cost or Weighted Average expressed as a percentage of the Cost Price, and the difference itself.

When printed to screen, the Cost Price Analysis report has the Standard ERP Drill-down feature. Click (Windows/Mac OS X) or tap (iOS/Android) on any Item Number in the report to open an individual Item record

---

Reports in the Stock module:

• Introduction
  

• Aged Stock Analysis
  

• Best Before List
  

• Cost Price Analysis
  

• Credit Notes, Updating Stock
  

• Deficiency List
  

• Deficiency List per Location
  

• Delivery Journal
  

• Delivery List
  

• Goods Receipt Journal
  

• Item Group List
  

• Item History
  

• Item History per Location
  

• Item/Delivery Mode Statistics
  

• Items at Position
  

• Location List
  

• Recipe List (Made of)
  

• Returned Goods Journal
  

• Returned Goods to Supplier Journal
  

• Serial Number History
  

• Source List
  

• Stock Depreciation Journal
  

• Stock In Journal
  

• Stock List
  

• Stock List Comparison
  

• Stock Movement Journal
  

• Stock Out Journal
  

• Stock Revaluation Journal
  

• Stocktaking Comparison
  

• Stocktaking Journal
  

• Stocktaking List
  

• Supplier/Item Statistics
  

• Varieties Enquiry
  

• Varieties in Stock
  

• Weighted Average

Go back to:

• Home page for Stock module manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form