Topic Options
#21272 - 03/05/10 08:07 AM Export vendor list AP or GL
raja Offline
Stranger

Registered: 03/05/10
Posts: 3
Loc: montreal
Hi, is there a quick way to export a vendor list to excel? Can it be filtered by (active in the last 24 months)?

Thank you,

Raja

Top
#21274 - 03/05/10 09:12 AM Re: Export vendor list AP or GL [Re: raja]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
In Adagio Payables, when displaying the vendor grid in View Vendors, press F6 and choose the fields in the SmartFinder you want to send to Excel. Include the last invoice date as one of the fields. Then create a criteria that selects all vendors where the last invoice date is greater than March, 2008. Click the ExcelDirect button to send the resulting list to Excel.
_________________________
Andrew Bates

Top
#21275 - 03/05/10 09:45 AM Re: Export vendor list AP or GL [Re: Retired_Guy]
raja Offline
Stranger

Registered: 03/05/10
Posts: 3
Loc: montreal
this is great it works well except that it doesnt filter out the older that records!

Top
#21276 - 03/05/10 09:49 AM Re: Export vendor list AP or GL [Re: raja]
raja Offline
Stranger

Registered: 03/05/10
Posts: 3
Loc: montreal
please ignore my previous message!! i didnt click on the search button once date criteria was set!
i'm ok now, thnx it work great!

Raja

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 44 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30