Home » Developer & Programmer » Reports & Discoverer » Trial Balance Report
Trial Balance Report [message #201259] Fri, 03 November 2006 05:44 Go to next message
ali1983
Messages: 13
Registered: October 2006
Location: Faisalabad
Junior Member
Hello All!
I am facing a problem in creating a trial balance report. In that report I want All chart of account and their balance in debit or credit side. I am getting the chart of account but balance is not available. So plz tell me the solution. I am sending the table structure so plz help me in solving that problem.

Bye
  • Attachment: dESK.bmp
    (Size: 378.53KB, Downloaded 239 times)
Re: Trial Balance Report [message #201943 is a reply to message #201259] Tue, 07 November 2006 08:39 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi ali,

Y dont you join the vch1 table and vch2 table. in you vch2 table you can get the debit and credit figures.

Can u send me the .rdf .

Bye
Ashu

Re: Trial Balance Report [message #202030 is a reply to message #201943] Tue, 07 November 2006 22:40 Go to previous messageGo to next message
ali1983
Messages: 13
Registered: October 2006
Location: Faisalabad
Junior Member
AOA!
Thanx 4 ur reply. The problem is that tables were not created by me. Someone create it and send me the table structure. I joined them by condition 'Where VCH1.VCD=VCH2.VCD' and another condition on which I get the debit credit figure along their Account Code is
(chrt.cod=vch2.cod). But the main problem is that I want total of accounts in it's parent account eg. I have account
Dbt Crd


010101--Parent Account of three below records
(0101010001 100
0101010002 200
0101010003 ) Child Account 400

Now in parent account balance would be either on Dbt side or Crd Side In this case the Parent account balance will become 300 on Dbt Side.
But I am getting only those record which are Child account of length 10. And when I remove that condition (chrt.cod=vch2.cod) then I also get the child records but I am unable to get the right balance for each account. So Please help me. If u don't mind can u give me ur personal email address so we can contant on messenger.
And I am sending u that ".rdf" file. So please solve this problem as soon as possible. The Query which I have used in it I have commented that condition (chrt.cod=vch2.cod) records are coming but not with proper balance. But as i will enable that condition the balance against that code will be right but there records will not contain their parent code.
  • Attachment: trial.RDF
    (Size: 88.00KB, Downloaded 219 times)
Re: Trial Balance Report [message #202744 is a reply to message #202030] Sat, 11 November 2006 11:10 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Ali,

U can contact me on ab_trivedi@rediffmail.com

I am seeing you problem you do one thing you send me the word file which contains the output you reuire from the report.

Bye
Ashu

Might be u r not taking the repeating frame at right place anyway i am tying at your problem send me some dummy data...

bye

[Updated on: Sat, 11 November 2006 12:11]

Report message to a moderator

Re: Trial Balance Report [message #202751 is a reply to message #202744] Sat, 11 November 2006 13:00 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi Ali,

I spend 11.pm to 12.30 p.m full 1.30 to solve your problem.
I have created 3 table which you have send and entered fake data into them and check your query.

as you are not taking the '--AND vc2.COD =ch.COD' and hence the oracle is returning the cartesian product.

I am sending a new report which I have developed so please tell me what is the progress from your side.

Bye
Ashu

[Updated on: Sun, 12 November 2006 11:14]

Report message to a moderator

Re: Trial Balance Report [message #203412 is a reply to message #202751] Wed, 15 November 2006 01:21 Go to previous messageGo to next message
ali1983
Messages: 13
Registered: October 2006
Location: Faisalabad
Junior Member
Hello:
Very Very sorry for late replying because my PC was out of order. Thanx 4 ur reply. I havn't got the file which u send me.
And I'll send u the word file with dummy data in few days.

Bye
Muhammad Ali
Re: Trial Balance Report [message #203807 is a reply to message #201259] Thu, 16 November 2006 06:56 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi ali

I am sening u the .rdf file, you just see it and tell me if any extra is required. You send your copy of report.

Bye
Ashu
  • Attachment: my_trial.RDF
    (Size: 56.00KB, Downloaded 247 times)
Re: Trial Balance Report [message #204079 is a reply to message #203807] Fri, 17 November 2006 12:35 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi,

have u tried the report...

bye
Ashu
Re: Trial Balance Report [message #205309 is a reply to message #204079] Fri, 24 November 2006 04:10 Go to previous messageGo to next message
ali1983
Messages: 13
Registered: October 2006
Location: Faisalabad
Junior Member
Hello:-
Sorry 4 replying u late this is because I am having a problem of Internet. So today it worked and now I am mailing u.
I tried the report which u send me. But It is giving me the same result as the previous one which I send u was giving.
Bye.
Muhammad Ali

Re: Trial Balance Report [message #205372 is a reply to message #205309] Fri, 24 November 2006 06:42 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi ali,

this is strange but anyway you send me the copy of the report? and the desired output you require.

I will try my level best to solve the problem.

How is Pakistan team playing with West Indies???

Bye
Ashu
Previous Topic: Insert parameter in report
Next Topic: How can I print the EAN 13 barcode with Oracle Report
Goto Forum:
  


Current Time: Tue Dec 06 04:09:29 CST 2016

Total time taken to generate the page: 0.05485 seconds