Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

(0) Share

Report

Posted on by Community Member

Which report would I use to get results that include purchases by account numbers (financial) but also show each invoice (purchasing)? Here is a modified result from that report:

Loc	Code	GP GL	Inv Date	Invoice #	Vendor	Amt
71	7570	01-80-71-7570	03/31/13		Batesville Casket Co Inc	39.50
72	7570	01-80-72-7570	01/28/13	72-41457	Modern Press	342.47
72	7570	01-80-72-7570	03/31/13		Batesville Casket Co Inc	79.00
73	7570	01-80-73-7570	03/31/13		Batesville Casket Co Inc	26.34
74	7570	01-80-74-7570	02/11/13	82-8300043236	Fedex	99.40
74	7570	01-80-74-7570	03/11/13	74-20715	Belmont Business Systems	250.12
74	7570	01-80-74-7570	03/11/13	74-20714	Belmont Business Systems	325.70
74	7570	01-80-74-7570	03/31/13		Batesville Casket Co Inc	188.00

*This post is locked for comments

All responses (16)

Answers (0)

Steve Baldasti 325 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

Depending on how an A/P department keys in transactions. We use Invoice Date so that's the date that shows up in our GL.
Victoria Yudin 22,768 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

I believe the problem with using both the GL Trial Balance and the Account Transactions SmartList for this is that they will not show the Invoice Date, which was one of the fields that Rachel originally asked for. :-(
Steve Baldasti 325 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

Thanks Mariano - another way to skin this cat. Then Rachel you can run it out to Excel thru the Options.
Mariano Gomez 26,225 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

You can accomplish this by using a simple GL trial balance. You can choose to run it by segment, in which case you are going to select segment 7570. The Originating Master Name and Originating Document Numbers are now a standard part of this report.

To run the GL Trial Balance Detail, select Financial | Reports | Trial Balance.
Steve Baldasti 325 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

Rachel I'm thinking you're a user not a programmer. I relooked at your request.

Did you try the SL

Financial

Account Transaction option.

This may work depending on your system setup
Suggested answer

Victoria Yudin 22,768 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

Hi Rachel,

There is nothing like what you're asking for out-of-the-box in GP. If you have SmartList Builder, you can create a custom SmartList for this using code from my blog, as Mahmoud suggested. Here is the post with this code: victoriayudin.com/.../sql-view-to-show-all-gl-distributions-for-ap-transactions.
Steve Baldasti 325 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

It maybe already be part of your Column list? If a column isn't on the listing then it's part of the search. That's my experience.
Community Member on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

The Purchases Account No isn't an option for me in the Payables smart list columns.
Steve Baldasti 325 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

Ok try this - open SL, when you open Payables Transactions, the window opens. Click on Columns, a window opens with the preset columns. You want to add a column, See the button ADD, click it. All the Columns open.

Find Purchases Account No. Click it. Now it's part of the sort. Go to Search to fine tune your search, say by Vendor ( your not looking through all the Vendors) or Date or Acct. You get the list you can send to Excel or Word. You like what you see then you can save by going to Favorites
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Which report do I use to show both financial gl account numbers and purchasing invoice and vendor information

Smart List Option

The Payable Transactions Smart list shows all the payable transactions including the following types (Invoice, Finance Charge, Misc Charge, Return and Credit Memo). By default, the smart list shows basic columns, you could add the associated GL Accounts from the "Columns Button", add the corresponding "Amount" fields to retrieve this piece of information.

For drill down capabilities (In order to dig for further details for a specific transaction), you could simply double click on the transaction and then go to "Distribution" in order to check the GL entries made by the selected transaction.

For customized Payable Transaction Views, you could check Ms. Victoria Yudin blog as she has provided several useful customized payable views on the link below;

Payable SQL Views

Hope this helps,