Question
Please submit the solutions to the following tasks in the same sequence as they appear on the test through the Assignment Link. For this part
Please submit the solutions to the following tasks in the same sequence as they appear on the test through the Assignment Link. For this part of the test you will need the AP_Trans (Accounts_Payable Folder) Table from the ACL's Sample Project. 1. Open the AP Trans Table, filter for invoice amount greater than 100 and Quantity greater than 10. How many records do you get after filtering? Now stratify the Table on the Invoice Amount field. Include the graph in your analysis and comment on the result. (5 Points) For this part of the test you will need the ar (Accounts Receivables) and customer (Customer Master) Tables that were used for the class work and assignment #1. Both Tables are located in the Sample project. Payment from customer (Type PM) in ar should be presented by negative Transaction amount values, while the other transaction types are either positive or negative depending on the Type. 2. Open the ar Table and use the Edit View Filter to create a filter that screens for Customer Payments greater than or equal to $1,000. Print a report of the result with customer names, total payment amount and comment. (3 Points) 3. Identify any credit policy violations. Policies include the following: o Individual sales transactions (Type IN) must be $3,500.00 or less. How many violations did you find and whats the total invoice amount at stake? o Individual Customer Balances may not exceed a total of more than $40,000 (Hint: For this you will need to summarize on Cust No, accumulate Trans Amount, and output to an ACL Table instead of Screen). (5 Points) Do these results identify any problems? What actions might be taken to prevent the problems in the future? Write your comments. (2 Points) For this part of the test you will need the Payroll (Payroll Transactions) and the Empmast (Employee Master) Tables from the ACL's Sample Project. 4. Open the Payroll (Payroll Trans Table). (i) Do a Duplicate Check on the Payroll to list any duplicate payments. (ii) Using the Join feature create a view of data from both Payroll (Primary) and Empmast (Secondary) Tables that tests for exceptions. (Choose fields Employee #, Gross-Pay from the Payroll Table and Employee#, First Name, WorkDept, and Pay-per-period from the Empmast Table). (4 Points) Create a 'Remarks' Column in the joined table using Expressions to automatically highlight at least three types of exceptions (e.g.: Ghost Employees, Employees over/under-paid, Valid Employees not paid). (4 Points) Do these results identify any potential fraud? Which ones, and why? What are some reasonable explanations, if any? (2 Points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started