This chapter contains the following topics:
Section 5.2, "Understanding the System Setup to Work With France Electronic Invoices"
Section 5.4, "Working with Accounts Receivable Invoices in France,"
Section 5.5, "Working With Sales Order Processing for France,"
In addition to using standard JD Edwards EnterpriseOne functionality to work with invoices, you can use country-specific software to:
Add additional information to the invoices.
Specify whether the system enables or requires that you enter related invoices when you add credit notes or debit notes.
Generate electronic invoices.
Public sectors in France are required to submit a digital version of the issued invoices that meet specific criteria. The information in this electronic document is issued as an Extensible Markup Language (XML) file that complies with specific format and content requirements.
JD Edwards EnterpriseOne Localizations for France uses standard programs to generate a printable invoice document, and country-specific generic invoice functionality to generate a digital electronic invoice.
The system generates the electronic document in accordance with French regulations so that you can submit it later to the fiscal authorities.
The system uses Oracle's BI Publisher (Business Intelligence Publisher) to produce the required XML files. The system has different versions of the extractor process, which relate to different report definition templates to manage the data formatting process of the basic information.
The BI Publisher creates the XML files in a two-phase process:
Information extraction, generation, and data formatting
XSLT transformation
An Extensible Stylesheet Language Transformation (XSLT) is an XSL script that maps an XML schema to another XML schema. The XML generation programs extract the required information and produce an XML schema that is mapped to the schema provided by the government fiscal authorities.
To generate the different XML files that comply with the output information and format required by the fiscal authorities, the system uses specific templates and report definitions. Review the relationships in the following table:
Output | Batch Version Program | Version | Template | BI Publisher Report Definition |
---|---|---|---|---|
Electronic Invoice XML File | R7030040 | ZJDE0003 | TP7430040TS3 | RD7030043 |
Note: Before you run the XML generation programs, verify that the BI Publisher is set up correctly in your system.See Also: |
Before you start working with electronic invoices for France, you must enable the generic invoice functionality, set up additional information, legal companies, and legal documents.
JD Edwards EnterpriseOne Localizations for France simplifies the process to set up your system and generate electronic invoices that meet legal requirements.
Verify that the UDC tables required to work with electronic accounting are correctly set up in your system.
See Chapter 3, "Setting Up UDCs for Electronic Invoices for France,".
Use the Functionality by Country Setup program (P700000) to enable the Generic Invoice functionality for the modules Accounts Receivable and Sales Order Processing.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Functionalities By Country | W700000A | Electronic Invoice Setup (G74FEI), Functionality by Country Setup | Enable or disable the electronic invoice functionality. |
Access the Functionalities by Country form.
Select the country code FR for France from the Localization Country Code UDC table (00/LC).
The system triggers the country-specific functionality based on the country code using the country server methodology in the base EnterpriseOne product.
Select the value of the functionality that you want to enable from the Functionalities by Country UDC table (70/FC).
To enable the Generic Invoice functionality for Accounts Receivable, select the value GI-ARINV. To enable the Generic Invoice functionality for Sales Order Processing, select the value GI-SOPINV.
Before you can generate digital electronic invoices according to the requirements specified by the French fiscal authorities, you must set up legal documents. You can generate electronic invoices for several types of documents as defined by fiscal regulations. The solution is not limited to invoices only.
After you set up different legal document types, you must associate the legal document to the internal document types that your company uses, relate the legal document to the program that processes the documents, and set up next number.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Legal Document Types | W7400002A | Legal Document Set Up(G74FLD00), Legal Document Type | Review or select an existing legal document type. |
Legal Document Type Revision | W7400002B | On the Work With Legal Document Types form, click Add. | Enter legal document types. |
Legal Document Type for Electronic Invoice | W74F0003A | Legal Document Set Up(G74FLD00), Legal Document Type for Electronic Invoice | Add, or select an existing record. |
Work With Legal Document Type | W74F0003B | Click Add on the Legal Document Type for Electronic Invoice form. | Associate legal document types with document types. |
Work With Legal Documents Print UBEs & Versions | W7430024A | Legal Document Set Up(G74FLD00), Legal Document / Print UBEs Relation | Select an existing record. |
Legal Documents Print UBEs & Versions Revision | W7430024B | On the Work With Legal Documents Print UBEs & Version form, click Add. | Specify the versions and print programs that the system uses to print legal documents. |
You set up legal document types to specify how the system handles taxes for a type of document, whether the system must print the document on one page, and whether multiple payment terms are allowed for a document.
Set up legal document types for:
380: Invoice
386: Prepayment Invoice
381: Credit Memo
The system stores the legal document types that you create in the Legal Document Types table (F7400002).
Access the Legal Document Type Revision form.
Enter the name code that you assign to a legal document type. The French government defines the codes and the legal document types that you must use.
Examples of values that you can set up are:
380: Invoice
386: Prepayment Invoice
381: Credit Memo
Enter a value that exists in the Legal Document Type Group (74/DG) UDC table to specify the group to which the legal document type belongs.
Leave this field blank to specify that this information is not applicable for France.
Select this check box to have the system calculate taxes. The Discriminate Taxes field is enabled when you select this option.
For France, you should always select this option for all document types.
Enter a value that exists in the Discriminate Taxes (74/DL) UDC table to specify whether the system prints the value of the goods or services and the tax amounts separately (discriminates the taxes). This field is enabled only if the Calculate Taxes option is selected.
Values are:
0: Do not discriminate. The taxes are included in the unit and extended prices.
1: Discriminate by detail line. The taxes are not included in the price. The total tax rate and total tax amount of a line are printed in each detail line.
2: Discriminate by tax code. The taxes are not included in the price; they are printed separately below each detail line. This option is not applicable if you select the One Page Document check box.
3: Total taxes by tax code and rate. The taxes are not included in the price; they are grouped by tax rate at the end of the document. This option is not applicable if you select the One Page Document check box.
4: Discriminate by tax code and total. The taxes are not included in the price; they are printed separately below each detail line and also grouped by tax rate at the end of the document. This option is not applicable if you select the One Page Document check box.
Select this check box to have the system print the legal document on one page.
The system does not use this information for electronic invoices. You can leave this field blank. The system ignores any value that you enter in this field when you generate electronic invoices for French legal documents.
Select this check box to have the system print the detail lines for only one payment term. If you do not select this check box, the system does not create a page break based on payment terms.
Do not select this check box for electronic invoices of legal documents in France.
Enter a value that exists in the Number of Copies Source (74/NC) UDC table. Values are:
Blank: Use the customer billing instructions that exist in the Customer Master Information (P03013) program to specify the number of copies.
L: Legal document. The system prints the number of copies that you specify in the Number of Legal Document Copies field.
Enter the number of copies to print. The system enables this field only if the value in Number of Copies Source field is L.
Enter a value that exists in the Supplier Address Source (74/SC) UDC table to specify the source that the system uses for the entity that prints the document. Values are:
Blank: Legal company
B: Business Unit
C: Company
S: Country-Specific
Leave this field blank to specify that the system uses the legal company for French legal documents.
Select this check box to have the system include banking information on the legal document. You specify the details of the banking information in the Bank Connections for Legal Document Program (P700050).
The system does not include contact information on legal documents for France, so you can leave this field blank. The system ignores any value that you enter in this field when you work with French legal documents.
Before you can generate electronic legal documents, you must set up document types (internal document types) in the Document Type (00/DT) UDC table for each legal document that you use. You associate the values in the 00/DT UDC table with the values that you create for legal document types.
You use the Legal Document Types program to create legal document types, then use the Legal Document Type for Electronic Invoice program (P74F0003) to create the relationships between legal document types and internal document types. When you create the relationships, you also specify the company for which the relationship applies. If the company that you enter in this program is not already in the Company Additional Information table (F7400010), then this program creates a record for it.
You can set up relationships for many internal document types to a single legal document type. For example, you can associate the internal document type RI (Invoice) to the legal document type for France 380 (Invoice), and also associate the document type RR (Recurring Invoice) to the legal document type 380.
The system stores the relationships in the Legal Doc Types for Electronic Invoice (F74F0003) table.
Access the Work With Legal Document Type form.
Enter the company for which the association applies.
Enter the internal document type that you want to associate with the legal document type. You must enter a value that exists in the Document Type (00/DT) UDC table.
Enter the legal document type that you want to associate with the document type. The legal document type that you enter must exist in the F7400002 table.
This section provides an overview of versions for legal documents and corresponding versions and discusses how to specify versions and print programs.
You use the Legal Document / Print UBEs Relation program (P7430024) to associate legal document types with versions of print programs that generate legal documents.
The system stores the information for versions and programs in the F7430024 table.
A corresponding version is a version with an identical name. You set up the corresponding versions in addition to completing the steps to set up legal numbering and associate print templates with legal document types.
For legal documents that you printed from the JD Edwards EnterpriseOne Sales Order Management system, you must set up corresponding versions for the legal documents in the country-specific programs for the legal documents, and in the Print Invoices (R42565) program.
You use the PO - Sales Legal Document Generation program (P7420565) to set up versions for electronic invoices.
Verify that a version with the same name exists for the program P7420565 for every version that you use with the Print Invoices (R42565) program for France.
Access the Legal Documents Print UBEs & Versions Revision form.
Enter the company for which you set up the association between a print program and a version for the print program.
Enter the legal document type for which you associate a print program and a version of the print program. The value that you enter must exist in the F7400002 table.
For France, create a record for each legal document type specified in the regulation.
Enter the place of issue of the legal document. This field is optional.
Enter a user ID to restrict permission to print the document to the specified person. This field is optional.
Enter the program to which you want to associate a version.
Specify R7030030 (Generic Invoice Grouping program) for all the electronic invoices and legal documents types in France.
Enter the version of the program that you specified in the UBE field that you want the system to use when you run the specified program.
This section provides an overview of the process to work with AR invoices, lists prerequisites, the forms used to work with AR invoices, and discusses how to:
Set the processing options for the PO - Localization Invoice Entry program (P7433B11).
Enter additional information for invoices.
Set the processing options for the Generic Invoice Grouping program (R7030030).
Set the processing options for the Legal Document Print Process program (R7430030).
Run the Legal Document Print program (R7430030).
Before you perform the tasks in this section:
Set up your system with standard information for Accounts Receivable.
Set up your system to work with the electronic invoice functionality.
See Understanding the System Setup to Work With France Electronic Invoices.
Set up the legal documents.
Enter additional Address Book information and tax areas information.
Set up the legal company.
In addition to the standard next numbering schemes, set up next numbers for legal documents in France.
Set the processing options for the Customer Ledger Inquiry program (P03B2002).
To work with the Accounts Receivable invoice process in France, you:
Generate Accounts Receivable Invoices using standard programs and processes.
Enter additional information for the invoices for which you are generating electronic invoices.
Post the invoices using the General Ledger Post program (R09801).
Depending on whether you need to generate an electronic invoice for the customer or not you:
Run the standard Invoice Print program (R03B505) to generate a printable PDF version of the invoice.
If the option Generate Electronic Invoice in the additional information entered for the customer is enabled and you try to run this program, the system displays an error message in the PDF output file that instructs the user to run the Legal Document Print Process program (R7430030) instead.
Run the Legal Document Print Process program (R7430030) to launch the electronic invoice process and generate a digital XML electronic invoice file.
If the option Generate Electronic Invoice in the additional information entered for the customer is not enabled and you try to run this program, the system displays the message "No Data Selection" in the report output and does not include any transactions.
When you run this program, the system also populates the VR01 "Reference" field with the legal document number.
If applicable, submit the XML file that the system generates to the fiscal authorities.
Note: Submitting the XML files to the fiscal authorities is a step in the process that occurs outside of the JD Edwards EnterpriseOne for France Localizations system and processes. |
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Versions (PO - Localization Invoice Entry)(P7433B11) | W983050B | French Accounts Receivable (G74F03B), PO - Localizations Invoice Entry | Select the version for the Localization Standard Invoice Entry program (P03B11) and set up the applicable processing options. |
Work With Customer Ledger Inquiry | W03B2002A | Customer Invoice Entry (G03B11), Standard Invoice Entry | Select or review invoices. |
Standard Invoice Entry | W03B11A | On the Work With Customer Ledger Inquiry form, click Add. | Enter invoices. |
Work With Invoice Additional Information | W7003B11A | On the Work With Customer Ledger Inquiry form, select a record and click Regional Info from the Row menu. | Enter information that the system uses when you work with electronic invoices. |
Navigate to France Accounts Receivable Menu (G74F03B), PO - Localization Invoice Entry program (P7433B11).
When you launch the PO - Localization Invoice Entry program (P7433B11) from the France Accounts Receivable menu (G74F03B), you add or select a version. When a version is selected, the system displays the processing options.
The Standard Invoice Entry program (P03B11) uses these processing options when you enter an invoice.
Enter 1 to require entry of the shipping date. Leave this option blank or enter 0 to allow, but not require, the entry of the shipping date.
Enter 1 to allow the entry of related invoices for a debit or credit note. Leave this processing option blank to disallow entry of related invoices.
Enter 1 to allow the entry of multiple related invoices for a credit or debit note. Leave this processing option blank to allow the entry of only one related invoice.
Complete this processing option if you entered 1 in the Related Invoices processing option.
Enter 1 to require the entry of a related invoice. If no related invoice is entered, the system displays an error message and does not allow the user to continue until a related invoice is entered.
Leave this processing option blank to have the system display a warning message when no related invoice is entered. The warning message allows the user to continue without entering a related invoice.
Enter 1 to allow the entry of a related invoice with a different address book number from the record associated with the credit or debit note. Leave this processing option blank to have the system display an error message if the user enters a related invoice with a different address book number.
Enter 1 to allow the entry of a related invoice issued with an Issue Place different than the issue place in the credit or debit note. Leave this processing option blank to have the system display an error message if the user enters a related invoice with a different Issue Place.
Enter 1 to display an error when the user enters a duplicated related invoice. Leave this processing option blank or enter any value other than 1 to have the system display a warning if the user enters a duplicated related invoice.
This section provides an overview of the additional information that you can add, lists the forms used to add or review additional information for invoices, and discusses how to enter additional information for invoices.
Some country-specific functionalities for France require information that does not exist in the standard Accounts Receivable records. You use the Localizations Additional Fields AR Invoice Header program (P7003B11) to enter the required additional information.
The system launches this program from the Regional Info row menu option in the Customer Ledger Inquiry program (P03B2002), when your user profile is set to FR (France).
The system saves the data that you enter for customers and suppliers in the Additional Information forms to the Localizations Additional Fields Customer Ledger - 01 table (F7003B11).
Access the Work With Invoice Additional Information form.
The information that you enter in this tab is a set of numeric characters.
Enter the 10-digit project unique code. This code must be present on each electronic invoice header.
Enter the supplier's internal contract or project number.
It is mandatory to enter Project Unique Code value for entering the internal contract/project number value.
Processing options enable you to specify default processing values for programs and reports.
Select a value from the Invoice Group Code UDC table (70/IG) to specify if the system generates a single lot per invoice or if it generates a lot grouping invoices that meet specific criteria when you work with electronic invoices.
Valid values are:
1 - One lot per invoice: The system generates one XML electronic file per invoice.
2 - One lot per "Invoice To" Address Book record: The system groups the transactions for the same customer into a single XML electronic file.
3 - Invoice Range: The system groups the transactions based on the invoice range that you specify into a single XML electronic file.
Note: For France, the only valid value is 1 for electronic invoices. |
Processing options enable you to specify default processing values.
Enter 1 to process records in final mode. Leave this processing option blank to process records in proof mode.
Enter D to process records in domestic currency. Enter F to process records in foreign currency.
If you leave this processing option blank, the system processes records in domestic currency.
Leave this processing option blank to automatically launch the Print Invoice - PO program (R7430030). Enter 1 to suppress the automatic launch of this program.
Enter 1 to print the attachment that you specified when you entered the invoice. Leave this processing option blank to suppress printing of the attachment.
Enter the contact information address number or leave this processing option blank to use legal document type option instead.
This section provides an overview of the process to work with Sales Order Processing in France, lists prerequisites, and discusses how to:
Set the processing options for the PO - Localizations Sales Order Entry program (P7424210).
Enter additional information for Sales Orders.
Set the processing options for the Generic Invoice Grouping program (R7030030).
Set the processing options for the PO - Print Legal Documents from Sales Orders program (P7420565).
Run the Invoice Print program (R42565).
Before you perform the tasks in this section:
Set up your system to work with the electronic invoice functionality.
See Section 5.2, "Understanding the System Setup to Work With France Electronic Invoices,".
Set up the legal documents.
Enter additional Address Book information
Set up the legal company.
Set up the programs that process invoices.
You use standard JD Edwards EnterpriseOne Sales Order Management to work with sales orders. You use country-specific programs to generate electronic invoices of your legal documents.
To work with sales orders for France, complete these tasks:
Process | Description |
---|---|
Set processing options for the PO - Localizations Sales Order Entry program (P7424210). | You set these processing options to specify additional parameters for the Standard Sales Order Entry program (P4210). You must set up corresponding versions for P7424210 and P4210.
The system uses the additional parameters when you enter sales orders. |
Enter sales orders. | You use the Sales Order Entry program (P4210) to enter sales orders. |
Enter Additional Sales Order information. | You use the Localizations Additional Fields Sales Order Header program (P704201) to enter the required additional information. The system launches this program on selecting SO Header Browse from the Form menu.
The system includes the additional information entered when you generate electronic invoices. See Section 5.4.5.2, "Entering Invoice Additional Information,". |
Set processing options for the Generic Invoice Grouping program (R7030030). | You set these processing options to specify how the system should group the transaction records to generate the electronic XML file.
See Section 5.4.6, "Setting Processing Options for the Generic Invoice Grouping Program (R7030030),". |
Set processing options for the PO - Print Legal Documents from Sales Orders program (P7420565). | You set these processing options to specify additional parameters for the Standard Invoice Print program (R42565). You must set up corresponding versions for P7420565 and R42565.
The system uses the additional parameters to generate electronic invoices. |
Run the Print Invoices program to generate printable or electronic invoices. | You use the Print Invoices program (R42565) to:
|
Update sales. | When you run the Sales Update program (R42800) for French transactions, the system populates certain fields in the Customer Ledger table (F03B11) with values from the Legal Document Header table (F7430010).
When you run this program, the system also populates the VR01 "Reference" field with the legal document number. |
After completing these steps, submit the XML file that the system generates for the electronic invoices to the fiscal authorities (if applicable).
Note: Submitting the XML files to the fiscal authorities is a step in the process that occurs outside of the JD Edwards EnterpriseOne for the France Localizations system and processes. |
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
Work With Versions (PO - Localization Sales Order Entry (P7424210)) | W983050B | French Sales Order Processing (G74F42), PO - Localizations Sales Order Entry | Select the version for the Sales Order Entry program (P4210) and set up the applicable processing options. |
Work With Sales Order Headers | W4210H |
|
Review and select sales order header records, or access forms to add a new sales order. |
Work With Sales Order Header Additional Information | W704201A | On the Work With Sales Order Headers form, select a record and click Regional Info from the Row menu. | Enter information that the system uses when you work with electronic invoices. |
Navigate to French Sales Order Processing menu (G74F42), PO - Localization Sales Oder Entry program (P7424210).
When you launch this program, you add or select a version associated with the Sales Order Entry program (P4210). When you select a version, the system displays the processing options.
The Sales Order Entry program (P4210) uses these processing options when you enter a sales order.
Enter 1 to allow the entry of related invoices for a debit or credit note. Leave this processing option blank to disallow entry of related invoices.
Enter 1 to require the entry of a related invoice. If no related invoice is entered, the system displays an error message and does not allow the user to continue until a related invoice is entered.
Leave this processing option blank to have the system display a warning message when no related invoice is entered. The warning message allows the user to continue without entering a related invoice.
Enter 1 to allow the entry of a related invoice with a different address book number from the record associated with the credit or debit note. Leave this processing option blank to have the system display an error message if the user enters a related invoice with a different address book number.
Enter 1 to allow the entry of a related invoice issued by a different company than the company in the credit or debit note. Leave this processing option blank to have the system display an error message if the user enters a related invoice with a different company.
This section provides an overview of the additional information that you can add, lists the form used to add or review additional information for sales orders, and discusses how to enter additional information for sales orders.
Some country-specific functionalities for France require information that does not exist in the standard Sales Order Processing records. You use the Localizations Additional Fields Sales Order Header program (P704201) to enter the required additional information.
The system launches this program from the Regional Info row menu option in the Sales Order Header Browse form, when your user profile is set to FR (France).
The system saves the data that you enter for the transactions in the Additional Information forms to the Localizations Additional Fields Sales Order - 01 table (F704201).
Access the Work With Sales Order Header Additional Information form.
The information that you enter in this tab is a set of numeric characters.
Enter the 10-digit project unique code. This code must be present on each electronic invoice header.
Enter the supplier's internal contract or project number.
It is mandatory to enter Project Unique Code value for entering the internal contract/project number value.
Use these processing options to specify default values for France that the system uses when you run the Print Invoices (R42565) program to print legal documents or generate electronic invoices. The system uses the PO - Print Legal Documents from the Sales Orders program (P7420565) when you run the Invoice Print program for France.
Specify the legal document issue place.
Specify the document type that you use to identify invoices for electronic invoices. The value that you enter must exist in the Document Type (00/DT) UDC table and should be the document type that you specified for invoices in the Legal Doc. Types Relationship program (P74F0003).
The document type that you specify must be different from the document type that you specify for the dummy invoice document type in the Print Invoices program (R42565) to avoid duplication when the system assigns next numbers for the electronic invoice lot.
If the document types are different, the system uses the document type set in this processing option to determine the applicable Next Number value for the XML lot number when generating electronic invoices.
This processing option is not used for France.
Enter 1 to print in final mode. Leave this processing option blank to print in proof mode.
Enter 1 to summarize sales order lines by item. If you leave this processing option blank, the system prints all the lines in the sales order.
Leave this processing option blank to call the R7030030 program and automatically generate electronic invoices. Generally, you leave this option blank. Enter 1 to suppress the automatic process.
Enter the contact information address number or leave this processing option blank to use the legal document type option instead.
Specify the unit of measure that the system uses to print the weight of the shipment. The value that you enter must exist in the Unit of Measure (00/UM) UDC table. If you do not complete this processing option, the system uses Item as the unit of measure.
This processing option is not used for France.
This processing option is not used in France.
Specify the last status code that invoices should have attained. The value that you enter must exist in the Activity/Status Codes (40/AT) UDC table. If the invoice has not attained the status code that you specify, the system displays an error message.
If you leave this processing option blank, the system uses 931 as the last status code.
Specify the next status code to which invoices will be moved. The value that you enter must exist in the Activity/Status Codes (40/AT) UDC table. If the invoice does not move to the status code that you specify, the system displays an error message.
If you leave this processing option blank, the system uses 831 as the next status code.
Specify the last status code that shipment notes should have attained. The value that you enter must exist in the Activity/Status Codes (40/AT) UDC table. If the shipment note does not attained the status code that you specify, the system displays an error message.
If you leave this processing option blank, the system uses 932 as the last status code.
Specify the next status code to which shipment notes will be moved. The value that you enter must exist in the Activity/Status Codes (40/AT) UDC table. If the shipment note does not move to the status code that you specify, the system displays an error message.
If you leave this processing option blank, the system uses 832 as the next status code.
From the Statement Reminder Processing menu (G03B22), select Invoice Print.
If the option Generate E-Invoice is enabled in the additional information entered for the customer, the system generates an electronic XML file document.
If the option Generate E-Invoice is not enabled in the additional information entered for the customer, the system generates a standard printable PDF file document.