https://netsuiteprofessionals.com logo
#suitescript
Title
# suitescript
m

Matt Wise

03/23/2022, 5:25 PM
we need to build an integration from salesforce that will results in building a sales order with 600 lines, anybody have any experience with large single transactions and any tips or advice ?
s

Sciuridae54696d

03/23/2022, 5:28 PM
i think it'll depend on your item structure setup, there are some readily available apps such as celigo or even workato that can act as an iPaSS that can achieve that. Building it from scratch is also possible, but unless it's a customized solution, usually i'd suggest previewing built solutions first.
i'd split the thought into two parts, a partially customized solution in which you're accomodating suitetalk, (by soap or by rest) or a fully customized solution using a fully customized suitelet. I think all of those solutions are possible, it's more about leveraging time and cost
b

Brian Brown

03/23/2022, 9:33 PM
I try to keep transactions under 500 lines. And even fewer than a couple hundred is even better. Just FYI.
Doesn't hurt to split it out into multiple NetSuite transactions if you must.
2 transactions with 300 lines each. Something like that.
c

Craig

03/23/2022, 10:57 PM
The problem with Brian's solution is the downstream processes, what if you only want one invoice @Brian Brown?
m

Matt Wise

03/24/2022, 4:44 PM
exactly @Craig i need one invoice - we also run ARM so im concerned about having a sales order with 2000 lines - will create thousands of lines when it comes to revenue arrangements for Kits on billing schedules...
c

Craig

03/25/2022, 9:55 AM
@Matt Wise I wouldn't even look for a technical solution, I'd try to change the process. Why does the order need to be that large? You can customise this with SuiteScript to create one invoice for multiple orders but you'd have to think about all the other processes that might be affected.