Due Date Calculation

[Former Member]

Hi Experts,

I have a situation here and the scenarios are as below;

1. The standard payment date is either 5th or 20th day of the month.

2. However in case of bank holiday on that day, payment will be made on previous business day of the bank.

3. The ER's processed 3 business days prior to the scheduled date of payment should be considered. For example if the ER processed till 2nd of the month will be paid on 5th of that month and the ER's processed from 3rd to 16th of the month will be paid on 20th of the same month.

How this can be solved?

Can this be solved just by the use of the payment terms configuration with the factory calender or does this need any technical help?

Thanks in advance

[Former Member]

hi,,,,,,,,,,,,,,friend,

i will give one solution may be that is the answer to your problem

Reconciliation account is changed in the master data of vendor or customer accounts (FK02, FD02) and the new open items will be posted to the new reconciliation account.

The open items from the old reconciliation account should be transferred to the new reconciliation account. As the reconciliation account can't be posted directly, the postings will be done on adjustment accounts.

This allocation is carried out automatically by the report SAPF101 / FAGL_CL_REGROUP. The report does not change the document itself, the old reconciliation account is stored in the original document like before. The report also creates a posting to cancel this correction posting one day after year end / month end closing.

The adjustment accounts are defined in transaction OBBW (IMG Financial accounting > Accounts Receivable and payable > Business Transactions > Closing > Regrouping > Define adjustments accounts for changes reconciliation accounts). The balance of the old reconciliation account will be set automatically to zero if all open items on this account are cleared.

As long as there are open items on this old reconciliation account, SAPF101 / FAGL_CL_REGROUP must be executed at year end to perform Adjustment postings.

[former_member188028]

I think this can be handled using with factory calender & grace days option for vendors.

[sachin_bhutani]

Hi Prasanna,

I would suggest not to make changes to payment terms to handle this scenario,

This should be handled at the time of payment program processing.

If next day is a bank holiday,One day should be added to the next payment date parameter.

For your example below, if 5th of may is a bank holiday. while processing payments on 4th May, enter the next payment date as 6th May , this would ensure all invoices due on 5th are also paid on the 4th.

Regards

Sach!n

[eduardo_hinojosa]

Hi

I believe you need technical help. You can change the due date in MIRO with badi MRM_PAYMENT_TERMS (see Note 1156325 - BAdIs in the Logistics Invoice Verification environment). In SD billing you can check the enhancements in the interface between SD and FI in Note 301077 - User exits for the interface to accounting (try with EXIT_SAPLV60B_002). In other documents (for instance, in FI as FB60, FB70 and so on) check with BTE 00001120 and in structure BSEG_SUBST you have the field (eg: VALUT).

I hope this helps you

Regards

Eduardo