1. Using Financials for EMEA
  2. Retroactive Reporting

Retroactive Reporting

Use retroactive reporting to report VAT transactions in any given range for which the company has not already submitted VAT data online.

Retroactive reporting includes required and optional setups.

Setup Required for Retroactive Reporting

Here is the setup list required for retroactive reporting:

  • Lookup Type: ORA_JEES_SII_RETROACTIVE_DATES

  • Lookup Codes: The default lookup code is ORA_EFFECTIVE_DATES, with the start date as January 1, 2017 with the Retroactive option enabled. The application automatically assumes June 30, 2017 as the end date. You can change the dates, or disable the original line and add a new range.

    Note: Enable only one lookup code before you run retroactive reporting.

  • Application and Party Level Lookups: The application and party level default value are the same for normal and retroactive reporting.

  • Global Descriptive Flexfields: You don't need additional transaction level global descriptive flexfields for Online VAT Reporting for Spain. Changes in global descriptive flexfields are only for the retroactive data that has been reported through Modelo reporting. These Modelo contexts are predefined:

    • JE_ES_MODELO347
    • JE_ES_MODELO347PR
    • JE_ES_MODELO349
    • JE_ES_MODELO415_347
    • JE_ES_MODELO415_347PR

This table displays those segments that apply to all the Modelo contexts discussed previously:

Entry Level GDF Values Type Display Type Read Only Description Additional Comments
AR Transaction Header Transaction Status Character LOV No

R - Ready,

S-Submitted,

O-On Hold,

M-Modified,

D-Directly

Reported

Tax Authority Status Character Text Box Yes N-New, cepted, AE-Accepted with Errors, R-Rejected Only system update is allowed. Updated when you run the confirmation process.
Message Code Character Text Box Yes Message codes that are available at SII web site. Only system update is allowed. Updated when you run the confirmation process.
Message Description Character Text Box Yes Message code descriptions that are available at SII web site. Only system update is allowed. Updated when you run the confirmation process.
Date Last Updated Date Date No Updated when the submission or confirmation processes are run.

Optional Setup

Consider these actions before you run retroactive reporting:

  • To assign user-defined attributes to any of the invoices in the retroactive date range, such as document type override, query the transactions and update the necessary changes in the Regional Information tab with Online VAT Reporting for Spain. Don't make any other SII changes to your transactions.
  • Ensure the application and party level defaults are complete.
  • If you have excluded supplier or customer accounts or sites from selection and if you have exceptions for these third parties and sites, query the corresponding transactions in both Payables and Receivables and select E in the Regional Information field.
  • You don’t need to perform any transaction level changes. If you need any of the invoices in the retroactive date range to be assigned with non-default attributes, such as document type override, query these transactions and update the necessary changes under Regional Information with ‘Online VAT Reporting for Spain’ context. Don’t attempt to make any other SII changes to your transactions.

IMPORTANT: Your transaction may already have a Modelo context assigned. To avoid inconsistency, don’t make any context changes. If you change the context from 'Modelo' to 'VAT Reporting for Spain', you will lose all modelo related data that you previously entered for the transaction. This also means that this transaction will not be selected for modelo reporting auditing purposes.

  • Ensure system and party level defaults are complete. These are documented in previous sections except for the new lookup ‘ORA_JEES_RETROACTIVE_DATES ‘, which is documented earlier in this section.
  • If you have excluded supplier/customer accounts or sites from selection and if you have exceptions for these third parties and sites, query corresponding transactions in both Receivables and Payables and enter ‘E’ (Excluded) in the regional information fields.
  • For Issued Invoices Register, you may want to exclude one or more batch sources from reporting. For this you can set receivables batch source global descriptive flexfield ‘Exclude from Online Reporting’ to ‘Yes’.

Producing the Retroactive Reports

This’s what a typical process flow looks like:

Related Topics