Historical Stock Balance Report

Report >> Stock Report >> SBR-05 Historical Stock Balance

Filters

1. Location : Select All location that belong to 1 Company (included the STOCK TRANSFER LOCATION)
2. Date : Enter date of balance to be calculated.
3. Item Code Fuzzy Search : leave it blank to view all the items codes (for Total) or If you have the item code, enter a specific item
4. Item Code :  leave it blank to view all the items codes (for Total) or If you have the item code, enter a specific item code range
5. Item Category : leave it un-select (for Total) or Select Item Category and tick the checkbox (If want to view particular category stock value) 
6. Status: ALL (if you want to get the listing compare with the Balance Sheet "inventory" glcode)
7. Type: Choose Item type, when necessary
8. Group By : alloy to tick for 2 levels
9. Order By: Item Name or Item Code
10. Option: Chose options whether to include positive / zero / negative balance (by default Select ALL)
11. Transaction Type (Optional) : Deselect ALL for view all result

1. No : Numbering of item in the list
2. Item Code : Show Item Code that matches the filter Setting
3. Item Name : Show Item Name
4. UOM : Show Unit Of Measurement
5. Qty(A) : Show historical stock quantity of the item on the selected date
6. Min Purchase Price : Minimum GRN Price
7. Max Purchase Price : Maximum GRN Price
8. Curr MA (B) : Moveing Average of the item on the day the report is generated.
9. Inv Value base on Curr MA (A*B) : As described it is the multiplication of A and B . It takes the historical quantity and multiply with current MA Cost. It gives a total value of the historical stock based on current MA.
10. Acc Inv Value(C) : This is the historical stock balance based on the stock / inventory movement.
11. Acc Inv Value/unit (C/A) : This Value gives an item unit price based on Historical Accounting Value and Historical Stock Quantity
12. Reset MA (D) : Any Cost Adjustment done on the item will be listed here
13. Balance Sheet Inventory Value(C+D) : This is combination of Movement and Reset MA amount - which gives the actual value of stock on the selected day.
14. Last Purchase : Latest GRN date

Miscellaneous Information:

• Acc Inv Value/unit(C/A) is NOT same as Curr MA (B)
• Reset MA does not have any Stock Movement. Hence Acc Inv Value(C) which is based on movement - does not include the Reset MA amount.
• Balance Sheet Inventory Value(C+D) is comparable to the Balance Sheet Inventory GL Value.
• SBR-05 Historical Stock Balance does not take note of stock movement of Internal Stock Transfer, since the Stock Transfer does not affect the Company Stock Value in any manner.
• Calculation on Acc Inv Value/unit(C/A), refer to https://wavelet.atlassian.net/wiki/display/WMS/How+to+retrieve+Closing+Stock+Balance+on+a+particular+date

Example:

Example item Test_Item has the following transactions:

Generating the SBR-05 on 2nd May 2013
With filter setting date: 1st May 2013
Only one GRN is involved.

Generating the SBR-05 on 8th May 2013
With filter setting date: 1st May 2013
Only GRN is involved. However different GRN unit price caused current MA to affect Inv Value base on Curr MA (A*B)

Generating the SBR-05 on 10th May 2013
With filter setting date: 8th May 2013
Different Transactions (with movements) involved. No Reset MA Value.

Generating the SBR-05 on 10th May 2013
With filter setting date: 9th May 2013
Transactions with Movement (Invoice & GRN) along with Reset MA (No movement - not effecting Acc Inv Value)