Question Status

Unanswered
gpro77 asked a question on 23 Jun 2008 1:33 PM

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. 

Reply
callen responded on 26 Jun 2008 6:49 PM

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.

Reply
iruser responded on 19 Jun 2012 8:04 AM

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

Reply
gpro77 responded on 19 Jun 2012 8:16 AM

Can you please explain the method?

Reply
iruser responded on 19 Jun 2012 11:08 AM

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

Reply
Bradley Gehrls responded on 13 Sep 2012 12:29 PM

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

Reply