In some cases, transactions accidentally appear in the Marked for Deletion on Portal section of GSTR-1 due to some changes in the transaction details, as explained below. You can easily address such cases by making the suggested updates.

• • Change in company GSTIN
  • Change in party
  • Change in party GSTIN/UIN
  • Change in GST amount
  • Change in voucher number
  • Deletion of transaction from books

This exception occurs when the Voucher No. or Document No. is duplicate. In case of duplicate voucher numbers, drill down to the voucher and update the voucher number. In case of duplicate document numbers, you can update the voucher numbering from the respective voucher type master. To learn more, refer to Duplicate Voucher No./Document No. for a detailed resolution. 

This error may appear while uploading the JSON file to the GST portal. Below are the possible solutions.

1. Copy the data as a backup.
2. Download and install the latest release of TallyPrime.
3. Open the company data in TallyPrime.
   1. Ensure all Incomplete/Mismatch in information in GSTR-1 are resolved, and all masters GSTIN including HSN details are validated.
   2. In case, e-Invoice is applicable to your business, you need to open the GSTR-1 report in CSV format, and upload the files created for sections other than B2B, and exports. For more information, refer to the Use the GST Offline Tool.

If the error appears again, and the Status is Processed with Error, then error report is generated in the GST portal.

To know the cause, under the Error Report column click Generate error report.

1. Download the error report from the GST portal.
   1. On GST portal > Downloads > Offline Tools > Returns Offline Tool.
   2. Click Download to download the error report.

