emi_sastra
asked on
Show Parent is total below the Child.
Hi,
I have query into below result.
AccNo Name Debit Credit Parent Account
32 PENDAPATAN/BIAYA NON OPERASI 0.0000 1448947.0000 3
6103 BIAYA KARYAWAN 6433000.0000 0.0000 61
6104 ADMINISTRASI KANTOR 1831500.0000 0.0000 61
6108 BIAYA PEMELIHARAAN 250000.0000 0.0000 61
7103 Main Nursery 229250000.0000 0.0000 71
How could I show it into :
32 PENDAPATAN/BIAYA NON OPERASI 0.0000 1448947.0000 3
TOTAL
6103 BIAYA KARYAWAN 6433000.0000 0.0000 61
6104 ADMINISTRASI KANTOR 1831500.0000 0.0000 61
6108 BIAYA PEMELIHARAAN 250000.0000 0.0000 61
TOTAL
7103 Main Nursery 229250000.0000 0.0000 71
TOTAL
Thank you.
I have query into below result.
AccNo Name Debit Credit Parent Account
32 PENDAPATAN/BIAYA NON OPERASI 0.0000 1448947.0000 3
6103 BIAYA KARYAWAN 6433000.0000 0.0000 61
6104 ADMINISTRASI KANTOR 1831500.0000 0.0000 61
6108 BIAYA PEMELIHARAAN 250000.0000 0.0000 61
7103 Main Nursery 229250000.0000 0.0000 71
How could I show it into :
32 PENDAPATAN/BIAYA NON OPERASI 0.0000 1448947.0000 3
TOTAL
6103 BIAYA KARYAWAN 6433000.0000 0.0000 61
6104 ADMINISTRASI KANTOR 1831500.0000 0.0000 61
6108 BIAYA PEMELIHARAAN 250000.0000 0.0000 61
TOTAL
7103 Main Nursery 229250000.0000 0.0000 71
TOTAL
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The link helps a lot.
Thank you very much for your help.