Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 05 at 08:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded