Error:
Post to NetSuite Failed: You have entered an Invalid Field Value 3570 for the following field: ccnumber
Cause of the issue:
This error occurs when Webgility attempts to send a masked credit card number (e.g., XXXXXX0000) to NetSuite during order posting. NetSuite's standard fields typically do not accept or require credit card numbers, which results in this validation error.
Steps to fix:
To resolve the issue, you need to add a customization node to the Webgility API config file, which stops Webgility from sending the masked card number and sends only the payment method.
Navigate to the API Config File:
- On your Webgility Desktop machine, browse to location: C:\Webgility\Unify Enterprise\XML
- Locate and right-click on the file named apiconfig.xml
- Choose Open With and select Notepad
Backup First:
- Before making changes, create a backup of the apiconfig.xml file by copying it to a safe location.
Insert the Customization Node:
- Find the fourth line from the bottom of the file.
Just above that line, insert the following:
<CustomizationNode>DOWNLOADNETSUIT_PAYMENTMETHOD</CustomizationNode>
If a CustomizationNode Already Exists:
Update it by adding a comma and appending the new value like this:
<CustomizationNode>AUTO_VALID,DOWNLOADNETSUIT_PAYMENTMETHOD</CustomizationNode>
Save and Restart:
- Press Ctrl + S to save the file.
- Close Notepad.
- Restart Webgility Desktop.
Redownload the Order:
- After restarting, redownload the affected order.
- You’ll now see only the payment method in Webgility Desktop, not the credit card number.
Post the Order:
- Try posting the order again to NetSuite — it should now succeed.
⚠️ Important Notes:
- Do not modify any other lines in the config file.
If the problem persists, contact Webgility Support for further assistance.