Dear All, Am trying to directly export the Ewaybill data from Voucher / Invoice... I Want data to be updated and exported in the excel file... [Function: TGSTeWayBillVchrExport] Variable : vMstID : Number : If ##IsVchInDuplicateMode Then 0 Else $MasterID Variable : vExcelUpdate : Logical : ##SVExcelExportUpdateBook Variable : vIsVchExported : Logical : $VChIsExportedToeWayBill Variable : vIsPurchaseFromURD : Logical : No Variable : VARVchDate : Date : $Date 040 : Set : SVPrintFileName : C:\Program Files\TallyPrime\GSTVch_e-WayBill.xlsx ;;If $$IsEmpty:##SVExportLocation Then ##SVExpFileName Else ##SVExportLocation + "\" + ##SVExpFileName 060 : Set : SVOutputType : "ExportButton" 050 : Set : SVExportLanguage : If $$IsUnicodeSupported Then ##SVExportLanguage Else $$SysName:English 070 : Set : SVExportFormat : If $$IsSysNameEqual:GSTeWayBillJson:##SVExportFormatVar Then $$SysName:Utf8JSON Else $$SysName:Excel 080 : Set : SVExcelExportUpdateBook: If $$IsSysNameEqual:Excel:##SVExportFormat Then Yes Else No 100 : Call : GenerateGSTeWayBillExportSmry$$SysName:GSTeWayBill):##VARVchDate:##VARVchDate:##VARVchDate:##vIsVchExported:##vMstID ;; 350 : Do If : ($$IsSysNameEqual:Utf8JSON:##SVExportFormat) : Export : GSTeWayBillVch_JSONExport : Yes 355 : Do If : ($$IsSysNameEqual:Excel:##SVExportFormat) : Export : GSTeWayBillVch_ExcelExport : Yes 360 : Set : SVExcelExportUpdateBook: If $$IsSysNameEqual:Excel:##SVExportFormat Then No Else ##vExcelUpdate 380 : Set : SVExportFormat : $$SysName:Excel 390 : Set : SVExpExportFormat : $$SysName:Excel 400 : Return
