udiMagic Release Notes

New features, fixes and changes in each version of udiMagic, the Excel to Tally import software.

Excel to Tally - Sample Excel sheet formats

Get link
Facebook
X
Pinterest
Email
Other Apps

May 05, 2011

The following sample Excel sheets formats are now available for UDIMagic users :-

1) Sales Vouchers with StockItems and Multiple Sales Ledgers
2) Sales Vouchers without StockItems, with multilple VAT rates
3) Point of Sale vouchers with Sales Return, Cancelled vouchers
4) Purchase Vouchers with VAT and CST (Local Purchase and CST Purchase)
5) Purchase Vouchers with StockItems and multiple VAT rates
6) Purchase Vouchers without StockItems, with multiple VAT rates

Sample Excel Sheet formats

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

No cash or bank ledger specified - Error in Tally

May 09, 2014

Applies to : Tally ERP 9 Steps to Reproduce the error (1) Create a group named " My Bank Accounts " under Primary ; Nature Of Group: Liabilities (2) Next, create a ledger named " Axis " under the group " My Bank Accounts " (3) Next, create a payment voucher as show below : Rs 500-Dr-------Petrol Expenses Rs 500-Cr-------Axis PS: Tally does not allow you to save the payment voucher and a message "No cash or bank ledger credited" is displayed. (4) Next, change / modify the ledger named " Axis " and set its parent / group as " Bank Accounts " (5) Again, try creating a payment voucher as mentioned in point 3. Still, you are not allowed to save the payment voucher and the same error message is displayed. This happens inspite of fact that we had modified the ledger " Axis " with correct group . Solution suggested by Tally Solutions, Bangalore In Gateway of Tally, press Ctrl+Alt+R. Select your Company ...

Tally Error: Voucher Totals do not match

November 04, 2008

"Voucher Totals do not match. Dr 122.00 Cr 122.00 Diff 0.00 " Surprised. Even though the Debit and Credit figures shown in the error are same, Tally Software still shows Dr and Cr mismatch. Cause of the Problem:- It is likely that the Excel sheet that you are using contains some FORMULA's. Though the display format (may) have been set to 2 decimals, MS-Excel internally does not round it off to 2 decimals until you use the =ROUND() function. Solution :- Search for FORMULA's used in the Excel sheet and use the =ROUND() function wherever decimal points are required. For example, let us assume, cell D2 has a FORMULA. i.e. =+A2 / B2 . You must change it to =Round(+A2 / B2,2) Remarks:- 1) You can set the number of decimals places DISPLAYED in Excel-sheet using option "Format >> Cell >> Number". However, when UDIMagic programmatically retrieves the cell-data, MS-Excel may return a different value which is not rounded-off to two decimals. 2) Hence,...

Agst Ref changes to New Ref

June 19, 2015

FAQs Using UDIMagic, I imported few Vouchers with "Against Reference" details. It is noticed that if the Reference-Number exists in Tally, then the bill-wise information is correctly imported and it correctly appears as "Agst Ref". However, if the Reference-Number does not exist in Tally, then the Voucher is still imported but with incorrect bill-wise information as "New Ref" I do not want "Agst Ref" to be automatically changed to "New Ref", but would prefer that the records be marked with error and should not be imported in Tally . Ans: Presently, there is no way to prevent the conversion of "Agst Ref" to "New Ref" which is the default behavior of Tally Software. To be more specific, the whole process is as follows :- a) UDIMagic sends the Voucher data to Tally with correct bill-wise details (i.e. Agst Ref) b) Tally automatically converts the "Agst Ref" to "New Ref", if the specified R...