Table A | | | | |
| | | | |
S.no | code | Doc.code | Total | |
1 | ILE | 1001 | 20 | |
2 | ILE | 1002 | 40 | |
3 | ILE | 1003 | 30 | |
4 | ILE | 1004 | 50 | |
5 | ILE | 1005 | 80 | |
| | | | |
| | | | |
Table B | | | | |
s.no | code | Ref code | Ref Doc code | Total |
1 | SRLE | ILE | 1002 | 20 |
2 | SRLE | ILE | 1004 | 40 |
3 | SRLE | ILE | 1005 | 80 |
| | | | |
hI above are my two tables .
table A is invoice and table B is sales return.
i need to find the sum of sales by subtracting the second table . as if sales return has been done it wont be consider as profit.
how can i achieve this in expression. please help
Thanks
Vignesh