web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Check remittances
Microsoft Dynamics GP (Archived)

Check remittances

(0) ShareShare
ReportReport
Posted on by gpro77 55

How does one reproduce in detail a remittance advice for a check?  This is to include all credit memos applied to invoices being paid on the check.  I find that in looking back at a check - all i can find is the net amount on invoices being paid but no visiblilty on credit memos used. 

*This post is locked for comments

I have the same question (0)
  • Bradley Gehrls Profile Picture
    Bradley Gehrls on at
    Re: Check remittances

    Hello,

    Thank you for using Microsoft Online Communities.  I understand that you would like to reproduce the information that would show on a Check stub when paying off an invoice.  You would like to see what credit memos that are applied to the invoices.

    When you go through the check printing process there are records in the PM20100 table that are stored in this table until a check is printed.  This information will print on the remittance even if the invoices were not paid off by this check.  There is a print previously unprinted checkbox in the select check window.   What this will do is print any lines where a credit memo, manual payment or return was applied but not print anywhere.

    Once the check has been printed and posted the documents move to history or the PM30300 table, this is the list of apply records.  The issue that we run into with trying to create a report to show all credit memos that were applied to invoices and all invoices that were applied to a payment is there could be a many to many relationship.

    The voucher number in this table is the number for your credit document (payment, credit memo and return).  The apply to voucher number would be the invoice.  So depending on which way you search this table if you are looking what is applied to the payment you will get the results of invoices applied to that payment.  If you search by invoice number then you will get the results of credit documents that are applied to it.  Since the table is like this you would not be able to print but all the invoices that were paid off by a check and then a list of credit memos that were applied to those invoices.

    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

    social.microsoft.com/.../threads

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

  • iruser Profile Picture
    iruser 527 on at
    Re: Check remittances

    in GP 2010 using smartlist builder

    product = msft dynamics

    series = purchasing

    add table PM Apply to History File

    add table PM Paid Transaction History file

    link the two tables together using

    document type and voucher number (GP made these suggestions on its own)

    You can then select the fields you need.

    I have

    apply to document number

    apply to document date

    originating applied amount

    off apply to history table

    and

    vendor

    document dae

    document number

    off the transaction history table

  • gpro77 Profile Picture
    gpro77 55 on at
    Re: Check remittances

    Can you please explain the method?

  • iruser Profile Picture
    iruser 527 on at
    Re: Check remittances

    realizing this is an old question - i have just used smart list builder to create a query against the two tables noted to get the list of invoices that was paid on the cheque.

    Ian

  • callen Profile Picture
    callen 4,595 on at
    Re: Check remittances

    There is no native way to reproduce that information. You would need to create a report using the tables: PM30200 and PM30300.

    PM30300 has the apply to information. Depending upon what you need in the report, you may be able to get by with just PM30300.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans