Posts

Showing posts from May, 2011

Excel to Tally - Sample Excel sheet formats

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

Date displayed as number in MS Excel

Query On entering DATE in Excel, it is displayed as a number rather than Date. Solution 1) Select "Tools >> Options >> View" 2) Uncheck the option "Formulas"  which appears under the section "Window options".

Failed to fetch Tally data

The aforesaid error Failed to fetch Tally data appears if the Tally License Server and Tally Software both are running on the same Port. Solution :- 1) In Tally Software, press F12 and select option Advanced Confiuration 2) Next, set the Port to a different than the current Port, say 9001 or 9002. 3) Save it using Ctrl+A. The new Port settings will be visible in the Gateway of Tally. 4) Next, start UDIMagic and in the 2nd screen, click on the Settings button and set the Port as assigned in Tally Software in point 2. 5) Next, in UDIMagic 3rd screen, click on the "Test Connection" button to test connection with Tally Software.