Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Accounts Payable Quick Query - Need the invoice # and invoice date fields in the AP Transaction Query

Posted on by 575

A frequently used field are the vendor's invoice # and date.   That would be helpful.

  • Re: Accounts Payable Quick Query - Need the invoice # and invoice date fields in the AP Transaction Query

    Hi Laura,

    That data is not stored in the Aptran table.  The detail area does not provide for a place to input the invoice number or the invoice date.  However, the document area provides for this information, so it is stored in the APdoc table.  You could use one of the document queries.

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