JDE E1 Automatic Bank Reconciliations
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.