1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

EXPORT ITEM IN EXCEL

Discussion in 'Requests' started by Nupur, May 1, 2015.

    
  1. Nupur

    Nupur Member


    Please Help? How to Export Item In Excel Including Standard Rates? Please Please provide Full Tdl Code
     
    Nupur, May 1, 2015
    #1


  2. D Lokesh

    D Lokesh Member


    for this better you try in Excel ODBC.
    go to Excel and select ODBC Drive then Stock Item there you select Name & Rate it'll come.


    or Other Wise See this Code



    [#Menu : GateWay Of Tally]

    Key Item : ItemExport : E : Display : ItemExport

    [Report : ItemExport]

    Form : ItemExport

    [Form : ItemExport]

    Use : Dsp Template
    Part : ItemExport

    [Part : ItemExport]

    Line : ItemExportT, ItemExportD
    Repeat : ItemExportD : ItemExport

    [Collection : ItemExport]

    Type : Stock Item

    [Line : ItemExportT]

    Use : ItemExportD
    Local : Field : ItemExport1 : Info : "S NO"
    Local : Field : ItemExport2 : Info : "Name"
    Local : Field : ItemExport3 : Info : "Rate"

    [Line : ItemExportD]

    Field : ItemExport1, ItemExport2, ItemExport3

    [Field : ItemExport1]

    Use : Number Field
    Set as : $$Line
    Width : 10

    [Field : ItemExport2]

    Use : Name Field
    Set as : $Name
    Width : 70

    [Field : ItemExport3]

    Use : Rate Field
    Set as : $StandardPrice
    Width : 20
     
    D Lokesh, May 10, 2015
    #2


  3. Nupur

    Nupur Member


    This Code not working the follwing error show on screen. see the attach image
     

    Attached Files:

    Nupur, May 11, 2015
    #3


  4. D Lokesh

    D Lokesh Member


    Try This

    [#Menu : GateWay Of Tally]

    Key Item : ItemExport : E : Display : ItemExport

    [Report : ItemExport]

    Form : ItemExport

    [Form : ItemExport]

    Use : Dsp Template
    Part : ItemExport
    FullWidth : Yes
    FullHeight : Yes

    [Part : ItemExport]

    Line : ItemExportT, ItemExportD
    Repeat : ItemExportD : ItemExport
    Scroll : Vertical

    [Collection : ItemExport]

    Type : Stock Item

    [Line : ItemExportT]

    Use : ItemExportD
    Local : Field : ItemExport1 : Info : "S NO"
    Local : Field : ItemExport2 : Info : "Name"
    Local : Field : ItemExport3 : Info : "Rate"

    [Line : ItemExportD]

    Field : ItemExport1, ItemExport2, ItemExport3

    [Field : ItemExport1]

    Use : Number Field
    Set as : $$Line
    Width : 10

    [Field : ItemExport2]

    Use : Name Field
    Set as : $Name
    Width : 70

    [Field : ItemExport3]

    Use : Rate Field
    Set as : $StandardPrice
    Width : 20
     
    D Lokesh, May 12, 2015
    #4


  5. Nupur

    Nupur Member


    Thank you so much Mr. D Lokesh. Please just one more help. how Can Export with Item parts no in this list?
     
    Nupur, May 13, 2015
    #5


  6. Nupur

    Nupur Member


    Here is the modify the code. Export Item list with part number of stock items including standard rates
     

    Attached Files:

    Nupur, May 16, 2015
    #6


Share This Page