Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

is anyone have experience in trial Balance Sheet?

Poor-BoyNov 3 2016 — edited Nov 5 2016

Create table accounts (inv_no number(10),Inv_no number(10),Client_id number(10),Client_name varchar2(50),Client_flag varchar2(50),Flag2 Varchar2(40),Debit number(10),Credit number(10));

Alter table accounts add constraint Inv_no_Pk primary key (Inv_no);

Insert into Accounts Values(1,1,101,'Usman','Purchaser','Credit Purchase',0,20000);

Insert into Accounts Values(1,2,101,'Usman','Purchaser','Cash Purchase',3000,3000);

Insert into Accounts Values(2,3,102,'Manu','Sale','Credit Sale',400,0);

Insert into Accounts Values(3,4,104,'Kalpataru','Sale','Cash Sale',200,200);

Insert into Accounts Values(4,5,102,'Manu','Sale','Cash Received',0,2-0);

Insert into Accounts Values(5,6,104,'Kalpataru','Sale','Cash Paid',200,0);

Insert into Accounts Values(6,7,200,'Generator','Expenses','Expenss',900,900);

Insert into Accounts Values(7,8,202,'Building','Building','Expenss',4000,4000);

Insert into Accounts Values(7,8,109,'Poor Boy','Cash','Cash Paid',2000,0);

ol.png

I want to create a Trial Balance Sheet.. if anyone have experience in Accounts Trial Balance sheet then plz give me the query

here is the example of Trial balance

Trial balance Sheet.jpg

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 3 2016
Added on Nov 3 2016
2 comments
694 views