Different Terms of Payment at line item level in Sales order

[former_member623826]

Hi All,

Let me explain my scenario - my company A has recently merged with company B. Company A has one set of Terms of Payment for its customers (as it took advance payment). Company B has separate set of Terms of Payment for its customers..

After the merger, they will have common customers. The requirement is that if a sales order is created for one customer with one material from company A and another material from company B, the Terms of Payment for company A material should be separate and Terms of Payment for company B material should be different.

So, for this, first step is for all the item categories (to which these materials belong), the "Business Data" field should be ticked. Then,can you please mention in details what steps are required to have separate Terms of Payment at item level automatically (not manual change)?

Regards

[jignesh_mehta3]

Hello Abhinav,

You can maintain Payments Terms at Pricing Condition level for respective materials. Please refer to my blog here: https://blogs.sap.com/2013/04/19/different-payment-terms-for-each-line-item-in-sales-order/

Only point to note here is Invoice would be split based on Payment Terms.

Thanks,

[former_member623826]

@Veselina - Your answer is also correct. Basically the solution is to add statistical condition type and update Terms of Payment in that.

Now coming to your comment - what we were thinking was to have the separate Terms of Payment at the line item level but this will lead to invoice split (as Terms of Payment is a split criteria). I asked if there is any way to keep the separate Terms of payment at the line item level, still have one common invoice. To show the separate Terms of payment in invoice pdf/printout, we can enhance the invoice layout form and program and add the Terms of payment at line item level.

[Former Member]

Other way of solving it, if both companies have separate plants, you could define the payment terms for the materials in the pricing conditions (VK13). In your gross price condition you can find the column Payment Terms. This allows you to differentiate the payment terms based on your access sequence.

You need to create an access sequence including the fields where you make the split in payment terms.

For more info see: https://blogs.sap.com/2013/04/19/different-payment-terms-for-each-line-item-in-sales-order/

[former_member623826]

The blog link that you shared perfectly answers the question how to achieve separate terms of payment per line item.

One further question - as per this solution, the invoice split will happen per Terms of Payment. Is there any Routine available in copy control (Delivery->Invoice) which can avoid this invoice split due to different Terms of Payment per line item? Or any other way?

Regards

[Former Member]

Check SPRO > Sales & Distribution > Billing > Billing Documents > Copy Control for Billing Documents > Copy Control for Billing Documents from Deliveries.

Check the routines for items within your source and target object. Display source and check if the payment terms are used as split criteria. I'm not sure if there is any, otherwise let an ABAP'er create a custom routine.

[VeselinaPeykova]

How is this different from "You can use payment terms from pricing conditions with a statistical pricing condition (placed at the bottom of the procedure) to change the payment terms." ?

As to the part with clearing payment terms in the billing document yo avoid invoice split: payment terms field is on billing header, when you have different payment terms the invoice will be split without additional data transfer routines (it is described in 11162 - Invoice split criteria in billing document). Considering that having separate payment terms for the products of company A and B is a desired outcome adjusting the payment terms will defeat the purpose of having them in the first place.

On top of that I am not sure whether such change should be permitted even if it might be technically possible somehow. It looks illegal to change payment terms in the final billing document if you have already agreed with a customer on different terms of payment for specific items.

[VeselinaPeykova]

You can use payment terms from pricing conditions with a statistical pricing condition (placed at the bottom of the procedure) to change the payment terms.

You need to make payment terms not editable (MV45AFZZ USEREXIT_FIELD_MODIFICATION).

You need to bypass credit check for critical fields.

Hopefully this is a temporary solution until A and B unify the rules for selling to end customers, this is not a nice solution and it has certain limitations.

[former_member623826]

So, I will have to create a new condition type which is statistical, maintain Terms of Payment in it, and add it at the bottom of the pricing procedure.

The Item category should have "Business Data" field checked.

Once these 2 are done, the Terms of payment at item level will be picked as per the one maintained in the condition type. Correct?

Thank you

[VeselinaPeykova]

Yes, just one minor thing: if you have several pricing conditions with payment term set - the payment term from the last condition will be applied to the item. Hopefully pricing condition maintenance in your company is centralized or controlled via workflow etc.