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

AGRESSO

In Agresso, we have been successful in running a General Ledger transaction enquiry and adding some custom fields.

By default the following fields are included, we can limit the TT to AP unless you have other types (Credit Card, Automatic Payments etc, possibly BA and BE and BF types your system may vary)

TT
TransNo
Trans.date
Period
Account
TC
Text 
Amount

We'd then like to see some additional fields added to give us supplier and tax information, for example:

Supplier #
Supplier #(T)
InvoiceNo
Account(T)
CostC
CostC(T)
Project
TC(T)

Your system may have some different named fields.

Older Instructions:

In Agresso, we have been successful in working with a report that generates a text file, with comma separated fields with the following data:

Fields:

Vendor_Name
Vendor_ID
Transaction_Date
Transaction_ID
Invoice_Type
Invoice_Number
Sequence_No: Sequence Number
Invoice_Date
Period
Account
dim_1 and dim_2: these two fields seemed to me like the Cost Centre according to the content of the fields.
TAX_CODE
Description
Amount
VendorType

Invoice Types:

AP: Supplier Invoices
BA: Batch AP Invoices
BC: Batch AP Payroll Contractors
BE: Batch AP Expenses
BF: Batch AP Foreign Invoices
BG: Batch AP PO Expenses
BJ: Batch AP PO Foreign Invoices
BP: Batch AP PO Invoices
BX: Batch AP Student Expenses
IP: Payment Transactions
MP: Manual Matching of AP Open Items
OP: AP PO Invoice Posting
PN: Register AP Invoices
SR: Speedy Registration of Invoices

Your system may have some different fields.