HOW TO UPDATE EVERY ITEM'S MAIN SUPPLIER VIA CODE TO AUTOMATE IT?

[Former Member]

Hi,

My consultant company do not have any idea how to update massively the item's main supplier in its master data.

I know how to program I just need your help to find out SAP command prompt and its variables names.

Beforehand I appreciate your help.

[Johan_H]

Hi Mauricio,

If you are asking about SAP Business One, and not about SAP All-In-One, and if you only need to perform this update once, or only once a month or less, it will be much easier to just use the Data Transfer Workbench. No need to start coding anything.

At any rate, the B1 client cannot be used from the command prompt. Automated interaction with the B1 system goes through the DI API (database manipulation) and UI API (GUI manipulation). You will need to code everything in VB.NET or C#. Your options are a console or Windows application, or you can create an addon to run within the B1 client. For that you should get the SAP Business One SDK. Ask your SAP Partner about it.

With the SDK comes documentation and all kinds of code examples.

Regards,

Johan