O
Omi4u
Guest
I have 7 tables of COA as show in the picture attached. what I need is whenever opening balance goto - (negative) , the type must automatically show CR sign and whenever that account goto positive + , it must change to DR automatically. Please remember that the account will change to DR or CR as per entries . suppose I am doing entry in cash payment and if cash in hand account is Debit and utilities are CR in Chart of account. and if I pass an entry then and make utilities debit then in chart of accounts it must change from CR to DR in type column.
also my accountant do not want to see (-) sign with negative he need type should change as per entries
Let me explain more
suppose I have 2 accounts (cash in hand ) and ( Utility Bills )
the Opening balance of both accounts in Chart of Accounts is
Cash in Hand = 5000 DR
Utility Bills = 2000 CR
now if I do an entry in cash payment so it will be
utility bills (DR) = 8000
cash in hand (CR) = 8000
now after i do this entry the Chart of accounts must look like
Cash in hand = 3000 CR ( because it is in negative due to i had only 5000) (now here the balance must show like -3000) but instead of (-) it showing 3000 and DR change to CR
it must also update in ms sql database
This is what I need to do
Continue reading...
also my accountant do not want to see (-) sign with negative he need type should change as per entries
Let me explain more
suppose I have 2 accounts (cash in hand ) and ( Utility Bills )
the Opening balance of both accounts in Chart of Accounts is
Cash in Hand = 5000 DR
Utility Bills = 2000 CR
now if I do an entry in cash payment so it will be
utility bills (DR) = 8000
cash in hand (CR) = 8000
now after i do this entry the Chart of accounts must look like
Cash in hand = 3000 CR ( because it is in negative due to i had only 5000) (now here the balance must show like -3000) but instead of (-) it showing 3000 and DR change to CR
it must also update in ms sql database
This is what I need to do
Continue reading...