Financial - JDE1 (MOSC)

MOSC Banner

JDE E1 Automatic Bank Reconciliations

edited Jun 5, 2018 5:00AM in Financial - JDE1 (MOSC) 3 commentsAnswered

Is anyone using JDE E1 Automatic Bank Reconciliations for payment transactions?  If so, how did you get around the original design of the F0911 where GLCKNU is populated by a batch number?  According to the setup, for the automatic reconciliation process to work, the data in the bank statement (for payments) is a payment number which will not reconcile to the batch number on the F0911 when processed through P09631.  My aim is to find a fix/enhancment for the F0911 to contain the payment number in GLCKNU for payment transactions.  See below for program functionality:

To accommodate reference numbers such as those for receipts, payments, and bank wire transfers, the F09611 table includes a Customer Reference (CUSTREF) field that allows up to 16 alphanumeric characters and maps to the Receipt Number (CKNU) field in the F09617 table. The contents of the CUSTREF field also map to the Document Number (DOCM) and Reference 1 (REF1) fields and are truncated in the F09617 table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center