


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
The procedure for generating an account analysis report in the ufs system, specifically the transaction detail (ufs) - excel version. The report provides detailed information about individual transactions from modules such as accounts payable and accounts receivable, and is suitable for exporting to excel for further analysis.
Typology: Lecture notes
1 / 4
This page cannot be seen from the preview
Don't miss anything!



Versions available
Full Field Transaction Detail 1 (CAPSA) Transaction Detail 3 (CAPSA) Transaction Detail (UFS) – Excel Version Good for information about the source of the transaction Good all round report especially for information on transactions from AP Report limits data for each transaction to a single line, to assist with downloading into Excel and subsequent sorting etc. Directly exports in to Excel, enabling the data to be interpreted and manipulated
Source of transaction (eg Payables, Receivables)
Category (e.g. Purchase invoice, Journal)
Batch name
Full Field Transaction Detail 1 (CAPSA) Transaction Detail 3 (CAPSA) Transaction Detail (UFS) – Excel Version Journal name Posted Date Flexfield Flexfield Description Description of transaction always the journal line description as held in the General Ledger
Reference 1 Display depends on the category of the transaction (Eg. AP Invoices/AR invoices/AR Misc. receipts)
supplier/customer name
supplier/customer name
Supplier/customer/comments
Reference 2 Display depends on the category of the transaction (Eg. AP Invoices/AR invoices/AR Misc. receipts)
Supplier’s invoice number/ AR invoice number/paid from
Supplier invoice number/ AR sales invoice/paid from PO Number if matched Debit column Credit column Amount column Suitable for exporting to Excel Automatically outputs to Excel