UF - Service Layer
Answered
Intro:
As of version 10 of SAP Business One, SAP encourages the usage of Service Layer. Not only because it's fancy, but it outperformances DI API integrations by far.
As example, I have 2 scenarios:
- One integration that inserts 1 Journal Entry with 16.000 lines, with DI API took 2-4 hours to run and when we changed it to Service Layer, took one and a half minute;
- 4 integrations that inserts around 300.000 documents and Journal Entries, with DI API if there were any problem in the month, thousands of documments would be affected in a day and it would took one or two days to the integration get synced with the current documents. With Service Layer, minutes are enough to catch up.
Trouble:
Moving from developed integrations to B1UP, using DI API integration with .NET UF is so much better when comparing to doing the same process with Macro UF for creating documents and so. But, when we talk about handling thousands of documents, even .NET UF is slow... I had to Cancel and Create 30.000 Journal Entries one day and the .NET UF took around 3-4 hours to accomplish each step.
Suggestion:
My suggestion is to create an UF for SL handling. It could be used withing C# code or with SQL Query.
For SQL I was thinking something like using the fields of SL as columns of the query, and B1UP would handle and group the result to deliver the POST to the SL.
Or it could be something integrated to the "HTTP Trigger" UF, where you would define the fields and attach a query to fulfill those fields.
-
Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
(Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
Read more about the Feature Request process here
[Internal Id: 98415] -
Within the last couple of years I have been able to make really great systems using the Dynamic Syntax Universal Functions (DI API via C#). Many of these customizations avoided the need for a fully custom add-on. I think it's important to use B1UP to give access to consultants to use these types of tools, otherwise they are stuck behind the SDK which is pretty inaccessible for normal people. I don't know enough to make recommendations regarding SL but the Boyum approach has always been well thought out. Thanks!
Please sign in to leave a comment.
Comments
2 comments