General Ledger Transaction Detail report

Hola Family

I will like to know if someone can help me, I need to know the path to run a 
General Ledger Transaction Detail report in Dynamics GP 10. The file will 
include the daily transactions posted to the general ledger for the periods 
identified. 

Thank you in advanced.

-- 
LOS
1
Utf
1/22/2010 10:36:07 PM
greatplains 29623 articles. 2 followers. Follow

1 Replies
4044 Views

Similar Articles

[PageSpeed] 26

Hola Carlos,

The detailed trial balance in GL can be generated via this path 
Reports>>Financial>>Trial Balance (Detailed).  When you create/modify a 
report options, you can use the ranges field (dates, accounts, etc.) to limit 
the records that will be included in the report.

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
Citrix Certified Enterprise Administrator


"Carlos" wrote:

> Hola Family
> 
> I will like to know if someone can help me, I need to know the path to run a 
> General Ledger Transaction Detail report in Dynamics GP 10. The file will 
> include the daily transactions posted to the general ledger for the periods 
> identified. 
> 
> Thank you in advanced.
> 
> -- 
> LOS
0
Utf
1/22/2010 11:03:01 PM
Reply:

Similar Artilces:

eConnect SOP Transaction DEFPRICING Problem
Hi, I have just started to use eConnect and had successfully import some SOP Transaction into GP following the examples provided in the help document. However, when I tried to calculate standard or extended pricing automatically by using the DEFPRICING, it gives me the following error: ******************************************************************************** System.Data.SqlClient.SqlException: Procedure 'sopExtPricingGetPrice' expects pa rameter '@QuantityFrom', which was not supplied. Server stack trace: Exception rethrown at [0]: at System.Runtime.Remoting...

Z Report Does Not Print but the X Report prints fine
I just upgraded to RMS 2.0 One of the problems I'm having is i can not print the z report. When i processes it it shows "No receipt to display" in journal. It does reset the total so the function itself is working. The strange part is that i have no problem printing the X report. As far as i know both Z and X use the same report template. How can i fix this Thanks hi Robert, go to Database> Cashier and then select the user having this issue, go donw to security and make sure that "Allow to generate the Z & ZZ reports" are checked this is the frist step you ...

Problems with matching a downloaded transaction with a paid invoic
I've got an invoice that I marked as paid and it shows up in my checking account. I deposited the check into the bank, but when it clears it gets downloaded in as ATM DEPOSIT and it doesn't match itself with the actual bill payment that's already there, so now I have duplicate deposit. When I click on the downloaded transaction and go to Change, and then Match with another tranasction in my register, I don't get that paid bill in the list to match with!? I see all my paid items and all of my pay check deposits (from full time job checks) but these checks that are subco...

Great Plains and SQL Reporting Services
I'm currently using FRx to generate some basic reports off of our Great Plains database (which is a SQL Database), but I'm also using SQL Reporting Services for some other reports systems within our company. I'm wondering if there might be some product that uses SQL Reporting Services as a reporting mechanism to Great Plains (like, but instead of FRx)? Anybody know of anything or have any other ideas along this line? Thanks, Chris Hello there, I've joined a company that uses GP and SQL Reporting Services. I've never used GP Before. Why cant I see my expenses in t...

general question!
Hello there. Outlook XP in a networked environment. When viewing an email (that has an attachment)in the preview pane, I can see the attachment icon on that little header area between the list of emails and the previewed email. However, when I click away to an email that is a reply to a meeting request (that I sent out)and then click back on the attachment-email, in the information viewer the little attachment icon is no longer on the header. Obviously I can still tell if the email in question has an attachment from the information viewer. This is more annoying more than anything els...

unable to enter transactions in money plus deluxe
not able to enter transactions in Money Plus deluxe, getting error obres:7891, started having problems about 3 weeks ago with adding investment transactions from the update saying transaction cannot be entered try deleting the security, then today have not been able to enter any transactions in any register without getting the above error. Any ideas? ct No bells ringing here on this one. Got backups? "ct" <ct@discussions.microsoft.com> wrote in message news:CC6AE125-1B6B-4DCA-9F0D-AF49228CD69E@microsoft.com... > not able to enter transactions in Money Plus d...

