on item no validate in courier table, im having this below code and works fine
IF item.GET("item No") THEN
DealerPrice:=item.DealerPrice;
VATIdent:=item."VAT Prod. Posting Group";
VATident value here is VAT14.5
how to map the VATident = VAT Posting Setup.VAT Prod. Posting Group
and get the value of the VAT % and store this value in courier.VAT% field..
any ideas.. thanks
*This post is locked for comments
and what if you have multiple lines for VATIdent?
do you always need first record VAT% only?
IF item.GET("item No") THEN BEGIN
DealerPrice:=item.DealerPrice;
VATIdent:=item."VAT Prod. Posting Group";
END;
VATPosting.RESET;
VATPosting.SETCURRENTKEY("VAT Prod. Posting Group");
VATPosting.SETRANGE("VAT Prod. Posting Group",VATIdent);
IF VATPosting.FINDFIRST THEN BEGIN
VATPer:= VATPosting."VAT %"
END
and it worked.. thanks for your support....
1. if you multiple lines below IF THEN. Please use begin and end
IF item.GET("item No") THEN BEGIN
DealerPrice:=item.DealerPrice;
VATIdent:=item."VAT Prod. Posting Group";
END;
2. You have written code in VATIdent onvalidate trigger.
so you have to validate the field in 1st code.
VALIDATE(VATIdent,item."VAT Prod. Posting Group");
3. In order to use GET on VATPosting setup, you need to know all primary keys
Primary key of Vat Posting setup table is VAT Bus. Posting Group,VAT Prod. Posting Group
so you need VAT Bus. Posting Group
yes sure, thanks im trying this on, and im sure this wrong..
VATIdent - OnValidate()
//IF VATPosting.GET("VATIdent") THEN ( i dont know, how to search a field in the .VAT Prod. Posting Group)
//"VAT%":=VATPosting."VAT %";
Please try yourself and let us know if you have any issues.
please don't ask forum to do your job.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (