PracticeISCFree practice exam

ISC · Information Systems and Data Management · 6 practice questions

AP-to-GL Batch Recovery: Fix, Reprocess, and Reconcile

When mapping errors block AP postings, correct the mapping and reprocess only failed transactions before reconciling. Below: a partially posted batch shows why replaying the full amount overstates AP.

The ruleWhen a mapping failure prevents AP transactions from posting, correct the mapping, reprocess failed transactions without duplicating successful postings, and reconcile the AP control account to the subledger.

Try one first

A mid-size company uses an ERP with separate Sales Order and General Ledger modules. Each night the Sales Order system sends a summarized batch file of that day's invoices to the GL. Over the last two months, several overnight interface jobs have failed unnoticed; IT occasionally manually resends batches, but there is no automated alert, no automated comparison of batch control totals, and finance often discovers missing or duplicate postings only at month-end when reconciling subsidiary AR to the GL. Management asks which immediate control change is required to reduce the risk of incomplete or inaccurate revenue and AR balances. Which response is most appropriate?
Hint

Focus on controls that directly address nightly interface failures and that promptly detect or prevent missing or duplicate transactions before the GL is updated.

Step by step

  1. Establish what actually posted

    MidCo has no opening AP balance, and its source batch contains 100 invoices totaling $100,000. The job reports completion, but only 20 invoices totaling $20,000 posted successfully; mapping errors blocked the remaining 80 invoices totaling $80,000.

  2. Compare source and target

    Compare the source batch of 100 invoices and $100,000 with the initial GL results of 20 invoices and $20,000. The missing postings are 80 invoices totaling $80,000.

  3. Identify the failed transactions

    Use the processing results to identify the 80 failed invoices and distinguish them from the 20 successful postings. A job-completion message alone does not establish posting completeness.

  4. Correct the mapping

    Correct the identified mapping error through approved change procedures before reprocessing.

  5. Reprocess only failed invoices

    Reprocess only the 80 failed invoices totaling $80,000. Exclude the 20 invoices totaling $20,000 that already posted successfully.

  6. Reconcile the recovered balance

    The recovered AP control account balance is $20,000 + $80,000 = $100,000, matching the AP subledger. Confirm that all 100 invoices posted once and that no failures remain.

  7. Reject the full-batch manual credit

    A manual AP credit for the full $100,000 would produce $20,000 + $100,000 = $120,000. That overstates the correct $100,000 AP balance by $20,000 and leaves the failed interface unresolved.

Key points

  • Remember: Recover the missing postings, not the full batch, because some invoices may already be in the GL.
  • A completed job does not prove that every invoice posted successfully.
  • Matching balances must be supported by the correct invoice postings, not just a manual adjustment.

How the exam traps you

  • Manually credit AP for the full $100,000 source batch without checking which invoices already posted. Identify the $20,000 already posted, correct the mapping, and reprocess only the failed $80,000; then reconcile.
  • Rerun all 100 invoices without excluding successful postings. Reprocess only the 80 failed invoices to avoid duplicating the $20,000 already posted.
  • Wait for the next scheduled run despite a known mapping error. Correct the identified mapping error before reprocessing; another run does not fix the configuration.

5 more, each from a different angle

0 of 5 answered · 0 correct

Question 2

A manufacturer replaced separate purchasing, receiving, and accounts payable applications with a single ERP. Assume no compensating controls exist beyond those described. Approved purchase orders are immediately available across modules. Warehouse staff enter goods receipts. Vendor invoices that match purchase order price and recorded receipt quantity auto-post to accounts payable and the general ledger. For 48 hours after entry, warehouse supervisors may edit receipt quantities to correct dock-count errors. If a receipt quantity is edited after an invoice has auto-posted, the ERP updates inventory quantities only; it does not reopen or adjust the posted accounts payable transaction. The system stores the user ID and timestamp of the edit, but not the original receipt quantity. What is the primary issue with this AIS design?
Hint

Focus on which data element the automated three-way match relies on after posting, and ask what happens if that element can later be changed.

Question 3

