One Customer - Several Payment Terms

[Former Member]

we have a situation where several customers have different payment terms - depending on how we ship or who the supplier is.

For example Customer ABC - has 60 days from sailing date for shipments sailing west coast and 90 days from sailing date for those shipments sailing east coast.

Another Customer DEF has 0 day terms if the product is bought from supplier XXX and 30 day terms if bought from supplier YYY

somehow we need to give the user the ability to choose from approved terms for each customer - but not from other terms (so i can't leave the sales order wide open)

any suggestions?

[former_member212707 · Accepted solution]

Shane,

I don’t think you can achieve the above reqt thru standard SAP Config and would have to involve Z-Development.

A good idea would be to leave the payment terms field in the Customer master of the payer to be blank, so that no payment terms are determined on the sales order. Also ensure that the incompletion log for your order type includes the Payment term as a compulsory field. (Just to ensure that the users do not save order without entering payment terms)

Now create a Z-Table with the help of an ABAPer containing the list of customers, Suppliers and allowed payment terms similar to the one shown below

Payer number	Suppliers	Allowed Payment Terms
ABC		60 Days
		90 Days
DEF	XXX	0
	YYY	30

You need to write custom code in the Sales order user exit so as to check the payment terms entered by the user against the Allowed payment terms field that is maintained in the Z-Table for the Payer on the order and suppliers (when applicable).

You can give a hard error when the wrong payment terms are entered thereby prompting the user to check for the correct entries

(Hopefully the users can differentiate between the west coast customers vs east coast ones!)

Hope this gives you some idea.

Thanks,
Ravin

[Former Member]

As per My Understanding Please Follow the below process:

Create a Condition type in Pricing procedure with statistical.

Create the condition table against the condition type  as  Key combination according to the ship to location.(As per the requirement)

Maintain the condition record on the basis of key combination & maintain the Payment terms as well in the condition record.

when ever you create a sales order depending on the Key combination maintained  the Condition record payment terms will overwrite the customer payment terms in sales order .

By doing the above you have restricted the payment terms in  Master Level.

Regards

Damu

[eduardo_hinojosa]

Hi

As Rabin suggests, you can do it with userexit. For instance userexit_move_field_to_vbkd in include MV45AFZZ.

Maybe you can try also to do it with conditions. In VK11 you can populate field ZTERM. You can try using as conditions depending of your shipment agreements. If you don't find fields for this shipment agreements you can enhance them. See SAP Note 531835 - Using field PSTYV in the condition access for further information. You would have the advantage of sequence access for complex settings for this type of payment terms.

I hope this helps you

Regards

Eduardo