eBay - NS Sales Order error due to Sales Rep over 100% Contribution Amount

We haven't been able to resolve this yet, so I thought we could reach out to the community. We have the eBay - NS integration working relatively smoothly and we are on the last two hurdles to overcome.

The integrator successfully creates the customer. The customer is a child of a parent. The parent has a sales rep primary at 100% contribution amount. The child has a sales rep primary at 100% contribution amount.

The Sales Order when created has a field called Event Code that has a Sales Rep also assigned to it.

NS Native when the event code is filled out, (in this integration it is always 6-eBay Rep = Kelsey 100%) the Sales team is overwritten with the event code rep.

The integrator keeps erroring out because when the SO is created it is trying to enter the sales rep 3X's at 100% contribution amount. Once from the Parent, once from the child and once from the event code.

We cannot remove the rep from the Parent or the child records nor the event code

We know that there is an 'overwrite' in the integrator, but can't find the way to write it in the integrator.

Error message =

"Failed to save record because Total contribution for sales reps cannot exceed 100%"

03/27/2021 3:28:31 pm

Script Log =

03/17/2021 11:22:55 am nlapi calls registered for $R r = nlapiCreateRecord("salesorder", {});
r.setFieldValue("entity", 101063);
r.setFieldValue("custbody_celigoat_ebay_orderid", "26-06747-79634");
r.setFieldValue("trandate", "3/16/2021");
r.setFieldValue("shipmethod", 1325);
r.setFieldValue("currency", 1);
r.setFieldValue("custbody215", "STATE_SALES_TAX");
r.setFieldValue("custbody216", "239.92");
r.setFieldValue("department", 8);
r.setFieldValue("custbody_order_source", 10);
r.setFieldText("custbody_order_type", "Chairs");
r.setFieldValue("class", 37);
r.setFieldValue("location", 2);
r.setFieldValue("custbody_ice_delivmeth", 1);
r.setFieldValue("custbodyebay_totalmarketplacefee", "305.16");
r.setFieldValue("custbody_infinity_ebay_trans_fee", "0.30");
r.setFieldValue("custbodyebay_totalfeebasisamount", "3238.92");
r.setFieldValue("custbody_cseg1", 2846);
r.selectNewLineItem("item");
r.setCurrentLineItemValue("item", "item", 11432);
r.setCurrentLineItemValue("item", "rate", "2999");
r.setCurrentLineItemValue("item", "quantity", 1);
r.setCurrentLineItemValue("item", "amount", "2999.0");
r.setCurrentLineItemValue("item", "location", 2);
r.setCurrentLineItemValue("item", "description", "Infinity Dynasty 4D Full Body Zero Gravity Massage Chair ft. Calf Rollers");
r.commitLineItem("item");
nlapiSubmitRecord(r, false, false);

We only have 'basic' down-only service from NS

Can anyone please advise a path to resolve this hurdle?

Thank you.

Paula

pcourtemanche@comcast.net

Thanks for posting this to the community, Paula and @seanohare. I’ve also opened a ticket so Support can assist with this.

Has there been any update on the 'overwrite' feature for the Sales Rep, when the Sales Rep is being pulled from the Parent Customer, however when the eBay integration is ran it is 'replacing' the sales rep. There is a field in Sales Rep : Replace all fields. Can anyone please advise how to set up this field from NS into the Celige eBay Integration?

Paula

Hello @seanohare

Thanks for writing to us. Please allow me to help you here,

To confirm, we are basically discussing about the Customer Import to NetSuite right ? And also, to clarify, we don't support the "Overwrite" functionality on any record (either SalesOrder or Customer) for the field "Sales Rep". We will only import / create the respective record if any mapping exists for the particular field, else we depend on NetSuite to render the value based on Parent customer or Customer records.

And as well to confirm, "Sales Rep: Replace All" mapping is meant to replace the existing the lines with the new data. This mapping basically accepts the boolean value i.e., True or False, if it's True, then it removes all the existing Sales Rep lines, and add the new data. And if it's False, then the flow basically add / update the incoming data.

Please review this and let us for any further questions.

Thanks,