Posts

Showing posts from November, 2014

UDIMagic on Remote Desktop

Can I use UDIMagic Software on Remote Desktop ? No . UDIMagic uses Excel OLE Automation and hence must not be used on a Remote Desktop wherein :- a) Multiple users work simultaneously on UDIMagic b) Multiple users work simultaneously on Excel

Import data into a specific Company in Tally

How do I specify/hard-code/fix the CompanyName in which data is to be uploaded from Excel to Tally ? There are three alternatives to specify the Company in which data is to be uploaded in Tally ERP Accounting Software. 1) COMPANYNAME tag in XML You can use the COMPANYNAME tag in the XML tags to specify the CompanyName. Ex: <MASTER TYPE="LEDGER"> <COMPANYNAME>ABC Company</COMPANYNAME> .... other tags </MASTER> 2) COMPANYNAME attribute in XML You can use the COMPANYNAME attribute in the XML tags. Ex: <MASTER TYPE="LEDGER" COMPANYNAME="ABC Company"> .... other tags </MASTER> 3) COMPANYNAME in UDIMagic.ini (configuration) file You can specify the Company Name in "c:\udi-magic\udimagic.ini" file as shown below:- [ExcelToTally] CompanyName=ABC Company Remarks:- a) The aforesaid alternatives are given in accordance to their precedence. i.e. >> 1st precedence is COMPANYNAME tag in XML ...

Understanding new features in v6.0

Show the Upload status (individually for each record) in Excel When you enable this feature, the Upload status ( Yes or No ) is set for each row in the Original Excel sheet. What does the Upload Status mean ? Yes   - Record is successfully uploaded into Tally No -  Record is NOT uploaded into Tally What is the benefit / use of this feature ? a) You can easily identify the records with errors (if any), and correct those records. b) When you re-import the data, the records with Upload Status as " No " (i.e. which were not imported earlier ) are processed and uploaded into Tally. Remarks:- This feature is disabled by default. You can enable it using the "Settings" button in UDIMagic.