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.
Review Existing Account Codes
Open the list of existing accounts.
Scan through the account codes for any special characters (e.g.,
@,#,&,*, etc.).
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.
Last updated