Tax Point Date Adjustment

Use the Tax Point Date Adjustment feature to change the tax point date on Payables and Receivables transactions at the header or line level, as required for VAT reporting in many EU countries.

The feature supports adjustment based on manual entry, spreadsheet import, or automated rule-based configuration, and is available in countries including Bulgaria, Croatia, Czech Republic, Poland, Russia, Serbia, Slovakia, and Slovenia. Adjustments can be applied individually, in bulk, or using predefined rules linked to fiscal classification or process parameters.

Setup

Complete these steps to set up the Tax Point Date Adjustment feature:

1. Assign security privileges.
   1. Assign the Run Tax Point Date Adjustment Process privilege to the Tax Manager role.
   2. Add the required BI privilege to the role hierarchy, if needed.
2. Set up tax reporting type codes.
   1. Go to Setup and Maintenance and use the Manage Tax Reporting Types task.
   2. Review and use the seeded tax reporting types:
      1. ORA_JG_AP_TPD_ADJ_DATE (for Payables)
      2. ORA_JG_AR_TPD_ADJ_DATE (for Receivables)
   3. Assign the appropriate descriptions and effective dates. Only the predefined ORA-prefixed codes are available.
3. Assign document fiscal classification for adjustment rules.
   1. Navigate to the Manage Transaction-Based Fiscal Classifications page.
   2. Search for and edit the relevant document fiscal classification codes.
   3. Assign ORA_JG_AP_TPD_ADJ_DATE for Payables or ORA_JG_AR_TPD_ADJ_DATE for Receivables as needed.
   4. Save your changes.
4. Assign adjustment rules at transaction entry (optional).
   1. For Receivables, select the value with the predefined adjustment rule on the invoice header.
   2. For Payables, enter the valid value with the predefined adjustment rule on the invoice header.

Transaction Processing

Manual Adjustment (Low Volume)

1. For Receivables, go to Manage Transactions. For Payables, go to Manage Invoices.
2. Enter the adjusted tax point date at the header or line level.
   1. For Receivables:
      1. At header level, click Show More and go to the Miscellaneous tab.
      2. Enter a valid date in the Adjusted Tax Point Date field and save.
      3. At line level, open invoice line details, enter the date in Adjusted Tax Point Date, and save.
   2. For Payables:
      1. At header level, click Actions > Edit, then Show More and go to the Additional Information tab.
      2. Enter a valid date in the Adjusted Tax Point Date field and save.
      3. At line level, open invoice line details, enter the date in the Adjusted Tax Point Date field, and save.
3. Submit the Process Tax Point Date Adjustments process with Process Type set to Manual.
4. For Receivables, only transactions with a tax point basis of Invoice and status Completed are eligible.
5. For Payables, only transactions with a tax point basis of Invoice and status Validated are eligible.

Spreadsheet Import (Bulk Adjustment)

1. Run the Select Transactions for Tax Point Date Adjustment process.
2. Download the CSV output and update the New_Header_Tax_Point_Date and/or New_Line_Tax_Point_Date columns with new dates in DD-MM-YYYY format. Do not change the column order or structure.
3. Save the file as CSV.
4. Upload the file:
   1. Go to File Import and Export and upload to the fin/tax/import directory.
   2. Use Load Interface File for Import. Set the Import Process to Process Tax Point Date Adjustments and select your uploaded file.
   3. Submit to transfer data to the interface table.
5. Run Process Tax Point Date Adjustments with Process Type set to Import to update the transactions.

Automated Rule-Based Adjustment

• Predefine rules in document fiscal classification, or set default rules as parameters when submitting the adjustment process.
• The process applies the following priority:
  • Line-level adjustment (Global Descriptive Flexfield)
  • Header-level adjustment (Global Descriptive Flexfield)
  • Predefined rule on document fiscal classification
  • Default rule parameter value

Reporting and Additional Information

• Always run the Process Tax Point Date Adjustments process immediately before tax reporting to ensure compliance.
• Only transactions with a tax point basis of Invoice are eligible for adjustment.
• Run in Draft mode to preview changes, and in Final mode to apply changes and update transaction history.
• The process does not update accounting entries; update them manually if required.
• For countries not previously supported, only predefined rules are allowed for adjustment.