Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i cant figure out the formula to use to extract in IDEA. Anyone familiar with IDEA software? 7. Assume that you asked the client for

i cant figure out the formula to use to extract in IDEA.
Anyone familiar with IDEA software? image text in transcribed
7. Assume that you asked the client for a control total, per the company's accounting records, of the open sales invoices as of March 31, 2020. As indicated below, the client's control total does not equal the control total you calculated in step 4 above. Control Total Calculated per Client Control Total GROSS AMT 406,223.25 472,897.35 Scan the Sales Invoice Data file to determine why the control totals differ. Use Direct Extraction to resolve this issue. Name the extracted file Sales Invoice Data - Reconciled. Print a hardcopy of the Field Statistics report for GROSSAMT only or print the report to a pdf file named Sales Invoice Data - Reconciled - Field Statistics. Expand and print a hardcopy of the Record Extraction portion of the History Log or print the portion of the History Log to a pdf file named Sales Invoice Data - Reconciled - Record Extraction 7. Assume that you asked the client for a control total, per the company's accounting records, of the open sales invoices as of March 31, 2020. As indicated below, the client's control total does not equal the control total you calculated in step 4 above. Control Total Calculated per Client Control Total GROSS AMT 406,223.25 472,897.35 Scan the Sales Invoice Data file to determine why the control totals differ. Use Direct Extraction to resolve this issue. Name the extracted file Sales Invoice Data - Reconciled. Print a hardcopy of the Field Statistics report for GROSSAMT only or print the report to a pdf file named Sales Invoice Data - Reconciled - Field Statistics. Expand and print a hardcopy of the Record Extraction portion of the History Log or print the portion of the History Log to a pdf file named Sales Invoice Data - Reconciled - Record Extraction

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

This Mom Sells Real Estate Got Referrals

Authors: Be Mi Real Estate Store

1st Edition

B0BW2S2WXS

More Books

Students also viewed these Finance questions

Question

What are six characteristics of effective teams? [LO-1]

Answered: 1 week ago

Question

What steps would you take to make a meeting more productive? [LO-3]

Answered: 1 week ago

Question

What are the skills you need to be an effective listener? [LO-4]

Answered: 1 week ago