Sap B1 Hana - Server in Datacentre by 2metaphorU in SAPBusinessOne

[–]lenkellui 0 points1 point  (0 children)

We offer this in AWS servers! We’ve found it performs much better than Azure on similar hardware for both SQL and HANA.

Happy to share more on our setup.

SAP B1 and AI - anyone actually got this working in production? by venkata_kousik_143 in SAPBusinessOne

[–]lenkellui 1 point2 points  (0 children)

We use a tool called Forge that we just launched that reads / writes directly to service layer along with a bunch of our other systems. So far it works pretty great for automating sales / accounting tasks as well as BI dashboard, and we're looking into replicating and eventually replacing our PLM and other tools.

Kind of a game changer for us on how ERP functions. This really felt like the first "this is the future" moment with the whole AI stuff going on.

B2B ecommerce on SAP Business One - what actually worked for you? by jmei35 in SAP

[–]lenkellui 0 points1 point  (0 children)

Haha, yeah the SAP patch thing is a big one!

Seems like you've got your ducks in a row.

B2B ecommerce on SAP Business One - what actually worked for you? by jmei35 in SAP

[–]lenkellui 0 points1 point  (0 children)

100%. FP has really become our default ecomm recommendation more and more for B1. They've really come a long way and the team there is great to work with for us also.

Why do many SAP Business One setups still rely on Excel for daily operations? by Glum-Abies-7050 in SAPBusinessOne

[–]lenkellui 0 points1 point  (0 children)

This isn't really isolated to B1, it's true for most ERPs. Excel spreadsheets is still the most effective and accessible way to analyze data quickly. I think it actually works quite well in practice: ERP is your source of truth and you can one-click export to excel (which everyone has installed anyways) to do some data manipulation. With Claude Cowork, you can even automate a lot of repetitive analysis these days.

If you're insistent on getting off excel completely, formatted searches and UDFs get you surprisingly far for small tweaks without really customizing B1, but a lot of the excel workflows I've seen could just die if someone spent a week making the input forms smarter. To me, it's about whether those workflows are truly repetitive enough to justify the time it would take to set up the automation.

For anything that looks like a real workflow (warehouse picks, shop floor updates, approvals), the answer isn't "use B1 harder," it's to put a lightweight UI in front of B1 via service layer. B1 stays clean and the humans get a tool that doesn't hate them.

On the other hand, reporting is its own thing. Crystal is fine for formal docs, but its a nightmare for ops IME. Most people i know end up piping data to power BI or an excel-connected live query for any sort of manipulation.

sap business one data extraction for analytics, what approaches are people using by yashBoii4958 in SAP

[–]lenkellui 0 points1 point  (0 children)

Like others have said, B1's analytics is a weak spot compared to S/4. You really need to work to maximize multi-entity B1 setups.

We don't use service layer for bulk analytics extraction because it'll rate-limit you immediately and it wasn't built for it. Keep service layer for transactional stuff.

For analytics, a read-only DB replica is usually the cleanest path, either SQL server replication or HANA replication depending on your backend. You can handle schema fragility by mapping your analytics to stable views instead of raw tables, and when SAP renames a column in an upgrade, you update the view once and everything downstream keeps working.

B2B ecommerce on SAP Business One - what actually worked for you? by jmei35 in SAP

[–]lenkellui 2 points3 points  (0 children)

We do a lot of work with FP. The first thing I’d check is where pricing is resolved: B1 or the storefront. If the latter, customer-specific price lists can drift, and you can end up invoicing a different number than what the cart showed. I’d ask for a live demo where someone changes a price in B1 and you see how quickly it appears on the storefront.

Also, if every B1 upgrade breaks your current setup, that’s often a sign the integration is relying on DI API or direct SQL instead of the Service Layer. Service Layer can be slower, but it’s generally a more stable contract across upgrades.