Inventory Report (Reference)

Article Details

Summary

The Inventory Report shows retail inventory for a past or current date.

What This Does

Reporting and Location Access

Reports in Gingr use location-based reporting. Gingr calculates results from the locations you select in the report. Each report's location label decides how it calculates results.

You can only pick locations in the user's Allowed Locations. If a location does not show as an option, check the user's location access before you run the report.

Where to Find It

Go to Book Icon » Reports » Inventory Report.

Report Parameters

Setting Description
As of Date Choose a date to see current or past inventory for all retail items on that date.
Location Select the locations you want to see data for.
Export to Excel? Select this to export and download the report data to an Excel file.

Report Output

Inventory table with item details.

Column Description
Item The name of the retail item.
Stock on Date The number of items in stock on the date. If no inventory amount is entered for the item, the report shows "Not Available".
Wholesale Cost The wholesale cost of one item. Set it for each item on the Admin » Retail page. If no wholesale cost is entered, the report shows "Unknown".
Total Value The wholesale cost multiplied by the number of items in stock on the date.
Last Action The last action for the item. It can be a sale, an inventory addition, or an inventory deduction.
Last Action Date The date of the last action.

Tips

  • If no wholesale cost is entered for an item, the Total Value uses $0.00.
  • Select any top-level column header to sort the table.

Export and Print the Report

To get a PDF, generate the report and select the green Export to PDF button at the top of the report. To export a CSV file, select Export to Excel? in the report parameters before you generate the report.

Inventory report page with export options.

Related Articles

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.