...
Example item Test_Item has the following transactions:
| Transaction | Transaction Date | Quantity | Unit Price (Selling / buying price) | Total stock value change | Balance Quantity | MA Cost | Remark |
|---|
| | | | | | | |
| GRN 1 | 05/01/13 | 10 | 100 | 1000 | 10 | 100 | MA Cost Calculated |
| GRN 2 | 05/03/13 | 5 | 70 | 350 | 15 | 90 | MA Cost Recalculated: (100*10+70*5)/15 |
| Invoice 1 | 05/05/13 | -5 | 150 | -450 | 10 | 90 | MA Cost Remain unchanged |
| Reset MA | 05/09/13 |
5505| 10 | 110 | MA Cost is set manually from 90.00 to 110.00 . Total amount on the Reset MA is : change of unit price * total balance quantity . So for this case (110.00-90.00)*10 = 200 |
| Invoice 2 | 05/11/13 | -1 | 150 | -110 |
4Generating the SBR-05 on 2nd May 2013
With filter setting date: 1st May 2013
Only one GRN is involved.
| No | Item Code | Item Name | UOM | Qty(A) | Min Purchase price | Max Purchase Price | Curr MA (B) | Inv Value base on Curr MA (A*B) | Acc Inv Value (C) | Acc Inv Value/unit (C/A) | Reset MA (D) | Balance Sheet Inventory Value (C+D) | Last Purchase |
|---|
| 1 | Test_Item | Test_Item | unit | 10 | 100 | 100 | 100 | 1000 | 1000 | 100 | 0 | 1000 | 05/01/13 |
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)
| No | Item Code | Item Name | UOM | Qty(A) | Min Purchase price | Max Purchase Price | Curr MA (B) | Inv Value base on Curr MA (A*B) | Acc Inv Value (C) | Acc Inv Value/unit (C/A) | Reset MA (D) | Balance Sheet Inventory Value (C+D) | Last Purchase |
|---|
| 1 | Test_Item | Test_Item | unit | 10 | 100 | 100 | 90 | 900 | 1000 | 100 | 0 | 1000 | 05/01/13 |
Generating the SBR-05 on 10th May 2013
With filter setting date: 8th May 2013
Different Transactions (with movements) involved. No Reset MA Value.
| No | Item Code | Item Name | UOM | Qty(A) | Min Purchase price | Max Purchase Price | Curr MA (B) | Inv Value base on Curr MA (A*B) | Acc Inv Value (C) | Acc Inv Value/unit (C/A) | Reset MA (D) | Balance Sheet Inventory Value (C+D) | Last Purchase |
|---|
| 1 | Test_Item | Test_Item | unit | 5 | 70 | 100 | 110 | 550 | 900 | 90 | 0 | 900 | 05/03/13 |
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)
| No | Item Code | Item Name | UOM | Qty(A) | Min Purchase price | Max Purchase Price | Curr MA (B) | Inv Value base on Curr MA (A*B) | Acc Inv Value (C) | Acc Inv Value/unit (C/A) | Reset MA (D) | Balance Sheet Inventory Value (C+D) | Last Purchase |
|---|
| 1 | Test_Item | Test_Item | unit | 5 | 70 | 100 | 110 | 550 | 900 | 90 | 200 | 1100 | 05/03/13 |