|
|
Purpose
View a financial summary of stock movement transactions for each Stock Item.
How to… View financial summary of transactions per Stock Item
1. Click Material Manager - Stock Analysis - Stock Financials then 
.
The Stock Financials browse window opens.
Data fields
These data fields are displayed on the Stock Financials window.
|
Field |
Description/Setting |
|
Warehouse Code |
The Warehouse to which the Stock Item is linked. |
|
Stock Code |
The code that identifies the Stock Item. The Stock Item’ Description is displayed. |
|
Financial Period |
The financial period in the specified Financial Year to which the transaction was posted. |
|
Financial Year |
The financial year to which the transaction was posted. |
|
Opening Balance |
The number of units in the Warehouse at the start of the Financial Period. |
|
Closing Balance |
The number of units in the Warehouse at the end of the Financial Period. |
|
Opening Item Cost |
The Stock Item’s Average Item Cost at the start of the Financial Period. |
|
Closing Item Cost |
The Stock Item’s Average Item Cost at the end of the Financial Period. |
|
Opening Value |
The value of the Opening Balance (Qty on Hand) at the start of the Financial Period. |
|
Closing Value |
The value of the Closing Balance (Qty on Hand) at the end of the Financial Period. |
|
Difference in Value |
The difference between the Opening Value and the Closing Value. |
|
Quantity In |
The number of units received by the Warehouse as Receipts, Returns to Warehouse and Stock Transfers In. |
|
Quantity Out |
The number of units despatched by the Warehouse as Issues, Credit Notes and Stock Transfers Out. |
|
Quantity In Value |
The value of the Quantity In using Avg Item Cost for each transaction. |
|
Quantity Out Value |
The value of the Quantity Out. |
|
Variance Quantity |
The difference between the Quantity Out and the Quantity In. |
|
Variance Value |
The difference between the Quantity Out Value and the Quantity In Value. |
|
Receipts |
The number of units received by the Warehouse as Receipts. |
|
Receipts Value |
The value of the Receipts. |
|
Issues |
The number of units despatched by the Warehouse as Issues. |
|
Issues Value |
The value of the Issues. |
|
Returns to Warehouse |
The number of units received by the Warehouse as Returns. |
|
Returns to Warehouse Value |
The value of the Returns to Warehouse. |
|
Returns to Supplier |
The number of units despatched by the Warehouse as Credit Notes. |
|
Returns to Supplier Value |
The value of the Returns to Supplier. |
|
Transfers to Warehouse |
The number of units received by the Warehouse as Stock Transfers In. |
|
Transfers to Warehouse Value |
The value of the Transfers to Warehouse. |
|
Transfers from Warehouse |
The number of units despatched by the Warehouse Stock Transfers Out. |
|
Transfers from Warehouse Value |
The value of the Transfers from Warehouse. |
Please note!