we need to build an integration from salesforce th...
# suitescript
m
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
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
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
The problem with Brian's solution is the downstream processes, what if you only want one invoice @Brian Brown?
m
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
@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.