Billing document in FI - different document and posting date

[kristaps_grosbahs]

Hello dear coleeges,

I have a requirement that the document and posting date are different in the FI document after billing invoice is posted.

E.g.Group period closes on 02.09.2011 but local period closes on 31.08.2011

So we need that the FI document date is 31.08.2011 to suit local reporting needs but the posting date is 03.09.2011 to suit group closing.

I know that system takes the billing date for both doc and posting dates, but is it possible that these dates are different?

Is it possible to achieve this in a different way?

Thanks

[former_member217082 · Accepted solution]

Hi

Welcome to SCN Forum

It is not possible.Because if the billing dates and accounting document dates are different then it will affect the data in reporting also,so you need to go with an enchancement.

Regards

Srinath

[kristaps_grosbahs]

Thank you all for the input, we' ll try to investigate the user exit route to change the dates

[former_member131691]

Hi

Although you can manipulate the billing date using a data transfer routine

this will not help a custom handling of the FI posting date (BKPF-BUDAT)

If you have such a requirement you can handle the dates according to your

requirements in the SD/FI interface.

Go to SE37

RV_ACCOUNTING_DOCUMENT_CREATE

...

call customer-function '008'

Here is the user exit you can use to set your dates before the call to FI

AC_DOCUMENT_CREATE. The dates are available in the XACCIT table.

Kind regards

Brian

[Lakshmipathi]

Yes possible. Set the Posting Block ticked in VOFA for that billing document type so that as and when you generate a billing document, accounting document will not be generated. You can release the billing document manually or through VFX3 for bulk processing.

In the meanwhile, while releasing such billing documents, through some exit, you need to populate a field (say by name posting date) where the user has to key in some date and execute so that system should in the background treat this as a posting date.

G. Lakshmipathi

[Former Member]

There is an aditional possibility.

Try to cange the posting and/or the invoice date by using the VOFM-copy-control for this kind of invoice and set the new date in the background - if you are able to determine the correct date in background.

But you have the check the reporting:

What happend during the day between posting date and creation date ?

Do you copy data into a reporting system ? How are these data proceeded?

Do you perhaps create sales reporting before and after the local closing -> they can lead to different results.

...

...

The effect should be the same as in the manual way - but with less work in the daily bussiness.

Regards

Manuel