Detailed TB (Vendor/Customer) - Navision 4.0

ac-clara

Hi,

I am new to Navision (and so may be missing something right under my nose) but I can't seem to get a simple list of outstanding invoices on the accounts payable vendors.

The only way I can think of doing it is running a detailed vendor tb, with no date filter (to prevent "opening balances") and using the remaining amount. Filtering on remaining amount does not seem to be an option. Therefore this produces a list of every invoice ever which is over 1000 pages long, even on our relatively small purchase ledger.

Saving this to html, opening in excel, tidying the mess of merged cells, deleting page headings etc.. is possible but takes ages due to the size of the file.

To get this with currency as well as local currency, so I can revalue I have to repeat twice and merge the two reports.

There has got to be a better way surely - Please tell me what it is!

Thanks

Andrew

raveendran.s

Try 'Vendor - Balance to Date' Report, This report may help you out. Still you can get it only in one currency at a time.