on 10-27-2014 6:17 AM
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
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:
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.