Smart List Creation, touble finding right Tables GP2010

(0) Share

Report

Posted on by Community Member

I am working on a smartlist that includes invoice date, paid date, paid amount, vendor name and checkbook ID, but I am not able to locate the proper tables that would include a common value to link them together. My first assumption that there was a basic report already made like this in GP2010, but it was brought to my attention that there wasn't. If there is a report in GP2010 already that I may have over looked that includes the columns that I need please let me know.

Thank you in advance.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Check out Victoria Yudin's blog. www.victoriayudin.com. I'm sure she has a SQL view created to give you what you need.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
I guess this is what you are looking for,

SQL view to show AP apply information in GP

SQL view for all posted Payables payments in Dynamics GP

SQL view for Payables payment apply detail in GP

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Frank & Mahmoud for the help. They both helpped alot. For some reason the Doc Date,Post Date,Inv paid off date is all the same. I am in search for the invoice entry date to be added on.

Thanks

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

What you are looking for is usually stored under "created date" field. Although, not all Dynamics GP tables have this field.

As for your case, PM20000 and PM30200, you can get make use of the Dex_Row_TS field (Dex Row Time Stamp), it has the date on which the record has been thrown on the database level.

Was this reply helpful? Yes No