1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

HELP FOR MRP IN INVOICE PRINT

Discussion in 'Free Source Codes' started by narayane88, Dec 23, 2017.

    
  1. narayane88

    narayane88 Active Member


    Please admin Help me for Mrp Show Invoice Print
     
    narayane88, Dec 23, 2017
    #1


  2. manish T

    manish T New Member


    any one can please share code for MRP code
     
    manish T, Dec 23, 2017
    #2


  3. narayane88

    narayane88 Active Member


    i have try this code for Mrp

    [Field:SCS MRP Qty]
    Use:Rate Field
    Set as : @MRPRateSetVal
    Set Always : Yes
    Skip : Yes
    MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else +
    If NOT $$IsEmpty:$MRPRate Then $MRPRate +
    Else If $$IsEmpty:mad:locPartyStateName OR $$IsSysName:mad:locPartyStateName Then $$GetEIStkItemMRP:$StockItemName:$Date Else +
    $$GetEIStkItemMRP:$StockItemName:$Date:mad:locPartyStateName
    locPartyStateName: $$BaseOwner:$VATPartyLedState
    Inactive : $$IsEnd:$StockItemName OR $$IsSysName:$BaseUnits:StockItem:$StockItemName OR $$IsEmpty:mad:MRPRateSetVal
     
    narayane88, Dec 24, 2017
    #3


  4. D Lokesh

    D Lokesh Member



    HI Sir

    Try this below code

    Before this need to enable VAT Details in F11 --> F3 Features

    [Field: EXPINV MRPValue]

    Use : EXPINV MRPTitle
    Set Always : Yes
    Align : Right
    Set as : @MRPRateSetVal ;;$MRPRate
    Set Always : Yes
    Skip : Yes
    MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else +
    If NOT $$IsEmpty:$MRPRate Then $MRPRate +
    Else If $$IsEmpty:mad:PartyStateName OR $$IsSysName:mad:PartyStateName Then $$GetEIStkItemMRP:$StockItemName:$Date Else +
    $$GetEIStkItemMRP:$StockItemName:$Date:mad:PartyStateName
    PartyStateName : If @@IsGSTOnAndAppl Then $$BaseOwner:$GSTVchPartyState Else $$BaseOwner:$VATPartyLedState
     
    D Lokesh, Dec 25, 2017
    #4


  5. raju kumar

    raju kumar New Member


    Dear Sir,

    Required Advance TDL Training
    you can me help me
    Charges I will Pay

    Mobile No-9334426044
     
    raju kumar, Dec 28, 2017
    #5


  6. narayane88

    narayane88 Active Member


    please correct my code
    [Field:SAS Item Description]
    Use: Simple Field
    Set as: if NOT $$IsSysName:$StockItemName then @@InvItemName else + "Mrp : "+ @MRPRateSetVal
    Width: 35
    Line:0
     
    narayane88, Dec 28, 2017
    #6


  7. Ejajkhan

    Ejajkhan New Member


    [#Field: EXPINV MRPTitle]
    Use : Name Title Field
    Width: @@NameWidth - 15
    Info : $$LocaleString:"Sale Rate"
    Align : Centre
    Style : Small
    Border : Thin Left
    Invisible : NOT @@InvWithMrp
     
    Ejajkhan, Jan 1, 2018
    #7


  8. Ejajkhan

    Ejajkhan New Member


    [#Field: EXPINV MRPTitle]
    Use : Name Title Field
    Width: @@NameWidth - 15
    Info : $$LocaleString:"Sale Rate"
    Align : Centre
    Style : Small
    Border : Thin Left
    Invisible : NOT @@InvWithMrp
     
    Ejajkhan, Jan 1, 2018
    #8


  9. D Lokesh

    D Lokesh Member


    Dear Sir,

    Try This Code

    [#Line : EXPINV Column1]

    Option : SAL EXPINV Column1 : @@IsSales

    [!Line : SAL EXPINV Column1]

    Local : Field : EXPINV MRPTitle : Set as : "Sales"

    [#Line : EXPINV Column2]

    Option : SAL EXPINV Column2 : @@IsSales

    [!Line : SAL EXPINV Column2]

    Local : Field : EXPINV MRPTitle : Set as : "Rate"
     
    D Lokesh, Jan 2, 2018
    #9


  10. narayane88

    narayane88 Active Member


    I want print
    Stock Item Name + Mrp: +Rs xxx (Mrp of Item)
     
    narayane88, Jan 2, 2018
    #10


  11. D Lokesh

    D Lokesh Member



    Hi Sir,

    Try This
    Set as : $$String:$StockItemName + $$String:#EXPINVMRPValue
     
    D Lokesh, Jan 2, 2018
    #11


  12. narayane88

    narayane88 Active Member


    Hi Sir,

    $$String:#EXPINVMRPValue
    These Statement not get any value in TDL
     
    narayane88, Jan 2, 2018
    #12


  13. Ejajkhan

    Ejajkhan New Member


    thanks sir ji is working PERFECT
     
    Ejajkhan, Jan 3, 2018
    #13


  14. D Lokesh

    D Lokesh Member


    Thank You sir
     
    D Lokesh, Jan 3, 2018
    #14


  15. Vikash Kumar

    Vikash Kumar New Member


    Respected Experts
    What's Wrong in this TDL?

    ;;======TO SHOW IGST RATE & MRP IN SALES & PURCHASE VOUCHER ONLY FOR DISPLAY======

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

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

    [Field : IAMRPT]
    Info : "MRP"
    Align : Centre
    Width : @@NumberWidth
    Style : Small bold

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

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

    [!Line: Global EI ColumnTwo]
    Add : Right Fields : At Beginning : IAMRPT, IAMVAT
    Local : Field : IAMRPT : 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 : IAMRP, IAMVA

    [Field : IAMRP]
    Use : Number Field
    Set As : If $$IsEmpty:$ExciseMRPRate Then $$GetExciseMRPRateForStkItem:$StockItemName:$..ExciseUnitName Else $ExciseMRPrate
    Align : Centre
    Border : Thin Left Right
    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 :$MRP
    Fetch:MRP


    ;;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 :"MRP"
    Add :Format :$MRP
    Fetch:MRP


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


    ;;=====END OF CODE========
     
    Vikash Kumar, May 11, 2018
    #15


  16. Sanjeev S

    Sanjeev S Active Member


    Small correction.....

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

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

    [Field : IAMRPT]
    Info : "MRP"
    Align : Centre
    Width : @@NumberWidth
    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 : IAMRPT, IAMVAT
    Local : Field : IAMRPT : 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 : IAMRP, IAMVA

    ;;;******************* Field definition changed. **********************
    [Field : IAMRP]
    Use : Number Field
    Set As : @MRPRateSetVal
    Align : Centre
    Border : Thin Left Right
    Skip : YES

    MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else +
    If NOT $$IsEmpty:$MRPRate Then $$Number:$MRPRate +
    Else If $$IsEmpty:mad:PartyStateName +
    OR $$IsSysName:mad:PartyStateName +
    Then $$GetEIStkItemMRP:$StockItemName:$Date Else +
    $$GetEIStkItemMRP:$StockItemName:$Date:mad:PartyStateName
    PartyStateName : $$BaseOwner:$VATPartyLedState


    [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 :$MRP
    Fetch:MRP


    ;;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 :"MRP"
    Add :Format :$MRP
    Fetch:MRP


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


    ;;=====END OF CODE========
     
    Sanjeev S, May 16, 2018
    #16


  17. Sanjeev S

    Sanjeev S Active Member


    Small correction.....

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

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

    [Field : IAMRPT]
    Info : "MRP"
    Align : Centre
    Width : @@NumberWidth
    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 : IAMRPT, IAMVAT
    Local : Field : IAMRPT : 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 : IAMRP, IAMVA

    ;;;******************* Field definition changed. **********************
    [Field : IAMRP]
    Use : Number Field
    Set As : @MRPRateSetVal
    Align : Centre
    Border : Thin Left Right
    Skip : YES

    MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else +
    If NOT $$IsEmpty:$MRPRate Then $$Number:$MRPRate +
    Else If $$IsEmpty:mad:PartyStateName +
    OR $$IsSysName:mad:PartyStateName +
    Then $$GetEIStkItemMRP:$StockItemName:$Date Else +
    $$GetEIStkItemMRP:$StockItemName:$Date:mad:PartyStateName
    PartyStateName : $$BaseOwner:$VATPartyLedState


    [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 :$MRP
    Fetch:MRP


    ;;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 :"MRP"
    Add :Format :$MRP
    Fetch:MRP


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


    ;;=====END OF CODE========
     
    Sanjeev S, May 16, 2018
    #17


  18. Adeshwar Mehta

    Adeshwar Mehta Member


    This code has a weird problem
    It shows MRP in saved vouchers which are reopened. While entering in voucher it always shows MRP as 0 even before item is selected. Also the MRP is black in the list of Stock items.
    GST Rate Works fine
     
    Adeshwar Mehta, May 16, 2018
    #18


  19. Adeshwar Mehta

    Adeshwar Mehta Member


    This code has a weird problem
    It shows MRP in saved vouchers which are reopened. While entering in voucher it always shows MRP as 0 even before item is selected. Also the MRP is black in the list of Stock items.
    GST Rate Works fine
     
    Adeshwar Mehta, May 17, 2018
    #19


Share This Page