Historical Stock Balance Report

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

Filters

1. 'Select All' branches (belong to 1 Company) or 1 Branch(es)
2. Enter date of balance to be calculated.
3. If you have the item code, enter a specific one or a range or leave it blank to view all the items codes.
4. Select Item Category and tick the checkbox.
5. Choose status of items that are to be listed
6. Choose Item type
7. Chose options whether to include positive / zero / negative balance

Result Set

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.

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)