Infor FSM: Run the Outstanding Check Listing Report
infor fsm outstanding check listing report
Also searched as
- infor lawson outstanding checks report
- infor fsm uncleared checks report
- infor fsm bank reconciliation outstanding checks
Short answer
In Infor Financials and Supply Management, outstanding checks are payments issued from Accounts Payable that the bank has not yet cleared in Cash Ledger. You run the outstanding check listing from the Cash Ledger (bank reconciliation) reporting area, filtered by bank code and as-of date. Report and menu names vary by version and configuration.
Applies to: Infor FSM / Lawson S3 Financials (Accounts Payable and Cash Ledger), on-prem and cloud. Confirm the program names with your administrator.
How to run an outstanding check listing
- 1Sign in to the portal and open the Cash Ledger (bank reconciliation) menu, or the Accounts Payable inquiry area, depending on how your site exposes the report.
- 2Locate the outstanding check or uncleared payments report; if you cannot find it, ask your administrator which job or inquiry your company uses.
- 3Enter the company and bank code. Run it per bank account so totals can be compared with the statement.
- 4Set the as-of date to the statement date, not today, so late-clearing items fall on the right side.
- 5Choose the output (print or file) and run the job; check the job log for errors if the output is empty.
- 6Compare the total with the difference between the book balance and the bank statement balance.
- 7Investigate stale items, voids and stop payments that should no longer be outstanding.
- 8Keep the dated report with the reconciliation for audit.
Where outstanding checks come from
When Accounts Payable issues a check, the payment posts to cash and appears in Cash Ledger as an item awaiting reconciliation. It stays outstanding until a bank statement line or a manual match clears it.
Voids, reissues and stop payments change that status. A voided check should drop off the listing, which is why a void in the wrong period is a classic cause of mismatch.
Why the listing might not match the bank
Timing is the main reason: checks cleared by the bank after the statement date but already matched in the system, or the as-of date set to today. Next are manual cash entries outside Accounts Payable, bank fees and electronic payments handled in a different bank code.
Multi-company setups add another trap: running the report for the wrong company or bank code hides items that belong on another account.
Reporting outside the standard report
If the standard output is too rigid, many sites build a custom query or use their reporting tool against the Cash Ledger and payment data. Build it read-only and test it against the standard listing before trusting it.
Document the logic and review it after upgrades, since table and field definitions can change between versions.
Try it here, free
Days Inventory Outstanding Calculator
Enter average inventory and annual cost of goods sold to get DIO, turns and the cash locked up above a target.
Common pitfalls
- !Running the report with today's date instead of the bank statement date.
- !Ignoring old outstanding checks that should be escheated or reissued according to policy.
- !Mixing bank codes and reconciling totals across accounts.
- !Voiding a check in a different period than the original and leaving a permanent difference.
- !Using an unvalidated custom report as the evidence for an audit.
How an ERP-grounded AI assistant handles this
A grounded assistant can answer questions like which checks to this vendor are still outstanding over 90 days by reading Cash Ledger and payment data read-only, and show the query it used. Netray builds that layer on private models so Infor financial data stays inside your environment.
Frequently asked questions
What is an outstanding check?
A check recorded as paid in your books that has not yet cleared the bank. It reduces the book balance but not yet the bank balance, so it is a reconciling item.
Why is my outstanding check listing empty?
Common causes are the wrong company or bank code, an as-of date before the items were created, all items already reconciled, or a job error. Check the job log.
How do I clear a check that never cashed?
Void or stop-pay it following your policy so it reverses in Accounts Payable and Cash Ledger, then reissue if needed. Do not delete the record.
Does the report differ between FSM versions?
Program names, menu locations and parameters differ between versions and customisations. Use your administrator or Infor documentation to confirm the exact report for your build.
Related
Infor Birst: Documentation, BQL and Smart Insights Explained
Infor Birst is a cloud analytics and BI platform that connects to ERP data, models it into a semantic layer and lets users build dashboards and reports. BQL (Birst Query Language) is its SQL-like query language over that model, and Smart Insights uses automated analysis to point out drivers and outliers. Official documentation is published by Infor.
Error fixDiagnose and fix a failed BOD document flow in ION Desk
A Document Flow showing Failed in ION Desk means a BOD (Business Object Document) stopped either at schema validation, at the mapping step, or at the target application. Open the failed instance's detail to see the exact failing element, fix the source data or mapping, then use Resubmit rather than re-triggering the original transaction to avoid duplicates.
CIO briefingSyteLine or CloudSuite Industrial: how to decide in 2026
Infor's roadmap has converged on CloudSuite Industrial (CSI), which is SyteLine's code line delivered as a multi-tenant cloud service on AWS with continuous updates; on-prem SyteLine still runs and is still supported on current versions, but new Infor OS, ION, and AI-adjacent capability lands in CSI first. The decision is not 'SyteLine is dying' so much as 'on-prem SyteLine is a slower lane on the same road.' CIOs should decide based on integration needs, customization depth, and whether IT wants to keep owning SQL Server and patching, not on vendor pressure alone.
Error fixFix a 401 Unauthorized error from Infor ION API
A 401 from ION API almost always means the credentials in the .ionapi file no longer match what ION API Gateway expects - not that the password is simply wrong. Check whether the Authorized App or service account behind the file was revoked, regenerated, expired, or issued for a different tenant, then re-test with a direct OAuth2 client_credentials call before touching any calling code.
How-toHow to query Infor Data Lake with Compass SQL
Compass is the SQL query layer in Infor OS for querying Infor Data Lake, where flattened copies of BODs published over ION are stored by Noun and Verb. Open a Compass SQL Workbench tab, browse the schema for the correct table, and run a filtered SELECT rather than pulling the full history, since Data Lake tables can hold years of append-only data.
Error fixFix a Ming.le homepage widget that will not load
A blank or endlessly spinning Ming.le widget is usually a permissions, session, or backend availability problem, not a broken widget itself. Confirm the issue is widget-specific, check the user's Security Group access to the underlying app, and look at the widget's network calls in browser dev tools to see whether it is failing with 401/403 or simply timing out against a down service.
AI for ERPInfor M3 AI: A Practical Path from MI Programs to a Private Assistant
Infor M3 AI explained: grounded natural-language answers over MI programs and MEC, agents for distribution and manufacturing, on-prem or EU private cloud.
AI for ERPAI Agents Over Infor ION API, BODs, and the Infor Data Lake
Build AI agents on Infor ION API Gateway, BODs, and Data Lake, alongside or instead of Infor's own GenAI features, with your choice of model and hosting.
Stuck on Infor FSM (Financials and Supply Management)?
Talk to engineers who work inside Infor FSM (Financials and Supply Management) every week, and who build private AI that answers these questions from your own ERP data.
Keep exploring
Free tools
- Days Inventory Outstanding CalculatorEnter average inventory and annual cost of goods sold to get DIO, turns and the cash locked up above a target.
- Cash Conversion Cycle CalculatorCombine days inventory, days sales outstanding and days payable into one cash conversion cycle, and see how many days and how much cash each lever is worth.
- Days Sales Outstanding CalculatorCalculate DSO, best possible DSO and average days delinquent from your AR aging, then test how much cash a lower DSO target would release.
ERP fixes and how-tos
- How to Void a Check or Payment in SyteLine (CSI)How to void an AP check or payment in SyteLine/CSI: what a void reverses, period and posting rules, bank reconciliation effects and what to check afterwards.
- How to void a check (cheque) in SYSPROThe procedure to void or reverse a payment or cheque in SYSPRO Cash Book and Accounts Payable, with the GL impact and period and reconciliation limits.
- Business Central Bank Integration: Bank Feeds and Bank File FormatsHow to connect bank accounts in Business Central: online bank feeds, bank statement import formats, payment export formats and data exchange definitions.
Runs with your ERP
- SAP Field Service Management with SAP Business OneHow SAP Field Service Management, with Coresuite, syncs with SAP Business One service calls and billing: data flows, setup, pitfalls and a private AI layer.
- Esker Accounts Payable Automation with SAP S/4HANA and ECCHow Esker Accounts Payable Automation captures supplier invoices, matches them to POs and posts to SAP S/4HANA and ECC, plus setup steps, pitfalls and options.
- Esker Accounts Payable with JD Edwards: Invoice Capture and PO MatchingEsker Accounts Payable captures invoices, matches POs and posts to JD Edwards 9.0 and later. Data flows, setup, pitfalls and where a private AI helps.
Guides
- SyteLine Bank Reconciliation Configuration GuideConfigure bank reconciliation in Infor SyteLine with bank statement import, automatic matching, outstanding check tracking, and reconciliation posting.
- How to Configure Accounts Payable in SyteLineComplete guide to configuring accounts payable in Infor SyteLine. Set up vendor management, invoice matching, payment runs, and AP automation for manufacturing.
- Infor LN Financial Integration GuideIntegrate Infor LN financials with external systems. General ledger, accounts payable, accounts receivable, and financial consolidation integration patterns.
AI on your ERP
- AI for accounts payable invoice matching in your ERPOn-prem AI reads vendor invoices, runs 3-way match against your ERP PO and receipt, and routes only real exceptions to your AP team. No invoice data leaves your network.
- AI for NetSuite Order to Cash: Find Where Every Order and Dollar Is StuckAI for the NetSuite order to cash cycle: sales orders, item fulfillment, invoicing and collections. Ask where an order is stuck and why cash is late.
Integrations
- How to add document OCR to Dynamics 365 Finance and Supply ChainAdd document OCR to Dynamics 365 Finance and Supply Chain: invoices, packing slips and certificates of conformance with confidence thresholds and review.
- How to add a mobile app to TallyPrimeBuild or choose a mobile app for TallyPrime: sales orders, outstanding, stock and approvals through a sync service over Tally's XML port, with offline handling.