Account Payable Detail report

Hola Family

I will like to know if someone can help me, I need to know the path to run 
an Account Payable Detail report. This file should contain the lowest level 
of detail. Each record should include the General Ledger account number to 
which the transaction is being charged. I am using Dynamics GP 10 with SQL 
2005.
Thank you in advanced.

-- 
LOS
0
Utf
1/22/2010 10:35:01 PM
greatplains 29623 articles. 6 followers. Follow

1 Replies
3475 Views

Similar Articles

[PageSpeed] 15

Hola Carlos,

The GL Distribution Detail in Purchaing Posting Journal can be access via 
Reports>>Purchasing>>Posting Journals (GL GL Distribution Detail).  When you 
create/modify a  report options, you can use the ranges field (Batch, Posted 
Date, Adit Trail Code etc.) to limit the records that will be included in 
the report.

However the since this is integrated (when posted, dependin on you posting 
setup) in GL, Detailed GL Trial Balance via this path 
Reports>>Financial>>Trial Balance (Detailed) will provide similar details 
which you can use alternatively.

Hope this helps!

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008

"Carlos" <Carlos@discussions.microsoft.com> wrote in message 
news:94A135F7-8928-439F-8EEC-43BCECB6B04D@microsoft.com...
> Hola Family
>
> I will like to know if someone can help me, I need to know the path to run
> an Account Payable Detail report. This file should contain the lowest 
> level
> of detail. Each record should include the General Ledger account number to
> which the transaction is being charged. I am using Dynamics GP 10 with SQL
> 2005.
> Thank you in advanced.
>
> -- 
> LOS 

0
Dencio
1/22/2010 11:31:13 PM
Reply:

Similar Artilces:

Custom Reports in Reports not available??
2 questions... 1. I just figured out how to download the reports available. I just realized that when I go to reports in store operations manager, the custom reports option is not available. Is there a reason for this? How can I fix this? 2. I really need to do a report on customers. I need to know how much money a list of customers has spent between certain dates. I can't seem to get any of my report options to let me do all of those things at once. EX. customers that spent greater than or equal to $50 between 11/1/06 and 12/31/06 and to have it list the total sales for that time fr...

Reporting Error #3
Hi, When running CRM 4.0 reports I receive the following error in Windows Events : Web service request ListExtensions to Report Server http://ucserv:8085/reportserver/ReportService2005.asmx failed. Error: La demande a =E9chou=E9 avec l'=E9tat HTTP 404 : Not Found. thanks for your ideas. Bernard ...

Remove account from online update #2
I had two Citbank credit cards which I updated through Money(2007). I have cancelled one of the cards. How do I remove that account from the online update? TIA, Joe R In microsoft.public.money, bdog wrote: >I had two Citbank credit cards which I updated through Money(2007). I have >cancelled one of the cards. How do I remove that account from the online >update? If both the same login credentials, I would just mark the cancelled card as Closed in Money. ...

Subreport Data Listing Twice for Each Report Record
On a report & subreport pair, the subreport data is listing out twice, and I can't seem to sort out why. Any suggestions appreciated. -- Thanks, tbl tbl wrote: >On a report & subreport pair, the subreport data is listing >out twice, and I can't seem to sort out why. Does the subreport diplay two records? If so, the problem is that your main report's record source query has a Join to the subreport's data source. -- Marsh MVP [MS Access] in article bq9q83pdvsepjusn44j91g84rpveu5a9bk@4ax.com, Marshall Barton at marshbarton@wowway.com wrote on 7/5/07 1:18 PM...

how do i report a bug in excel
how do i report a bug in excel Hi Dave well if you'ld like to post here what you've found we can (probably) tell you if it is a known one already and maybe even suggest a solution or workaround. Cheers JulieD "dave" <dave@discussions.microsoft.com> wrote in message news:DF36F937-24C7-4E2C-A4FF-D743A4E9AAC0@microsoft.com... > how do i report a bug in excel Or, as is often the case, not a bug at all but "just the way things work". -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JulieD&q...

Making sub reports invesible
I have this repot that has 3 text boxes Summer Brochure Winter Brochure Skiing Brochure Which will have -1 or 0 depending if true or false I also have 3 sub reports for each brochure How can i set it to make the a subreport invesiable if one of the brochures is false 0 Thanks Simon. I think you mean you have 3 subforms... one for each of the Brochure types. Do you mean that if SummerBrochure is False, hide the SummerBrochure subform... and the same for each of the Brochure types. In the OnFormat event of the report section that contains the brochure subforms... Su...

