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, A-Accepted, 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: