User Tools

Site Tools


reports_-_inventory

This is an old revision of the document!


Inventory Reports

  • This report is for quantity, not value. Qty in stock, qty sold, and so on are reported on. It does not give dollars sold
  • There are many filtering options and other report options that come into place. It is quite customizable

Multicat Report

Inventory Value Report

The inventory value report allows you to get the total, and broken out details of the value of your inventory. This is the recommended report for reporting on your inventory sub-ledger. This value should correspond to the value of your Inventory GL account (1200) if you are following the best practice methods.

How This Report Works

This report takes the First In First Out (FIFO) stock lines for each part in your system and adds up the value to calculate the value of your inventory. You can view categories with a total, or you can view detail to see the value of each inventory item within the report.

When Can The Inventory Value Report Be Used

  • This report is a relatively easy way to review the breakdown of the values of your inventory.
  • It is used at year end before and after you count your inventory.
  • It is used on a regular basis to help you reconcile your inventory.

Back Dated Inventory Value

  • This report performs a guesstimate of what the inventory value is at a previous date.
  • This report does not take into account all scenarios so it is not always correct.
  • This report should not be used for financial purposes due to its inaccuracy
  • This report does not contain details on the adjustments that make it up.
  • Note: This report was made for a customer who wanted the back dated inventory value report calculated in a particular way, and even though additional scenarios have been included, it is by no means complete.
  • In order to move forward with issues of accuracy I believe that we would have to be able to produce a report where we can drill down into the details of the changes including date/time and transaction the change occurred on.

Open To Buy Report

  • This report shows inventory value information for a category and the associated GL information for budgets from the associated GL accounts.

Back order report

  • The back order report shows information about inventory back ordered on invoices for your customers
reports_-_inventory.1425916193.txt.gz · Last modified: 2015/03/09 08:49 (9 years ago) by cliff