SAP Business One

Content regarding SAP Business One, ranging from functionality to development.

64-bit HANA ODBC driver exception System.OverflowException

Hi everyone, Recently I ran into an issue with the HANA ODBC driver 64-bit. At the time of writing the latest version is 2.01.47.40090. When attempting to run a simple query such as: then the result is an exception thrown of type “System.OverflowException: Arithmetic operation resulted in an overflow”. The temporary workaround for this issue Continue reading 64-bit HANA ODBC driver exception System.OverflowException

DI API error -119 – Database type is not supported

Hi guys, Today I faced an issue with the DI API. A new database server was recently installed and we were “pointing” some apps to it. These apps are using the DI API and the error being thrown was -119 – Database type not supported. We tried a bunch of things until we found that Continue reading DI API error -119 – Database type is not supported

Transactions and the SP_TransactionNotification

Hi everyone, Thought I’d share with you something that I experienced recently. SAP Business One makes available a stored procedure that according to the documentation can be used to perform some “checks” and, in the case of failure, stop the process. Take the following code: // SP_TransactionNotification // addon code This code will always fail Continue reading Transactions and the SP_TransactionNotification

BitLocker and SAP Business One ” (SCLC)

Hi everyone, Recently my laptop hard drive was encrypted with BitLocker. This caused an issue where I couldn’t log in anymore to SAP Business One. There was a message like so: ” (SCLC) No other information was provided. Checking the License Control Center on the machine in question revealed that the Hardware Key (along with Continue reading BitLocker and SAP Business One ” (SCLC)

How to find the SAP Business One Process Id

Hi guys, I’ve always struggled with finding the correct process id of the SAP Business One a given add-on connects with. This becomes a necessity when displaying window dialogs, or when we need to grab window handles from SAP Business One client (for whatever reason). Many solutions involve using the OS API which has been Continue reading How to find the SAP Business One Process Id

True Modal Forms in SAP Business One

Implementing a modal form in SAP Business One was laborious. There was no support for a truly modal form until recently. Version 9.2 PL 2 introduced a new functionality that allows a developer to indicate that a form is modal. When creating a new form you can use the property Modality of the FormCreationParams class, Continue reading True Modal Forms in SAP Business One

SCN is on the move

If you haven’t already heard SCN is moving. A new community platform will be replacing it on the 10th of October. As a member of the community, I welcome this move. I believe it will bring improvements to some shady areas of the old SCN. There are some significant changes as well. Such as the Continue reading SCN is on the move

SAP B1 Forms Session

Forms Session It’s hard dealing with the stateless condition of objects between events fired on the UI. Static variables help with the problem. But when you wish to have more than one instance of the form then this approach does not work. To work around this I came up with the class below. It uses Continue reading SAP B1 Forms Session

Multiple specific selection in SAP B1 ChooseFromList

I recently had the need to create a selection type that would allow selection of specific values (multiple ones) from a ChooseFromList. The basic case of single selection and range selection also had to be supported. As an example, consider the ChooseFromList from Items. I needed to be able to select A1, A3, A5 – Continue reading Multiple specific selection in SAP B1 ChooseFromList