# Error Converting Data Type nvarchar to Numeric
**YouTube:** [How to Fix the Error Converting Data Type nvarchar to Numeric When Creating a New Account?](https://www.youtube.com/watch?v=tnltsRUzP_A)
## How to Fix the Error Converting Data Type nvarchar to Numeric When Creating a New Account?
In this tutorial, we'll discuss a common error that may occur while saving a **new supplier account** in Logic ERP and how to resolve it by correcting invalid account codes.
***
### Problem Overview
* When attempting to **save a new account**, an **error message** may appear.
* This is often due to the presence of **special characters** in existing account codes within the Account Master.
***
### Step-by-Step Solution
* Navigate to the **"Setup New** **Account"** under the **"Setup Account"** Module and start setting up a **New Supplier Account**.
* Proceed to **Save** the Account.
* If the error appears, follow the next steps to resolve it.
As shown in this picture, an error like this usually appears.
***
### **Review Existing Account Codes**
* Open the **list of existing accounts**.
* Scan through the **account codes** for any **special characters** (e.g., `@`, `#`, `&`, `*`, etc.).
Look for account codes as shown in the picture.
* If you find any account code with **special characters**, **edit the account**.
* Replace all special characters with **numeric digits** or **alphanumeric characters only** (e.g., SUP123).
***
### **Retry Saving the New Account**
* Return to the new account creation screen.
* Attempt to **save the account again**.
* The system should now allow you to save without any error.
***
### Root Cause
* This error usually occurs when **Account Masters are imported from Excel**.
* During import, **special characters** may accidentally be included in account codes, causing conflicts during account creation.
***
### Key Takeaways
* Always use **alphanumeric account codes**—avoid special characters.
* **Review and clean** imported data before saving to avoid conflicts.
* This small step ensures **smooth functioning** of account creation and prevents future system errors.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/troubleshooting/setups/setup-account/error-converting-data-type-nvarchar-to-numeric.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.