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 |