To access any of the below snapshots, simply click the snapshot name to open this in your Purchase Plus account.
List of Inventory Snapshots available in Purchase Plus:
- Cost of Goods Sold (static)
-
Period End Balances - Detail (static)
-
Stock Reconciliation (static)
Note - Some Inventory reports are static, and the results are based on the last stocktake for the period selected under the Inventory reporting menu.
Cost of Goods Sold (static)
This report shows the Opening/Closing Balance, Transfer Balance, and Cost of Goods Sold (Variance) for all Stock and Expense Locations for the selected given period.
|
Location name |
|
Opening balance |
|
Transfer balance |
|
Closing balance |
|
Cost of goods sold |
Period End Balances - Detail (static)
This report displays stocktake data for the period selected at a product level by Stock locations.
|
Location name |
|
Product code |
|
Product |
|
Category |
|
Subcategory |
|
Count units |
|
Unit price |
|
balance_quantity |
|
balance_value |
Stock Reconciliation (static)
This report is the same as the Cost of Goods Sold report but with additional fields and only displays Stock Locations. The additional fields include the Direct Purchase Value, Sale Value, Transfers In/Out, and any Adjustments.
|
Location name |
|
Opening balance |
|
Direct purchase value |
|
Sale value |
|
Transfer in value |
|
Transfer out value |
|
Adjustment value |
|
Price adjustment value |
|
Variance value |
|
Closing balance |
This report displays the Stock information in each Stock and Expense location and is a live report with current data generated.
|
Location name |
|
product |
|
count by |
|
current quantity |
|
unit value |
|
balance value |
|
Product ID |
|
Category |
This report displays a summary of the Stock Valuation at each Stock and Expense location and is a live report with current data generated.
|
Location name |
|
Stock value |
This report displays the Stock Variation from a Stocktake by product and by Stock Location and is a live report with current data generated.
|
Location name |
|
product |
|
count by |
|
System count |
|
Stocktake count |
|
Variance |
|
Variance value |
This report displays any Stock Adjustments completed for a given date range. This report includes the date and the item that was adjusted.
|
Destination location |
|
origin location |
|
status |
|
Date |
|
product |
|
count by |
|
quantity |
|
unit value |
|
Value |
|
Reference |
This report displays any Stock Receipts completed for a given date range. The report contains the below fields and should match up to the Direct purchase value in the Stock Reconciliation report.
|
Destination location |
|
status |
|
Date |
|
product |
|
count by |
|
Reference |
|
Supplier name |
|
quantity |
|
unit value |
|
Value |
|
Purchase order number |
|
Invoice numbers |
|
Product ID |
|
Category |
This report displays any Direct Transfers completed for a given date range. For Internal Requisition Transfers, see the Stock Requisitions report.
|
Destination location |
|
origin location |
|
status |
|
Date |
|
product |
|
count by |
|
quantity |
|
unit value |
|
Value |
|
Product ID |
|
Category |
|
Selected Location |
|
Related Location |
|
Credits |
|
Debits |
This report displays any Internal Requisitions completed for a given date range.
|
Reference |
|
destination location |
|
origin location |
|
status |
|
Date |
|
product |
|
count by |
|
quantity |
|
unit value |
|
Value |
|
Product ID |
|
Category |
This report generates Stocktake sheets.
The Stocktake sheets can either be generated with a system expected count or with a blind count.
Note - The Excel export can not be used to import back into your Stocktake.
|
product code |
|
Location name |
|
Category |
|
product |
|
count by |
|
current quantity |
|
Stock take count |
This report shows the number of days an item in a stock location hasn’t moved. It also shows what the last transaction for that item was. The report can be filtered by 15, 30, 60, 90 days.
|
Product ID |
|
Location name |
|
product code |
|
product |
|
current quantity |
|
balance value |
|
Last transfer out date |
|
Last transfer out quantity |
|
Last transfer to |
|
Last received date |
|
Last received quantity |
|
Product subcategory |
|
Number of days |
This report is the same as the Stock Reconciliation report but at an item level and also includes Expense Locations.
|
Location |
|
Product |
|
Category |
|
Unit Value |
|
Opening Qty |
|
Purchase Qty |
|
Sale Qty |
|
Transfer In Qty |
|
Transfer Out Qty |
|
Closing Qty |
|
Cogs Qty |
|
Cogs Value |