Error being caused by lines that do not exist on the record trying to be sync'd with a numeric value of "Infinity"
NetSuite invoice only has two lines on it. The data being seen by the Salesforce - NetSuite IO has two extra lines that are not on the invoice and is using a value of "Infinity" where a numeric value should be.
1) The extra lines should not be showing up.
2) Why would it use a value of "Infinity" in a field that should be numeric?
I thought the recent bundle update and package update would resolve this but it did not.
Error and data is shown below.
Error: "Composite Operation failed due to the following error(s)\nPrice: value outside of valid range on numeric field: Infinity for celigo_sfnsio__Financial_Transaction_Line__c[2]\nPrice: value outside of valid range on numeric field: Infinity for celigo_sfnsio__Financial_Transaction_Line__c[3]"
Data:
{
"id": "28070",
"recordType": "invoice",
"Internal ID": "28070",
"Amount": "103500.00",
"Amount (Gross)": "103500.00",
"Quantity": "",
"Tax Item": "",
"Item": "",
"Memo": "",
"Amount Discount": "",
"Line Unique Key": "60143",
"Line ID": "4",
"Item Type": "",
"Item Rate": "Infinity",
"Amount (Tax)": "",
"Item Internal Id": "",
"Salesforce ID (IO)": "",
"netsuite_line_id": "28070_4"
},
{
"id": "28070",
"recordType": "invoice",
"Internal ID": "28070",
"Amount": "103500.00",
"Amount (Gross)": "103500.00",
"Quantity": "",
"Tax Item": "",
"Item": "",
"Memo": "",
"Amount Discount": "",
"Line Unique Key": "60144",
"Line ID": "5",
"Item Type": "",
"Item Rate": "Infinity",
"Amount (Tax)": "",
"Item Internal Id": "",
"Salesforce ID (IO)": "",
"netsuite_line_id": "28070_5"
}
]
Comments
Hi Jeff Sheibels,
Thanks for letting us know about this issue! I'm checking with our Salesforce-NetSuite IO experts. For quicker resolution, I'd recommend you enter a support ticket on this.
Courtney,
A ticket has already been created, #78527.
Please sign in to leave a comment.