Can I import a check number reconciliation reference for payments made by a 3rd party system?
We have an inhouse developed system that prints benefit checks. We import the transaction activity into our ledger using the excel journal entry upload template that Oracle provides with Oracle Financials Cloud system.
We process too many checks to manually clear these transactions using the manual reconcile tool with Oracle. We would like to use the "auto-reconcile" tool to automatically match and clear checks in the reconciliation module. There is a column in the multiple journal entry upload template (Column AM) called `reconciliation reference`. We populated the check numbers into the journal entry upload template, and uploaded it. The entry uploaded fine, except for the "reconciliation reference" information appeared to have been dropped, and was not imported into the journal entry line information.