Hi,
I need to have a report on the vendor / item as per the below table / format for a specific period.
I tried with the Vendor/Item statists report , here I can have only the receipts for the period with value /amount..
From : 01-01-2020 To : 31-08-2020
Vendor Account : VEND00001 Vendor Name : Ace Suppliers
| Item No |
Opening Stock |
Receipt |
Closing Stock |
Value / amount |
| Item A |
10 |
12 |
5 |
110 |
| Item B |
3 |
5 |
7 |
1234 |