can stored procedure create sales order?

[former_member20262]

Dear Expert

I have a user defined table, I would like to use this table information to create sales order in B1.

If I don't use program, can stored procedure create sales order?

Regards

Edmund

[former_member20262]

@invhead (code)
@invdetail (code, subcardcode, itemcode, amount, periodfrom, periodto)

user will input those data on the above tables.

when the first day of each month, the query will select all data within the periodfrom and periodto, and then generate the sales order.

[azizelmir]

So you need to provide us with your user defined table and fields ...

[former_member20262]

Dear All

I am not a programmer, but I would like to get some data by SQL on the first day of each month.

Then I will use this data to create sales order.

Can anyone teach me how to do it?

Regards

Edmund

[former_member225732]

Dear SBOTEAM SBOTEAM,

Only SP will not help you to add Sales Order, you need to take help of SDK(Addon) to do it for you.

Best Regards,

Sandesh Shinde

[agustin_marcoscividanes]

Hi

to create a document you have to use the SDK development. When a sales order is created, the process includes more tasks, as updating the BP balance, the committed amount for the item in the warehouse, and selecting the right series and the document number.

You have to develop a program, and invoke from stored procedure.

Kind regards

Agustín

[azizelmir]

Hi Sboteam,

SAP Business One supports adding user-defined fields that might be essential for the day-to-day activities of your business. Please check this link to add all the additional information that you considers should be included on the Sales Order window.

https://help.sap.com/doc/saphelpiis_hc_b1_image_repository_consultant_training_basic_b1_90_tb1200_03...

Thank you,

Aziz