2. Open the downloaded error report file. Refer to the Use the GST Offline Tool.
   The errors are listed for transactions. While filing GSTR-1, the common errors and solutions are mentioned on the table below:

   Error	Cause & Solution
   Invalid UQC	Cause: UQC for HSN is blank or not valid or created New UQC where GSTIN accepts values only from the recommended list.
   	Solution: Gateway of Tally> Alter > Unit. Press Enter to select the Unit Quantity Code (UQC) from the list of Units. On Unit Quantity Code (UQC) field, select the UQC from List of UQCs. The list is published as per the GSTIN updates. If a new UQC is selected from the list, press Ctrl+A to save and try to upload on GSTR-1.
   Inactive GSTIN	Cause: According to GST norms, if your GST Registration is cancelled, your GSTIN is no longer valid.
   	Solution: Make a note of the inactive GSTINs and follow the steps below to convert those transactions (where inactive GSTIN was used) from B2B to B2C sales. Press Alt+G > search GSTR-1. Press Enter on B2B Invoices 4A, 4B, 4C, 6B, 6C. Select the inactive GSTIN and change the nature of transactions as Sales to Consumer – Taxable. Note: In case you need to move multiple transactions to B2C, then alter the party master’s Registration Type as Consumer and remove the GSTIN to avoid the same error for upcoming Transactions billed for the customer.
   State code is not available. or, The place of supply and state code of the supplier should be different for Inter State Supply.	Cause: New state created by the users instead of selecting state from List of States Data is imported from other software Due to spelling errors while creating a new state Letters of the state is created with upper case The state code starting and Place of supply are different
   	Solution: TallyPrime has listed all the states and their state code as per the GSTN Master sheet. Recommend selecting the state from List of states, so that the respective state code can be assigned accordingly while exporting returns. In case the place of supply is modified during voucher entry, ensure the place of supply is the same as the supplier state when IGST is collected, or the place of supply code is the same as the supplier state when CGST / SGST is collected. For example, when the place of supply is Karnataka, GSTIN / State Code should be always starting with 29.
   HSN does not belong to the service/Goods or, Invalid HSN/SAC	Cause: Type of supply is wrongly configured in inventory or accounting Master.
   	Solution: In case of Services, HSN/SAC should begin with the number 99, which identifies the code as a SAC and not an HSN. Click here to know the correct HSN details. Make a Note of HSN/ SAC for reference. Gateway of Tally > Alter > select the Ledger, and press Enter. Under Statutory Details, ensure the Type of Supply is selected as Goods, and HSN/SAC starting with other than 99, and if the Type of Supply is Services, the HSN/SAC is starting from 99. In case of incorrect HSN code, validate the details from HSN code and enter the appropriate HSN/ SAC.
   Voucher number not maintained for invoices. or, Invoice number does not exist.	Cause: An invoice number is must for any GST transactions not exceeding 16 characters, containing alphanumeric with/without special characters including “-“or “/” for any financial year. Generally, this is found in Journal or Receipt vouchers wherein GST is levied and doesn’t have voucher number series.
   	Solution: Check the voucher type and ensure that all Invoices with GST have Invoice Numbering set. In GSTR-1, select Document Summary and check the serial number for any voucher type. If it is blank, provide the voucher number in the relevant vouchers and try to upload with a new JSON.
   IGST is mandatory for interstate supply and CGST & SGST should not be present.	Cause: The nature of transactions is overridden. The place of supply is changed during the entry. In case the transaction supplies covered under section 7 of IGST Act, SGST and CGST, and IGST are counted as wrong for the interstate supply. Wherein IGST to be charged although supplier and buyer in the same state in case of courier services.
   	Solution: Follow the steps below to resolve the error: Make a note of the invoice number displayed in error report. Check the place of supply and the State of the Buyer to whom goods are billed. Select the appropriate nature of transaction if the nature of transaction is overridden. In the Statutory Details screen, set the option Supplies under section 7 of IGST Act to Yes. For more information, click here.
   Date is invalid, the invoice date cannot be before the registration date.	Cause: The invoice date is earlier than the date buyer obtained for GST registration or GSTIN.
   	Solution: Before the date of GST registration, all such transactions should be B2C sales. After confirming the date from the customer, or check the effective date of registration from Goods & Services Tax (GST) | Services, create a new party with GSTIN Number and then start issuing GST invoice.
   Please enter some value in IGST tax amount field / Export Sales Transactions.	Cause: Sales invoice for a foreign party with a Nil Rated item, wherein by default the nature of the transaction will Export Nil Rated, and GST Payment type should capture as WOPAY instead of picking WPAY.
   	Solution: From the error report, note the transaction. Open JSON file through Notepad and search for exp_typ:WPAY. Update WPAY to WOPAY. Save the file and re-upload the JSON file.
   Error in JSON structure validation.	Cause: The GSTN portal cannot recognize the uploaded JSON file, or there are structural errors in the uploaded JSON file.
   	Solution: Follow the steps below to resolve the error: Ensure that the GSTIN is specified on the JSON file. If the same is blank or not available, Gateway of Tally > press F11 > set Enable Goods and Services Tax (GST) as Yes. Check whether the Company GSTIN is provided, if not provide the same and re-export the JSON file. Secondly, ensure that the uploaded JSON file is the latest and has been exported from the latest TallyPrime Release.
   Errors encountered while uploading the file.	Cause: Due to multiple users accessing the GSTN portal to upload the file.
   	Solution: Try to upload the JSON file after some time or login to the GST portal from another browser and retry.

This exception occurs when certain GST Registration Details are missing or invalid for your party. 

You can resolve this exception using any one of the following resolutions:

• Update transactions party-wise
• Update transactions using Multi Alter
• Update transactions one by one

This exception occurs when the Taxability Type is missing or invalid in the GST details for stock items. You can resolve this exception using any one of the following resolutions:

• Update transactions Ledger-wise or Stock Item-wise
• Update transactions one by one

This exception occurs when the Tax Ledger is missing in the transaction. To resolve this exception, you can update the relevant tax ledgers in the transactions. To learn more, refer to Tax Ledger is not specified for a detailed resolution.

This exception occurs when the HSN/SAC is missing or invalid in the GST details for stock items.

You can resolve this exception using any one of the following resolutions:

• Update transactions Ledger-wise or Stock Item-wise
• Update transactions one by one

This exception occurs when an incorrect Tax Ledger is selected in the transaction. You can resolve this exception by updating the transaction with the correct tax ledger. To learn more, refer to Incorrect Tax Ledger is selected for a detailed resolution.

This exception occurs when the Tax Rate is missing in the GST details for stock items.

You can resolve this exception using any one of the following resolutions:

• Update transactions Ledger-wise or Stock Item-wise
• Update transactions one by one

To enjoy the benefits of e-Way Bill in TallyPrime, you have to enable the e-Way Bill facility in your company features.

