Intrastat - Intrastat Posting Date

[former_member462807]

Hello all,

I hope you can help me please. This is an Intrastat query for ECC6.

We submit our Intrastat return a few days after the end of each calendar month. We use the Invoice Posting Date as the trigger for imports data to be included within the Intrastat return.

As our accounting periods do not end on the last day of the calendar month, this means that users can continue to post Vendor invoices using a posting date. This causes us a reporting problem when these postings are made after we have finalised the Intrastat return.

Is anyone aware of a standard Intrastat solution which prevents users from backdating the posting date on invoices into the previous calendar month?

Example:-

Step 1 - P1 Period end 25 January

Step 2 - Intrastat return for January = £100 (submitted end January)

Step 3 - Invoice posted in P2 (Entry Data is 01.02.2020, Posting Date 26.01.2020)

Issue. Invoice is not included in the February Intrastat return as the posting date was in January.

Many thanks Danny

[Former Member]

Hi Danny,

May be my answer is not the answer you expected but this is the way it is: you should wait for the accounting period to be closed before extracting the Intrastat data from ECC.

Depending for which country you need to submit the Intrastat declaration, you have between 10 and 30 days after month end to submit the Intrastat declaration (If I am not mistaken, I don't know the deadlines for all 28 EU countries...).

So, unless closing the accounting period takes way too much time, you should still have sufficient time for the Intrastat deadline.

I always told my customers to wait for the closing of the accounting period and so far it was always possible to wait for the accounting period to be closed and then still have time to do the ECC data extraction, eventually check/correct/complete the extracted data and then send the Intrastat report to authorities. Sure, the users would be under pressure between the time of closing of the accounting period and the Intrastat declaration deadline but it is feasible if you have good and clean master data, transactional data and processes in place.

Regards.

Mouaz BEN REDJEB

[former_member462807]

Hi - many thanks for getting back to me.

It does appear that for the UK the return has to be submitted 21 days after the close of calendar month. Unfortunately our accounting periods overlaps calendar months and often ends around the 21st. Take P1 for example - this ends 25 January, P2 doesn't end until 22 February. This would mean that we wouldn't be able to submit January's return until the 22nd of February which would push us beyond the deadline.

I was thinking perhaps a validation on vendor invoice posting date (i.e. can't backdate into the previous calendar month). I just wanted to check if there were any other standard options - but it does appear not.

Thanks so much for getting back to me though - Danny

[Former Member]

Hi Danny,

Alternatively, instead of using the Invoice Posting date, you could change the Intrastat selection logic to use the selection called "date on which service rendered".

For dispatch flows, this is basically using the Goods Issue Posting date to select data. Technically speaking, the selection is based on field VBRP-FBUDA.

No sure this would solve your issue as untill the accounting period is closed, users can (theoraticly) back date the GI date too. E.g. GI is "physicaly" done in Month M2. But as the accounting period of Month M1 is still open (and M2 closed), users will need to use a date in M1 for the GI posting. In such case, you would still have descrepancies between physical movement date and reporting periods

Anyhow, may be something to try or dig, results could possibly better match your expectation than using the Invoice Posting period.

Regards.

Mouaz BEN REDJEB

P.S. 21 days is an awful lot to close the accounting period... Maximum I had with my customers was something around 6-8 days, and everyone agreed that 6-8 days was already too much...

[former_member215181]

Hi Danny,

I'm not sure if there's a way to prevent back-posting, but would an easier solution be to run the Intrastat report later in the month. I'm sure the official requirement varies, but for example in the UK, the report does not have to be submitted until the 21st day of the following month.

Regards,
Dave