Additional column of GST rate and hsn code in Voucher entry

Discussion in 'Free Source Codes' started by JAYRAM96A, Nov 23, 2018.

    
  1. JAYRAM96A

    JAYRAM96A Member


    ;;======TO SHOW GST RATE & HSN CODE IN SALES & PURCHASE VOUCHER ONLY FOR DISPLAY======

    [#Line : EI ColumnOne]
    Option : Global EI ColumnOne

    [!Line: Global EI ColumnOne]
    Add : Right Fields : At Beginning : IAHSNcodeT, IAMVAT

    [Field : IAHSNCodeT]
    Info : "HSN/SAC Code"
    Align : Centre
    Width : 15
    Style : Small bold

    [Field : IAMVAT]
    Info : "GST%"
    Align : Centre
    Width : @@NumberWidth
    Style : Small bold

    [#Line : EI ColumnTwo]
    Option : Global EI ColumnTwo

    [!Line: Global EI ColumnTwo]
    Add : Right Fields : At Beginning : IAHSNcodeT, IAMVAT
    Local : Field : IAHSNCodeT : Info : " "
    Local : Field : IAMVAT : Info : " "


    [#Line : EI InvInfo]
    Option : Global EI InvInfo

    [#Line : CI InvInfo]
    Option : Global EI InvInfo

    [!Line: Global EI InvInfo]
    Add : Right Fields : At Beginning : IAHSNCode, IAMVA

    [Field : IAHSNCode]
    Use : Short Name Field
    Set As : $GSTHSNCode:StockItem:$StockItemName
    Align : Centre
    Border : Thin Left Right
    Width : 15
    Skip : YES

    [Field : IAMVA]
    Use : Number Field
    Set As : $GSTIGSTRate:StockItem:$StockItemName
    Format : "NoZero, Percentage"
    Align : Centre
    Border : Thin Left Right
    Skip : YES


    ;;=====HSN-SAC CODE IN VOUCHER ENTRY

    [#Collection: List of Stock Items]

    Use : Alias Collection
    Title : $$LocaleString:"List of Stock Items"
    Type : Stock Item
    Fetch : Name
    Report : Stock Item
    Variable : SStockItem
    Trigger : SStockItem
    IsODBCTable : Yes
    ;;Unique : $StockItemName

    Add :Format :$GSTIGSTRate
    Fetch:GSTIGSTRate

    Add :Format :$GSTHSNCode
    Fetch:GSTHSNCode


    ;;TO SHOW GST DETAILS IN STOCK SUMMARY

    [#Collection: List of Stock Items]
    Add:Sub Title :"Item Name"

    [#Collection: List of Stock Items]
    Add:Sub Title :"GST"
    Add :Format :$GSTIGSTRate
    Fetch:GSTIGSTRate

    [#Collection: List of Stock Items]
    Add:Sub Title :"HSN/SAC"
    Add :Format :$GSTHSNCode
    Fetch:GSTHSNCode


    [#Collection: List of Stock Items]
    Add:Sub Title :"CL Qty"


    ;;=====END OF CODE========
     
    Last edited: Dec 2, 2018


  2. udaya

    udaya Active Member


    sir please add PartNo also.....
     


  3. Rais Ahmed

    Rais Ahmed Member


    All ready these type of post r so many even with part no. pl search and what Jayaram has posted also r copy past.
    Regards
     


  4. udaya

    udaya Active Member


    sir "partno"
     


Share This Page