How to remove phantom Bill transactions
Money 2004 Standard. The other day I noticed that the amount in my checking account on the Home Page (and in the Accounts List) did not match what was shown in the checking register. The checking register was correct. The Home page was several thousands of dollars less. Poking around I discovered on the bill calendar a number of paid bills corresponding to the next payment of yearly (and bi-yearly) bills last paid in Dec. '03 to April '04 (i.e. the bills in Dec. '04, Jan-Apr '05, etc. were marked as paid) A duplicate of the same bills also showed up on the same day as sti...

Request for custom report
I apologize if this is an inappropriate forum for the request, but I would like to hire someone to write a custom RMS report for my company. Please send me an email offlist if you are available and interested. Thanks, Paul Contact me by email with detail of what report you want. Afshin Alikhani - [ afshin@retailrealm.co.uk ] CEO - Retail Realm = = = = = = = = = "montare" <montare@gmail.com> wrote in message news:1158341748.667831.253330@d34g2000cwd.googlegroups.com... >I apologize if this is an inappropriate forum for the request, but I > would like to hire someo...

Item Movement/Movement History and Item Qty reports
Hi, Does anyone know if there would be a reason for the Item Quantity report to not match the Item Movement History or Item Movement reports? For testing purposes, I checked out the sample database. If I run the Item Movement and Item Movement History report, they agree that there is quantity 5 of the Football (item 15100). But if you run the Item Quantity Report, it shows 17 on hand. I've checked the off-line inventory already and I can't find any explanation as to why these 2 don't match. The only possible thing I was thinking of was that the initial loading of the...

Customizing Reports
It seems like the income and expense report doesn't show a subcategory if it's amount is 0. Is there a way to customize it to show ALL subcategories... even if the amount is 0? Thanks! In microsoft.public.money, Jeff wrote: >It seems like the income and expense report doesn't show a >subcategory if it's amount is 0. Is there a way to >customize it to show ALL subcategories... even if the >amount is 0? You can create a $0 transaction with a split with $0 items for every category you want included. ...

Saving excel to Crystal Report *.rpt
I am looking for a way to save an excel file as *.rpt (Crystal reports). OR as *.rep Does anyone have a way to do this? Aren't .rpt files just plain old text? You may find that you can get close with file|Saveas Save as Type: Formatted Text (Space delimited)(*.prn) But that's limited to 240 characters wide. Dani wrote: > > I am looking for a way to save an excel file as *.rpt (Crystal reports). OR > as *.rep > > Does anyone have a way to do this? -- Dave Peterson ...

General
I created a workbook with several worksheets that are protected and when it is opened it is to go to sheet1 and select cell A10. My problem is that when I open it not only is sheet1/A10 selected but a cell in sheet2 which causes half of each sheet to be visible. Now if I unprotect sheet2 the problem goes away but cells in the two sheets are linked and both need to be protected. Any help with this would be greatly appreciated. Thank you. Carl, care to post the code you are using? maybe somebody can see why it is doing that -- Paul B Always backup your data before trying something new Usin...

vbAdvance general dll problem
I want to create a plugin for an external application in VB6. To do this I create a regular dll, export the necessary functions and compile the dll. So far so good. The problem comes when I developed a second plugin (also in vb6 with vbAdvance) and try to load both in the external application. The first plugin is loaded fine, but the second fails with error 998 (ERROR_NOACCESS). I traced the problem to the code that starts the required vb stuff, in MRuntimeInit: ... pGetClass = GetProcAddress(hMod, "DllGetClassObject") If pGetClass Then CopyMemory pCall, InitDelegato...

Money 2000: Wont Add New Transaction
If anyone can help me I would greatly appreciate it. Anyways I went to add a new withdrawal to my checking account and when I go to hit the button to add a new withdrawal transaction it wont do anything. Transfer and deposit will work. Am I missing something? In microsoft.public.money, Cousintroy wrote: >If anyone can help me I would greatly appreciate it. >Anyways I went to add a new withdrawal to my checking >account and when I go to hit the button to add a new >withdrawal transaction it wont do anything. Transfer and >deposit will work. Am I missing something?...

eConnect: The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
When I send one particular XML chunk (<GLTransactionType>) through to eConnect via eConnectMethods.eConnect_EntryPoint it complains with "The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction." The timeouts on the client and server are both set to "0", which means no timeout. Importing the locally on the server via the same application works. The XML chunk is about 1000 lines long and can't be broken up into smaller fragments. Any suggestions? Server is Win2003 Server. Client is Windows XP SP2. GP 9. Thanks. ...

