Report >> Stock Report >> SBR-05 Historical Stock Balance
Filters
- 'Location : Select All ' branches (location that belong to 1 Company ) or 1 Branch(es(included the STOCK TRANSFER LOCATION)
- Date : Enter date of balance to be calculated.
- 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 one or a range or leave item
- 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
- Item Category : leave it un-select (for Total) or Select Item Category and tick the checkbox .
- Choose status of items that are to be listed
- Choose Item type
- (If want to view particular category stock value)
- Status: ALL (if you want to get the listing compare with the Balance Sheet "inventory" glcode)
- Type: Choose Item type, when necessary
- Group By : alloy to tick for 2 levels
- Order By: Item Name or Item Code
- Option: Chose options whether to include positive / zero / negative balance
...
- (by default Select ALL)
- Transaction Type (Optional) : Deselect ALL for view all result
Result Set
- No : Numbering of item in the list
- Item Code : Show Item Code that matches the filter Setting
- Item Name : Show Item Name
- UOM : Show Unit Of Measurement
- Qty(A) : Show historical stock quantity of the item on the selected date
- Min Purchase Price : Minimum GRN Price
- Max Purchase Price : Maximum GRN Price
- Curr MA (B) : Moveing Average of the item on the day the report is generated.
- 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.
- Acc Inv Value(C) : This is the historical stock balance based on the stock / inventory movement.
- Acc Inv Value/unit (C/A) : This Value gives an item unit price based on Historical Accounting Value and Historical Stock Quantity
- Reset MA (D) : Any Cost Adjustment done on the item will be listed here
- 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.
- 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:
...