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.