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

Jeff Sheibels NetSuite Integration Whiz

• January 27, 2021 17:54

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

0

• 

  Courtney Jordan Experience Strategy & Design Director Community moderator

  • January 27, 2021 19:41

  

  

  

  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. 

  0
• 

  Jeff Sheibels NetSuite Integration Whiz

  • January 27, 2021 20:03

  

  

  Courtney,

  A ticket has already been created, #78527.

   

  0

Please sign in to leave a comment.