You’re offline. This is a read only version of the page.
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
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.
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. :-(
Thanks Mariano - another way to skin this cat. Then Rachel you can run it out to Excel thru the Options.
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.
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
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.
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.
The Purchases Account No isn't an option for me in the Payables smart list columns.
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
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;
Hope this helps,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (