Hi,
Is there a way to print a report that shows the deposits made for a month, as long as which invoices were applied to each deposit?
Thanks,
Brenda
Hi,
Is there a way to print a report that shows the deposits made for a month, as long as which invoices were applied to each deposit?
Thanks,
Brenda
Hi Brenda,
There is not a default cash receipt/deposit report that will show the invoices the payments were attached to in Dynamics GP, with the most common resource for this detail being the Inquiry | Sales | Transaction By windows.
About the closest option you have in default reporting would be the SmartList available under Sales | Sales Transactions for 'Deposits on Unposted Sales Transactions'.
Accordingly, if you have experience with SmartList Designer you should be able to build similar SmartList reporting linking the following tables:
RM20101 - RM Open File (Transactions)
RM20201 - RM Apply Open File
RM30101 - RM History File (Transactions)
RM30201 - RM Apply HIstory File
Best Regards,
Jeff
Microsoft Dynamics GP Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156