1. Press F11 and set Enable Goods and Services (GST) to Yes. The GST Details screen opens.
   

   If you are using the multiple GST registrations feature of TallyPrime Release 3.0 or later releases, then the GST Registration screen appears.
   Select the GST Registration for which you want to enable e-Invoicing and press Enter.

2. Set the option e-Way Bill applicable to Yes. You will find options to set the date of applicability, threshold limit, and so on. You also have the option to generate e-Way Bill details along with the e-invoice, if required.
3. Set the required details and accept the screen. As always, you can press Ctrl+A to save the details.

You can easily generate an e-Way Bill while saving your invoice and also print the QR code and other details. If you want to generate your e-Way Bill details along with your e-invoice, then set the option Send e-Way Bill details with e-Invoice to Yes in your company (F11) features.

Record a GST Sales transaction, as usual.

1. Under Party A/c name, select the party. The Dispatch Details screen will appear.
   1. Enter the required details and press Enter.
      The Party Details screen will appear. This will be prefilled as per the information provided in the party ledger.
   2. Update the Party Details, if required, and press Enter to proceed to the transaction.
      To know how to use the multiple GST registrations feature during voucher creation, refer to the Enable GST for Your Company – Single and Multi-Registration section in the Getting Started with GST in TallyPrime topic.
2. Specify other voucher details, such as the Sales ledger, Name of Item, GST ledger, and so on.
3. Set the option Provide GST/e-Way Bill details to Yes. The Additional Details: Sales Taxable screen will appear. The e-Way Bill will be generated based on the details entered in this screen.
   • Dispatch from and Ship to: This will be prefilled based on the address provided in the Company and Party ledger, respectively. You can update this, if required.
   • Distance (in Km): This is the distance between the addresses of the Consignor and Consignee. The validity of your e-Way Bill depends on the distance entered in this field. The next time you record a transaction for this party, the distance will be prefilled based on the address and PIN code entered in the Party ledger.
     If you are using TallyPrime Release 3.0 or later releases, then press Alt+L (Calculate Distance on Portal) and TallyPrime and you will be redirected to the link on the portal on which you can calculate the distance by providing the pin of both the places.
   • Transporter Name: Select the Transporter Name. You can set it as None if you are transporting the goods using your own or hired vehicle, or if you are using a different mode of transport such as Rail, Air, or Ship.
   • Transporter ID: Enter the Transporter ID provided by the transporter.If Part B Details are available, then you can enter the following details.
   • Mode: Select the mode of transport, such as Road, Rail, Air, or Ship. You can also create a New Mode, if required.
   • Vehicle Number: Specify the number of the vehicle used for transporting the goods. 
   • Vehicle Type: Specify the size of the vehicle, such as Regular, Over Dimensional Cargo, and so on. You can also create a New Vehicle Type, if required.
     
     Press Enter to proceed to the transaction.
     
4. Press Ctrl+A to save.
   A confirmation screen for e-Way Bill generation will appear.
   1. Press Enter to proceed. The e-Way Bill Login screen will appear.
   2. Enter your Username and Password.
      
      You will remain logged in for the next six hours, provided you do not turn off the computer or reset your credentials.
      In case of multiple GST registrations, log in with the credentials of the GST registration of which e-Invoice Login screen is displayed.
      If one or more login credentials are incorrect, then TallyPrime shows an error message from the portal and you will need to log in again with the correct credentials.
      If there is some network issue, or in other such scenarios, then the screen displays Request not sent (Login cancelled).
   3. Press Enter. TallyPrime will start exchanging information with the e-Way Bill system.
      
      After the exchange of information, a confirmation message will appear.
      
      You can see a preview of the invoice.
   4. Press Page Down to view the generated e-Way Bill with all the relevant details and QR Code.
      The e-Way Bill No. and Validity Date will also get updated in the Additional Details screen. If you want to explore additional options for configuring your e-Way Bill, then you can press Ctrl+I (More Details) or F12 (Configure).

If you are using TallyPrime Release 3.0 and later, then you can navigate to the link for the calculation of the distance from within the product.

1. During voucher creation, set Provide e-Way Bill details to Yes.
   The e-Way Bill Details screen appears.
2. Press Alt+L (Calculate Distance on Portal).

You will be redirected to the portal on which you can calculate the distance between the pincodes.

