I have to join 2 tables table1 is purchase details written 1 below the other as basic price tax1 debit in next line tax2 debit in 3rd text 3 debit and rounding off which can be debit or credit and party total as credit . In this table it has id number connected to master ID indicating name of the party or taxes and rounding off.
Want to make a report so that I get reports from to option with bill details written in 1 line like Bill date Bill no party name cr at tax1 name amount debit tax2 debit amount tax3 debit amount rounding off if there db/credit and bill total
Please can anyone help