2.1.1.2.1 Bulk Invoice File Template

This topic provides systematic instructions to upload bulk invoices.

Create Invoices Format – Allows user to upload invoice records in bulk along with the commodity records. This format does not support the user to link purchase order to invoices. To link purchase orders to invoices, refer Bulk Invoice File Template (Link Purchase Order to Invoice).

The file to be uploaded should have data in a specific sequence. For each invoice, there must be a top row with indicator ‘I’, which specifies invoice-level parameters. For each commodity under the invoice, there must be a row with indicator ‘C’, which specifies the commodity-levelparameters. Refer this file for the sequence: Bulk Invoice File Template

Note:

While uploading a .XLSX / .XLS file, if you do not have the required data for a particular cell, and need to leave it blank, then ensure that the particular empty cell has been formatted to the data type of the expected data of that cell. For example, a cell that is supposed to hold textual content, such as name or description, should be formatted to 'Text'. Similarly, a cell that is supposed to hold a number, should be formatted to 'Number'.

Table 2-13 Field Description

Field Name	Description
Invoice Record Details	The following fields are specific to the invoice as a whole. This row must be present for each invoice being added.
Indicator	Specify the indicator. Enter ‘I’ for an invoice row.
Customer Invoice Number	Specify the customer’s own invoice number.
Invoice Date	Specify the date of creation of the invoice. This should not be a future date.
Invoice Due Date	Specify the date when the invoice payment is due. This should be greater than the invoice date.
Currency	Specify the currency of the invoice amount.
Gross Invoice Amount	Specify the total invoice amount.
Buyer Id	Specify the ID associated with the buyer.
Supplier Id	Specify the ID associated with the supplier.
Buyer Name	Specify the name of the buyer.
Supplier Name	Specify the name of the supplier.
Program Code	Specify the program code associated with the invoice. This field is applicable only if the Oracle Banking Supply Chain Finance application is implemented by the bank.
Discount Amount	Specify the total discount amount applicable for all commodities being purchased.
Tax Amount	Specify the total tax amount applicable, on all commodities being purchased.
Net Invoice Amount	Specify the net invoice amount. Net Invoice Amount = Gross Invoice Amount – Discount Amount + Tax Amount
Acceptance Amount	Specify the invoice amount that has been accepted.
Purchase Order Number	Specify the reference number of the purchase order corresponding to the invoice.
Funding Request Date	Specify the date when the invoice should be funded. This field is applicable only if the Oracle Banking Supply Chain Finance application is implemented by the bank.
Commodity Record Details	The following fields are specific to a commodity. You must add a row for each commodity being purchased, under the respective invoice row.
Indicator	Specify the indicator. Enter C for a row at the commodity level.
Customer Invoice Number	Specify the customer’s own invoice number.
Commodity Code	Specify the code associated with the commodity.
Commodity Name	Specify the name of the commodity.
Quantity	Specify the quantity of the commodity.
Cost Per Unit	Specify the cost per unit of the commodity.
Gross Amount	Specify the total cost of the commodity. Gross Amount = Cost Per Unit * Quantity
Discount Amount	Specify the discount amount applicable to the commodity.
Tax Amount	Specify the tax amount applicable to the commodity.
Net Amount	Specify the net amount of the commodity. Net Amount = Gross Amount – Discount Amount + Tax Amount

1. Select the file identifier, select the file to be uploaded, and click Upload.
2. For more information on the procedure of uploading the file, refer User Manual Oracle Banking Digital Experience Corporate Bulk File Upload – Supply Chain Finance.

The invoices are uploaded.