This program creates invoices for your procurement card issuers in the Payables Open Interface tables. This program selects all records for a given date range in AP_EXPENSE_FEED_DISTS with a status of at least Validated. The program will not select any statuses that you have specifically excluded from payment in the Card Programs window. Also, the program will not select any records that have been previously selected by the program. If you choose to summarize the transactions, the system will create a single invoice for each unique combination of GL Account and Tax Code. In addition, if you summarize the transactions, the report will display only the Line, Account, and Amount.
After this program creates invoices in the Payables Open Interface tables, they can be imported into Payables for approval and payment using the Payables Open Interface Import program. When you run Payables Open Interface Import, enter Procurement Cards in the Source parameter.
You submit the Create Procurement Card Issuer Invoice program from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Employees and managers have completed any verification or approval of the transactions that your organization requires. See: AP Procurement Card Employee Verification Workflow and AP Procurement Card Manager Approval Transaction Workflow.
Card program administrators or profile administrators make any necessary adjustments to procurement card transaction distributions in the Procurement Card Transactions window. See: Procurement Card Transactions Window.
Card Program. If you want to limit the import to a single card program, enter the card program name.
Transaction Start Date and Transaction End Date. If you want to limit transfer to transactions within a particular posted date range, enter the date range in these fields.
Roll Up Transaction by Account. Enter Yes if you want to create one record in AP_INVOICE_LINES_INTERFACE for each code combination ID. Enter No if you want to create one record in AP_INVOICE_LINES_INTERFACE for each record in AP_EXPENSE_FEED_DISTS. If you summarize the records, the report will not display the following Headings: Transaction Date, Employee, Card Number, and Merchant Name.
Invoice Number. Payables concatenates the unique identifier with the invoice date.
Invoice Amount. Total invoice amount.
Invoice Currency. Currency of the invoice.
Card Issuer. Name of supplier that issued the procurement card. The invoice is created for this supplier.
Payment Site. Supplier payment site.
Line. Transaction line number.
Employee. Employee in your organization who is the procurement card holder for the transaction.
Card Number. Card number to which the transaction was charged.
Merchant Name. Merchant that recorded the transaction.
Account. GL account to which you will charge the transaction amount. This account was built by the Procurement Card Transactions Validation program.
Amount. Amount of the transaction.
Invoice Line Count. Total number of transaction lines for the invoice.