...
| 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 | 510 | 70 | 100 | 110 | 5501100 | 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 | 510 | 70 | 100 | 110 | 5501100 | 900 | 90 | 200 | 1100 | 05/03/13 |
Generating the SBR-05 on 11th May 2013
With filter setting date: 11th May 2013
| 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 | 9 | 70 | 100 | 110 | 990 | 790 | 87.78 | 200 | 990 | 05/03/13 |