Load bulk invoice data from an Excel template into the Accounts Payable Operations invoice import staging table sn_spend_intg_imp_invoice.
Before you begin
Role required: admin
Procedure
-
Navigate to .
The Load Data page appears.
-
In Import set table, choose Existing table option.
-
Choose the invoice table from the drop-down list.
-
In Source of the Import, choose File.
-
Browse the excel template that was created from Import data into invoice.
-
Enter the Sheet number of the excel template that needs to be loaded into the staging table.
-
Enter the Header row of the excel template that needs to be loaded into the staging table.
-
Click Submit.
Result
The invoice data from the excel template is processed successfully.