Multi Price List Rate

Discussion in 'Requests' started by Vijaya Kumar, Jan 5, 2013.

    
  1. Vijaya Kumar

    Vijaya Kumar New Member


    Hi,

    How to get the rate from Stock Item.? Am not Able to get the Rate from the below Code.

    "Select $masterid,$name,$Parent, $$FullList:FullPriceList:$Date,$$FullList:FullPriceList:$pricelevel,$$FullList:FullPriceList:pricelevellist:$Rate from StockItem "


    Thanks

    Vijayakumar
     


  2. admin

    admin Administrator Staff Member


    U can write a method in stock Item object and call that in Select Query
    Ex:
    [#Object : Stock Item]
    MyMethod: $$FullList:FullPriceList:$Date

    Query:

    Select $Name,$MyMethod from StockItem
     
    Pritam Krishna likes this.


Share This Page