Z Report Printing Issue
Having an issue printing Z reports from Manager. We have two printers set up on our back office from a network share, one is a label printer, the other a HP LaserJet. The default printer is the LaserJet. In Manager we have a receipt printer set up for this back office pc as a windows device called \\servername.ourdomain.local\LaserJet, which is the name of the share. When we print the Z report (which doesn't give us an option of which printer to use) it goes straight to the label printer. The receipt format we have set for the Z report is the same that we use at our other store...

print query prompts in report header when no data to report
a report which uses a Query with prompts(expr1: xyz) and other criteria selects no records. The report header prints, but (expr1) which is a field in the header is blank. I want the prompts to print in the header even when no data is found. http://www.tek-tips.com/faqs.cfm?fid=6763 If you use references to controls on forms, the values will always be available even if the query returns no records. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "ConfusedCraig" wrote: > a report wh...

Transaction log and System path location
Is possible to change the location path of the system and Transaction log to another hard drive on the same server. I need to free diskspace on my c drive i want to move them to my e drive which is larger in size. Transactio n log paths are exposed in the Storage Group properties. Paul "fanman36" <fanman36@discussions.microsoft.com> wrote in message news:329F0E0B-7CB2-447C-BF40-0CD6A32D84F2@microsoft.com... > Is possible to change the location path of the system and Transaction log > to > another hard drive on the same server. I need to free diskspace on my c &g...

Matching Transactions Jumps Ahead
I am currently using M$2007 Deluxe. For some of my accounts I have it download transactions from my bank. I've noticed a weird issue that I am not sure why it is happening. In my checkbook, I mark transactions that have been paid via automatic debit as "EFT" in the check number field. When the transactions are downloaded, Money wants to match the downloaded transaction with the next month's payment as opposed to the payment that was just made. For example: I have an entry in my checkbook for "Cable Company" on 01/15 for $50. I've edited this transaction ...

Printing multiple graphs on a report
Is there an easy way to place and print multiple graphs on a page for printing, i.e., send these 6 graphs to an 8.5 x 11 portrait page and auto-arrange? Thanks! ...

alt.windows7.general
Windows 7 is Vista regurgitated. But it now has it's own news group. alt.windows7.general (uncensored) Canuck57 wrote this, with guidance from inner voices: > Windows 7 is Vista regurgitated. > > But it now has it's own news group. > > alt.windows7.general (uncensored) Just couldn't leave them in peace, could ya? -- Vita brevis breviter in brevi finietur, Mors venit velociter quae neminem veretur. Canuck57 wrote: > Windows 7 is Vista regurgitated. > > But it now has it's own news group. > > alt.windows7.general ...

Crystal Reports 9 Logon Failure
Hi there! I'm trying to log in to CRM 1.2 from Crystal Reports 9 (create New Connection) and I get the following error: Logon failed. Details: An error occurred while resolving logged on user IDs through the BizUser service. Any help? Thanks, Elena Are you able to log on to CRM otherwise, ie thru the web client or SFO? If not, check your server to make sure the CRM Security Service is started. If you still have problems, in Crystal are you using the "Trusted Connection" logon to create the connection? Are you logged into Crystal as a user who is also a licensed CRM user? &...

Download Transactions #3
After downloading online transactions, money hangs and the only way to get out is to end the application with task manager. After restarting the application I can process the transactions. This all began around 2/1/07. File repair does not resolve the problem. Any ideas as to why this started happening? ...

Money 2004 incorrectly assigns Payee on point of purchase transact
Two or three different point of purchase payees are incorrectly identified as my Water Bill when downloaded into Money 2004. What is going on? Also, because this version of Money was purchased installed on my new Dell computer Microsoft will not allow help on this issue, but refers me to Dell. Dell's outsourced tech support does not have a clue (but they are profusely apologetic)and says its a Microsoft problem. Very frustrating! In microsoft.public.money, uss225 wrote: >Two or three different point of purchase payees are incorrectly identified as >my Water Bill when downl...

alt.windows7.general newsgroup
Reference Email Subject: Mysterious Message in Drafts Folder, by Grenou, dated Saturday, November 28, 2009, 5:43 AM., comment: "I subscribe to alt.windows7.general." Grenou, I would very much appreciate the name of the server for the alt.windows7.general newsgroup. I already subscribe to news.microsoft.com and msnews.microsoft.com but could not find the alt.windows7.general newsgroup on either of these servers. Thanks for any help, Sam. Try aioe news server. "Sam" <scams@Remove This att.net> wrote in message news:ej3t87ScKHA.808@TK2MSFTN...