Integrating custom functionality in SAP Business One

[Aeroptl]

Hello everyone, 

I am looking to seek direction on a project I'm currently in which I have access to SAP Business One. 

I would like integrate custom calculations to calculate a cutting list for a product (like a bill of materials). 

The idea is the user inputs a three-letter product type code, the overall length and width of the product and the quantity to be manufactured. 

The output is a bill of materials with dimensions and quantities to make that product. 

The calculation in-between the input and output would involve extracting values from a matrix based on the input and doing some simple additions. 

What do you recommend I look into to help create this functionality? Is this something that can be done within SAP Business One or do I need to Install SAP Business One Studio? 

Many Thanks. 

Pritesh 

[Johan_Hakkesteegt · Accepted solution]

Hi Pritesh,

If I understand your scenario correctly, it would involve creating a BOM on the fly. I do not see a way to do that directly in SAP Business One (B1). You will have to build an addon, so you need to Install SAP Business One Studio.

Alternatively, the interface does not necessarily have to run in the B1 client, so if you would like to use for example a PDA, phone or tablet or something like that, you could build a web based interface, and use the DI API or Service Layer to create the BOM in the B1 system.

Regards,

Johan

[Aeroptl · Accepted solution]

Hi Johan, Yes you are correct. The BOM would generate each time the user enters the required inputs.

[Aeroptl · Accepted solution]

The interface will have to run on premise so it'll need to be on B1 client. Are there any go to instructions/documentation/tutorials on creating addons with SAP Business One Studio? Thanks.

[Johan_Hakkesteegt · Accepted solution]

We run an on-premise web application on our intranet, so that does not need to be a limit.

As for the SAP Business One Studio. I have never used it myself, but I think there are a couple of blogs about it here on the community. Please search for it, and you should be able to get more information.

[Abdul]

Unfortunately, there is no standard way to create a bill of materials based on product variants or limited info entered by the user. 

An easy solution is to manage it in Excel and use DTW to import data.

A proper solution is to either find a standard add-on like BEAS or process force or develop a custom add-on to fulfil this requirement. 

[Aeroptl]

Hi Abdul, Thanks for your reply. Unfortunately I want to try and get away from using Excel (since the functionality I spoke about is based on Excel). To custom add-on, I assume you'd be talking about using SAP Business One Studio?