Update Payment Terms for Business Partners in SAP all at once

[former_member674709]

I want to change the payment terms from Net 60 to Net 30 for all my vendors. I have over 800. Do i have to go into each one by one and update. Or is there a way to select all applicable vendors that have Net 60, and change to Net 30 all at once?

[kenan_jaddeny]

guery the OTCG table to see the available payment terms in your system, then from this path

C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Templates\Business Partners\Payment Terms Types

open the payment terms template and prepare file to be uploaded using DTW

[Abdul]

Use DTW and your template will have only two columns one is BP code and Second is payment terms code and update all the BPs

[DipenShah]

Hi Jamil,

You can use DTW for SAP business one to update payment terms for all BP master at a time.

Thanks and Regards,

Dipen Shah

[kothandaraman_nagarajan]

Hi,

No need to change one by one. You can use Data Import function to update payment terms for selected vendor code.

The path is Administration--> Data Import/Export-->Data import from excel

Regards,

Nagarajan