Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

SL Accounts Payable

Posted on by Microsoft Employee

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. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL Accounts Payable

    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.

  • Suggested answer
    Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: SL Accounts Payable

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans