Microsoft Dynamics GP (Archived)

viewing saved payments in Dynamics GP-2013

(0) Share

Report

Posted on by zulfi721

How can i view the saved payments in Dynamics GP-2013

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

SmartList; assuming this is a payment in Purchasing the Payables Transaction SmartList Object which can be filtered by Document Type = Payment.

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

Hi Ian,

thx for the reply.....

but in the smart list it is showing me only posted transaction and history vouchers.

thats why i posted the question over.so kindly suggest some way .

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

The Payables Transactions SmartList shows all transactions unless you define a search definition which excludes some.

Are you only seeing 1,000 records being returned? If so use the Search button and increase the number of records in the bottom left corner.

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

this is the search criteria used by me....

and it is showing me only staus of posted and history PAYMENT vouchers....

i want to view the saved vouchers only

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

another criteria used by me but report shows no unposted voucher..

Infact there are saved payment vouchers

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Zulfi,

Remove the voucher number condition and just use one search which is unposted and try again.

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

Remove the Voucher Number search definition and add one for Document Type = Payment.

Was this reply helpful? Yes No
Suggested answer

Justin Thorp 2,265 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

is there any other way to view the saved payments in Dynamics GP-2013....

As iam not familiar with SQL

Was this reply helpful? Yes No