Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Printing payables check stub

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

When a Credit Memo exists to reduce the invoice totals, there is the option to selectively apply the credit memo to a specific invoice. This may be done during the entry of an invoice, if the credit memo existed at that time, OR the credit memo may be applied to one of the outstanding invoices afterwards, using the 'Apply Payables Documents' option.

But if neither of these options were selected, (meaning the credit memo was not specifically applied to a given invoice), the payables application automatically applies that credit memo to the first available invoice, reducing that invoice amount to show the net amount of that invoice, as part of the check amount.

My customers do not like the idea of Dynamics automatically applying the credit memo to an arbitrary invoice, and would prefer that the original Invoice amounts and the original amount of the credit memos be shown on the check stub, with the running, cumulative total, which will net out to the sum of the invoices and the reduction of that amount by the credit amount.

This logic is often based on the fact that more often than not, the credit memo arrives, AFTER the original invoice has been paid, and the arbitrary selection of any available invoice, does not serve any purpose, other than to confuse the vendor.

Does anyone have a way to ensure the original amounts of the documents are listed on the stub, including the amount of the credit note, w/o the reduction of an invoice?

thanks for your suggestions & comments.

deesom.

 

*This post is locked for comments

  • Re: Printing payables check stub

    Hello,

    Thank you for the update.  I understand that you invoices and credit memos that are in history are printing on your checks.  If the credit memo and invoice were fully applied and moved to history since the last time you printed a check for this vendor they would show on the check stub if you have the Print Previously Applied Documents checkbox marked in the Select Payables Checks window.  This will default from the Payables Setup window.  With this checkbox marked the system will print anything that was applied and moved to history that was not printed already.  The records for this are held in the PM20100 table.  If you unmark this checkbox you will not see these show on the stub.

    If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    community.dynamics.com/.../default.aspx

    This posting is provided AS IS with no warranties, and confers no rights

  • Rita C. Profile Picture
    Rita C. 820 on at
    Re: Printing payables check stub

    Brad,

    The credit memos and invoices that are printing on my check stub that shouldn't be are HISTORICAL.  

    Let me know what you think.

    Thank you

    Rita

  • Rita C. Profile Picture
    Rita C. 820 on at
    Re: Printing payables check stub

    Thank you Brad for your assistance.  I have confirmed in SQL that my check stub is set to 1 which equals invoices only.  However, I'm still getting credit memos on my check stub.

    Is there anything else that you can think of that may be the cause of this?

    Thank you

    Rita

  • Re: Printing payables check stub

    Hello Rita,

    Thank you for the update.  I understand that you have it setup to show invoices only but the credit memos are still showing on the check stub.  You are wondering if there is a table that you can check to verify the setting is correct for this field.  

    The table is the PM40100 and the field is the Check_Stub_Default

    This field contains the default check stub format to use when creating checks.

    Field values:

    1 = Invoices Only

    2 = All Documents

    3 = Applied Order

    4 = Totals Only

    If you have invoices only it should only show the invoices being paid by this payment.  You could try toggling the dropdown menu and then saving and switching it back.

    If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    community.dynamics.com/.../default.aspx

    This posting is provided AS IS with no warranties, and confers no rights

  • Rita C. Profile Picture
    Rita C. 820 on at
    Re: Printing payables check stub

    Brad I was wondering if you could shed some light on an issue I'm having with credit memos and check stubs.  

    I have my set up to be Invoices Only and I've unchecked the Print Previously Applied Documents box.  I only want the invoices that are being paid to appear on my check stub.  This was working properly until this week.  Even with the setting correct, my check stubs are showing credit memos.  What could be wrong?  Is there a table I can look at that maybe my settings are correct in GP, but not the table?

    Any suggestions would be greatly appreciated.

    Thank you

    Rita

  • Re: Printing payables check stub

    Hello Deesom,

    Thank you for the update.  I am glad to hear that this information was helpful for you.  If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    community.dynamics.com/.../default.aspx 

    This posting is provided AS IS with no warranties, and confers no rights

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Printing payables check stub

    Brad: Thank you for taking the time to answer my question about the payables check stub. I do appreciate the details.

    It is the response in your very last paragraph that was of interest to me, and unfortunately, it does not seem possible to list the original amounts of the invoices sans credit note reductions.

    This would leave to believe that it would be possible to give the customer (my client) what he/she wants, by simply modifying the Check Stub, using Report Writer.

    Thank you once again for your help. Should I need further assistance, I will certainly get back to this forum.

    With much regards,

    Deesom.

  • Re: Printing payables check stub

    Hello,

    Thank you for using Microsoft Online Communities.  I understand that you have some questions about showing the credit memos that are applied to invoices that are being included in a check run.  

    I would like to step back and explain how GP will automatically apply credit memos to invoices.  There is a setting in the Payables Setup window to Apply by Document Date or Due date.  Depending on the option that is selected the system will either look at the oldest invoices that are included in the check run and apply the invoice to those documents.  If you have by due date the system will look at the invoices that are most past due and apply the credit memo to those invoices in the check run.

    If they do not want these invoices automatically applied when they process a check make sure to uncheck the Automatically Apply Existing Unapplied in the Payables Select Checks window.

    To answer your question about displaying documents on the check stub there is a drop down in the payables setup window or the payables select checks window to List Documents.  Based on the selection you make for this drop down will determine what is shown on the check stub.  The Print Previously Applied Documents checkbox will print anything that was applied but not printed since the last time a check was printed for this vendor.

    You are wondering if there is a way to print the original amount of the invoice on the stub.  The documents that are listed on the stub come from them PM20100 table.  There is no document amount in this table, the only amounts are the apply amounts.  This would then be the difference if there is a credit memo applied to the invoice.  Since the system uses temp tables to process checks there is not a way that I could see how to  pull the original amount.

    If you have any other questions please let me know.

    Best regards,

    Brad G

    Microsoft Dynamics GP

    We hope you get value from our new forums platform! Tell us what you think

    community.dynamics.com/.../default.aspx

    This posting is provided AS IS with no warranties, and confers no rights

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,387 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans