How to generate a list linking invoice numbers with payments?

(0) Share

Report

Posted on by rogue_mason

If I click on Sales >> Inquiry >> Transactions by Customer I can click on an individual transaction and see what document number it was linked with. For example, if click on a payment or credit memo I can then see what invoice number it is associated with.

How can I generate a list where I can easily see all of the transactions involved in a sale. For example, headings might be: Customer #, Customer Name, Invoice #, PMT #, CDT #?

Thanks. This is the first time I've used accounting software.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to generate a list linking invoice numbers with payments?

If you want an exportable list, you could create a SmartList with SmartList Builder or an Excel or SSRS report but you would need to start with a view similar to this one on Victoria Yudin's blog - victoriayudin.com/.../sql-view-with-ar-apply-detail.
Suggested answer

soma 24,406 on at

Like (0)

Report

RE: How to generate a list linking invoice numbers with payments?

You can also see the customer transactions details from the Print Receivable Statement window (MS Dynamics GP-->Tools-->Routines-->Sales-->Statements) as below.

Hope this helps!!!
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: How to generate a list linking invoice numbers with payments?

On the inquiry level, this is what you can track few records at a time, For instance, you go to transaction by customer to drill down to specific document number (invoice, for example), then you click on the apply button to check the payment numbers applied to this specific invoice. As shown below;

You still have many other methods, like the reports. Go to Reports > Sales > Trial Balance. Printing the Historical Aged Trial Balance, or the Aged Trial Balance provides the same details mentioned above, as shown below;

You could check the document along with the other applied transactions,

Your feedback is highly appreciated,