Error Converting Data Type nvarchar to Numeric

YouTube: How to Fix the Error Converting Data Type nvarchar to Numeric When Creating a New Account?

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.