How can I identify the link between credits and debits on GL?
I need to build a report that shows the link between the debits and credits. I don`t know which table or field on database I can use to do that.
For example, I have one credit of US$1,000.00 and 3 debits of US$500.00, US$300.00 and US$200.00. The total balance for the credits and debits is US$1,000.00. But on the same batch, I have many others credits and debits on this batch. How can I identify that this credit have relationship with these 3 debits?
Many Thanks,
Mark