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..
Archives : January-2020
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 ..
Error : Error while importing Sales with Inventory excel – proper ref name is not given for retailer Solution : Please fill data in column name Bill Ref No It should not blank, If you don’t have data for this column then, please copy Invoice No and paste inBill Ref no then generate xml file again. Try importing the newly created ..
Issue : Bank Statement xml Data Import in Tally Error – Proper Ref Name not given for ‘Suspense A/c’! Solution : 1. Please fill data in column name ‘Bill Ref No‘ in Excel. It should not blank. 2. Before Processing your excel data, make sure column Transaction ID & Bill Ref No are not blank in excel, if yes, please ..
Issue : Tally Import Error – Voucher totals do not match! Dr: 22,050.00 Dr Cr: 22,000.00 Cr Diff: 50.00 Dr Solution : 1. Verify the excel data filled with proper Debit and Credit Amount 2. Remove excel formula’s if any 3. After correcting point 1,2 in excel, Please regenerate XML file using Excel4Tally 4. Import newly created ..
Recent Comments