Group logo of B1 Technical Tips and Tricks

B1 Technical Tips and Tricks

Gary Robert Sales + 72 Members
  • In this page SAP provides you with the tools aimed to help you in determine the configuration that fit your prospect: Hardware requirements, sizing tools and required additional resources. https://partneredge.sap.com/en/library/education/products/entManage/sbo/market/ep_sbo_hardware_require_sizing_tools.html

  • The Administrator’s Guide for SAP Business One 10.0 on MS SQL provides a central point for the technical implementation of SAP Business One 10.0, including server components, client components, and add-ons. https://help.sap.com/docs/SAP_BUSINESS_ONE_ADMIN_GUIDE_SQL/f6fb230cc90949d8b66586a39189992b/c0038069e54b46368b9e73c7218834da.html

  • The SAP Business One Administrator’s Guide, version for SAP HANA provides a central point of guidance for the technical implementation of SAP Business One, version for SAP HANA. Use this guide for reference and instructions before and during the implementation project. https://help.sap.com/docs/SAP_BUSINESS_ONE_ADMIN_GUIDE_HANA/1a2fc202f7f64336abf9fbc957d9b9ba/6c8b59c7f2a44aa2b474e58b9732e0d4.html

  • Hello Experts, I hope you are doing well. How do I install the SSL certificate in ACCESS Browser Dispatcher and Web Client? SAP Business One 10 FP2505

  • The 2026 roadmap commits to two things that deserve a second read: “Extend DI API and Service Layer coverage.” “Service Layer support for Microsoft SQL Server.” Both sound progressive. Both share the same architectural ceiling. Neither mentions 🔥OBServerDLL.dll🔥. Navigate to %temp% on any production SAP B1 server. Find SM_OBS_DLL. That folder — dynamically extracted at […]

  • This release brings powerful Lifecycle Management (LCM) enhancements that streamline how you manage, access, monitor, and secure your SAP Business One environment, delivering greater efficiency for admins and a smoother experience for end users. Read about it in SAP Product Expert Guy Sujetski’s latest blog. https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-sap/what-s-new-in-lifecycle-management-for-sap-business-one-10-0-fp-2602/ba-p/14357195

  • I got a new machine and was installing SAP B1 v10 SP1125 for a standalone instance. I got through the new computer permissions errors quickly and got stuck on a failure of the server tools. Specifically Authentication service (B1ServerToolsAuthentication): FAIL. This was after creating my own certificate using openSSL, since the install was failing trying […]

  • Here’s the style guide For Sql and HANA with plenty of examples. We’ll use this thread as a jump off point for discussion on this topic.

    Tagged: ,

  • An interesting LinkedIn article from Amirhossein Tonekaboni on how to block specific items for certain customers in SAP Business One. https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-members/custom-sales-blocklist-in-sap-business-one/ba-p/14164922 We had a situation where certain customers were allowed to sell certain products after certification and used master data properties on both BPs and Items without stored procedures, but this might give people ideas!

  • In SAP, we use two columns regularly: DocNum and DocEntry. But do you know what they actually mean, where they come from, and why you would want to use one over the other? What do they have to do with the ValidFor column? Let’s deep dive into DocNum and DocEntry to explore their many uses […]

  • ROuting Slips are missing from the production module reports. That started me on a journey to put them in. In this series of videos, I implement them in SQL Queries and in Crystal reports, showing how to use subqueries and subtables to get the data to show properly. https://www.youtube.com/playlist?list=PLZ4LEZjOL87fWuyTMhb5Z2fgLbKbNK6_D

  • Often when writing queries in SAP Business One, you’ll encounter user-defined fields (UDFs) that use valid values—essentially dropdowns with predefined options. The typical approach is to write a long CASE statement to translate the stored value into its display label. While this works, it quickly becomes unwieldy and hard to maintain. These CASE blocks clutter […]

  • Another great tip from Mitul Mehta that separates sales from existing and new customers for analysis. https://www.linkedin.com/posts/mitul-mehta-296207169_sapbusinessone-hana-erp-activity-7364649717961502723-O8Wx?utm_source=share&utm_medium=member_desktop&rcm=ACoAAAAvmAwBkuusxDIzXe2lqqv6HlLfJJ7CQPo

  • Most ERP systems have a standard default General Ledger Account for Vendors. We included this feature in our Start template database to ensure customers were not surprised by the lack of functionality. Simple creation of a few UDFs and one UDV solve the problem and increase user satisfaction.

  • Mitul Mehta SAP Business One Tip #345 explains how to create a document summary report showing all the marketing documents created that day. https://www.linkedin.com/embed/feed/update/urn:li:share:7354747570285346816

Viewing 1 - 15 of 17 discussions

You must be logged in to create new discussions.

About group

Group Organizers

  • Gary

    Active 5 weeks ago

Description

SAP Business One Tips and Tricks for technical topics.  This includes:

Queries,
User defined fields, tables, objects, and valuesShow more

Group Description

SAP Business One Tips and Tricks for technical topics.  This includes:

  • Queries,
  • User defined fields, tables, objects, and values
  • Authorizations
  • Forms
  • Crystal Reports

About group

Group Organizers

  • Gary

    Active 5 weeks ago

Description

SAP Business One Tips and Tricks for technical topics.  This includes:

Queries,
User defined fields, tables, objects, and valuesShow more

Group Description

SAP Business One Tips and Tricks for technical topics.  This includes:

  • Queries,
  • User defined fields, tables, objects, and values
  • Authorizations
  • Forms
  • Crystal Reports