Syntax for MRP

Discussion in 'Requests' started by Adeshwar Mehta, Jan 24, 2018.

    

  1. Can someone help me outline what is the Syntax to be used for MRP

    Like whats the function name that I have to use so that it fetches MRP for that field.
     



  2. So I tried This for getting GST and MRP in list of Stock Items

    i get only 0

    I have tried using MRPRate or MRPValue but it keeps returning only 0

    Can someone correct it


    ;;======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 : $MRP:StockItem:$StockItemName
    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========
     


  3. sattam

    sattam Active Member


    [Field : IAMRP]
    Use : Number Field
    Set As : If $$IsEmpty:$ExciseMRPRate Then $$GetExciseMRPRateForStkItem:$StockItemName:$..ExciseUnitName Else $ExciseMRPrate
    Align : Centre
    Border : Thin Left Right
    Skip : YES

    Try this.
     



  4. Hey,

    Thanks for the suggestion. Unfortunately it is still returning zero along with the error that the function is not defined.
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Send you Demo Tally Company data with items as shown in your Invoice...so i can work on it............
     


  6. Nikhilesh

    Nikhilesh New Member


    Hello Sir I want to display MRP price in List of Stock Item, but i cann't fetch the value. So please send me code for that.

    My code is ::::
    [*Collection: Vch Stock Item Extract]

    Use : ExtractAlias Collection
    Source Collection : Stock Item Src
    Collection : StockItem PartNo With Closing
    Title : $$LocaleString:"List of Items"

    Fetch : Name,parent, VchStkItmBalance,Rate
    Set as : $FirstName
    Keep Source : ()...
    Client Only : No
    Filter : StGroupjobi1
    Format : $VchStkItmBalance : "Base"
    Format : $Rate: "Base"


    [System:formula]
    StGroupjobi1: If $$IsEmpty:#TRSPORTF1 or $$IsEndOfList:#TRSPORTF1 or not $EnableGroupWiseBilling:Company:##SVCurrentCompany then not $$IsEqual:$parent:$$LocaleString:#TRSPORTF1 else $$IsEqual:$parent:$$LocaleString:#TRSPORTF1
     


  7. Satish Verma

    Satish Verma New Member


    [Field : IAMRP]
    Use : Number Field
    Set As : $StockItemMRPRate
    Align : Centre
    Border : Thin Left Right
    Skip : YES
     


Share This Page