Is it possible to have this list in a report? I want to display/sort by Document number. I have tried T.Number but I am failing to get the intended results.
So far the report that I have displays all the purchases made for a certain period. I want to be able to view /filter report by Document Number-That is the Invoice Number.
This is the type of report that I want. Whenever I post a purchase I want to be able to retrieve purchases by invoice or by a supplier.
For example, let’s say I have purchased 5 products from supplier A and 5 products from supplier B. I want to be able to view the invoices/goods received voucher separately.
I have noticed that similar information is stored under Manage>Inventory>Transactions.
The only issue is that I have to hard code the Document Number. You mentioned creating a dynamic report, how do I go about creating that one? I assume a dynamic report will allow me to filter by a particular supplier without having to hardcode the names. Say I have about 25-30 suppliers and would like to filter by the supplier and list their invoices.
Right now I have hard coded these three suppliers and it works fine. Just need help on how to dynamically fill in the