report showing email sent
Is there any way to report on # of email sent by each user? Sounds like there's a default report that will provide this in SBS, but I'm running Exch 2K3 Std. I was hoping there was an option built into exchange, but it seems like I'll need to use a 3rd party tool. Anyone know a way to generate this type of report from Exchange? Thanks 3rd party, or write something yourself that is able to grep this information out of the message tracking logs and present it in a readable format :-) Seriously though, 3rd party is really what you need to look at for this type of reporting....

Problems with CRM 3.0 Reports
Hi, I am having problems opening reports from the web client direct from the CRM server. When i ckick reports either in My Workplace the following message occurs: Reports.config has invalid schema, and could not be loaded. Any ideas what might be the problem? Note: I have not implemented Microsoft CRM myself, but one of our partners, so I know little about the install process. Hi, If you are running sqlserver 2005, the following could help: - log on to your server - start - all programs - microsoft sql server 2005 - configuration tools - reporting services configuration - connect to...

Troubleshooting Crystal Reports in CRM
The MS-CRM Implementation Guide states that the "Please verify that you have enough Crystal licenses" message you see when Crystal Reports fails to display can be addressed with the proper user privileges. As a result of the guide's recommended resolution, I went to the CRM Server and added the following members to the "Crystal NT Users" Group: * [domain]\Domain Users * NT Authority\Authenticated Users * NT Authority\INTERACTIVE After doing so, I still receive the message. It appears that all of the Crystal Reports-related services are up and running on the C...

Money 2005 Bug: Create (not just add) account setup
Problem Description: List of banks or brokerages is *always* unavailable. Repro steps: 1) Create (not just add) new account using MS Money 2005 accepting all of the defaults. 2) Use or create a new passport to sign in. 3) Attempt to "Select a bank or brokerage" during the setup proccess and get the following error message: "The list is temporarily unavailable. Please try again later." Expected: An actual list of banks or brokerages Problem Area: Setup Frequency of problem: Always Happens Operating system / version: Microsoft Windows XP Professional - 5.1.2600 Computer ma...

customer summary report
1. I would like to print the customer summary report for all of the customers at the same time. I can print this report for one customer at a time from Inquiry>sales>Yearly summary. 2. I am looking at getting the YTD sales numbers for customers through smartlist or reports. Is this possible? Also what sql table holds this information. Check RM00103 and RM00104. Have you looked at the Period Sales Analysis report? -- Jim@TurboChef "Jack" wrote: > 1. I would like to print the customer summary report for all of the customers > at the same time. I can print this r...

GP9 Inquiry->Financial->Detail Window
We seems to be having a strange problem in GP9. In the Inquiry->Financial->Detail Window there are the Account Balance and the Total's on the bottom. If I log in as SA they do not appear but most of our users they do. This is also on in that for some users they do not. This is not a customized window in any way and there are not field level security section relevant to this. Is anyone else able to produce this error. Any suggestions on how to fix it. Thank You Alex Reid Systems Analyst Vecima Networks Alex, Unless you have a customization that is only available to selected ...

Parameterized Reports in v1.2
Greetings all, From what I understand, CRM 1.2 permits parameterized reports. Do I need Crystal 9.x for this type of reporting? I am still able to run and build reports (outside of CRM) with the 8.5 Designer with no problems. I have not tried saving them to CRM's Enterprise folder. Also, can we use the Crystal Report Viewer component that ships with Visual Studio to build applications that access the CRM database? (This was not possible in the previous version.) Thanks, Justin Yes you need crystal 9 to use reports with parameters "Justin" <anonymous@discussi...

Is there a trick to having multiple email accounts now!?
I've always had a couple of different email accounts setup in Outlook Express. When I send a message, I select which email address I want the recipient to see as the "sent from" address. Today I tried to add more email accounts, but Outlook won't send mail from them. The new email accounts are from the same place, and I copied the same settings over from the accounts that already work. But no dice. Messages won't send from them. I then deleted all the accounts, disabled virus scanning and then set them up again one at a time - and tested each one as I went. They al...

Report Manager Add In for 2003
I have upgraded laptop and Office software but cannot find the add in for Report Manager on this latest version. On 2000 it came on the disc, on 2002 I downloaded it from Microsoft site but the only download I can find now is the 2002 version and it does not appear to work. Running XP Pro. What has happened to it? Has it been replaced? the download didn't like my machine, had to put it on another then transfer. Sorted! >-----Original Message----- >I have upgraded laptop and Office software but cannot find >the add in for Report Manager on this latest version. On >200...

