File Upload and AP Report Instructions Upload Data
General Info / Sample Reports Abacus AccountEdge Accpac Adagio Agresso Bellamy Blackbaud Colleague (by Ellucian) Comvida FMS Distrib-u-tec Dynamics (see Great Plains or Sparkrock) Epicor/Eclipse Explorer Great Plains JD Edwards MAIS aka Progress aka Concord Masterworks Munisoft Muniware MYOB (Mind Your Own Business) Navision Netsuite by Oracle Oracle Financials Ormed Pacific Rim PeopleSoft PowerSchool/SRB/TSC/atrieveERP ProfitMaster Canada / Acceco / Transaxion Prosoft Gemini Quickbooks Sage SAP SDS (School District Software) Simply Accounting Sparkrock / MS Dynamics Steel Plus by Bayern Syteline Timberline Vadim Xero

Oracle Financials

Accounts Payable Journal Entry Audit Report

This report is similar to the report which typically gets printed when you submit the Payables Transfer to General Ledger program.

Having run a report you can view its output. From the output-viewing screen the menu option Tools > Copy File can be chosen. This will open up the output in your default web browser from where you can choose File > Save As and then choose to save the file as a text file on the local machine.

If this report isn't available, we have worked with files created from worksheets in Discoverer before. These were:

  • AP TRADE
  • AR GST

Display the worksheet that you want to export.

Choose File | Export.

The Export dialog box appears. The following 3 export options are typically our preferred options and have no limit on lines:

Text (Tab delimited) (*.txt)
CSV (Comma delimited) (*.csv)
Formatted Text (Space delimited (*.prn)

Alternatively
We have also successfully received a report called InvoiceRegister. This report comes in Excel format.

In addition to this report we need a Chart of Accounts.