You’re offline. This is a read only version of the page.
6,825
How can i view the saved payments in Dynamics GP-2013
*This post is locked for comments
Zulfi,
Please go to the following window to activate the Smartlist Builder.
Administration >> Setup >> System >> Registration
Select Smartlist builder at the end and press ok. Log out of GP and log back and you might be prompted to run utilities and just run the same and luanch GP and you will have smartlist builder then.
Hi Zulfi,
Please confirm whether you have tried the above to see your payment not posted.
Hi Zulfi,
Please build a new smartlist the following are the instructions to follow.
1. Open the SmartList Builder window (Administration >> Setup >> SmartList Builder >> SmartList Builder).
2. Enter the SmartList ID.
3. Enter the name of the SmartList – Unposted Payments. This is the name that will be displayed in the left hand pane of the SmartLists window and at the top of the SmartList data area when the SmartList has been selected.
4. Enter the Item Name – Unposted Payments. This is the description that will be displayed in the count area of the SmartList window.
5. Select the Product that the SmartList will be grouped under select Microsoft Dynamics GP as the product, select the Series-Purchsing
6. Add tables by pressing the Plus symbol on the top and select PM Manual Payment Work File and select all fields on right side.
7. Click Save.
8. Open the SmartList window.
9. Select Yes to create the new SmartList.
10. Once you open the Smartlist it will process for new smartlist created and after that if you go Smartlist-Purchasing you can see the new smartlist title called Unposted Payments. If you go to that you can see all unposted payments.
It does return payments; there is a Microsoft default SmartList Object called Today's Payments*
Actually just tested further, and it only returns posted payments; I hadn't realised that before.
So either an Inquiry or report, or perhaps SmartList Designer to create a SmartList Object for unposted payments.
I believe the Payable Transactions smartlist only pulls from PM10000, PM20000 and PM30200 (and doesn't pull from the PM Payment Work or PM Manual Payment Work tables which are PM10300 and PM10400.
And when I save a payables payment (edit checks), and then attempt to use smartlist to view it, the payment isn't returned.
Further, capturing a SQL profiler confirms that unposted PM payments won't show in the Payables Transactions Smartlist.
So your options for viewing unposted payments:
1.) Goto the relevant batch window and print a batch/edit list.
2.) Goto the relevant transaction entry window and pull up (or browse) through the unposted documents.
3.) Use the inquiry windows
4.) Create a sql script to pull from PM10300 and/or PM10400 (...and any other table that you need).
Thanks,
Justin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (