OraFAQ Forum: Forms » Accounts Management Program

Home » Developer & Programmer » Forms » Accounts Management Program

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Accounts Management Program [message #601620]

Sat, 23 November 2013 00:26

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

Hey Experts of Oracle.

I want to create a accounts management program in forms 6i.

i need your help to create tables and column's.

please give me idea of complete accounts schema.

Thanks

Report message to a moderator

Re: Accounts Management Program [message #601626 is a reply to message #601620]

Sat, 23 November 2013 04:27

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Are you trying to design and develop "General Ledger Accounting System"?

Regard
Mughal

Report message to a moderator

Re: Accounts Management Program [message #601631 is a reply to message #601626]

Sat, 23 November 2013 07:49

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

Yes.off course
I want to create a general ledger account with debitor and creditors chart of account.
Invoice and payment voucher etc

Report message to a moderator

Re: Accounts Management Program [message #601654 is a reply to message #601631]

Sat, 23 November 2013 14:46

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

i cant't explain the whole things like this but i will give you some ideas how to design & develop General Ledger Accounting System. lets go step by step. I have had designed and developed G/L SYSTEM in 2008 for largest reputed company in Italy basicly i have got Residence permit of Italy(: anyway I can give you my complete application which i have designed & DEVELOPED but i wanted you to design & develop G/L your self like this you will learn more and more.hope you will do it. If you would LIKE to know more about G/L then read documents from net.

What is a general ledger account?
A general ledger account is an account or record used to sort and store balance sheet and income statement transactions. Examples of general ledger accounts include the asset accounts such as Cash, Accounts Receivable, Inventory, Investments, Land, and Equipment. Examples of the general ledger liability accounts include Notes Payable, Accounts Payable, Accrued Expenses Payable, and Customer Deposits. Examples of income statement accounts found in the general ledger include Sales, Service Fee Revenues, Salaries Expense, Rent Expense, Advertising Expense, Interest Expense, and Loss on Disposal of Assets.

Let start from chart of accounts

A chart of accounts is a listing of the names of the accounts that a company has identified and made available for recording transactions in its general ledger. A company has the flexibility to tailor its chart of accounts to best suit its needs, including adding accounts as needed.

chart of accounts Normally works on six account heads

01 -- FIxed Assets
02 -- Deffered Liabilities
03 -- Income
04 -- Expenditure
05 -- Current Assets
06 -- Current Liabilites

how i have had designed & developed G/L first you have to create account numbers which will be something like this.

MAIN HEAD AND SUB HEAD

01000000--"FIXED ASSETS"-------------MAIN HEAD

01001000 ASSETS--------NOW--SUB HEADS-------
01001001 FURNITURE
01001002 CONVEYOR BELTS
01001003 SEMI AUTOMATIC STAPPING MACHINE

02000000--"DEFFERED LIABILITY"

02001000 AF CAPITAL A/C
02001001 AF CAPITAL A/C
02001002 CURRENT AF A/C

03000000 "TURNOVER"
03001000 EXPORT SALES
03001001 RICE EXPORT SALES
03001002 SEA FREIGHT
03001003 FOREIGN AGENT COMMISSION

04000000 "EXPENDITURE"
04001000 PROCESSING EXPENSES
04001001 BANK INTEREST
04001002 SALARIES
04001003 ELECTRIC
04001004 TRANSPORTATION

05000000--"CURRENT ASSETS"
05001000 ACCOUNTS RECEIVABLE
05001001 EXPORT RECEIVABLE
05001002 LOCAL SALE RECEIVABLE
05001003 SANPAOLO BANK
05002000 CASH & RUNNING BANKS
05002001 CASH AT OFFICE
05002002 CASH AT GWD
05002003 CASH OF RESIDUES (LOCAL SALE)
05002004 BANK CARIGE
05002005 BANK BIPOP

06000000--"CURRENT LIABILITY"
06001000 REFINANCE LOAN
06001001 ASKARI BANK REFINANCE LOAN

07000000--"COST OF GOODS"
07001000 COGS RICE
07001001 RICE PURCHASED

08000000--"OTHER INCOME"
08001000 LOCAL RESIDUES SALE
08001001 LOCAL SALE
08001002 COMMISION FROM WESTERN UNION
08001003 COMMISION FROM RIA INVIA
08001004 COMMISION FROM EUROENVIOS
08001005 PCO SALE VIA AVIO
08001006 PCO SALE VIA PRE

99999000 NEW---------This code to create new account

something about tables structures

01.chart of account
02.voucher_master
03.voucher_Detail

---------FORMS ENTRY----

CHART OF ACCOUNT
JOURNAL VOUCHER
BANK PAYMENT VOUCHER
CASH PAYMENT VOUCHER
CASH RECEIVE VOUCHER

----------------REPORTS---------

CHART OF ACCOUNT
GENERAL LEDGER
CASH BOOK
BANK BOOK
TRIAL BALANCE
SUMMARY TRIAL
BALANCE SHEET
PROFIT AND LOSS

And please see this PNG file about MAIN MENU you will see the detail of whole forms and reports as far inventory that we will discuss later and still have to explain about "DEBIT" & "CREDIT" it is better you read document from internet about debit, credit as i told you i can't explain the whole things like this hope will take some idea .

Feel free for any further query

Regard
Mughal

[Updated on: Sat, 23 November 2013 14:48]

Report message to a moderator

Re: Accounts Management Program [message #601655 is a reply to message #601654]

Sat, 23 November 2013 14:55

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

forgot to upload PNG

Attachment: MAIN_MENU.PNG
(Size: 60.93KB, Downloaded 2764 times)

[Updated on: Sat, 23 November 2013 14:57]

Report message to a moderator

Re: Accounts Management Program [message #601673 is a reply to message #601655]

Sun, 24 November 2013 03:33

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

Wow that's great i really like it and i want to create software same like your software.

Dear i know everything about accounting and g/l because i am doing job as a accountant in a huge fabric export company. in my department we have no any accounts management software, so i want to create it myself but i m new in oracle and dont have idea to create software like your's.
If you give me your project table entities, triggers, functions, procedure, object lib then i will successfully create a account software of myself.

I am waiting your prompt reply. ...........waiting anxiously........

Report message to a moderator

Re: Accounts Management Program [message #601681 is a reply to message #601673]

Sun, 24 November 2013 07:09

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

ok take this table structure and start to create table


chartofaccount--------Table name

 Name                                      Null?    Type
 ----------------------------------------- -------- --------------
 ACCOUNT_NO                                NOT NULL VARCHAR2(8)
 DESCRIPTION                               NOT NULL VARCHAR2(40)
 OPENING_DATE                              NOT NULL DATE
 OPENING_BALANCE                                    NUMBER(15,2)
 ACCOUNT_NATURE                                     VARCHAR2(2)
 CATAGORY                                           VARCHAR2(2)
 SEQ_NO                                             NUMBER(2)
 OPENING_BAL_NATURE                                 VARCHAR2(4)

Voucher_master---------Table name

Name                                      Null?    Type
----------------------------------------- -------- -----------------
VOUCHER_NO                                NOT NULL VARCHAR2(20)
NARRATION                                          VARCHAR2(240)
VOUCHER_DATE                                       DATE
VOUCHER_TYPE                                       NUMBER(3)
TOTAL_CR                                           NUMBER(17,2)
TOTAL_DR                                           NUMBER(17,2)
SUPERVISED_BY                                      VARCHAR2(40)
PREPARED_BY                                        VARCHAR2(40)
RECEIVED_BY                                        VARCHAR2(40)
ACCOUNT_NO                                         VARCHAR2(10)
AMOUNT                                             NUMBER(17,2)
CHEQUE                                             VARCHAR2(15)
MANAGER                                            VARCHAR2(40)
PAIDTO                                             VARCHAR2(40)
ACC_TITLE                                          VARCHAR2(40)
TP                                                 VARCHAR2(2)

------------------------------
Voucher_Detail---Table name

 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------
 ENTRY_NO                                  NOT NULL VARCHAR2(20)
 ACCOUNT_NO                                         VARCHAR2(10)
 VOUCHER_NO                                         VARCHAR2(20)
 DR_AMOUNT                                          NUMBER(17,2)
 CR_AMOUNT                                          NUMBER(17,2)
 NARRATION                                 NOT NULL VARCHAR2(120)
 WAIGHT                                             NUMBER(10,2)
 TP                                                 VARCHAR2(2)

and create relation VOUCHER_MASTER.VOUCHER_NO AND VOUCHER_dETAIL.VOUCHER_NO

Start now step by step

Regard
Mughal

[Updated on: Sun, 24 November 2013 07:13]

Report message to a moderator

Re: Accounts Management Program [message #601721 is a reply to message #601681]

Sun, 24 November 2013 23:39

Adeel Qadir
Messages: 48
Registered: November 2013
Location: Pakistan

Member

Thanks for your prompt reply.

This procedure completed successfully.

VOUCHER_MASTER.VOUCHER_NO(PRIMARY_KEY) = VOUCHER_DETAIL.VOUCHER_NO(PRIMARY_KEY) RELATION CREATED Smile