How to get two different amount with same document no. from the same table? For e.g both document is 44 and supplier no. is 55. The amounts for the records are 15 and 0.1 . How do i display the two amounts?
Vat2.SETRANGE(Vat2.“Document”, Vat1. "Document ");
IF Vat2.FINDSET THEN BEGIN
BaseAmtNoGst := Base;
UNTIL Vat2.NEXT = 0;
This is my code. However, it does not work properly. Please advice