6 E-Invoicing
E-Invoicing is the electronic exchange of financial documents between a business and a government agency, a business to another business, or a business to a consumer. Invoice Matching uses a configurable approach to identifying documents to be extracted for E-invoicing. The configurable approach allows the user to identify documents by country or by country/set of books combination and map transaction types to be included in the extract for integration with third-party solutions which manage local tax reporting.
The E-Invoicing functionality is an optional batch process and can be configured at a country or country set of books level, and is only applied to specific documents. Therefore, you can configure the system to only extract specific documents created for specific countries. The list of document types eligible for E-Invoicing is listed below.
The batch job extracts documents from Invoice Matching Cloud Service and passes them to the Financial Document Generation (FDG) system in Merchandise Foundation Cloud Service. See the Oracle Retail Invoice Matching Operations Guide for additional details on the batch job.
Setting up Configuration Data to Identify Documents for E-Invoicing
The configuration data for creating and maintaining a document sequence is entered via the Data Upload / Data Download process in the Merchandise system.
Perform the following procedure to initially create the configuration for E-Invoicing:
-
Download the E-Invoicing Configuration (this creates an empty spreadsheet).
-
Populate the spreadsheet to identify documents to be extracted for E-Invoicing.
-
Upload the E-Invoicing Configuration.
Detailed steps:
-
Download the E-Invoicing Configuration.
-
Log in to the Merchandise system.
-
Navigation: Foundation Data > Download Foundation Data
-
Select Template Type: Finance Administration
-
Select Template: E-Invoice Mapping
-
Click the Download button
-
-
Populate the E-invoices worksheet on the spreadsheet. The table below shows the columns on the worksheet, and provides information on the usage.
-
Upload the E-Invoicing Configuration:
-
Log in to the Merchandise system.
-
Navigation: Foundation Data > Upload Foundation Data
-
Select Template Type: Finance Administration
-
Select Template: E-Invoice Mapping
-
Select: Choose File and browse to the spreadsheet to be uploaded.
-
Click the Upload button.
Table 6-1 E-Invoices Worksheet Columns
Columns Field Type Mandatory Comments Worksheet: E-Invoices
Country Id
Free Text
Yes
The Country ID associated with the documents to be extracted. The country of the location on the document will be one of the criteria to determine if the document should be included in the extract.
Set of Books
Free Text
No
The Set of Books associated with the documents to be extracted. This optional field allows an organization to specify that only documents for a particular set of books for a particular country should be extracted.
Receiving Authority
Drop Down
No
Receiving Authority is an optional field which is passed with the extracted document to identify the 3rd party who should be receiving the document
The values available to be used for the Receiving Authority are stored in a codes table in the Merchandise system:
Code Type - IMRA -
Trusted Third Party
Transaction Type
Drop Down
Yes
The transaction type identifies the types of documents to be included in the extract.
The values available to be used for the transaction types are stored in a codes table in the Merchandise system:
Code Type - IMTT -
-
MRCHCI - Consignment Invoice
-
MRCHEI - ERS Invoice
-
DEBMBB - Bill Back Deal (Fixed or Complex deal)
-
MRCHI - Other Merchandise Invoice *
-
NMRCHI - Non-merchandise Invoice
-
DEBMEC - Debit Memo Cost
-
DEBMEQ - Debit Memo Quantity
-
DEBMET - Debit Memo Tax
-
CRDMEC - Credit Memo Cost
-
CRDMEQ - Credit Memo Quantity
-
CRDNT - Credit Note
-
CRDNRC - Credit Note Request Cost
-
CRDNRQ - Credit Note Request Quantity
-
CRDNRT - Credit Note Request Tax
The values shown are the only value values for Transaction Type, user cannot create additional values.
Extract Point
Drop Down
Yes
The extract point determines when a document will be extracted for E-invoicing. Creation means at the time when the document was first saved in Ready to Match, Tax Discrepant, or Approved status. Posted means at the time the document is sent to the financial system.
The values available to be used for the Extract Point are stored in a codes table in the Merchandise system:
Code Type - IMEP -
-
Creation
-
Posting
Creation and Posting are the only valid values for Extract Point.
Retailer Issued Document
Drop Down
Yes
Indicates whether the document type is issued by either the ‘Retailer’ or the “Vendor’. See below for additional details on this indicator.
Approval Required
Drop Down
Yes
Indicates whether this document type must be approved by the Fiscal Authority before posting to the financial system.
-
Retailer Issued Document vs. Vendor Issued Documents
There are legal requirements in some countries to associate a Fiscal ID to invoices. When a document type is flagged as ‘Retailer Issued’, the retailer is responsible for sending the document to a government agency which will assign a fiscal ID to the document and send it back. Invoice Matching integrates with the Financial Document Generation (FDG) system in MFCS to facilitate this process. For document types flagged as ‘Retailer Issued’, the Fiscal ID is not allowed to be entered through the UI, EDI or Induction processes. Instead, the only way to get the Fiscal ID for Retailer Issued documents is through the Integration with FDG and the government agency describe above.
For Vendor Issued document types, if a Fiscal ID is required the Vendor is expected to provide it with the Invoice, and it could be entered via the UI, EDI, or Induction. The Vendor has the responsibility to provide the Fiscal ID, and retailer only needs to keep the Fiscal ID with the document.