Need Help: Export to excel - from a purchase voucher, Item Name and Batch Name

Discussion in 'Requests' started by Gaurav Kothari, Jan 12, 2022.

    
Tags:
  1. Gaurav Kothari

    Gaurav Kothari New Member


    I have added this code to add button to purchase and sales voucher

    [#Form: Voucher]
    Add : Button : MMSReport2021
    [Button : MMSReport2021]
    Key : ALT + 2
    Title : "Serials"
    Action : Display : MMSReport2021
    [Report: MMSReport2021]
    Form : MMSReport2021
    [Form : MMSReport2021]
    Part : MMSReport2021
    Height : @@InvHeight inch
    Width : @@InvWidth inch
    [Part : MMSReport2021]
    Line : ItemExport, HiLine1
    Repeat : ItemExport : Batch Allocations
    [Line : ItemExport]
    Field : ItemExport1, ItemExport2, ItemExport3
    [Field : ItemExport1]
    Use : Name Field
    Set as : $Name
    Width : 70
    [Field : ItemExport2]
    Use : Name Field
    Set as : $BatchName
    Width : 20
    [Field : ItemExport3]
    Use : Name Field
    Set as : "Hi - Test Field - If This is Printing Meaning not fatching proper batch Fields"
    Width : 100
    [Line : Hiline1]
    Field : Hifield1
    [Field : Hifield1]
    Use : Name Field
    Set As : "Hi - Test Line - If This is Printing Meaning Only Line ItemExport is not Printing"
    Width : 100

    above code is not working, i'am not sure why

    Now what i need is when I press this button, report directly get exported to an excel file, which contains only Four column of data, First column containing ITEM NAME, Second column containing BATCH NAME, Third Column containing Voucher Number and Fourth Column containing Voucher Date, no other data is required except mentioned
     
    Last edited: Jan 12, 2022


Share This Page