This is for Auto XML Sales Voucher after Save (Both Alter or Create). Code: [#Form: Sales Color] On : Form Accept : $$InAlterMode : CALL : SALES Export Report On : Form Accept : $$InCreateMode : CALL : SALES Export Report ;; Function Definition begins [Function: SALES Export Report] Variable: TempStr : String Variable: VoucherId : String 020 : IF : $$InCreateMode 030 : SET : TempStr : $Cmpvchid:Company:##SVCurrentCompany;$$CollectionField:$MasterId:@@LastItem:CompanyVouchers 040 : SET : VoucherID : "ID:" + ##TempStr 050 : ELSE 060 : SET : VoucherID : "ID:" + $$String:$MasterId 070 : END IF 080 : SET : SVExportLocation : $(AppINIConfig, "AppINIConfig").ExportPath 090 : SET : SVExportFormat : $$SysName:XML 100 : Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber 110 : SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat 111 : Set : SVOpenFileAfterExport : No 120 : EXPORT REPORT : . : TRUE ;; End of File
For AUTO PDF Add this line Code: 80a : SET : SVExportFormat : $$IsSysNameEqual:English:#DSPExportLanguage OR @@EnglishLanguageId = ##SVCurrentUILanguageId And Replace This $$SysName:XML to $$SysName:PDF
how do i replace the "/" in the voucher number with "-" eg. voucher number is abc/2013-14/1234, so how do i change it to abc-2013-14-1234 so that the same can be used as a name. when i use $$String:$Vouchertypename+"_"+$$String:$vouchernumber with a voucher number using the "/" i get folder vouchertype_abc, subfolder 2013-14 and file named 1234 also how do i break apart the voucher number into the three parts, prefix - number - suffix
thanks to give this code and it's successfully Works, but i have a one additional Query. How to Change XML File "Export Location"..?
Dear Can u just give me the working TDL for the Auto XML Sales invoice creation on Saving & Editing .... I tied above code , but it I snot generating any files.. Pls help me Regards Vinoj
[#Form: Sales Color] On : Form Accept : $$InAlterMode : CALL : SALES Export Report On : Form Accept : $$InCreateMode : CALL : SALES Export Report ;; Function Definition begins [Function: SALES Export Report] 10: SET : SVExportLocation : "D:\TallyExportFile" ; Export Location path 20: SET : SVExportFormat : $$SysName:XML 30: Set : SVPrintFileName : $$String:$Vouchertypename+"_"+$$String:$vouchernumber 40: SET : SVPrintFileName : $$MakeExportName:##SVPrintFileName:##SVExportFormat 50: Set : SVOpenFileAfterExport : No 60: EXPORT REPORT : . : TRUE ;; End of File Its work very fine for me. Please Check it...
WONDERFUL TDL. SUCH THOUGHTS DO HELP IN TAKING THE TALLY TO THE NEXT LEVEL AND EASY WORKING ATMOSPHERE. Thank you Mr. H V Patel, your contribution is truly helpful. Bye
Very fine work...But in pdf middle part expands page width and mismatch with upper part & bottom part...Can you guide me...?
Dear Experts Thanks in advance can any one help me to design code for below format in EXCEL to auto export to single file with below fields voucher no dateparty nameAmount 21202/03/2015kamal500-00 21302/03/2015cash 700-00