Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Detailed TB (Vendor/Customer) - Navision 4.0
ac-clara
Member Posts: 3
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
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
0
Comments
Regards,
Raveendran.BS