here is my relationship between tables. I want product wise actual amount after minus credit memo from the sales invoice amount. i created a custom column in data view but this process giving wrong values. how to do that ? for the card value i can in total amount but i need product wise actual value.
for example :- a product sales amount (Table 1:- Sales Invoice Lines) is 9000 and its credit memo (Table 2:- Credit Memo) is 3000 i want a custom column with product amount after less credit memo.
thanks in advance