A parent company uses an ERP in which customer aging, collection workflows, and automated credit holds are driven from the accounts receivable (A/R) subledger, while the general ledger (GL) receives balances from that subledger. After acquiring a subsidiary, management wants to keep the subsidiary's billing on a legacy system but still use the parent ERP for consolidated aging and customer credit-limit decisions. IT proposes either: (1) sending one summarized daily journal entry to the ERP GL for total A/R and revenue, or (2) sending transaction-level invoice and cash-application data that creates and updates customer open items in the ERP A/R subledger. Assume account mapping, customer cross-references, and posting timing can all be configured accurately under either approach. Which factor most directly governs whether the parent can rely on the ERP's aging and credit-hold workflows for the combined business?
Hint

Focus on which part of the system actually powers aging and credit holds: the control-account balance in the GL or the customer-level open-item records.

Question 4

In Year 1, Nova Co. implemented an integrated ERP in which supplier invoices recorded in the Accounts Payable (AP) subledger are posted to the General Ledger (GL) via an automated vendor‑class → GL‑account mapping table created during conversion. After go‑live, GL expense accounts were understated and a 'suspense/unassigned' GL account contained many invoice amounts. Investigation showed several vendor records had a blank or 'unassigned' vendor class after conversion; because the mapping table lacked a valid mapping for that class, the AP interface coded those invoice lines to the suspense account rather than to the correct expense accounts. Nova still allows users to post manual journal entries directly to the GL, and reconciles subledger to GL monthly. Which single remediation or control change would most effectively prevent recurrence of these kinds of mispostings?
Hint

Determine whether the discrepancy is because incorrect postings are getting into the GL (prevention needed) or because they aren’t being found quickly enough (detection needed).

Question 5

Starlight Manufacturing uses an ERP that receives a nightly batch of scanned vendor invoices from a third‑party imaging service. The imaging service changed the vendor ID format; to restore overnight processing, an operations analyst edited the live interface mapping in production and then continued to run daily payment batches. The analyst is responsible for vendor master and mapping changes and also executes vendor payments. There was no formal change request, no testing, and no supervisory approval; no automated exception report alerted management. For several days after the edit, some invoices failed to post and suppliers reported missing payments, causing an understatement of accounts payable and expenses until reconciliations discovered the problem. What is the primary internal-control issue that allowed this problem to occur?
Hint

Who implemented the change and what other duties did they have? Determine whether the problem is a failure to prevent an unauthorized change or a failure to detect it afterward.

Question 6

A distributor uses an integrated ERP in which billing and cash application normally update both the accounts receivable (AR) subledger and the AR control account automatically. To keep the general ledger "current" when lockbox cash is received before remittance details are fully researched, the assistant controller has been posting manual journal entries directly to the AR control account. The company already performs daily AR-subledger-to-GL reconciliations and reviews an exception report of all direct postings, yet customer-level balances used by collections often do not agree with the GL until later subledger processing. Assume the ERP can restrict posting paths and supports unapplied cash or suspense accounts. Which action is best?
Hint

Focus on which choice preserves the control-account-to-subledger linkage while still allowing timely recording when customer-level detail is incomplete.

Drill all 170 Enterprise and accounting information systems questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

How do you fix a partially posted AP-to-GL batch?

Identify successful and failed postings, correct the mapping through approved procedures, and reprocess only the failures. Then reconcile the AP control account to the subledger.

Should I manually post the full AP batch to the GL?

No. Here, a $100,000 manual credit added to the $20,000 already posted would produce $120,000 of AP, overstating the correct balance by $20,000.

How do I confirm an AP-to-GL reprocessing job worked?

Verify that the 80 failed invoices totaling $80,000 posted without duplicating the 20 successful invoices. The GL should contain all 100 invoices and reconcile to the $100,000 AP subledger balance.

Watch it solved

A full CPA ISC task-based simulation on Enterprise and accounting information systems, worked step by step.

ISC Simulation: Mapping Controls Through Order-to-Cash on YouTube

Practice ISC like the real exam

The free ChatCPA simulator: real exam layout, timed testlets, starting with a question on this topic. No account needed to start.

Open the free simulator →

More on Enterprise and accounting information systems

All Enterprise and accounting information systems practice →

Questions from the ChatCPA bank of 17,658 CPA exam questions, each with a written reason for every wrong answer. ChatCPA is built by Nicholas Miller, CPA (Oregon #14907). How these pages are made. Spot an error? Tell us.