...
| Transaction | Transaction Date | Quantity | Unit Price Purchase / Unit Cost | Unit Price Sales | Balance Quantity | Balance Amount | MA Cost | Change in Inventory Value |
|---|---|---|---|---|---|---|---|---|
| Opening | 0 | 0 | ||||||
| GRN 1 | 05/01/13 | 10 | 100 | 10 | 1000 | 100 | 1000 | |
| GRN 2 | 05/03/13 | 5 | 70 | 15 | 1350 | 90 | 350 | |
| Invoice 1 | 05/05/13 | -5 | 90 | 150 | 10 | 900 | 90 | -450 |
| Reset MA | 05/09/13 | 10 | 110 | 10 | 1100 | 110 | 200 | |
| Invoice 2 | 05/11/13 | -1 | 110 | 150 | 9 | 990 | 110 | -110 |
NOTES:
- Please exclude GL CODE item type when user want to compare the "inventory" with Stock Flow Report
Related WIKI Pages:
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|