This report was a request from Accounts Payable. They wanted to be able to quickly reconcile vendor payments against a vendor’s weekly or monthly statement. The report needed to run lean and have parameters for a user to specify which vendor they are seeking to reconcile. Of course, another requirement was it had to be built within the current accounting system.
Data Format: Excel (when exported)
Platform: Oracle Fusion
Requirement/s: Vendor Name, Invoice Number, Payment Method, Payment Amount, Invoice Date, Invoice Amount (additional requirements may be asked by user)
Language: SQL (to extract data)
Project Description: Create a data model utilizing SQL within Oracle Fusion and create a report that will pull the data within the fields specified in the requirements. The report format and data model will be maintained and updated as needed.