However, if you are using TallyPrime Release 2.1 or earlier, then you can open the following link on a browser and calculate the distance between the pincodes:

https://ewaybillgst.gov.in/Others/P2PDistance.aspx

When trying to generate an e-invoice, you will receive a duplicate IRN error if the IRN number has already been generated, cancelled, and repassed with another entry in the same cancelled voucher or with a previous voucher number with a new invoice.

Say for Voucher No 1, you have generated an e-invoice, which you have cancelled later. If you are now generating an e-invoice for another voucher with the same voucher number, you will be prompted with a duplicate IRN error.

In this case, record the new voucher with a separate voucher number. Also, remove the IRN from the e-invoice details and then generate the e-invoice through the new voucher.

• In case the IRN/QR code does not exist for the said invoice, then instead of re-generating, you can use “Get IRN”. If not done within 72 hours, then this solution works.
• In case voucher is deleted by any chance, and due to numbering it is showing, then we need to recommend not to delete voucher and insert same voucher and use get IRN and in case it greater than 72 hours then raise credit note.

There may be situations where the IRN is generated for a particular voucher, but you might have to cancel it. For example, this can happen when there is a change in the rate of an item, or if the party has cancelled the order. In such cases, you may want to cancel the invoice. As per department regulations, invoice cancellation has to be done within 24 hours of IRN generation.

1. Press Alt+G (Go To) > type or select e-Invoice > press Enter.
   Alternatively, Gateway of Tally > Display More Reports > GST Reports > e-Invoice > press Enter.
   
2. Drill down from the IRN generated from e-Invoice system section to open the e-Invoice – Voucher Register screen.
   
3. Select the voucher for which e-invoice needs to be cancelled, and press F10 (Cancel IRN).

   Press Ctrl+F10 (Mark as Cancelled) when the e-invoice is cancelled through some other medium on IRP, and you want to update the status in TallyPrime. When you mark the IRN as cancelled, then this invoice will appear in the Marked as IRN Cancelled section under IRN Cancelled, instead of the For IRN Cancellation section under Pending.

   

   1. Select the Reason for cancellation and enter the Remarks.
   2. As always, press Ctrl+A to save the details.
      The voucher will move to the For IRN Cancellation section under Pending.

Now, you can send the e-Invoice for cancellation from the Exchange menu.

1. Press Alt+Z (Exchange) > Send for e-Invoicing.
   
   The Send for e-Invoicing screen appears. You can view the transactions that are pending for generation and cancellation.
2. Select the required transaction and press S (Send) to send the details.
   If you press S without selecting any transaction, then all the transactions will be sent for e-Invoicing.
   
   If you are using the multiple GST registrations feature in TallyPrime Release 3.0 or later releases and e-Invoicing is applicable in more than one GST registrations, then the vouchers of those GST registrations that are ready for IRN Generation and Cancellation will be available for selection.
   The following confirmation screen will appear, with the number of transactions lined up for IRN generation and cancellation.
   
   If you are using the multiple GST registrations feature in TallyPrime Release 3.0 or later releases, then the total number of vouchers for IRN generation and cancellation from all GST registrations will be displayed.
3. Press Enter to continue.
4. Specify the e-Invoice Login details, and press Enter
   
   In TallyPrime Release 3.0 or later releases, if you are sending e-Invoices of multiple GST registrations for generation and cancellation, then The e-Invoice Login screen for all the registrations will be displayed one by one. You will need to log in for all the registrations.
   The Exchange Summary will appear after the cancellation is completed, and you can view the number of e-Invoices that are cancelled.
   

The voucher will move to the IRN cancelled from e-Invoice system section in the e-Invoice report. Even after cancellation, information like QR code and IRN details will be retained in the voucher for your reference in TallyPrime. You can also view the remarks you had entered while cancellation, using More Details.

If one or more login credentials are incorrect, then TallyPrime shows an error message from the portal and you will need to log in again with the correct credentials.

If there is some network issue, or in other such scenarios, then the screen displays Request not sent (Login cancelled).

Moreover, if you are using the multiple GST registrations feature in TallyPrime Release 3.0 or later releases, then the total number of vouchers  from all GSTIN registrations that are updated with IRN details and those that are rejected from the portal will be displayed.

