Tally XML Data Import Issue : Error while Importing Excel4Tally generated XML file to Tally.ERP 9 OR Can’t Import XML file to Tally.ERP 9 OR Check Import Error in Tally OR Verify Record Import or Failed in Tally. Solution :For all the Above Issue or Query, You can go to tally.imp file and check Import Error or check if Import ..
Category : Excel to Tally – Technical Error
Issue : When Xml Data Import in Tally Error – Ledger does not exist in Tally. Solution : 1. Please check if specified Ledger Name exist in Tally, 2. if already exist, Please make sure there is no space before or after ledger name in tally as Tally consider OR Ledger name spelling mismatch then ..
Issue : When xml data import – Duplicate entry created in Tally Solution : 1. Please go to Voucher type ‘Sales’ Option Method of voucher numbering ? = Manual Prevent duplicates ? = YES 2. If already data in voucher type so please crate new voucher type Method of voucher numbering ? = Manual Prevent ..
Error :- Item Master Error – Standard Rate not displaying in Tally Solution :- Make sure following values are fulfilled, not blank 1. Enter the Standard rate in Excel file 2. Please enter the date in ‘Applicable from SC / SP‘ excel c..
Option 1 :- Maintain balance bill by bill : Yes The error arises when the setting ‘Maintain bill by bill’ is ‘Yes’ in the ledger creation Please fill data in column name Bill Name. It should not blank, If you don’t have data for this column then, please copy Invoice No and paste inBill Name then generate xml file ..
How to concatenate two column in EXCEL Template. FORMULA ==CONCAT(A2,C2) – CONCAT two column in excel FORMULA ==CONCAT(A2,” “,C2)- CONCAT two column in excel with space ..
ERROR: Tally import error : No Accounting Allocations for ” SOLUTION : For above error, please Set the “Inventory values are affected” to Yes for the Sales/Purchase ledgers used in excel file. Steps 1. Go to Gateway of Tally 2. Select option “Accounts Info > Ledger > Alter” 3. Select the Sales/Purchase ledger 4. Set ..
Tally : Creating Auto Round Off Ledger Value in Excel. Please use following formula to set round off ledger value, it will automatically set round off based on your parameter. =ROUND(BF2+BS2+BU2,0)-SUM(BF2,BS2,BU2) Please find the attached Excel file with sample an..
How to Overwrite vouchers during import in Tally ERP 9? Solution : The option Overwrite vouchers during import can be enabled/disabled while importing vouchers into Tally.ERP 9.F12: General Configuration Set it to YES – if you want to Overwrite Vouchers. Ignore Error & Continue during Data Im..
Error : Error occur while Importing XML file to Tally “No entries in Voucher” Solution: This error normally occurs when the Voucher Amount is zero. To import/accept zero value entries in Tally, follow these steps : 1. Go to Gateway of Tally > F11: Features > F1: Accounts . 2. Set the option Enable Zero valued transactions as Yes 3. Try re-importing XML file in ..