I usually code for myself, using trial and error method but following scenario is simple but I am not able to code it [#Form: Voucher] Add : Button : MyModelSerialReport [Button : MyModelSerialReport] Key : ALT + 2 Title : "Serials" Action : Display : MYModelSerialReport [Report : MYModelSerialReport] ? ? ? Just want from a purchase voucher Item Names - in Column A Batch Names - in Column B Like Column A Column B Item 1 Item 1 - Batch 1 Item 1 Item 1 - Batch 2 Item 1 Item 1 - Batch 3 Item 2 Item 2 - Batch 1 Item 2 Item 2 - Batch 2 Item 2 Item 2 - Batch 3 Item 3 Item 3 - Batch 1 Item 3 Item 3 - Batch 2 Item 3 Item 3 - Batch 3 Nothing Else, no header, no footer nothing, file format required is excel, no formatting
Call Bellow function on key press [Function: Export Batch] 001: OPEN FILE : "Item_Batch.xlsx" : Excel : Write 010: Set Object 020: Set Target 240: WALK : Inventory Allocations 250: WALK : Batch Allocations 255: WRITE CELL : ##RowIndex : 1 : $StockItemName 260: WRITE CELL : ##RowIndex : 1 : $BatchName 265: INCREMENT : RowIndex 290: END WALK 300: END WALK 360: CLOSE TARGET FILE 370: EXEC COMMAND : Excel : "Item_Batch.xlsx"