Apart from regular sales invoice, TallyPrime also supports e-Way Bill for POS, debit notes, and credit notes. You can easily generate an e-Way Bill while saving your invoice and also print the QR code and other details. If you want to generate your e-Way Bill details along with your e-invoice, then set the option Send e-Way Bill details with e-Invoice to Yes in your company (F11) features.

Record a Debit or Credit Note and press Ctrl+A to save the voucher.

A confirmation screen for e-Way Bill generation will appear.

1. Press Enter to proceed. The e-Way Bill Login screen will appear.
2. Enter your Username and Password.
   
   You will remain logged in for the next six hours, provided you do not turn off the computer or reset your credentials.
   In case of multiple GST registrations, log in with the credentials of the GST registration of which e-Invoice Login screen is displayed.
   If one or more login credentials are incorrect, then TallyPrime shows an error message from the portal and you will need to log in again with the correct credentials.
   If there is some network issue, or in other such scenarios, then the screen displays Request not sent (Login cancelled).
3. Press Enter. TallyPrime will start exchanging information with the e-Way Bill system.
   
   After the exchange of information, a confirmation message will appear.
   
   You can see a preview of the invoice.
4. Press Page Down to view the generated e-Way Bill with all the relevant details and QR Code.
   The e-Way Bill No. and Validity Date will also get updated in the Additional Details screen. If you want to explore additional options for configuring your e-Way Bill, then you can press Ctrl+I (More Details) or F12 (Configure).

This error occurs when a foreign party is selected in both the Bill to and Ship to sections of the Party Details or Additional Details screen.

Moreover, in the Ship to section, you may have specified the Pincode as 999999 and the State as Other Territory, or you may have skipped the necessary Ship to details.

Migrating your company data (5-digit company) to TallyPrime 3.0 will recreate the company data with a 6-digit company. At the same time, the process will retain the existing 5-digit company data. You can continue to use the company data same in their respective releases.

1. Press F1 (Help) > Troubleshooting > Migrate > select a company.
   Alternatively, press Alt+Y (Data) > Migrate > select a company.You can also press F3 (Company) and select the company showing Migration Required status.
2. Configure for backup and difference in tax values, if needed.
   1. Set Backup Company Data before Migration to Yes.
      It is recommended to backup the company before you migrate.
   2. Backup Destination Path: Select a path where the backed up data should be stored.
   3. Ignore difference in tax value up to: This value ensures that your transactions are appropriately included in the GST Returns post migration.
      This is a one-time change while migrating from Release 2.1 to Release 3.0 and later. Retaining this field as is during migration might move your transaction into Uncertain category in your Returns. After migration, you can set the difference in tax value value from F11 (Company Features). This configuration is applicable only if you had:
      • Set the country for your Company as India
      • Enabled GST for the Company
3. Press M (Migrate) to migrate the data.
   
   Migration may take a while, according to the size of your company data.

Once you migrate to TallyPrime Release 3.0, a copy of the 5-digit company is retained and renamed to a folder. For example, if you migrate the company 10000, the company is retained as a folder and renamed to 10000-migrated-to-3.0. The new company after migration is renumbered as 010000.

The company data in the latest release of TallyPrime will be available as a 6-digit company number. For your easy reference the, the company number of the source data is prefixed with a zero (0) so that you can easily identify which company was migrated. In addition, the 5-digit source company is retained in the same data location and renamed as a folder.

For example, if you migrate the company National Enterprises (10000) to TallyPrime Release 3.0, the migrated company data is numbered as National Enterprises (010000), and the source company is retained but renamed as ‘10000-migrated-to-3.0’.

Renaming the source company helps in identifying the the company data has already been migrated. The renaming will occur only when the source company is closed or shut in the earlier release of TallyPrime while you migrate the company data.

In a multi-user setup using TallyPrime, all client and server nodes must be updated to the latest release to ensure seamless data functionality and synchronization across all nodes. If you’re experiencing issues locating your company data, it’s advisable to upgrade your TallyPrime server license. For guidance on updating your server, please refer to the Update TallyPrime Server License topic.

