Payables Batch Edit List

(0) Share

Report

Posted on by Community Member

I am trying to create a smart list for a payables batch edit list - so that I can review all details of a payables batch prior to posting. Information I need to have would include the batch #, doc#, doc date, vendor ID, Vendor name, Transaction description, distribution accounts...and possibly the discount amounts.

I found a video in the blogs written by Belinda Allen ... using Microsoft Query ... however ... our company does NOT have the Database set up to use in Microsoft Query at this point ... So I was trying to create something using a smart list by combining tables.

*This post is locked for comments

I have the same question (0)

All responses (40)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (1)

Report

Hi,

to build new smartlist the following are the instructions

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 PM10300 (Payment other than manual payment) and PM10400 for manual payment select all required fields on right side. Distribution account wont be available so you need to join another table by pressing the Add button again PM10100 to get that infromation. Field used to link these tables is PMNTNMBR on 10300 or 10400 & TRXSORCE on 10100.

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you I will try this!

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

Hi Babu,

Detailed Answer... :)

Can you let me know that this method of viewing unposted payments also work in case if you dont have a registered smart list builder............

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

When you upgrade to GP2013 you will have a built-in tool to create SmartLists without SmartList builder. It's an incredible enhancement for those who do not own SmartList Builder. Although it is a great tool, if you do have SmartList Builder I wouldn't even entertain the thought of giving it up in favor of the built-in tool. However, if you don't own SmartList Builder, this module is fabulous

Kind regards,

Leslie

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

Hi Leslie

Are you referring this smart list of GP-2013, shown in the screen short

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

Here's what the window looks like in GP 2013 R2. The only difference is that I have the 'ribbon bars' turned on.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Zulfi,

As suggested by Leslie you can create smartlist without the builder. Please try and let me know so that I can help you building the same.

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

Thx Babu,

Iam unable to locate the screen shot given my Leslie.........

Kindly you tell me ...........

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Zulfi,

Once you go to Smartlist you need to press new at the top left side.

Was this reply helpful? Yes No
zulfi721 on at

Like (0)

Report

Thx Babu

but if you look at my screen shot "New",Modify button are not there.......

Was this reply helpful? Yes No