The user will input Month and Year (AUG,2004)
It should fetch data from GL_BALANCE table joining CODE_ID from CODE COMBINATION table
it will calculate net_debit_credit (DEBIT-CREDIT) segment wise. from JAN 2004 to JUL 2004 where A_FLAG (GL_BALANCE) is 'B'. and for AUG 2004 it should pick up data where A_FLAG(GL_BALANCE) is 'A'
One Exception is : if user enter input (JAN,2004)
then only flag with 'B' in A_FLAG (GL_BALANCE) should be picked up.
Total Cost upto JULY = 10000(COSF 5000+SGA 3000+COMMON 2000)
Total cost upto AUG = 15000(COSF 8000+SGA 5000+COMMON 2000)
COSF = 0.52 (5000+8000) / (10000+15000)
SGA = 0.32 (3000+5000) / (10000+15000)
COMMON = 0.16 (2000+2000) / (10000+15000)
Also note that SEGMENT1 field
500000 is always COSF
600000 is always SGA
700000 is always COMMON
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.