In certain cases, after migrating company data from TallyPrime 2.1 to TallyPrime 3.0, you might encounter an issue where the data is not visible in TallyPrime 2.1. This occurs because TallyPrime 2.1 backs up the company data folder during migration, adding a suffix (migrated to 3.0) to the folder name. To make this data visible in TallyPrime 2.1, simply remove the added string (migrated to 3.0) from the data folder name.

1. 1. Gateway of Tally > F1 (Help) > About and press Enter.
      About screen opens.
      Under Data Information you can see Location of Company data.
      
   2. Note down the company data location path and open it on the desktop.
   3. Rename the required company data folder by removing the string (migrated to 3.0).

Once removed, the company data will be visible in TallyPrime 2.1.

Cause

This error appears while opening a company, if the file size of TranMgr.900 is 1 KB.

You will not be able to use this data.

Solution

The company will open only when the file size of TranMgr.900 is more than 1 KB, depending on the data entered.

Restore the data backup taken earlier and check the file size of TranMgr.900. If it is more than 1 KB based on the data entered, you can open the company. If not, try to restore the data backup taken prior to that.

This error may appear while opening TallyPrime, in the following situations:

1. TallyPrime data files, such as, .tsf or .900 files, are locked by any other process such as third-party backup software, or by any other application such as antivirus, backup software, search indexing software, and so on that accesses TallyPrime data files. At the same time, TallyPrime tries to write to the TallyPrime database, but it fails.
2. Since the Ransomware protection feature is enabled, the antivirus software blocks access to TallyPrime data.
3. Microsoft Windows Offline Sync has been enabled.

To fix this issue:

1. Change the permissions of the shared folder to full control.
   1. Right-click on your TallyPrime data folder and click Properties > Security > Edit.
   2. Select the user from the list of Group or user names.
   3. Under Permission for <user>, click Allow for Full Control and Apply.
      The permission of the shared folder will set to full control.
2. Exclude .tsf and .1800 files from scheduled backups in any third-party party backup software running on LAN-based systems. To know more, refer to the Auto Backup Your TallyPrime Data Using Cobian Backup topic.
3. Run a backup scheduler when no user is accessing TallyPrime data. To know more, refer to the Auto Backup Your TallyPrime Data Using Cobian Backup topic.
4. Avoid accessing the TallyPrimedata folder. Do not try to copy or open the .tsf files by double-clicking them.
5. Add Readretrycount=10 to the Tally.ini file and save it with the changes.
   1. In the TallyPrime folder open the Tally.ini file.
      
      
   2. Scroll to the bottom and add the text Readretrycount=10.
      
      (This parameter will impact the performance because the system will keep trying to write the data).
6. Disable Windows Offline Sync, as this may also cause problems when accessing the data. To know more, refer to How to Fully Disable Windows Sync Center – Stop Mobsync.exe (windowsloop.com).
7. Add TallyData files to the Exception list of the Antivirus Software’s Ransomware Protection feature. To know more, refer to the Add TallyPrime Data Extensions in Antivirus Exceptions List.

You need to first take a backup of the data (copy the company data folder to a different location), and then repair the existing data.

Follow the steps given below to repair the data.

1. Open TallyPrime > press F1 (Help).
2. Select Troubleshooting > Repair.
3. Select the company in which the MAV error is appearing, and proceed with the Repair.

If MAV persists even after repair, perform the following steps for advance repair.

1. Take a backup of the data folder (copy the company data folder to a different location).
2. Delete the files – TSTATE.TSF, TUPDATE.TSF, TEXCEL.TSF, TACCESS.TSF. Rename the data Tmessage.TSF available in the respective data folder.
3. Right-click the TallyPrime shortcut icon > copy the TallyPrime Path from Target path.
4. Copy the TallyPrime application path to the Run Command, followed by a space, and provide data path, for example, C:TallyPrimetally.exe Data. If the data is stored in a different drive or folder, enter the specific data path within double quotes.
5. Once TallyPrime is opened, press F1 (Help) > Troubleshooting.
6. Select Repair > select the data to be repaired.
7. Post completing the repair process open the company and check.

When you encounter an MAV error while loading a company, do the following:

