How to fetch Tax%(CST/VAT) separately

Markandey_PandeyMarkandey_Pandey Member Posts: 178
Hi Experts,

I want to fetch CST and VAT % in a separate variable.

i have written the following code

Sales Invoice Line, Body (1) - OnPreSection()
VATPercent:-Integer
CSTPercent:-Integer
Position->Integer


SalesInvLine.RESET;
SalesInvLine.SETRANGE(SalesInvLine."Document No.",SalesInvHeader."No.");
IF(SalesInvLine.FIND('-') ) THEN BEGIN
Position:=STRPOS(SalesInvLine."Tax Group Code",'CST');
// MESSAGE('Pos=%1',Position);

IF(Position<>0) THEN
BEGIN
CSTPercent:=SalesInvLine."Tax %";
END
ELSE
BEGIN
VATPercent:=SalesInvLine."Tax %";
END;
END;


Here actually TAX Group Code Contains Values like VAT12.5% ,CST 2% etc
i am comparing if this field contains CST then CSTPercent will have the value of CST and so on


Plz help me.
Markandey Pandey

Comments

  • Markandey_PandeyMarkandey_Pandey Member Posts: 178
    Hi Experts,

    I want to fetch CST and VAT % in a separate variable.

    i have written the following code

    Sales Invoice Line, Body (1) - OnPreSection()
    VATPercent:-Integer
    CSTPercent:-Integer
    Position->Integer


    SalesInvLine.RESET;
    SalesInvLine.SETRANGE(SalesInvLine."Document No.",SalesInvHeader."No.");
    IF(SalesInvLine.FIND('-') ) THEN BEGIN
    Position:=STRPOS(SalesInvLine."Tax Group Code",'CST');
    // MESSAGE('Pos=%1',Position);

    IF(Position<>0) THEN
    BEGIN
    CSTPercent:=SalesInvLine."Tax %";
    END
    ELSE
    BEGIN
    VATPercent:=SalesInvLine."Tax %";
    END;
    END;


    Here actually TAX Group Code Contains Values like VAT12.5% ,CST 2% etc
    i am comparing if this field contains CST then CSTPercent will have the value of CST and so on


    Plz help me.

    solved
    Markandey Pandey
  • navuser1navuser1 Member Posts: 1,329
    Hi Experts,

    I want to fetch CST and VAT % in a separate variable.

    i have written the following code

    Sales Invoice Line, Body (1) - OnPreSection()
    VATPercent:-Integer
    CSTPercent:-Integer
    Position->Integer


    SalesInvLine.RESET;
    SalesInvLine.SETRANGE(SalesInvLine."Document No.",SalesInvHeader."No.");
    IF(SalesInvLine.FIND('-') ) THEN BEGIN
    Position:=STRPOS(SalesInvLine."Tax Group Code",'CST');
    // MESSAGE('Pos=%1',Position);

    IF(Position<>0) THEN
    BEGIN
    CSTPercent:=SalesInvLine."Tax %";
    END
    ELSE
    BEGIN
    VATPercent:=SalesInvLine."Tax %";
    END;
    END;


    Here actually TAX Group Code Contains Values like VAT12.5% ,CST 2% etc
    i am comparing if this field contains CST then CSTPercent will have the value of CST and so on


    Plz help me.

    If Tax Group Code "XYZ" is equal to VAT 4% Then how can you retrieve the Actual Tax % from it?
    ....
    ....
    Have you answer ?? The answer is No.

    So forget the Value of Tax Group Code field use Tax % Field ONLY :mrgreen:
    Now or Never
Sign In or Register to comment.