Fetch Price in a Collection

Discussion in 'Tally Developer' started by Hasan@123, Jun 29, 2020.

         
  1. Hasan@123

    Hasan@123 Member


    Dear developers,
    I want to fetch price from pricelist instead of Last sale price. How can i do that?
    please check my code.


    [#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
    Delete : Format
    Add : Format : $Name,
    Add : SubTitle : $$LocaleString:"Stock Items","Closing Qty", "Price"

    Add: Format: $_ClosingBalance
    Fetch: ClosingBalance

    Add: Format:$_LastSalePrice
    Fetch: Last Sale Price
     


Share This Page