cancel
Showing results for 
Search instead for 
Did you mean: 

Need guidance for my first SDK project

leon_laikan
Participant
0 Kudos

Hi,

I am an absolute newbie in SDK. Read a lot on forum, but never programmed before.

I have a project which I can achieve in SQL 2008 Stored Procedure  and Crystal Reports 2011 (version for SAP Business One), but I want this to be my first SDK project.

Brief description of my project (called "Handing Over")

We are implementing the Inventory module in SAP B1.

Our storekeepers receive all goods, post the entries in SAP B1 as Goods Receipt PO, and send the invoices to the Accounts Dept.

We use a manual system using "Handing Over Forms" to ensure the storekeepers remit all their invoices to the A/cs Dept.

But the system is heavy and time consuming. Time to computerise...

My idea

My idea is to create a UDF (in Header) called "U_RecdInvoice" in Marketing Documents. This User Defined Field can take values NULL or "YES'.

At the end of the day, the Storekeeper prints a "Handing Over Form" from Crystal Reports. This lists all Goods Receipt PO not yet remitted to the A/cs Dept (i.e WHERE OPDN.U_RecdInvoice IS NULL)

When A/cs Dept receives the Invoices and the Handing Over Form, the staff will open each Goods Receipt PO screen and update the field U_RecdInvoice  to 'YES'

What I am expecting from SDK

  • Generate a screen which lists all GRPO not yet sent to A/cs Dept (SQL: WHERE OPDN.U_RecdInvoice IS NULL)
  • There will be a column of checkboxes
  • A/cs clerk will check each box if he has received the invoice.
  • Then presses UPDATE. This will update U_RecdInvoice with 'YES"
  • ...and the trick is done.

My Request

Please guide me along all the key steps required to create the project in SDK

It will not be necessary to give detailed coding (I intend using Visual Basic.NET), although these are welcome.

In particular, I would like to know:

  • How to create the screen? Screen painter?
  • How to attach the SQL code.
  • How to add the checkboxes..
  • How to run the screen in SAP B1 or Crystal Reports
  • Is it better to use GRID or MATRIX?
  • What are the objects in UI API and DI API which I need?

If you give me sufficient hints, I can search the forum for more details.

As this is my first project, any guidance (whether high level or detailed) will be most welcome.

Thanks

Leon Lai

Accepted Solutions (1)

Accepted Solutions (1)

edy_simon
Active Contributor
0 Kudos

Hi Leon,

Welcome..

The 1st thing I want you to do is install the SDK.

And then please take a look in the sample (if you install in default folder).

C:\Program Files (x86)\SAP\SAP Business One SDK\Samples\COM UI DI\VB.NET\HelloWorld

Here you will learn :

1. Connect to the running SBO. (UI API)

2. Connect to the Company object. (DI API)

On the next step.

Follow these two sample:

C:\Program Files (x86)\SAP\SAP Business One SDK\Samples\COM UI\VB.NET\05.AddingMenuItems

C:\Program Files (x86)\SAP\SAP Business One SDK\Samples\COM UI\VB.NET\02.CatchingEvents

Those three samples are the basic that you need for your project.

Once you are comfortable with the above,

I want you to make your own addon,

Add a menu on the SBO Application.

Handle the menu click of this menu.. (simple pop up the Hello world message first.

Let me know when you are done, I will guide you through the next steps.

Roughly the rest will be :

1. Designing your form (via screenpainter)

2. Extending your menu event to draw your form in SBO Application.

3. Add handler to your new form.

4. Retrieving the GRPO records into your form.

5. Update it back to SBO.

Note. the samples are from old way of SDK programming.

Other ways are using B1DE or the latest SBO 9 Framework.

B1DE is a tool to jump start your application development.

while SBO 9 Framework is a different way of programming introduced since SBO9.

I believe understanding the basic will be beneficial for you, you can then extend it to B1DE and SBO 9 Framework easily.

Regards

Edy

Regards

Edy

leon_laikan
Participant
0 Kudos

Hi Edy

Many thanks for your reply from a grateful newbie.

I am determined to make my project work, and will follow your advice during the coming days.

I'll let you know when I'm stuck.

Best Regards,

Leon Lai

leon_laikan
Participant
0 Kudos

Hi Edy

I have started working on the project.

I've seen the 3 samples you've mentioned, but opened and printed them with Notepad.

I have not yet installed Visual Basic.NET. I think it will be needed?

Which version (Express Edition) should I download.

Note: I use MS SQL SERVER ver. 2008, SAP Business One version 9, and Windows 7

I have not read anything about B1DE or SBO 9

Should I learn these or develop using Visual Basic.NET in Visual Studio

Where do I get B1DE and SBO 9?

NB: Microsoft .NET Framework 4 is already installed on my computer.

Best Regards,

Leon

edy_simon
Active Contributor
0 Kudos

Hi Leon,

Any version of VB.NET.

The latest version would be nice.

Install, open up the sample projects and try running it.

And watch how it works by stepping into the codes.

Don't worry about B1DE or SBO 9 first.

Regards

Edy

leon_laikan
Participant
0 Kudos

Hi Edy

My SAP partner will install Visual Studio 2010 on Friday.

See you soon.

Meanwhile, I am studying attentively the notepad versions of the sample projects, and seem to understand.

Regards,

Leon

leon_laikan
Participant
0 Kudos

Hi Edy

Visual Studio 2010 and SDK have now been installed on my computer!

I work with SAP B1 2011 - 32 bit version

I am working on the HelloWorld example.

I built the project without any error message, but could not run the .exe file.

I tried to debug the program, but I got this error message:

Connection - Could not find the SBO that match the connection string

I used the exact connection string specified in the sample.

Hope you can help.

Best Regards,

Leon

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Leon,

Please check the links below:

Hope it helps.

Thanks & regards

Ankit Chauhan

leon_laikan
Participant
0 Kudos

Hi Ankit Chauhan

Thanks for all the links you sent me.

I tried all the suggestions, but still cannot run "Hello World"

Many people have tried, but not succeeded

I have created a new post for this specific problem

Best Regards

Leon Lai

leon_laikan
Participant
0 Kudos

Hi Edy

After much struggle, I finally managed to make the samples work in SDK.

The cause of my previous failures was that I did not open SAP Business One.

Once I opened Sap B1, these samples worked fine.

I think I am going to close this thread, and reopen new ones, so as not to infringe any forum rules.

I hope you will continue to support me.

Now that you know what project I am undertaking, you can relate my future threads to this undertaking.

Again, many thanks from a very grateful newbie.

Best Regards

Leon

closing

edy_simon
Active Contributor
0 Kudos

Hi Leon,

great.

you can close the thread by marking the correct answer or assume answered.

regards

edy

Answers (0)