Is there a way to export Reference Numbers and Vendor Ids for a certain batch into an excel sheet? The goal is to have the reference number in a column next to the Vendor Id associated with it, then have them sorted by Vendor Id. I currently copy and paste from the Voucher and Adjustment Entry page and hit F3 in the reference number tab.
*This post is locked for comments
Because SL uses a SQL database, setup of an ODBC connection to query the database and return that data to Excel have been an option for years. This was the case even back when Btrieve databases were in use. This method of retrieving data wasn't used by many SL customers, since a basic understanding of where the data was maintained in the database was required. Quick Query makes the process of retrieving selected data much easier for the average user without needing to know the underlying database.
If you are in SL 2011 or above, there is a Quick Query called AP Documents that you could filter down to the batch number of interest.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (