LineNo. AccNo. Description/Descriptin 2
1000 11000 AAAAAAA /aaaaaaaaaaa
2000 21000 BBBBBBB/bbbbbbbbbbb
3000 11000 AAAAAAA/ccccccccccccc
CLEAR(AccNo); CLEAR(Desc); CLEAR(Desc2); CLEAR(AccDesc); PurchInvLine.RESET; PurchInvLine.SETRANGE("Document No.","Document No."); PurchInvLine.SETRANGE(Type,Type::"G/L Account"); PurchInvLine.SETRANGE("No.","No."); IF PurchInvLine.FIND('-') THEN BEGIN Desc := PurchInvLine.Description; Desc2 := PurchInvLine."Description 2"; END; IF GLAcc.GET(AccNo) THEN BEGIN IF Desc2 <> '' THEN AccDesc := Desc + '/' + Desc2; END; IF GLAcc.GET(AccNo) THEN BEGIN IF Desc2 = '' THEN AccDesc := Desc; END;
Comments
You would need to change the statement
to this
This will add the description from the GLAcc table to yoyr description.
Albert