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.
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.
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.
Can you please explain the method?
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.
apply to document number
apply to document date
originating applied amount
off apply to history table
off the transaction history table
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.
Microsoft Dynamics GP
We hope you get value from our new forums platform! Tell us what you think
This posting is provided AS IS with no warranties, and confers no rights