2.1.1.2.2 Bulk Invoice File Template(Link Purchase Order to Invoice)

This topic provides systematic instructions to upload Bulk invoices.

Create Invoice with Purchase Order format - Allows user to upload invoice records in bulk along with the commodity records and allows linkage of Purchase Order.

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 purchase order to be linked to the invoice, there must be a row with indicator ‘P’, which specifies the purchase order level parameters. For each commodity under the invoice, there must be a row with indicator ‘C’, which specifies the commodity-level parameters. Refer this file for the sequence: Bulk Invoice Upload Template Bulk Invoice File Template(Link Purchase Order to Invoice).

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-14 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.
Buyer Code	Specify the code associated with the buyer.
Supplier Code	Specify the code associated with the supplier
Buyer Division Code	Specify the division code of the buyer.
Supplier Division Code	Specify the division code of the supplier.
Tax ID	Specify the unique tax ID if shipment charge includes tax amount.
Payment Terms	Specify the agreed payment terms.
Terms of Sale (Incoterms)	Specify the applicable 3-digit Incoterms code. The available values are: EXW | Ex Works FAS | Free Alongside Ship FCA | Free Carrier FOB | Free On Board CPT | Carriage Paid To CFR | Cost and Freight CIP | Carriage and Insurance Paid To CIF | Cost Insurance and Freight DAP | Delivered at Place DPU | Delivered at Place Unloaded DDP | Delivered Duty Paid
Reason for Export	Specify the relevant reason of export.
Shipment Number	Specify the shipment number.
Shipment Date	Specify the date of shipment.
Shipment Address	Specify the the address to ship the goods to.
Shipment City	Specify the city to ship the goods to.
Shipment Country	Select the country to ship the goods to.
Zip Code	Specify the zip code to ship the goods to.
Country of Origin	Specify the country from where the shipment will originate.
Phone Number	Specify the contact number of the person who will receive the shipment.
Virtual A/c Flag*	Specify Y if the repayment is to be made to a virtual account number, and N if the repayment is to be made to a physical account number.
Payment Account number**	Specify the account number to which the payment is to be made. This field is mandatory if the Virtual A/c Flag is set to Y.
Bank_Name_For_P AN	Specify the name of the bank. Where the account number mentioned in Payment Account Number. PAN refers to Payment Account Number.
Branch_Name_For_P AN	Specify the the Branch code of the PAN..
Bank_Code For PAN	Specify the IFSC code here if the payment mode is EFT (mentioned in Payment mode for PAN field) else enter Swift code if payment mode is CBT.
Remarks	Specify any remarks, if applicable.
Filler Fields 1 to 4	This section displays the Filler Label Fields. The bank can configure these fields on Day 0, based on their requirement.
ACCOUNT_NAME_FOR_ PAN	Specify the the account name of the Payment Account Number.
Payment_Mode_For_PA N	Specify the payment mode whether it is an internal account transfer or EFT or Cross border transfer. For internal account transfer, domestic account, or cross border account respectively. Acceptable values are AC/EFT/CBT.
Bene_Addr1_for_PAN	Specify the beneficiary's address line1 for Payment Account Number. Applicable only for CBT.
Bene_Addr2_for_PAN	Specify the beneficiary's address line 2 for Payment Account Number.
Bene_Addr3_for_PAN	Specify the beneficiary's address line 3 for Payment Account Number.
Bene_Addr4_for_PAN	Specify the beneficiary's address line 4 for Payment Account Number.
Bene_cntry_for_PAN	Specify the beneficiary's country for Payment Account Number.
Bene_Phone_for_PAN	Specify the beneficiary's phone for Payment Account Number.
Bene_Email_for_PAN	Specify the beneficiary's Email ID for Payment Account Number.
Intermediary_Bank_Cod e_For_PAN	Specify the Intermediary bank swift code here if Payment Credit Mode is CBT.
Intermediary_Bank_Nam e_For_PAN	Specify the Intermediary bank name.
Intermediary_Bank_Add r1_For_PAN	Specify the Intermediary bank Address.
Intermediary_Bank_Add r2_For_PAN	Specify the Intermediary bank Address.
Intermediary_Bank_Add r3_For_PAN	Specify the Intermediary Bank Address.
Intermediary_Bank_Add r4_For_PAN	Specify the Intermediary Bank Address.
Disbursement_Credt_Ac count	Specify the an account number to receive the finance disbursement proceeds when the invoice is financed. It can be a CASA or a GL account. If it’s an account with any other bank in the country or if the account is in some another country even through the number should be mentioned in the same field. Disbursement credit account will be hereafter referred as DCA.
Account Name for DCA	Specify the account name for the entered DCA.
Payment_Mode_For_DC A	Specify the payment mode whether it is an internal account transfer or EFT or Cross Border Transfer. Acceptable values are AC/EFT/CBT. For internal account transfer, domestic account, or cross border account respectively.
Bene_Addr1_for_DCA	Specify the beneficiary's address line 1 for Disbursement Credit Account. Applicable only for CBT.
Bene_Addr2_for_DCA	Specify the beneficiary's address line 2 for Disbursement Credit Account.
Bene_Addr3_for_DCA	Specify the beneficiary's address line 3 for Disbursement Credit Account.
Bene_Addr4_for_DCA	Specify the beneficiary's address line 4 for Disbursement Credit Account.
Bene_cntry_for_DCA	Specify the beneficiary's country for Disbursement Credit Account.
Bene_Phone_for_DCA	Specify the beneficiary's phone number for Disbursement Credit Account.
Bene_Email_for_DCA	Specify the beneficiary's Email ID for Disbursement Credit Account.
Bene_Name_for_DCA	Specify the name of the bank.
Branch_Name_for_DCA	Specify the Branch code of the DCA.
Bank _Code _For_DCA	Specify thethe IFSC code here if Payment Credit Mode if EFT and can enter the swift BIC if the Payment credit mode is CBT.
Intermediary_Bank_Cod e_For_DCA	Specify the Intermediary bank swift code here if Payment Credit Mode is CBT.
Intermediary_Bank_Nam e_For_DCA	Specify the Intermediary Bank Name.
Intermediary_Bank_Add r1_For_DCA	Specify the Intermediary Bank Address.
Intermediary_Bank_Add r2_For_DCA	Specify the Intermediary Bank Address.
Intermediary_Bank_Add r3_For_DCA	Specify the Intermediary Bank Address.
Intermediary_Bank_Add r4_For_DCA	Specify the Intermediary Bank Address.