sapb1

When connecting SAP Business One to SQL Server 2005, what is the

we have SAP Business One - Fourth Shift Edition running here at a small manufacturing company. The consulting company that has come in to do the installation/implementation uses the "sa" id/pass to initially connect to the database to get the list of companies. From then on, I have to assume that its the sa id/pass that is being used t...

Invoke method dynamically in VB.Net

I've some classes defined in a dll file. These are in the form of com api. I'm trying to create an object of one of the class dynamically and than setting some property of that object. When I set the property manually, it works, but when I try to invoke the same using reflection it gives the error that Object does not match target ty...

What is the difference between Grid and Matrix in SAP B1?

When should I use a Matrix and when should I use a Grid? ...

Can I separate SAP B1 application and SQL Server to different machine?

I'm new to SAP B1, now I need to move my SAP application to new server. However I have asked to separate SAP and database into distinct server. I want to know, can I do that? If yes How can I do that? Thanks, Ek ...

Dynamic programming in VB

Hello Everybody, We develop applications for SAP using their SDK. SAP provides a SDK for changing and handling events occuring in the user interface. For example, with this SDK we can catch a click on a button and do something on the click. This programming can be done either VB or C#. This can also be used to create new fields on t...

Do breakpoints introduce delay?

How is that setting a breakpoint in my code allows the following code to complete which would fail otherwise. Here is the problem. I'm writing an add-on for SAP B1 and encountered following problem. When I load a form I would like to enter some values into the form' matrix. But without a breakpoint (set on a method in which loading a...

SAP B1: Activate a printing field depending on items

I have a user defined field that is a checkbox in item master data. When printing a sales order I need to print a field (a block of text) if there is any item with the checkbox activated. I know how to reach to the items and user fields, the only thing I don't know is how to define a text block to be shown when printing a document depend...

SAP B1 : Read from Matrix

I'm trying to read from a Matrix. The code that I have until now is: SAPbouiCOM.Matrix matrix = (SAPbouiCOM.Matrix SBO_Application.Forms.ActiveForm.Items.Item("38").Specific; SAPbouiCOM.Column col = matrix.Columns.Item("1") ; SAPbouiCOM.Cells cells = col.Cells; String cell = cells.Item(2).Specific.ToString(); String f = ce...

SAP Business One: Connection Error When I try to connect to UI API

Hi All, I got this error message "Connection - Could not find SBO that match the connection string [66000-85]" when I try to connect SAP Business One UI API. I connect like the following : private void SetApplication() { SAPbouiCOM.SboGuiApi SboGuiApi = null; string sConnectionString = null; SboGuiApi = new SAP...

SAP Business one

while using SAP Business One, we have database called SBO-COMMON, unfortunately i have deleted the Database SBO-COMMON without having any backup. could you help me to get SBO-COMMON database ...

SAP Business One: Why I can't convert PLD to Crystal?

Hi All, I am trying to convert SAP Business One 8.8 Reports from PLD to crystal report by using B1CrystalConverter 1.0.0.13. When I click on "Convert" button, I got the error message "Conversion failed.Try again". What the error can be? Please help me. Best Regards, RedDevils ...