Error being caused by lines that do not exist on the record trying to be sync'd with a numeric value of "Infinity"

Integration Apps
, ,
1

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"
}
]

2

Hi @jeffsheibels,

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.

3

Courtney,

A ticket has already been created, #78527.