Companies in France that do business with independent consultants must declare to tax authorities all payments to consultants each year for each supplier. These third party payments include fees, commissions, and rebates.
Your company submits this information to tax authorities in a formatted, electronic file. This file contains information about each supplier and supplier site, invoice details, and supplier payment totals. If a company has more than one location that makes payments to independent consultants, the company can submit the formatted file as either:
Separate files for each location that falls under a different tax district
or
One file if all locations are under the same tax district
You must provide complete and accurate information because the information in the DAS2 file is used to check the consultant supplier's tax declaration and tax payment and because omissions and errors in your DAS2 declaration may result in heavy penalties.
Extract program to extract supplier information into the DAS2 tables
Verification report to review extracted data
DAS2 update windows to update and modify information in the DAS2 tables
Update report to review your modifications
Formatted file, as specified by tax authorities, that contains the amount paid to each independent consultant for that year
Letters to the consultant suppliers that provide a breakdown of money earned per tax type
Use this list to help you complete the appropriate steps in the correct order.
Before you can set up for DAS2 reporting, you must run the Adpatch utility to load the French income tax types.
Use the Supplier window to enter address and tax information for each consultant supplier. You can also enter tax information at the invoice line level.
If the supplier is a French company, enter the company's full 14-digit SIRET (Systeme Informatise du Registre Etablissements), or taxpayer ID number, in the Tax Registration Number field. Oracle Payables does not validate the SIRET.
Note: You must enter the correct SIRET for each company to produce an accurate DAS2 for your consultant suppliers
You must enter a default income tax type and an organization type for the supplier while entering the tax details.
The value that you enter for income tax type determines the type of fee paid to the consultant supplier. Oracle Payables defaults this value to the supplier's invoice distributions. If necessary, you can change the income tax type at the invoice line level. See Enter Invoices for more information.
The value that you enter for organization type determines how the DAS2 report identifies the consultant supplier:
Corporation - For consultants that are companies. The DAS2 report identifies the consultant by supplier name (or Raison Sociale).
Individual - For consultants that are individuals. The DAS2 report identifies the consultant by the name of the supplier's primary contact.
Foreign Corporation - For consultants that are companies located outside France. The DAS2 report identifies the consultant by supplier name (or Raison Sociale).
Foreign Individual - For consultants that are individuals located outside France. The DAS2 report identifies the consultant by the name of the supplier's primary contact.
If the tax district of a supplier site that receives consultant fees differs from the tax district of the division of your company that issues payment, you must enter this tax district address information as the third line of the supplier site address.
To define supplier information for consultants:
Navigate to the Supplier window.
In the Supplier field, query or enter the supplier that you want.
If the supplier is a French company, enter the 14-digit SIRET in the Company Profile field in the Tax Details section .
Check the Federal check box.
In the Income Tax Type field, enter a default income tax type to identify consultant fees for this supplier.
Navigate to the Terms and Control - Tax and Reporting Information section.
In the Organization Type field, select the supplier's organization type from the list of values:
Corporation - French company
Individual - French individual
Foreign Corporation - Foreign company
Foreign Individual - Foreign individual
Enter address information for each applicable supplier site.
If a supplier site tax district differs from the tax district of the office that issues payments, enter the tax district address information in the Address Line 3 field.
If the supplier site is a French company that receives consultant fees, then enter the 14-digit SIRET in the Taxpayer ID field.
Check the Income Tax Reporting Site check box.
Related Topics
Suppliers, Oracle Payables User Guide
Use the Legal Entity Configurator to set up and maintain the first party legal entities and establishments for each company site that is responsible for reporting income taxes to the tax authority. You can modify the Release 11i migrated location and organization information, and you can enter new definitions according to your requirements
Related Topics
Defining Legal Entities Using the Legal Entity Configurator, Oracle Financials Implementation Guide
Use the Invoices window to enter invoices for consultant suppliers. The income tax type that you entered for each supplier defaults to the invoice distributions. Use the Distributions window to change the default income tax type for individual invoice lines.
All consultant supplier invoices that are partially or completely paid are included in the data extracted to the DAS2 temporary tables for DAS2 reporting.
Before you can enter invoices for consultants, you must:
Define consultant suppliers and supplier sites.
Define legal entities.
Related Topics
Entering Invoices Overview, Oracle Payables User Guide
Prepare and generate the DAS2 file to submit your company's declaration of all payments to consultants for the current tax year. The report contains:
Total invoiced amount for each consultant tax code for all divisions of the company
Total invoiced amount or each consultant tax code for each company division
Total invoiced amount for each consultant for each tax code
You prepare and generate the DAS2 file by extracting consultant transaction information into DAS2 temporary tables, reviewing and updating the extracted data, and submitting the formatted file to tax authorities.
To prepare and generate the DAS2 file, you must:
Extract consultant information - Extract transaction information for all consultants to the DAS2 temporary tables and print a report of extracted data. See French DAS2 Verification Report for more information.
Review and modify data - Review and modify the transaction information using the DAS2 update windows. See Modifying DAS2 Information for more information.
Review your updates - Review the changes that you made in the DAS2 update windows. See French DAS2 Type 210 Updates Report for more information.
Generate the DAS2 file - After you have modified and confirmed the contents of the extracted data, generate the DAS2 file. See French DAS2 Extract File for more information.
Print the consultant letters - Print the letters to consultants that provide a breakdown of money earned per tax type. See French DAS2 Consultant Letters for more information.
Use the French DAS2 Verification report to verify supplier information that is extracted into the DAS2 tables. You can use the French DAS2 Verification report to:
Print existing data in the DAS2 temporary tables
Print existing data to review the accuracy of information after you enter your modifications. You can run the report for a single legal entity or all the legal entities in your company.
Note: If you are running the report for the legal entity for which you have run previously, then you must submit the French DAS2 Purge Program to clear the existing data.
After you review the printed report, you can make changes to extracted data with the DAS2 update windows. See Modifying DAS2 Information for more information.
For each supplier site, the report prints one line for each paid invoice distribution line that includes a DAS2 income tax code. The French DAS2 Verification report is sorted by supplier, supplier site, DAS2 income tax code, and invoice number. The pages break at the supplier level. The report displays subtotals for each DAS2 income tax code for each supplier site as well as subtotals for each supplier site and supplier.
Use the Standard Request Submission windows to submit the French DAS2 Verification report.
Enter a reporting year.
Select a legal entity to indicate the reporting unit. If you leave this field blank, then the report runs for all the legal entities.
Enter No to run the report only. Enter Yes to purge existing data from the tables, extract new data, and print the report.
Enter Yes for DAS2 reporting type 5 to indicate to the French government that you pay both salaries and consultant fees and that an additional salaries report accompanies the DAS2 report.
Enter No for DAS2 reporting type 6 to indicate to the French government that you pay consultant fees only and that there is no additional report.
| In this heading... | Oracle Payables prints... |
|---|---|
| <Report Title> | State of Control DAS2 |
| Date | Date and time the report is run |
| Page | Current page of the report |
| Reporting Entity | Reporting entity that you selected, or All if you left the Reporting Entity parameter blank |
| In this column... | Oracle Payables prints... |
|---|---|
| DAS2 Code | Income tax type code that corresponds to the type of fees that you declared |
| Invoice Number | Invoice number of fee income that you paid to the supplier |
| Payment Number | Document number assigned to the invoice during payment |
| Payment | Payment amount in the ledger currency |
| In this row... | Oracle Payables prints... |
|---|---|
| Total for Tax Code | Subtotal per DAS2 code per supplier site. |
| Report Total | Total of all supplier subtotals. This value is the total amount of fee invoices that you paid to suppliers during the current fiscal year for all the DAS2 entities that you have extracted data into the DAS2 tables. |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the DAS2 update windows to view and modify extracted data after you use the French DAS2 Verification report to extract data to the DAS2 temporary tables.
You can modify this information:
Legal company name, address, and tax information in the DAS2 Company window
Division name, address, and tax information in the DAS2 Divisions window
Consultant information and invoiced amount totals per tax code in the DAS2 210 Third Parties window
After you modify information in the DAS2 temporary tables, run the French DAS2 Type 210 Updates report to review the updates that you made in the DAS2 update windows. See French DAS2 Type 210 Updates Report for more information.
Before you use the DAS2 update windows to update DAS2 information, you must run the French DAS2 Verification report to extract current data into the DAS2 temporary tables.
Use the DAS2 Company window to modify legal company information. You can modify this information:
Legal company address
Legal company address after December 31 (if different)
Legal company APE (Activite Principale des Enterprises) code
You can also view invoice amount totals for each consultant tax code.
To modify company information:
Navigate to the DAS2 Company window.
In the Company Name field, select your legal company from the list of values.
In the Declarer's Address field, enter the address for the legal company.
In the Declarer's Address on December 31 field, enter the legal company's address as of December 31 if the address changed between December 31 and the declaration date.
In the APE Code field, enter the legal company's APE code.
Note: Oracle Payables does not validate this field.
View company invoice totals for all consultants in the Type 310 region.
The Type 310 region displays the total invoiced amount for each consultant tax code for all divisions (for the current DAS2 year). You can modify these totals in the DAS2 210 Third Parties window. If you change a consultant tax code amount in the DAS2 210 Third Parties window, the corresponding total in this region is automatically updated.
Use the DAS2 Divisions window to modify information for a division of your company. You can modify this information for a division:
Division INSEE APE code
Division activity or profession
Division address after December 31 (if different)
Division SIRET
Identify division as a tax reporting entity
Number of employees
Division contact information
Division manager information
You can also view invoice amount totals for each consultant tax code for this division.
To modify division information:
Navigate to the DAS2 Company window.
Navigate to the DAS2 Divisions window by pressing the DAS 20/300 button.
In the Division Name field, query the division that you want.
In the APE Code field, enter the division's INSEE APE code.
Note: Oracle Payables does not validate this field.
In the Type of Work field, enter the division's area of business.
In the Address on December 31 field, enter the division's address as of December 31 if the address has changed between December 31 and the declaration date.
Navigate to the On January 1 region.
In the SIREN field, enter the company's old SIREN if the division's SIRET (SIREN + NIC) changed in the past year.
In the NIC field, enter the division's old NIC if the division's SIRET (SIREN+ NIC) changed in the past year.
Check the Division Submits Tax for Employees check box if the division submits taxes for its employees.
Note: The French DAS2 Verification report enters a default value during the extraction process, but you can change the default value by checking or unchecking the check box.
Navigate to the Modifiable Extract Data tabbed region to modify DAS2 contact information for the division.
In the End of Year Employee Total field, enter the number of employees in the division at the end of the year.
Navigate to the DAS2 Contact region.
In the Last Name field, enter the last name of the division's contact person.
In the First Name field, enter the first name of the division's contact person.
In the Telephone field, enter the work telephone number of the division's contact person.
Navigate to the DAS2 Manager region.
The default values in these fields are the name and telephone number of the division contact.
In the Last Name field, enter the last name of the division manager.
In the First Name field, enter the first name of the division manager.
In the Telephone field, enter the business telephone number of the division manager.
Navigate to the Totals tabbed region to view division invoice totals for all consultants.
The Totals tabbed region displays the total invoiced amount for each consultant tax code for this division (for the current DAS2 year). You can modify these totals in the DAS2 210 Third Parties window. If you change a consultant tax code amount in the DAS2 210 Third Parties window, the corresponding total in this region is automatically updated.
Repeat steps 3 to 22 for each division that you want.
Use the DAS2 210 Third Parties window to modify information for a consultant supplier included in the DAS2 declaration. The information you can modify for a consultant includes:
Consultant address, if the address has changed since the end of the previous year
Total invoiced amount per tax code
Total invoiced amount per tax code category
Categories that contribute to a total invoiced tax code amount
When you update a consultant invoiced amount, Oracle Payables automatically updates the corresponding totals in the DAS2 Company window and DAS2 Divisions window.
Note: Only one user can update consultant tax code amounts at any one time. Oracle Payables locks the company and division amounts as soon as the consultant amount is updated. You should save your work as often as possible when you update the consultant invoiced amounts.
To modify consultant information:
Navigate to the DAS2 Company window.
Navigate to the DAS2 Divisions window by pressing the DAS 20/300 button.
In the Division Name field, query the division that you want.
Navigate to the DAS2 210 Third Parties window by pressing the DAS 210 button.
In the Consultant Company field, query the consultant that you want.
If the consultant is a company, the Consultant Number field displays the consultant company's SIRET. If the consultant is an individual, the Last Name and First Name fields display the consultant's name.
In the Address on December 31 field, enter the consultant's address as of December 31 if the address has changed between December 31 and the declaration date.
Navigate to the Amounts tabbed region.
The Amounts tabbed region displays the total invoiced amount for each consultant, for each consultant tax code (for this DAS2 year).
Modify the total invoiced amount for a tax code by entering a new value in the appropriate field.
Navigate to the Breakdown Amounts tabbed region.
The Breakdown Amounts tabbed region displays the total invoiced amount for three main categories of consultant tax code: Fringe Benefits, Indemnities and Reimbursements, and Withholding Tax.
For each tax code, check the check boxes that contribute to the invoiced amount.
Modify the total invoiced amount for a tax code by entering a new value in the appropriate field.
Use the French DAS2 Type 210 Updates report to print the modifications that you made to data in the DAS2 temporary tables.
The French DAS2 Type 210 Updates report prints a list of all changes to DAS2 temporary tables that you made using the DAS2 update windows since the last extract. Changes to the DAS2 temporary tables include:
Company name, address, and tax information
Division name, address, and tax information
Consultant information
Invoiced amount totals per tax code
Categories that contribute to invoiced amount per tax code
After you run the French DAS2 Type 210 Updates report, you can compare changes to the French DAS2 Verification report to confirm that the DAS2 tables contain correct information.
Use the Standard Request Submission windows to submit the French DAS2 Type 210 Updates report. This report has no parameters.
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the French DAS2 Extract File to generate the DAS2 electronic file that you submit to the tax authorities. You should only run the French DAS2 Extract File after you have:
Extracted consultant transaction information into the DAS2 temporary tables with the French DAS2 Verification report
Reviewed the French DAS2 Verification printed report
Updated information with the DAS2 update windows
Run the French DAS Type 210 Update report to review your updates to information in the DAS2 temporary tables and confirmed the accuracy of all information
You can run the French DAS2 Extract File for a single reporting entity (division) or all reporting entities. You normally run the French DAS2 Extract File for a single reporting entity when you need to prepare a separate DAS2 file for this reporting entity's regional tax authority.
Use the Standard Request Submission windows to submit the French DAS2 Extract File.
Select a legal entity to indicate the reporting unit. If you leave this field blank, then Oracle Payables produces a DAS2 file for all the legal entities.
Enter the applicable establishment ID.
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the French DAS2 Consultant Letters to print letters to all consultants whose income is reported in the DAS2 file for the current year.
The letters describe, for each consultant, the total invoiced amounts and other DAS2 data that was reported to tax authorities for the current year.
Use the Standard Request Submission windows to submit the French DAS2 Consultant Letters. This report has no parameters because the report runs all consultants reported for the current year from the DAS2 temporary tables.
Before you run the French DAS2 Consultant Letters, you must:
Review and update extracted data in the DAS2 temporary tables
Run the French DAS2 Extract File to generate the DAS2 Report file for the consultants concerned
Enter the supplier that you want to report for.
Enter the legal entity that you want to report on.
| In this heading... | Oracle Payables prints... |
|---|---|
| Suppliers Reference | The number of the division issuing the payments. |
| <Supplier Information> | The supplier name and address of the site that declared amounts were paid to. |
| Division | The name of the division that paid the declared amounts. |
| <Location and Date> | The division location and date of the letter. |
| Subject: Declaration of Amount Paid in <Year> | The year that the letter applies to. |
| <Letter Text> | Dear Sir/Madame, Please find here the details (in <ledger currency>) of what we report, on our behalf, to the Tax Authorities: Amounts to Report to the Tax Authorities: For more information, please contact <contact name> (Tel. <contact information>). |
| <Closing> | Sincerely, <name> Financial Director |
| In this row... | Oracle Payables prints... |
|---|---|
| <Amounts Paid> | Any amounts paid in these fiscal categories:
|
| Total (VAT included) | The total payment including VAT |
| Total income | The total payment including VAT |
| Contribution | Tax amounts such as net VAT on royalties and withholding tax |
| Total Taxable Income | The total income minus the contribution |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
The Spanish Withholding Tax Data Extract (190) is a process that gathers withholding tax transactions from Oracle Payables and stores these transactions in the interface table JE_ES_MODELO_190_ALL.
Two reports use this interface table to report withholding tax transactions:
Spanish Withholding Tax report
Spanish Withholding Tax Magnetic Format (Modelo 190)
The data extract process is used in two ways:
Hard copy report for the data extract
Magnetic format for the data extract
The Spanish Withholding Tax Data Extract (Modelo 190) is automatically submitted as a Standard Request Submission program when you submit the hard copy report. The logfile for the hard copy report lists the concurrent request ID of the Spanish Withholding Tax Data Extract (Modelo 190).
The hard copy report waits until the data extract completes before reporting on the transactions it stores.
You must submit the Spanish Withholding Tax Data Extract (Modelo 190) prior to running the magnetic report. The data extract stores withholding tax transactions in the JE_ES_MODELO_190_ALL table in a format that the magnetic report uses.
Each time the Spanish Withholding Tax Data Extract (Modelo 190) is manually submitted, the data extract overwrites the previous transactions from any previous submission.
Select the applicable legal entity to indicate the reporting unit.
Select one of the following values:
Invoice GL Date - Report approved withholding transactions only
Payment Date - Report paid withholding transactions only
Note: If you withheld tax when you paid invoices, enter Payment Date.
Enter the first invoice date that you want to report from. The default is the first day of the year. The date is applied to the invoice distribution date or payment date.
Enter the last invoice date that you want to report to. The default is today's date. The date is applied to the invoice distribution date or payment date.
Enter a valid supplier's name.
Select a withholding tax regime:
Spanish Income Tax Withholding (Modelo 190)
Spanish Non Residents Withholding
Spanish Investment Income Withholding
For these values to be displayed, you must first define withholding tax codes with appropriate VAT transaction types.
The output from the Spanish Withholding Tax Data Extract (Modelo 190) indicates how many transactions are inserted into the table JE_ES_MODELO_190_ALL.
Use the Spanish Withholding Tax report to provide withholding information on your transactions. The report can be summarized by supplier or detailed by invoice.
The Spanish Withholding Tax report is available in two formats:
Summary report - reports approved or paid transactions. Send this format to notify suppliers about withholding on their payments.
Detailed report - reports approved or paid transactions. Use this format for your internal audits.
The Spanish Withholding Tax report lists only invoices that are posted to General Ledger. If you enter invoices with more than one withholding tax group, the Spanish Withholding Tax report may not produce correct information.
The report also lists prepayments. If prepayment is applied to an invoice on a date other than the invoice accounting date, the report displays the prepayment application as a negative amount with the prepayment application date.
When you run the report with the Selection Criteria parameter set to Payment Date, the payment amount is prorated across the discount amount, invoice line amount, and invoice withholding tax amount using these formulas:
Reported Withholding Amount = (Payment Discount + Payment Amount / Invoice Amount) * Summary AWT Amount
Note: The invoice amount in this formula is the unpaid invoice amount including VAT but excluding withholding tax.
Reported Net Amount = (Payment Discount + Payment Amount / Invoice Amount) * Summary Net Amount
Note: The invoice amount in this formula is the unpaid invoice amount including VAT but excluding withholding tax. Summary net amount is the sum of all the item lines originally on the invoice.
Use the Standard Request Submission windows to submit the Spanish Withholding Tax report.
Select the applicable legal entity to indicate the reporting unit.
Select one of these values:
Invoice GL Date - Report approved withholding transactions only
Payment Date - Report paid withholding transactions only
Note: Enter Payment Date if you withheld tax when you paid invoices.
Select one of these values:
Yes - Report summary transactions (Supplier Totals)
No - Report detail transactions (Invoice Totals)
Enter the first invoice date that you want to report from. The default is the first day of the year. The date is applied to the invoice distribution General Ledger date or payment date.
Enter the last invoice date that you want to report to. The default is today's date. The date is applied to the invoice distribution General Ledger date or payment date.
Enter a valid supplier name.
Select a withholding tax regime:
Spanish Income Tax Withholding (Modelo 190)
Spanish Non Residents Withholding
Spanish Investment Income Withholding
To display these values, you must first define withholding tax codes with appropriate VAT transaction types.
| In this heading... | Oracle Payables prints... |
|---|---|
| <Ledger> | The ledger name |
| <Report Title> | Withholding Tax by <Selection Criteria> - Detailed Report |
| Report Date | The current date |
| Page | The current page |
| Date From | The General Ledger or payment date from, depending on the type of report that is run |
| To | The General Ledger or payment date to, depending on the type of report that is run |
| Supplier | The supplier that you entered in the Supplier Name parameter |
| Tax Code | The tax code and tax rate for the invoice distribution lines on the current page |
| Supplier | The supplier name |
| Fiscal Code | The supplier taxpayer ID |
| Legal Address | The legal address for the supplier |
| In this heading... | Oracle Payables prints... |
|---|---|
| <Ledger> | The ledger name |
| <Report Title> | Withholding Tax by <Selection Criteria> - Summary Report |
| Report Date | The current date |
| Page | The current page |
| Date From | The General Ledger or payment date from, depending on the type of report that is run |
| To | The General Ledger or payment date to, depending on the type of report that is run |
| Supplier | The supplier that you entered in the Supplier Name parameter |
| Tax Code | The tax code and tax rate for the invoice distribution lines on the current page |
| In this column... | Oracle Payables prints... |
|---|---|
| Invoice Number | The invoice number |
| Sequence Number | The invoice payment document sequence number |
| Invoice Date | The invoice date |
| GL Date or Payment Date | The invoice General Ledger date or payment date depending on the type of report that is run |
| Net Amount | The net amount for the invoice |
| Tax Rate | The tax rate for the invoice distribution lines on the current page |
| Tax Amount | The withholding tax amount for the invoice |
| In this column... | Oracle Payables prints... |
|---|---|
| Supplier Name | Supplier name |
| Fiscal Code | Supplier taxpayer ID |
| Postal Code | Postal code for the supplier's legal address |
| Town or City | Town or city from the Supplier Site address |
| Net Amount | Net amount |
| Tax Rate | Tax rate for the invoice distribution lines on the current page |
| Tax Amount | Withholding tax amount |
| In this column... | Oracle Payables prints... |
|---|---|
| <Supplier Name> Supplier Total | The net and withholding tax amount totals for the supplier |
| Total for Tax Code <Tax Code> | The net and withholding tax amount totals for the withholding tax code |
| Report Total | The net and withholding tax amount totals for the report |
| In this column... | Oracle Payables prints... |
|---|---|
| Total for Tax Code <Tax Code> | The net and withholding tax amount totals for the withholding tax code |
| Number of Suppliers | The total number of suppliers on the report |
| Report Total | The net and withholding tax amount totals for the report |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Populate the interface table with Oracle Payables transactions to generate a Spanish Withholding Tax Magnetic Format (Modelo 190). You must run the Spanish Withholding Tax Data Extract (Modelo 190) from the Standard Request Submission windows.
Once the interface table is populated, you can run the Spanish Withholding Tax Magnetic Format (Modelo 190). The Spanish Withholding Tax Magnetic Format (Modelo 190) takes the form of a flat file.
Only one user can run the Spanish Withholding Tax Data Extract (Modelo 190) at a time. Each time the Spanish Withholding Tax Data Extract (Modelo 190) is run, the Oracle Payables transaction data is overwritten.
The Spanish Withholding Tax Magnetic Format (Modelo 190) also reports any external withholding tax transactions entered via the Open Interface.
For more information about file content, see Spanish Withholding Tax Magnetic Format (Modelo 190) Content.
Note: If you enter invoices with more than one withholding tax group, the Spanish Withholding Tax Magnetic Format (Modelo 190) may not produce your expected results.
Select the applicable legal entity to indicate the reporting unit.
Enter a valid year.
Enter the delivery medium:
Tape
Diskette
Enter the contact person's name.
Enter the contact person's phone number.
Enter the reference number that the tax authority uses to identify the file. The reference number appears in Record Type 1 of the magnetic format and must appear also on a summary page that accompanies your declaration.
If you are submitting a complementary or substitute declaration, enter the reference number of the previous declaration.
Use the Israeli Withholding Tax Detail/Summary report to prepare a summarized and detailed report to the tax authorities on withholding tax and income tax activities. This report shows the total payments before withholding tax, withholding tax deducted from payments to the vendors, and the number of vendors that had withholding tax deducted.
Use the Standard Request Submission windows to submit the Israeli Withholding Tax Detail/Summary report.
Before running this report, complete the following tasks:
Define a standard calendar in Oracle General Ledger for tax reports and set the calendar as the value for the IL: Tax Calendar profile option.
Run the Create Accounting process for Oracle Payables to ensure that the report displays the correct vendor balance.
Enter the applicable attributes and value sets for each attribute in the vendors or vendors site descriptive flexfield.
Set up withholding tax in the Payables Option tab.
Record first party information.
Enter only automatic tax lines as they appear in the report.
Manually enter withholding tax.
Apply the reporting SOB to show amounts in ILS if the primary currency is not ILS.
Display VAT for unprofitable organizations.
Note: Ensure that you complete these prerequisites for all the Israeli withholding tax reports.
Enter the start date of the tax reporting period.
Enter the end date of the tax reporting period.
Select Summary to display the total tax liability for each vendor and Detail to display the tax liability for each transaction for each vendor and vendor site.
Select the type of vendor to report for.
Select the ledger associated with the legal entity.
Select the applicable legal entity to indicate the reporting unit.
Select the sort order to display the report details.
Select the information level to display report details based on the vendor site or vendor descriptive flexfield..
| In this column... | Oracle Payables prints... |
|---|---|
| Report Logo | The report's logo. |
| Report Title | The report's title. |
| Report Run Date | The date you run the report on. |
| Page Number | The report page number in the Page X of Y format. |
| In this column... | Oracle Payables prints... |
|---|---|
| Vendor Number | The vendor sequence number. |
| Vendor Name | The vendor's name. |
| Taxpayer ID | The tax payer ID of the reported vendor. |
| Site | The vendor's site code and sequence number. |
| Check Number | The vendor's payment number. |
| Payment Type | The type of payment. |
| Payment Date | The check date. |
| Gross Amount | The payment gross amount. |
| Withholding Amount | The withholding tax amount. |
| Rate Percent | The withholding tax amount divided by the gross tax amount. |
| Total Per Site | The total gross tax amount for each site. |
| Total Per Site | The total withholding tax amount for each site. |
| Total Per Vendor | The total gross tax amount for each vendor. |
| Total Per Vendor | The total withholding tax amount for each vendor. |
| Total Per Report | The total gross tax amount for each report. |
| Total Per Report | The total withholding tax amount for each report. |
| In this column... | Oracle Payables prints... |
|---|---|
| Vendor Number | The vendor sequence number. |
| Vendor Name | The vendor's name. |
| Tax Payer ID | The tax payer ID of the reported vendor. |
| Site | The vendor's site code and sequence number. |
| Gross Amount | Total payments gross amount for the supplier. |
| Withholding Amount | Total withholding tax amount for the supplier site. |
| Rate Percent | The withholding tax amount divided by the gross tax amount. |
| Balance | The total liability for each vendor site. |
| Total Per Report | The total gross payment amount for each report. |
| Total Per Report | The total withholding tax amount for each report. |
| Total Per Report | The total tax liability amount for each report. |
| Number of Reported Vendors | The number of reported vendors. |
| Number of Reported Lines | The number of reported transactions. |
Use the Israeli Withholding Tax File to the Tax Authority report to prepare an ASCII file for submitting the annual withholding tax file to the tax authorities (form 856). The text file lists the withheld tax amounts for each vendor for the selected reporting period. Additionally, the file contains the vendors' personal details and the total amounts on their transactions including payments, withholding tax amounts, and liabilities.
Use the Standard Request Submission windows to submit the Israeli Withholding Tax File to the Tax Authority report.
To copy the output to a file, do the following:
Connect the system to a browser to obtain the output on the browser.
Select Copy file and save as a TXT file.
Enter the start date of the tax reporting period.
Enter the end date of the tax reporting period.
Select the ledger associated with the legal entity.
Select the applicable legal entity to indicate the reporting unit.
Select the type of vendor to report for.
Select the information level to display report details based on the vendor site or vendor descriptive flexfield.
Select the applicable option to indicate whether a manual report exists or does not exist.
Select the applicable option to indicate whether a manual or electronic complementary report exists.
Select the applicable option to indicate the payer's employment position.
Use the Israeli Withholding Tax Reconciliation report to review all payments and related withholding tax transactions for vendors and vendor sites for the selected reporting period.
Use the Standard Request Submission windows to submit the Israeli Withholding Tax Reconciliation report.
Enter the start date of the tax reporting period.
Enter the end date of the tax reporting period.
Select the ledger associated with the legal entity.
Select the applicable legal entity to indicate the reporting unit.
Select the applicable vendor's name.
Select the applicable vendor's site.
Select the type of vendor to report for.
Select the sort order to display the report details.
Select the information level to display report details based on the vendor site or vendor descriptive flexfield.
| In this column... | Oracle Payables prints... |
|---|---|
| Report Logo | The report's logo. |
| Report Title | The report's title. |
| Report Run Date | The date you run the report on. |
| Page Number | The report page number in the Page X of Y format. |
| In this column... | Oracle Payables prints... |
|---|---|
| Vendor Number | The vendor sequence number. |
| Vendor Name | The vendor's name. |
| Site | The vendor's site code and sequence number. |
| Tax Name | The name of the tax. |
| Taxpayer ID | The tax payer ID of the reported vendor. |
| Tax Name | The tax group assigned to the vendor site. |
| Certificate From | The starting date for the withholding tax certificate for the vendor site. |
| Certificate To | The ending date for the withholding tax certificate for the vendor site. |
| Tax Rate | The percentage of the withholding tax. |
| Tax Name | The name of the tax. |
| Comments | The comments, if available. |
| Payment Number | The vendor payment number. |
| Payment Type | The type of payment. |
| Payment Date | The payment date. |
| Payment Amount | The payment net amount. |
| Gross Amount | The payment gross amount. |
| Type | The tax type. |
| Withholding Amount | The withholding tax amount. |
| Tax Group | The tax group. |
| Rate Percent | The withholding tax amount divided by the gross tax amount. |
| Total Per Site | The total payment net amount for each site. |
| Total Per Site | The total gross payment amount for each site. |
| Total Per Site | The total withholding tax amount for each site. |
| Total Per Vendor | The total payment net amount for each vendor. |
| Total Per Vendor | The total gross payment amount for each vendor. |
| Total Per Vendor | The total withholding tax amount for each vendor. |
| Total Per Report | The total payment net amount for each report. |
| Total Per Report | The total gross payment amount for each report. |
| Total Per Report | The total withholding tax amount for each report. |
Use the Israeli Withholding Tax Annual Certificate to Vendors report to prepare an annual certificate to vendors on withheld amounts for the total payments registered by each vendor during the selected reporting period. The certificate summarizes the vendor's transactions with the entity issuing the certificate.
Use the Standard Request Submission windows to submit the Israeli Withholding Tax Annual Certificate to Vendors report.
Enter the fiscal year.
Enter the start date of the tax reporting period.
Enter the end date of the tax reporting period.
Select the ledger associated with the legal entity.
Select the applicable legal entity to indicate the reporting unit.
Select Yes to display the transactions with withholding tax amount equal to zero.
Select the type of vendor to report for.
Select the supplier number to start the report with.
Select the supplier number to report till.
Select the information level to display report details based on the vendor site or vendor descriptive flexfield.
Specify how you want the report to display the vendor's name.
| In this column... | Oracle Payables prints... |
|---|---|
| Reporting Year | The fiscal year. |
| From Date | The start date of the tax reporting period. |
| To Date | The end date of the tax reporting period. |
Use the Italian Payables Withholding Tax Letter to print a letter that confirms tax amounts that are withheld on invoices that are partially or fully paid within a calendar year. You must send a letter to every supplier that you withheld tax from within a calendar year, as well as a separate letter to each supplier site.
The Italian Payables Withholding Tax Letter displays the amount of withholding tax for each withholding tax rate applied to the invoices, along with the net amount that was paid for these invoices. The letter shows both the withheld amounts paid to the IRPEF (Imposta sui Redditi delle Persone Fisiche) withholding tax authority and the amounts paid to the INPS (Istituto Nazionale Previdenza Sociale) social security fees tax authority. The Italian Payables Withholding Tax Letter prints all amounts in the set of book's ledger currency regardless of the invoice currency.
The Italian Payables Withholding Tax Letter does not focus on VAT. The letter does include VAT amounts in the gross and net payment amounts but not in the exempt, taxable, withheld, or withheld social security fee amounts.
The text of the letter varies if the supplier is an individual or a company. If you do not enter additional information for a supplier who is an individual, the Italian Payables Withholding Tax Letter prints the company text for that supplier.
Use the Standard Request Submission windows to submit the Italian Payables Withholding Tax Letter.
Before you use the Italian Payables Withholding Tax Letter, you must enter additional information for suppliers who are individuals.
Enter the First Party Legal Entity you want to report on.
Enter the year that you want to report on. The Italian Payables Withholding Tax Letter prints invoices with a payment date between January 1 and December 31 of this year. You can report on a year even if the December period is still open.
Enter the first supplier name that you want to report from.
Enter the last supplier name that you want to report to.
| In this heading... | Oracle Payables prints... |
|---|---|
| Page | The current and total page numbers |
| <Supplier Information> | Dear (if to an individual) or To (if to a company) and the supplier name and address |
| Subject | Withholding Tax |
| Year | The year that you entered in the Year parameter |
| Date | The date that the letter is printed |
| In this column... | Oracle Payables prints... |
|---|---|
| Invoice Number | The invoice number |
| Gross Payment | The original, gross payment amount |
| Exempt Amount | The amount exempt from tax |
| Taxable Amount | The taxable amount |
| Rate | The withholding rate for the withholding tax but not for the social security fees |
| Amount Withheld | The amount withheld, which is the taxable amount multiplied by the rate |
| Net Amount Paid | The net amount paid after deducting the withheld amount and the withheld social security fees from the gross payment |
| Social Security Withheld | The withheld social security fees |
| In this row... | Oracle Payables prints... |
|---|---|
| <Letter Text> |
|
| Page Total | The page totals |
| Totals | The totals for the letter |
| Reasons | The withholding tax information, including the tax code description, the tax code total amount, and the ledger currency. The withheld social security fees are not included. |
| <Closing Text> | The overall withheld tax amount of <total withholding tax amount> <currency> was paid to the proper tax authority according to current law. Kind regards, |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
The annual withholding declaration is a legal requirement in Italy. All legal entries must complete the fiscal template according to the specifications of the Italian fiscal authority. The template requires specific information regarding withholding.
The Italy: Withholding Yearly Extract report meets all the Italian fiscal requirements. The report enables Italian customers to build their withholding yearly declaration.
The report includes an annual report listing for each legal entity, the withholding tax, and the tax identification information related to partially or fully paid payables transactions. The report is consistent with the information listed on Italian withholding tax letters.
The following requirements apply to this report:
Must be submitted for the first legal party entity
Must be submitted per calendar year
Must break (page break) per supplier
Must provide, per every supplier, per rate the withholding tax and social security information in detail and summary sections
Use the Italy: Withholding Yearly Extract Report to provide withholding information on your transactions. The report provides information to meet all Italian withholding requirements, and includes additional information such as summary details related to social security rate, withholding tax rate, and supplier identification information for all the suppliers.
Use the Standard Request Submission windows to submit the Italy: Withholding Yearly Extract Report. Add the Italian Withholding Yearly Extract report to the request group.
Before the Italy: Withholding Yearly Extract Report can be run, the following tasks must be completed in Oracle Payables:
The Italy: Withholding Yearly Extract Report is designed to work with withholdings calculated at payment time only. In the Apply Withholding Tax region Payables Options Withholding tab, select the At Payment Time checkbox.
In the Supplier Tax Details page – Supplier Site region, select the Allow Tax Withholding checkbox. This enables the Invoice Withholding Tax Group and Payment Withholding Tax Group fields. Italian withholding is calculated at the payment level.
In the Payment Withholding Tax Group field, create withholding groups with different withholding rate codes and social security rate codes. Withholding tax rate codes should be attached to the tax authority at the supplier site level, which is defaulted to the invoice level.
Use the Define Turnover Exclusion Rules window to define and maintain exclusion rules. Exclusion rules let you specify the supplier type/customer class, invoice/transaction types, or invoice/transaction distribution line types that you want to exclude from your Payables and Receivables turnover reporting.
For example, if you want to report on the accumulated purchases from all suppliers except suppliers that are designated as a No Tax Recovery supplier type, complete these steps:
Define an exclusion rule that excludes the No Tax Recovery supplier type from your turnover reporting.
Enter the rule in the Exclusion Rule Name parameter field when you submit the Greek Payables Supplier Turnover Report Set. Oracle Payables considers all suppliers for inclusion in the Greek Payables Supplier Turnover Listing and File Format, except suppliers with the No Tax Recovery supplier type.
Note: The Greek Payables Supplier Turnover Listing/File Format and the Greek Receivables Customer Turnover Listing/File Format display public sector companies as a single line. If you define a Payables or Receivables exclusion rule for the public sector company supplier type/customer class, all public sector companies are excluded from your Payables or Receivables turnover reporting.
See Greek Payables Supplier Turnover Listing and File Format and Greek Receivables Customer Turnover Listing and File Format for more information.
To define turnover exclusion rules:
Navigate to the Define Turnover Exclusion Rules window.
In the Rule Name field, enter a unique rule name for the rule that you want to define.
In the Description field, enter a description of the rule that you want to define.
Check the Enabled check box.
Navigate to the Rule Lines region to define specific rule line types that you want to create an exclusion rule for.
Note: If you define an exclusion rule with no lines, all transactions are extracted in the turnover reporting process for this particular rule.
In the Group Type field, from the list of values, select the lookup type (supplier type/customer class, invoice/transaction type, or invoice/transaction distribution line type) that you want to exclude from your turnover reporting with this rule.
In the Name field, from the list of values, select the lookup code that you want to exclude for this rule.
Lookup code selections that exist in the list of values are dependent on the entry that you make in the Group Type field.
The Description field is automatically populated with a description of the lookup code that you enter in the Name field.
Check the Excluded check box to exclude this rule line type from the turnover reporting process.
If you do not check the Excluded check box, the rule line type is considered for inclusion in the turnover reporting process.
Use the Greek Payables Supplier Turnover Listing and Greek Payables Supplier Turnover File Format to report on the turnover (purchase accumulation) of your suppliers. You run the Greek Payables Supplier Turnover Listing and File Format together as part of the Greek Payables Supplier Turnover Report Set.
The Greek Payables Supplier Turnover Listing and File Format show the total number of purchase invoices for each supplier during a specified period. You can specify which supplier types, invoice types, and invoice distribution line types that you want to report on by selecting a turnover exclusion rule when you submit the report set.
Public sector companies are displayed in summary form on a single line. You specify whether a supplier is a public sector company at the supplier level.
You must submit the Greek Payables Supplier Turnover File Format to the Greek tax authorities annually.
Use the Standard Request Submission windows to submit the Greek Supplier Turnover Report Set.
Before you submit the Greek Payables Supplier Turnover Report Set, you must:
Set the GL Ledger name profile option at the responsibility level for your ledger.
Set the JG: Application profile option to Oracle Payables at the responsibility level.
Use the Define Turnover Exclusion Rules window to define exclusion rules that determine the supplier types, invoice types, and invoice distribution line types that Oracle Payables considers for inclusion in the Greek Payables Supplier Turnover Listing and File Format. See Defining Turnover Exclusion Rules for more information.
Select the applicable application short name. The default short name is JE.
Enter the period date that you want to report from.
Enter the period date that you want to report to.
Note: The period start and end dates that you enter must fall within the same calendar year.
Enter Number or Name to specify the range type that you want Oracle Payables to use to extract information for your turnover reports.
If you enter Number, further define the number range by entering the start and end values in the Supplier Number From and To fields.
If you enter Name, further define the name range by entering the start and end values in the Supplier Name From and To fields.
Enter the name that begins the supplier range that you want to report accumulated purchases for. The default is the first supplier name in your supplier list.
Enter the name that ends the supplier range that you want to report accumulated purchases for. The default is the last supplier name in your supplier list.
Enter the number that begins the supplier range that you want to report accumulated purchases for. The default is the first supplier number in your supplier list.
Enter the number that ends the supplier range that you want to report accumulated purchases for. The default is the last supplier number in your supplier list.
Enter the currency code that you want to report supplier purchases in.
If you enter a currency code, only transactions that were entered in the currency code that you specify are reported. Transaction amounts are displayed in the ledger currency.
If you leave this field blank, all transactions are reported. Transaction amounts are displayed in the ledger currency.
Enter the minimum invoice amount that is included in the turnover reports.
Enter the amount type (positive or negative) of the purchase invoices that you want to report on. The amount type that you enter in this field also modifies the minimum invoice amount that you enter in the Invoice Amount Limit field.
Use this field to submit a positive balance listing as well as a negative balance listing. Greek tax authorities require that you submit both listing types on an annual basis.
Enter the exclusion rule that Oracle Payables should use to determine which supplier purchases are included in this report.
| In this heading... | Oracle Payables prints... |
|---|---|
| <Report Title> | Greek Payables Supplier Turnover Listing |
| <Balance Status> | Positive Balance or Negative Balance |
| Ledger | The name of the reporting currency |
| Period From | The period start date that you specified |
| Period To | The period end date that you specified |
| Report Date | The date the report was run |
| Page | The current and total page numbers |
| In this column... | Oracle Payables prints... |
|---|---|
| Serial Num | A number to track the number of suppliers reported |
| Supplier Name | The supplier's name |
| Taxpayer ID | The supplier's taxpayer ID |
| Profession | The supplier's profession |
| City | The supplier's address - city |
| Street | The supplier's address - street |
| Num | The supplier's address - street number |
| Postal Code | The supplier's address - postal code |
| Num of Invoices | The total number of the supplier's invoices for the period that you specified |
| Total Amount for Invoices | The total value of the supplier's invoices for the period that you specified |
| In this row... | Oracle Payables prints... |
|---|---|
| Invoice Total | The sum of the invoice amounts for purchases from all suppliers (except public sector purchases) |
| Purchases from Public Sector Companies | The sum of the invoice amounts for all public sector purchases |
| Report Total | The sum of the invoice amounts for purchases from all suppliers (including public sector purchases) |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the Greek Receivables Customer Turnover Listing and Greek Receivables Customer Turnover File Format to report on the sales turnover (sales accumulation) of your customers. You run the Greek Receivables Customer Turnover Listing and File Format together as part of the Greek Receivables Customer Turnover Report Set.
The Greek Receivables Customer Turnover Listing and File Format show the total number of sales invoices for each customer during a specified period. You can specify which customer types, transaction types, and transaction distribution line types that you want to report on by selecting a turnover exclusion rule when you submit the report set.
Public sector companies are displayed in summary form on a single line. You specify whether a customer is a public sector company at the customer level.
You must submit the Greek Receivables Customer Turnover File Format to the Greek tax authorities annually.
Use the Standard Request Submission windows to submit the Greek Receivables Customer Turnover Report Set.
Before you submit the Greek Receivables Customer Turnover Report Set, you must:
Set the GL Ledger name profile option at the responsibility level for your ledger.
Set the JG: Application profile option to Oracle Receivables at the responsibility level.
Use the Define Turnover Exclusion Rules window to define exclusion rules that determine the customer classes, transaction types, and transaction distribution line types that Oracle Receivables considers for inclusion in the Greek Receivables Customer Turnover Listing and File Format. See Defining Turnover Exclusion Rules for more information.
Select the applicable application short name. The default short name is JE.
Enter the period date that you want to report from.
Enter the period date that you want to report to.
Note: The period start and end dates that you enter must fall within the same calendar year.
Enter Number or Name to specify the range type that you want Oracle Receivables to use to extract information for your turnover reports.
If you enter Number, further define the number range by entering the start and end values in the Customer Number From and To fields.
If you enter Name, further define the name range by entering the start and end values in the Customer Name From and To fields.
Enter the name that begins the customer range that you want to report accumulated sales for. The default is the first customer name in your customer list.
Enter the name that ends the customer range that you want to report accumulated sales for. The default is the last customer name in your customer list.
Enter the number that begins the customer range that you want to report accumulated sales for. The default is the first customer number in your customer list.
Enter the number that ends the customer range that you want to report accumulated sales for. The default is the last customer number in your customer list.
Enter the currency code that you want to report customer sales in.
If you enter a currency code, only transactions that were entered in the currency code that you specify are reported. Transaction amounts are displayed in the ledger currency.
If you leave this field blank, all transactions are reported. Transaction amounts are displayed in the ledger currency.
Enter the minimum invoice amount that is included in the turnover reports.
Enter the amount type (positive or negative) of the sales invoices that you want to report on. The amount type that you enter in this field also modifies the minimum invoice amount that you enter in the Transaction Amount Lower Limit field.
Use this field to submit a positive balance listing as well as a negative balance listing. Greek tax authorities require that you submit both listing types on an annual basis.
Select the applicable legal entity to indicate the reporting unit.
Enter the exclusion rule that Oracle Receivables should use to determine which customer transactions are included in this report.
| In this heading... | Oracle Receivables prints... |
|---|---|
| <Report Title> | Greek Receivables Customer Turnover Listing |
| <Balance Status> | Positive Balance or Negative Balance |
| Ledger | The name of the reporting ledger |
| Period From | The period start date that you specified |
| Period To | The period end date that you specified |
| Report Date | The date the report was run |
| Page | The current and total page numbers |
| In this column... | Oracle Receivables prints... |
|---|---|
| Serial Num | A number to track the number of customers reported |
| Customer Name | The customer's name |
| Taxpayer ID | The customer's taxpayer ID |
| Profession | The customer's profession |
| City | The customer's address - city |
| Street | The customer's address - street |
| Num | The customer's address - street number |
| Postal Code | The customer's address - postal code |
| Num of Invoices | The total number of the customer's invoices for the period that you specified |
| Total Amount for Invoices | The total value of the customer's invoices for the period that you specified |
| In this row... | Oracle Receivables prints... |
|---|---|
| Invoice Total | The sum of the invoice amounts for sales to all customers (except public sector sales) |
| Sales to Public Sector Companies | The sum of the invoice amounts for all public sector sales |
| Report Total | The sum of the invoice amounts for sales to all customers (including public sector sales) |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the Regional Cash Requirement report before you begin to pay invoices. The report shows unpaid invoices due on or before a specific date, grouped by payment group and payment currency.
The Regional Cash Requirement report shows:
Original invoice amount in payment currency and in base currency
Open invoice amounts grouped by payment group and by currency in both payment and functional currency
The report orders invoices in four ways:
By payment group
By invoice currency
By supplier name
By invoice document sequence number
The Regional Cash Requirement report supports these report formats:
Currency Summary - displays the total amounts by payment group and currency.
Invoice Detail - displays invoice amounts in detail by payment group, currency, and supplier.
Pay Group Summary - displays the total account amounts.
Supplier Summary - displays the total amounts by payment group, currency, and supplier.
All Summary - displays the total amount, invoice amounts by payment group, currency and supplier.
Currency and Pay Group - displays the total amounts and the payment group.
Use the Standard Request Submission windows to submit the Regional Cash Requirement report.
Before submitting the Regional Cash Requirement report, you must:
Set up Financials System Options.
Set your VAT Member State.
Set up System Options
Set discount distribution to prorate tax.
Use multiple currencies.
Enter Operating Unit to set operating unit as the reporting level, else enterLedger to set ledger as the reporting level. The default value is Operating Unit.
Enter the reporting context which is an entity in the selected reporting level. This includes ledger names, or operating units and depends on the reporting level.
Enter No to not summarize for all the operating units, else enter Yes. The default value is No.
Enter report format or formats for this report. This table shows what is printed for each format.
| If you select this format... | Oracle Payables displays... |
|---|---|
| Account | Liability Account Summary Report |
| Account and Currency | Account and Currency Summary Report |
| All Reports | All Summary Reports and Invoice Detail Report |
| All Summary Reports | Account, Currency, and Supplier Summary Reports |
| Currency | Currency Summary Report |
| Invoice | Invoice Detail Report |
| Supplier | Supplier Summary Report |
| Currency and Pay Group | Currency and Pay Group Reports |
Enter the payment group. If you leave this parameter blank, Oracle Payables displays all pay groups.
Enter the payment currency. If you leave this parameter blank, the report displays all currencies.
Enter the supplier name. If you leave this parameter blank, the report displays all suppliers.
Enter the date. Oracle Payables selects all invoices that have an opening balance on or before the As of Date and are due for payment, with discounts taken, on or before the As of Date.
Enter Validated to only include validated invoices. Select Never Validated to include invoices that are never validated. Leave this parameter blank to include all invoices. The default value is Validated.
| In this heading... | Oracle Payables prints... |
|---|---|
| <Ledger> | The Ledger |
| <Report Title> | Regional Cash Requirement Report |
| Report Date | The date and time that the report is run |
| Page | The current and total pages of the report |
| Pay Group (except Pay Group Summary) | The payment group |
| Currency (Supplier Summary and Invoice Detail only) | The payment currency |
| Invoices Group By (Invoice Detail only) | The way that the report invoices are organized |
| <Summary Heading> (summary reports only) | The type of summary report:
|
| In this column... | Oracle Payables prints... |
|---|---|
| Doc Seq | The invoice document sequence number. |
| Invoice Num | The invoice number. |
| Approved | The approval status of an invoice or credit/debit memo.
|
| Due Date | The date that an invoice is due, assuming that discounts are taken. If the invoice has several due dates, Oracle Payables prints the earliest date. |
| Amount | The invoice amount in the payment currency. If the invoice is partly paid, Oracle Payables prints only the remaining amount of the invoice. |
| Base Amount | The invoice amount in the functional currency. |
| Discounts Taken | The discounts taken in a functional currency. |
| Gain/Loss | The foreign exchange rate gain or loss amount, if the invoice is partly paid. |
| Pay Date | The payment date, if the invoice is partly paid. |
| Doc Seq Num | The payment document sequence number. |
| Base Currency Paid Amount | The paid amount in a functional currency, if the invoice is partly paid. |
| Open Amount | The open amount in the invoice currency. |
| Base Currency Open Amount | The open amount in a functional currency. |
| In this column... | Oracle Payables prints... |
|---|---|
| Pay Group | The payment group name |
| Invoice Total | The total of all invoices for the payment group |
| Discounts Taken | The discounts taken in a functional currency |
| Gain(-)/Loss(+) | The foreign exchange rate gain or loss amount, if the invoices are partly paid |
| Paid Summary | The sum of paid amounts |
| Open Summary | The sum of open amounts |
| In this column... | Oracle Payables prints... |
|---|---|
| Currency (Currency Summary only) | The currency code |
| Supplier (Supplier Summary only) | The supplier information |
| Invoice Summary | The total of all invoices |
| Base Currency Invoice Summary | The sum of amounts in the base currency |
| Discount Taken | The discounts taken in a functional currency |
| Gain(-)/Loss(+) | The foreign exchange rate gain or loss amount, if the invoices are partly paid |
| Paid Summary | The sum of paid amounts |
| Base Currency Paid Summary | The sum of paid amounts in the base currency |
| Open Summary | The sum of open amounts |
| Base Currency Open Summary | The sum of open amounts in the base currency |
| In this row... | Oracle Payables prints... |
|---|---|
| <Supplier Name> | The supplier name |
| Supplier Summary | The supplier totals |
| Currency Summary | The payment currency totals |
| In this row... | Oracle Payables prints... |
|---|---|
| <Pay Group> Total | The totals for each payment group |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Overview of Multiple Organizations Reporting, Oracle Applications Multiple Organizations Implementation Guide
Use the Finnish Payables Account by Detail report to provide a legal audit trail of all recorded invoices and payments. The report ensures the audit trail from Oracle Payables to original documents.
The Finnish Payables Account by Detail report shows open invoices at a specific date. This report also shows paid invoices in an accounting date range grouped by liability account and supplier name (alphabetical order).
Use this report to reconcile your liability balances for specific dates and paid amounts for a specific period in General Ledger. This report is typically used after the accounting period has closed; however, you can reconcile total amounts between Account Payables and General Ledger at any time.
The Finnish Payables Account by Detail report shows:
Original invoice amounts in entered currency as well as ledger currency
Open invoice amounts grouped by liability account in both entered invoice currency and ledger currency
Paid amounts in an accounting date range
Discounts taken in an accounting date range
Exchange rate gain/loss amounts in an accounting date range
Invoice open total amounts are reconciled to YTD balances for liability accounts. Paid total amounts are reconciled to the PTD balances of cash accounts. Discount total amounts are reconciled to the PTD balances of discount accounts. Exchange rate gain/loss total amounts are reconciled to the PTD balances of gain/loss accounts.
The report organizes invoices in four ways:
By liability account
By invoice currency
By supplier name
By invoice document sequence number
The Finnish Payables Account by Detail report supports these layouts:
Account Summary - displays the total account amounts.
Currency Summary - displays the total account and currency amounts.
Invoice Detail - displays details of each invoice by account, currency, and supplier.
Supplier Summary - displays the total account, currency, and supplier amounts.
Use the Standard Request Submission windows to submit the Finnish Payables Account by Detail report.
Before submitting the Finnish Payables Account by Detail report, you must:
Set up Financials System Options. Set your VAT Member State to Finland.
Set up System Options.
Set discount distribution to prorate tax.
Use multiple currencies.
Enter report format or formats for this report. This table shows what is printed for each format.
| If you select this format... | Oracle Payables displays... |
|---|---|
| Account | Liability Account Summary Report |
| Account and Currency | Account and Currency Summary Report |
| All Reports | All Summary Reports and Invoice Detail Report |
| All Summary Reports | Account, Currency, and Supplier Summary Reports |
| Currency | Currency Summary Report |
| Invoice | Invoice Detail Report |
| Supplier | Supplier Summary Report |
Enter the liability account. If you leave this parameter blank, the report displays all liability accounts.
Enter the invoice currency. If you leave this parameter blank, the report displays all currencies.
Enter the supplier name. If you leave this field parameter, the report displays all suppliers.
Enter the date. Oracle Payables selects all invoices with an open balance on or before the As of Date and, depending on the value of the Paid Invoices parameter, any invoices that are paid between your period start date and the As of Date.
Enter Yes to select all open invoices at the As of Date and invoices paid between the period start date and the As of Date. If you enter No, the report does not show invoices that were paid between the period start date and the As of Date.
Enter Yes to include only invoices that were transferred to General Ledger. Enter No to include only invoices that were not transferred to General Ledger. Leave this parameter blank to include all invoices. The default value is Yes.
Enter Yes to include only payments that were transferred to General Ledger. Enter No to include only payments that were not transferred to General Ledger. Leave this parameter blank to include all payments. The default value is Yes.
Enter Yes to include only cleared payments. Enter No to include only uncleared payments. Leave this parameter blank to include all payments. The default value is Yes.
| In this heading... | Oracle Payables prints... |
|---|---|
| <Ledger> | The ledger |
| <Report Title> | Finnish Account Payables by Detail Report |
| Report Date | The date and time that the report is run |
| Page | The current and total pages of the report |
| Account (except Account Summary) | The liability account (balancing segment and account segment values) |
| Currency (Supplier Summary and Invoice Detail only) | The invoice currency |
| Invoices Group By | The way that the report invoices are organized |
| <Summary Heading> (summary reports only) | The type of summary report:
|
| In this column... | Oracle Payables prints... |
|---|---|
| Doc Seq | The invoice document sequence number. |
| Invoice Num | The invoice number. |
| Approved | The approval status of an invoice or credit/debit memo.
|
| Due Date | The date that an invoice is due, assuming that discounts are taken. If the invoice has many due dates, Oracle Payables prints the earliest date. |
| Amount | The invoice amount in the entered invoice currency. If the invoice is partly paid, Oracle Payables prints only the remaining amount of the invoice. Exceptions are if the Paid Invoices parameter is set to Yes and the payment information is between the period date and the As of Date. |
| Base Amount | The invoice amount in the ledger currency. |
| Discounts Taken | The discounts taken in the ledger currency. |
| Gain/Loss | The foreign exchange rate gain or loss amount. |
| Pay Date | The payment date. |
| Doc Seq Num | The payment document sequence number. |
| Ledger Currency Paid Amount | The paid amount in the ledger currency. |
| Open Amount | The open amount in the invoice currency. |
| Ledger Currency Open Amount | The open amount in ledger currency. |
| In this column... | Oracle Payables prints... |
|---|---|
| Account | The liability account |
| Invoice Total | The total of all invoices for the payment group |
| Discounts Taken | The discounts taken in a ledger currency |
| Gain(-)/Loss(+) | The foreign exchange rate gain or loss amount, if the invoices are partly paid |
| Paid Summary | The sum of paid amounts |
| Open Summary | The sum of open amounts |
| In this column... | Oracle Payables prints... |
|---|---|
| Currency (Currency Summary only) | The currency code |
| Supplier (Supplier Summary only) | The supplier information |
| Invoice Summary | The total of all invoices |
| Ledger Currency Invoice Summary | The sum of amounts in the ledger currency |
| Discount Taken | The discounts taken in a ledger currency |
| Gain(-)/Loss(+) | The foreign exchange rate gain or loss amount, if the invoices are partly paid |
| Paid Summary | The sum of paid amounts |
| Ledger Currency Paid Summary | The sum of paid amounts in the ledger currency |
| Open Summary | The sum of open amounts |
| Ledger Currency Open Summary | The sum of open amounts in the ledger currency |
| In this row... | Oracle Payables prints... |
|---|---|
| <Supplier Name> | The supplier name |
| Supplier Summary | The supplier totals |
| Currency Summary | The payment currency totals |
| In this row... | Oracle Payables prints... |
|---|---|
| <Account> Total | The totals for each liability account |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the Polish Supplier Statement report to provide information on recent payables transactions in response to supplier inquires.
The Polish Supplier Statement report shows, for each supplier included in the report, all invoice transactions within a specified range of dates for a specified transaction type. The report groups transactions by currency.
The Polish Supplier Statement report is also divided into two sections. The first section lists all transactions, including invoices, payments, withholdings, and applied prepayments, already applied to the supplier balance. The second section lists unapplied prepayments to show you what the supplier balance would be if the remaining amount of prepayments is applied.
You can enter user-defined text if you would like to print a note on the report to send to your suppliers.
Use the Standard Request Submission windows to submit the Polish Supplier Statement report.
If you would like to enter user-defined text that prints a note on the report to your suppliers, you must complete these prerequisites.
In the Applications Object Library Lookups window, query the JG_ZZ_SUPPLIER_STATEMENT_TEXT lookup type.
In the Lookup Code field, enter a sequence number. The Polish Supplier Statement uses this number to determine the order to print text on the report. You should also enter this number in the Meaning field.
In the Description field, enter a user-defined note to the supplier. You should limit text to 180 characters.
To create a blank line in the report, specify a sequence number in the Lookup Code and Meaning fields and leave the Description field blank. Check the Enabled check box.
Use one or both of these strings in the Description column to specify the report date or the total outstanding balance in the note to the supplier:
&F_AS_OF_DATE - The report prints the report date.
&F_TOTAL_BALANCE - The report prints the outstanding balance owed to the current supplier site.
Select either Ledger or Operating Unit.
Enter Functional to print transactions in the ledger currency. Enter Transactional to print transactions in entered currency. If you choose Transactional, the report groups transactions by entered currency.
Select the applicable context value.
Enter the name of the supplier that you want to report from. The Supplier Name From and To parameters are not affected by what you enter in the Supplier Taxpayer ID parameter.
Enter the name of the supplier that you want to report to. The Supplier Name From and To parameters are not affected by what you enter in the Supplier Taxpayer ID parameter.
Enter the taxpayer ID for suppliers that you want to include in the report. This parameter is not affected by what you enter in the Supplier Name From and To parameters.
Enter the accounting date for transactions that you want to report from. The supplier beginning balance is computed for all transactions before this start date.
Enter the accounting date for transactions that you want to report to.
Enter a document category to restrict the report to invoices for the document category. All invoices are included if the parameter is left blank.
Choose Yes to include invoices with accounting that is transferred to General Ledger. Enter No to include invoices regardless of posting status.
Choose Yes to include invoices that are validated or approved in Oracle Payables. Choose No to include all invoices regardless of approval status.
This table shows the report headings.
| In this heading… | Oracle Payables prints… |
|---|---|
| <Ledger Name> | The name of your ledger |
| <Report Title> | Supplier Statement |
| Report Date | The date and time that you ran the report |
| Page | The current and total pages of the report |
| Supplier Name | The supplier's name |
| Supplier Tax ID | The supplier's taxpayer ID |
| Site | The supplier's site information. |
| Supplier Address | The supplier's site address |
| Date From | The accounting date that you entered in the Start Date parameter to report transactions from |
| Date To | The accounting date that you entered in the End Date parameter to report transactions to |
| <User-Defined Text> | User-defined text to the supplier |
Note: Columns contain different information depending on whether the row is Invoice, Payment, Prepayment, or Withholding.
This table shows the column headings.
| In this column… | Oracle Payables prints… |
|---|---|
| Date | In the first section of the report:
|
| Document Category | In the first section of the report, the transaction type description. In the second section, the only possible value is Prepayments and Advances. |
| Transaction Number | The transaction number:
|
| Transaction Currency | The currency code of the original transaction. |
| Transaction Amount | The transaction amount in the transaction currency. In the first section of the report:
|
| Transaction/Ledger Currency - Amount | The transaction amount in original currency or ledger currency. |
| Transaction/Ledger Currency - Remaining Amount | The remaining balance of the transaction. For invoices, the invoice amount due is printed. For prepayments, the unapplied item line distribution amount is printed in the second section of the report. |
| Transaction/Ledger Currency - Balance | The supplier running total in original currency or ledger currency. |
| Reference Information - Date | The document reference date. For payments, applied prepayments, and unapplied prepayments, the invoice date may be referenced. If withholdings are calculated at payment time, the payment date is listed. |
| Reference Information - Document Type | The type of document that is referenced:
|
| Reference Information - Transaction Number | The number of the transaction that is referenced:
|
This table shows row headings.
| In this row… | Oracle Payables prints… |
|---|---|
| Beginning Balance | The beginning balance and the currency code for the transactions with this currency code. If submitted in transaction currency, the report displays a beginning balance for each currency code. If submitted in the ledger currency, the report prints only the beginning balance of the ledger currency code. The beginning balance is calculated with the information that exists in Payables Subledger Accounting Entries. |
| <Report Section 2 Title> | Unapplied Prepayments |
| Ending Balance | The ending balance and the currency code for the transactions with this currency code. In the first section of the report, the ending balance with all the transactions that were already applied for the supplier is printed. In the second section, the report prints what would be the ending balance if the unapplied transactions are applied. |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the Portuguese Payables Taxpayer ID Exception report to list any suppliers who do not have a taxpayer ID. The report only selects the customers for whom you inserted at least one transaction.
Use the Standard Request Submission windows to submit the Portuguese Payables Taxpayer ID Exception report.
Select the applicable legal entity to indicate the reporting unit.
Select the ledger associated with the legal entity.
Enter the balancing segment value used by the suppliers.
| In this heading… | Oracle Payables prints… |
|---|---|
| <Report Title> | Portuguese Payables Taxpayer ID Exception Report |
| Report Date | The date the report is run |
| Page | The current and total pages of the report |
| In this column… | Oracle Payables prints… |
|---|---|
| Supplier Name | The supplier's name |
| Supplier Number | The supplier's number |
Related Topics
Running Reports and Programs, Oracle Applications User Guide
Use the Hungarian Payables Invoice Aging report to analyze the cash flow of unpaid invoices and your uncleared payments. The report organizes uncleared items into time periods that you define, based on the transaction due date. You can only run the report in your functional currency.
Use the Standard Request Submission windows to submit the Hungarian Payables Invoice Aging report.
Before running the Hungarian Payables Invoice Aging report, you must set up aging periods in the Define Aging Periods window within Oracle Payables. The report displays invoice payment information for the first four periods that you define in an aging period.
Select the ledger that you want to report for.
Select the legal entity that you want to report on.
Enter one of the following sorting methods:
Invoice Type - Oracle Payables sorts the Invoice Aging Report by invoice type and displays each invoice type in a separate supplier grouping.
Trading Partner - Oracle Payable sorts the Invoice Aging Report by supplier name and displays different invoice types in the same supplier grouping.
Enter the summary option for this report:
Invoice - Displays each invoice number when calculating the total invoice payments due to a supplier.
Supplier - Displays the total invoice payments due to a supplier without displaying each invoice.
Select the format for this report:
Brief - Displays the name of each supplier without displaying a supplier's city and state.
Detailed - Displays the city and state for each supplier in addition to the supplier name.
Payables includes invoice information for invoices that have invoice amounts greater than this Minimum Amount Due and that fall within the aging period you specify.
Payables includes invoice information for invoices that have invoice amounts less than this Maximum Amount Due and that fall within the aging period you specify.
Enter the type of invoice that you want to review in this report, or leave the Invoice Type blank to select all invoice types.
Credit Memo
Debit Memo
Expense Report
Interest
Mixed
Prepayment
Standard
Withholding Tax
If you want to submit this report for only one supplier, enter the supplier name.
Enter the aging period you want to use for your Invoice Aging report. The report displays invoice payment information for the first four periods that you defined for this Aging Period in the Aging Periods window.
Select the type of aging report you want to run:
Combined - Displays the outstanding amount of each invoice, including any uncleared payments applied to the invoice.
Payments - Displays outstanding amount of any uncleared payments referencing the payment number as well as the invoice number.
The following table describes selected column headings.
| In this column… | Oracle Payables prints… |
|---|---|
| Due Date | The date an invoice is due, assuming no discounts are taken. |
| Days Due | The number of days until an invoice is due. For example, 30 Days Due describes an invoice that was due 30 days ago. -30 Days Due describes an invoice that will be due 30 days after today. |
| Payment | The payment number of the uncleared payment if you selected a report type of Payment. If you selected a report type of Combined, this column is blank and does not have a heading. |
| Amount Remaining | The amount remaining for payment, and/or the uncleared payment amount. If you are using multiple currencies, Payables converts invoice and payment amounts into your functional currency for this report. |
| <Aging Period 1 - 4> | In each of the four aging period columns, Payables prints the amount of invoices and/or uncleared payments due within the invoice aging period. Payables also displays the total amount of invoices and/or uncleared payments due to each supplier within this period. |
Related Topics
Running Reports and Programs, Oracle Applications User Guide