Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to show document t...
Microsoft Dynamics GP (Archived)

How to show document type on AP check stub

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

I am using the check on top/bottom graphical check layout.  I need to show the document type (INV, CRM, PMT) next to the document number on the check stub to help clarify for the vendor which lines are the applied payments or credit memos.  I have added the 'Document Type' field from every table in the report and none of them print any data. 

Any ideas?

Thanks ahead of time for any help.

Julie

*This post is locked for comments

  • beth SECI Profile Picture
    beth SECI 550 on at
    RE: How to show document type on AP check stub

    Hi Vail,

      I was hoping to show the vendor account number on the check stub.  There is a spot in vendor maint. to add the vendor account number, is there a way for that to show on the check stub?

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to show document type on AP check stub

    Beth,

    Are you talking about the accounts debited on the invoice that the check is paying off?  This is a little trickier because the check reduces accounts payable, it is not really the document that generates the expense.

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to show document type on AP check stub

    Thanks Leslie!

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to show document type on AP check stub

    Use the Apply From Document Type field from the PM Payment Stub Duplicate table. The field is an integer, but you can change it to a word using a calculated field.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to show document type on AP check stub

    Hi Beth,

    Which account are you talking about?  GL account, vendor account??

  • beth SECI Profile Picture
    beth SECI 550 on at
    RE: How to show document type on AP check stub

    Not an answer, but another question.  How do we get the account number to show on the check?

    Our checks do not show the code, INV or CRM, but they do show credits in (parenthesis).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans