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)

Stock Valuation - Detail

Stock Valuation - Summary

Stock Variation

Adjusting Transfer Items by Date

Receiving Transfer Items by Date

Stock Transfer Items by Date

Transfer Reconciliation

Stock Requisition

Stock Take List

Slow Moving Items

Stock Movement

Note - Some Inventory reports are static, and the results are based on the last stocktake for the period selected under the Inventory reporting menu.

Inventory Snapshots described in more detail:

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

Stock Valuation - Detail

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

Stock Valuation - Summary

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

Stock Variation

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

Adjusting Transfer Items by Date

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

Receiving Transfer Items by Date

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

Stock Transfer Items by Date

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

Transfer Reconciliation

Selected Location

Related Location

Credits

Debits

Stock Requisition

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

Stock Take List

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

Slow Moving Items

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

Stock Movement

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


Did this answer your question?