Leads and existing contacts/accounts
I have a situation where it is highly possible that visitors of one of my sites fill out a slightly modified Scribe lead page already exist in CRM either as contacts or accounts. What are the possible scenarios for me to 'match' them up without creating opportunities (it is a NFP organization, majority if the visitors are asking for information, no sales activities are expected). Thanks in advance! ...

Show prices with detail on Account Statements?
I am customizing statement.xml. I really need to show prices next to each item in the detail. Is this possible? Even with the variable AccountStatement.Activities.FullDetails, I just get the description of the item. Because this store is a pharmacy, customers want to know that they bought a prescription for $20.00 and a bottle of aspirin for $5. The transaction total of $25 is not good enough. Anyone know a way to show prices for each item within a transaction on a statement? Cheers! Steve Steve, Without looking, I would say no. That's the purpose of a receipt / invoice. A stat...

Varied Account Balances
This is in reference to my Checking Acount set up in Money 2004 When I look at my Account List, Account Register and Cash Flow, all three have a different current balance. My assumption would be that all would be the same as the Account Register drives the Cash Flow. Any suggestions on the discrepancies? Account list will show the balance of the account with all future transactions as seen in the account register included. Account register shows the individual items with the rolling balance. The final figure should match the account list. Cash flow starting figure will be today'...

One Line of Data Per Page of Report
When viewing/printing reports reports we are only getting one line of data per page. So instead of having a 5 page report with 60 entires we have a 60 page report with 1 entry per page. Is there an easy way to solve this probelm? We are not very familar with access and need this problem solved. Thanks! On Thu, 17 Jan 2008 11:07:03 -0800, Coutu <Coutu@discussions.microsoft.com> wrote: >When viewing/printing reports reports we are only getting one line of data >per page. So instead of having a 5 page report with 60 entires we have a 60 >page report with 1 entry per pag...

Link Tables in Report Writer
Hi everyone, Im working with Report Writer in GP10 I read David articles and they are interesting but my question is: for exemple I want to add the "expiration date" to the "POP Receivings Posting journal" report let's assume I found the table containing the "expiration date" how do I get to it when creating table relationships Im new with GP and Im having difficulties what tables to link to get the final table. I really tried everything to figure it out but I didn't succeed I hope I was clear explaning this. thank you guys in advance It sounds li...

create flixible forecast reports?
Is it possible to create flexible forecast reports (global reports, reports for one country, for one business-line, one account-executive, ...) with revenue and profit margin, given the following information for the opportunities: - global revenue and profit margin (percentage), equal split over several months - global revenue and profit margin (percentage), not equal split over several months - hourly revenue and cost price for a consultant (linked at an opportunity), split over several months based on working days per month - hourly revenue and cost price for different consultants (lin...

My Account Settings, Icons, Files are "Missing"
Recently, I booted up and discovered that my personalized icons (under my account) had disappeared from the desktop. The Account Name is "Gilxxx" but my data is under "Curxxx" When I looked closer, I was able to see the directory structure in my "Documents and Settings" folders, but none of the files. The files are there, however, as I can play MP3s in Windows Media Player (and they are in my My Music directory). And, when I tried to add new desktop icons to "re-create" my old desktop, Windows tells me that a shortcut with that name alread...

Ms Money hangs when generately monthly reports
I am using Microsoft Money Plus Deluxe Trial Version 17.0.120.727, and everytime I generate monthly reports under the Reports Tab I will encounter the following error and MS money will hang & close. Any idea what's wrong with ms money? Error message:- Runtime Error! Program: ... gram Files\Microsoft Money Plus\MNYCoreFiles\msmoney.exe This application has requested the Runtime to terminte it in an unusual way Please contact the application's support team for more information ...

Cash Accounts for Investments
I have two stocks held with the same Financial Institution. Each stock carries its' own Cash account (I opted for the Dividend Reinvestment Plan). However, since Microsoft Money recognises them as being from the same Financial Institution, it collates them into one Cash account. Is there a correct way to split them? I'm sorting through previous financial records, in an attempt to get Money up to date. Hence the influx of questions. Sorry :-) Thank you in advance. Andy There's no way to have more than one "Associated Cash Account". But maybe it doesn't mat...

retirement accounts
is it a feature in money to not allow financial institutions statements that have the header of investment to download into retirement 401k and 403b accounts downloaded into money 2004. ...