Backdating posting date for incoming payments.

[Former Member]

Hi All,

IN FICA, can we backdate posting date to give discounts for the customer payments. When I backdate posting date, the system gives me an error that the month end is closed.

Is there an event or function module for backdate posting.

Thanks for the help.

Kumar

[william_eastman]

Kumar:

You can only post into periods that are open. If you would like to backdate the posting, then the posting period has to be opened. You might consider using document date for this purpose - there is no check of that sort on this field.

regards,

bill.

[Former Member]

Hi Bill,

Thanks for the reply.

I can backdate document date and post the payment. With backdating document date, the system does not calculate the discounts, which is tied to the payment terms.

Thanks,

Kumar

[Former Member]

If you have the requirement to backdate the postings, then you will have to open the period for posting. Normally the finance users close and open periods and most often there will be an overlap of a couple days between current period and previous period during which both of them will be open.

You can use function module BKK_RFC_GL_FI_PERIOD_CHECK to verify if the posting period is open for a given posting date. If the posting period is closed, you can probably create a BPEM case or put it in clarification list for your users and then they can manually open the period, post the document and close the period.

Do you have a lot of such backdated transactions? Depending on that your users may or may not like this approach. If everything has to be done in your program, then you will have come up with your own logic to open and close the period for the duration of your program execution. Be cautious as this will be a direct table update and mistakes often happen. Also make sure you close the period that you just opened and keep the current period open.

[william_eastman]

Hold on. You cannot just open and close posting periods. Posting periods are shared by FI and are important for producing financial reporting and regulatory statements.

You probably need to re-evaluate the method by which the discount is determined. Posting date would not be the recommended way.

[Former Member]

William,

I agree that normally you don't open and close posting periods as it will impact the financial reporting/taxes and a whole lot. But if this user has a requirement to post to a past period and business is aware of its impact and still wants it, I think opening and closing the period will be the only option.

But I do strongly agree with you about revisiting the requirement and come up with an alternate strategy. First of all I would ask the user as to why they want that to be posted to a previous period that is closed. Maybe they just did not think that the backdated ones would go back to a closed posting period. Maybe it should be backdated only if the period is open and post it to current date if not and keep the original backdate in the document date field for any tracking/reporting purposes.

[Former Member]

Hi Srinivas / William,

Thanks for the solutions.

I have recommended them to post to the current period and post a credit to the account (discount amount).

Kumar.