https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hi all, very random question I am sure - but has a...
# suitescript
n
Hi all, very random question I am sure - but has anyone started seeing any issues in their user even scripts around Jun 13 in terms of shipping & handling calculation on Sales Orders? We saw a bunch of errors on that day from different scripts (it stopped after a few hours) and since then are having issues in couple of our user event scripts - keeping these scripts enabled is affecting s & h calculation - it actually adds shipping & handling in NS upon integraiton from our webstore we use Celigo as our middleware for our web orders- in our webstore though there is no s & h. So NetSuite is actually calculating s & h by following the shipping item shipping & handling rate setup. NS should just accept values that Celigo is sending. It does accept the s & h values if we disable these two scripts.
b
Are they flat rate shipping items
n
They are not - they are like Fedex Ground and Fedex Home Delivery for US orders & DPD for EU orders for example - Magento is already doing all shipping calculation - there is no handling cost for web orders -so Celigo should just push the s & h cost as-is from Magento to NS
We have removed the blame from Celigo as we confirmed from their json file that Celigo is indeed sending the actual shipping cost from Magento. It's only upon integration that this issue happens - and that too when these two user even scripts are enabled. If we disable these scripts then Celigo does the job perfectly for the mapping of s & h costs
b
You might want to try using flat rate shipping methods for your integrations
n
are you saying like flat rate 0?
b
It doesnt really matter what rate you choose
Celigo will hopefully override it
n
We actually tried making it flat rate 0 and it was doing the same thing
so we reverted back to the real-time rate
but even with real-time rate enabled, and the scripts disabled - the issue does not happen
b
My guess is that your scripts are causing netsuite to recalculate shipping costs
Which overwrites whatever values celigo integration set
What do your user events do
n
yeah, we do see them integrate with the correct values upon integration in system notes, but changes as soon as the script kicks in
The script is basically inserting discounts or copon as line items below the products that has a discount - this is to track the discounts on product class level
Ultimately, these discount items total show up how much discount we are giving per product class in an Income statement report
b
Before or after submit
if its after submit, i would recommend changing the logic to before submit
or if its forced to be after submit, try making the after submit overwrite the shipping and handling values with the values set by your integration
n
Got it, I will try these suggestions, thanks!
a
hey, just saw this - chekc out our thread in the general channel on this issue. https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1560970726128400
the summary is that according to NS, this is a feature, not a defect, but they do admit it changed on June 13th. there's a hidden field you can use to override the re-calculation behavior
n
@amy Thank you very much - I believe NetSuite support gave us a similar explanation. Their explanation basically say they were working on another defect related to the Shipping Record on SO which caused this issue- This is a new and expected behavior ever since a fix for the separate Defect 511881 was released on June 12th.-they asked us to do the below as a workaround until they find a fix for the defect. kindly add "nlapiSubmitField ( 'salesorder' , recordId , 'shippingcostoverridden' , 'T' , false );" to the end of the UE scripts that add the items to the Sales Orders. Make sure to change the recordid to the correct value.
By the way, I missed the message you posted by 2 days - it's no longer visible now
9 Views
Open in Slack
PreviousNext
Powered by