1. Take a backup of the data (copy the company data folder to a different location).
2. Open TallyPrime > press F1 (Help) > Troubleshooting > select Repair and perform a simple Repair (which is same as Ctrl+Alt+R)
3. If the issue persists, proceed with the advanced repair by following the steps given below:
   1. Take a backup of the data folder (copy the company data folder to a different location).
   2. Delete the files – TSTATE.TSF, TUPDATE.TSF, TEXCEL.TSF, TACCESS.TSF. Rename the data Tmessage.TSF available in the respective data folder.
   3. Right-click the TallyPrime shortcut icon > copy the TallyPrime Path from Target path.
   4. Copy the TallyPrime application path to the Run Command, followed by a space, and provide data path, for example, C:TallyPrimetally.exe Data. If the data is stored in a different drive or folder, enter the specific data path within double quotes.
   5. Once TallyPrime is opened, press F1 (Help) > Troubleshooting.
   6. Select Repair > select the data to be repaired.
   7. Post completing the repair process open the company and check.

Query

Record Insertion Failure in database error occurred while loading a company/saving a voucher in TallyPrime. How to avoid this in future?

Solution

When this Record Insertion error is displayed, it is suggested that you follow the steps given below:

1. Backup your data.
2. Press Alt+F1 (Help) > Settings > Startup > set Load companies on startup to No.
3. Perform a simple repair by pressing Ctrl+Alt+R.
   Alternatively, you can press Alt+F1 (Help) > Troubleshooting > Repair.
4. In case the problem persists, it is suggested to perform a Zero command rewrite.
5. We suggest an upgrade to latest release.
6. In case the problem persists contact Tally Support.

Cause: Your Transmgr file in Tally data folder may be deleted or corrupted.

To fix this issue:

1. Create a Data Backup.
2. Check file size of Transmgr.900. If the file size is 1 KB, restore the earlier backup, if any.
3. If the Transmgr.900 file size is large, follow the steps of Repair below:
   1. Take the existing backup of the corrupted data and repair the data. If you are on TallyPrime 2.1 or earlier, perform Zero Command Repair.
   2. Check the bad sectors on the Hard Disk as well. Click here to view the procedure.

To fix this issue:

1. Upgrade to the latest version of TallyPrime.
2. Backup your existing company data, and Repair.

Backup Company Data

The Backup Company Data feature safeguards your company’s valuable information and shields your data from unexpected mishaps or losses. Taking a backup of your data ensures that even if something goes wrong with your original data, you have a secure copy to rely on.

1. Press Alt+Y (Data) > Backup, to open the Backup Companies screen.
   Backup Destination Path: This is the default location of your company data.
   
2. Select the required company that you want to take the backup for, and press Enter to proceed.
   TallyPrime provides you the flexibility to back up all the companies as well.
   • In the Backup Companies screen, select All Items.

The backup file will be stored in the Backup Path as TBK1800_******. ***. If there is any conflict of data in the selected folder, you will have the option to either overwrite the older version or choose a different location or filename.

Backup of TallyVault Encrypted Company

You may have encrypted your company using TallyVault to safeguard your data. In this case, when you take a backup of your data, you will need to enter the TallyVault password to proceed.

1. Press Alt+Y (Data) > Backup.
   The Backup Companies screen appears, as shown below:
   
2. Select the company that you want to take the backup for.
   
3. Accept the screen. As always, you can press Ctrl+A to save.
   The Tally Vault screen appears.
   
4. Enter the TallyVault Password and proceed with the backup process.

If you are backing up multiple companies and one of the companies is encrypted with TallyVault, you will need to enter the TallyVault Password before taking the backup. To know more about how to enable TallyVault, click here.

Restore Company Data

The Restore Company Data feature helps you in retrieving your company’s vital information effortlessly. It ensures the smooth recovery of your company’s data when required. Restoring your company data ensures that even if data is lost or compromised, you have a way to bring it back quickly and efficiently.

1. Press Alt+Y (Data) > Restore, to open the Restore Companies screen.
   Restore Destination Path: This is the location where your company data will be restored.
   
2. Select the required company that you want to restore, and press Enter to proceed.
   TallyPrime provides you the flexibility to restore all the companies as well.
   • In the Restore Companies screen, select All Items.

If you have enabled TallyVault password for your company data, you will need to enter the TallyVault Password when you restore the data.

Back up your data to keep it secure and restore it whenever you need. Remember, even if something goes wrong with your data, you have a reliable way to restore it with TallyPrime.