Substitution - Baseline Date to be replaced by the Goods Receipt date

[Former Member]

Dear Forum,

We have the payment terms defined in the system, with the baseline date corresponding to the 'Document Date' and the credit terms as 60 Days. The users now desire that the Baseline Date should instead correspond to the Goods Receipt Date. To enable this we need to define the substitution such as the Baseline Date at the time of Invoice Verification gets substituted by the Goods Receipt Date, if the GR Date is earlier than the IV date.

Would appreciate help from the friends as to how to configure this and which feilds to be chosen and replaced.

Thanks!

Regards,

[Former Member · Accepted solution]

Hi

You can make the Baseline Date in Invoice (MIRO) with Goods Receipt Date using BADI.

BADI -->MRM_PAYMENT_TERMS

Tell your ABAP Guy to work on this BADI.

In the BADI, MRM_PAYMENT_TERMS Read the Value in WEBUD of Internal Table TI_DRSEG and Pass it into E_ZFBDT.

Also if the Baseline Date is changed manually, then after posting you can see the Goods Receipt Date in Baseline Date.

This resolves your issue.

regards

venkat

[Former Member · Accepted solution]

Hi,

i had followed the same process to have the Baseline date as the recent GR posting date which is our client req and it worked fine .but if incase we keep some retention on the amout to pay by amount split provision in sap, baseline date was not getting updated to Recent GR posting Date in a FI document which comes proper in MM document in MIRO.

so could you please just elaborate how to deal in such condition where we have to split the amout and requires the proper Baselin date(Recent GR posting Date)

your reply would be really Appreciated & will be awared .

Regards,

AvI

[Former Member · Accepted solution]

Hi,

i had followed the same process to have the Baseline date as the recent GR posting date which is our client req and it worked fine .but if incase we keep some retention on the amout to pay by amount split provision in sap, baseline date was not getting updated to Recent GR posting Date in a FI document which comes proper in MM document in MIRO.

so could you please just elaborate how to deal in such condition where we have to split the amout and requires the proper Baselin date(Recent GR posting Date)

your reply would be really Appreciated & will be awared .

Regards,

AvI

[Former Member · Accepted solution]

Hi Avi,

Could you not create the Installment Payment Term, while retaining the Baseline Date same as the GRN date. However, we are still working on the same. Also is there a simpler way of substituting the GRN Date in place of Baseline Date rather than the solution advised by Mr. Venkat involving the ABAP work.

Would appreciate if you could share your experience with us.

Regards,

[Former Member · Accepted solution]

Hi

suppose for a PO there are 4 GR's and you are doing MIRO for a single GR, its date is defaulted.

If you are selecting 4 GR's and doing MIRO, the recent GR's date can also be defaulted.

tell your ABAP Guy your clear requirement, he will do.

we have done the same in our company.

regards

venkat

[Former Member · Accepted solution]

Hi Venkat,

we have updated our Baseline date to recent GR posting date usign the Badi MRM_PAYMENT_TERMS.

and now its works fine.

if there is a scenario where user has keep some retention for the vendor then he uses the given amount split logic in MIRO.

but if he/she uses this amount split logic, it affects the Due on Date which is supposed to be baseline date + cash discount days gets changed to Baseline Date (this is sap logic incase of amount split ie set Due on date to Baseline date).

so pl suggest any Solution for changing Due on date to (Baseline date + Dscounted days).

Regards,

Avi

[ravichandran_iyer]

You can also do this with a User Exit in your substitution rule which you create in OBBH. You set up the Substitution rule and put the user exit routine there. The user exit will check the corresponding delivery document and replaces the date for the Baseline date. Your ABAP consultant should be able to do this without much strain.

Ravi.