AP batch report

(0) Share

Report

Posted on by Community Member

Good morning all,

I'd like to review all invoices entered into AP before they are posted. My AP team has been printing out the Batch, but it only shows two transactions per page and does not include the NAME of the vendor (only the vendor ID). Since the transactions aren't posted yet, I'm struggling to find a decent report that simply gives me the information, such as invoice date, vendor, description, GL accounts and amounts. It seems like a fairly easy request, I just can't figure out where to get it!

Thank you!

Lisa

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

ShawnMD 1,456 User Group Leader on at

Like (2)

Report

Lisa,

This is a very common situation - GP doesn't handle this eloquently, as you pointed out, and generates a giant report for something that should be pretty simple.

There is a 'go to' script I use that can be found on Victoria Yudin's website:

https://victoriayudin.com/2008/11/28/sql-view-to-show-all-gl-distributions-for-ap-transactions/

This gives a very simple list with distributions. Note that this SQL view includes posted and unposted so you would need to filter those out.

The easiest way to use this is to build a SmartList based on the SQL view.

Here is an example of what my results look like when using this view:

I hope that helps!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you! I will try it right now!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I feel somewhat stupid asking this question, but I've never done a "go to". Do I copy the text into a txt doc and then create a new smart list, click on GO TO and record the macro? I know it's a lot to ask, so if you can't answer, can you point me in the right direction for resources that will show me how to do this? I've done macros before, but it's been a while (about two years)!

Was this reply helpful? Yes No
Verified answer

ShawnMD 1,456 User Group Leader on at

Like (0)

Report

Sorry for the confusion - when I said 'go to' I was referring to my preferred solution... which was found at the website listed above.

That text you are referring to is a SQL Script that creates a SQL View. You will need someone (perhaps your IT department or your partner) to use that text to create the view. The view is then leveraged in the SmartList by creating a new smartlist and selecting that company view as the data source.

That is a 'high level' overview on how to do that - you should be able to discuss this with your partner or DBA internally and they can help get that done for you.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

That's exactly what they did and now I have an awesome report! Thank you.

Was this reply helpful? Yes No
ShawnMD 1,456 User Group Leader on at

Like (1)

Report

EXCELLENT!!! Glad it worked out - Victoria's scripts are top notch and super helpful!

Was this reply helpful? Yes No