I'm trying to get the turnover of each salesperson from the database and I need to calculate the sum of the lineTotal from the A/R Invoice-rows(INV1) and then deduce from it The lineTotal from the A/R credit memo(RIN1) so that I could get the pure turnover but when I searched I found different answers to the link between these two tables but none of those worked for me.
I'm new to SAP B1
Any help would be appreciated