Expend information in item table

Discussion in 'Free Source Codes' started by sashvat, May 5, 2018.

    
  1. sashvat

    sashvat New Member


    ;;Expend information in item table
    [#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,100.5
    Add : SubTitle : $$LocaleString:"PRODUCT","CODE","COMPANY","GROUP","%","MRP","LPP","LSP","CL Qty"

    Add :Format :$partno
    Fetch :partno

    Add :Format :$Category
    Fetch :Category

    Add :Format :$parent
    Fetch :parent

    Add :Format :$GSTIGSTRate
    Fetch :GSTIGSTRate

    Add :Format :$mrp
    Fetch :mrp

    Add :Format :$Standardcost
    Fetch :standardcost

    Add :Format : $LastSalePrice
    Fetch :LastSalePrice

    Add :Format : $closingbalance
    Fetch :closingbalance
     
    Last edited: May 6, 2018


  2. ali23033

    ali23033 New Member


    how to use this code?
     


  3. sashvat

    sashvat New Member


     

    Attached Files:



  4. R.Raj

    R.Raj New Member


    Heading in $$local string does not match with the add: format in item table. Their should be category in place of company & not able to see all the relative fields of item table. Kindly correct the code of item table.
     


  5. R.Raj

    R.Raj New Member


    Heading in $$local string does not match with the add: format in item table. Their should be category in place of company & not able to see all the relative fields of item table. Kindly correct the code of item table.
     


  6. Systecg

    Systecg Member


    how see report after add text file in tally
     


  7. sashvat

    sashvat New Member


    Capture.PNG
     


  8. amitkjangid

    amitkjangid New Member


    not working while passing voucher in tally 6.4.3 version
     


  9. sashvat

    sashvat New Member


    working fine 6.4.3 Capture.PNG
     


  10. R.Raj

    R.Raj New Member


    Sashvat ji,
    Your shared code is different from the screenshot. Kindly share your code as per screenshot, if completed. And kindly share how to increase width of Name of items in sales, purchase and stock item master so that Item names does not shrink and have a clear view like your item table and ledger table expansion.

    Thanks in advance.
     


  11. harishkhl43

    harishkhl43 New Member


    excellent code
     


Share This Page