P0030G Updating Records Incorrectly by Recognizing Form Mode as Update Mode in Clicking Add Button

When adding a new bank account through P0030G (G/L Bank Accounts), Bank Account and Transit Number are being pre-populated with values from an unrelated bank account record in F0030. If you do not change those numbers, the original bank account record is updated with the new account description when the new account is added.

Note that this type of issue (where SV Form_Mode is UPDATE_MODE in adding a new record) can be occurred in your running Address Book Master (P01012) or Item Master (P4101) which has primary key value with '0'. However this document shall not explain why '0' value is stored because there are too many possible scenario for this. So application listed here is a case study only.

Note:

In case you need to debug similar issue by yourself, check form mode either through JASDEBUG.log or Debuggr.exe application
For example, JASDEBUG.log may reads as below,

SELECT AYFLR,AYCKSV,AYUPMJ,AYJOBN,AYSWFT,AYFLP,AYUPMT,AYAID,AYIBAN,AYPID,AYCBNK,AYAN8,AYDL01,AYADPI,AYCHKD,AYBKTP,AYUKID,AYUSER,AYCTR,AYTNST FROM CRPDTA.F0030 WHERE ((AYUKID = 0 ))
JDBCProxy.jdbcProxy()>>>response is good(execute()) -> , status = 2, nextpageid = -1, data = JASResultSet is returning 1 rows

Note:

This is considered functioning as designed for following reason,
- BOB_MODE is message on the status of business view
- Currently available BOB_MODE (enumeration) are,
  - BOB_MODE_UNDEFINED = 0
  - BOB_MODE_SPECIAL = 1
  - BOB_MODE_ADD = 2
  - BOB_MODE_ADD_PRIMARY = 3
  - BOB_MODE_ADD_SPECIAL = 4
  - BOB_MODE_DELETE = 5
  - BOB_MODE_UPDATE = 6
  - BOB_MODE_UPDATE_SPECIAL = 7
  - BOB_MODE_INQUIRE = 8
  - BOB_MODE_COPY = 9
- So it is communication between JDBC (or ODBC) and tools code in opening any form (if business view is associated - otherwise, it depends on button clicked - e.g., Select for update and so on). It checks mode based on business view with primary key, if found, then it sets BOB_MODE as update mode (else, update mode or copy mode).
- In many applications/forms, the way it handles data in form/grid are vary depending on SV Form_Mode.
- To adjust UKID, refer to <Document 2015705.1> - E1: 04: Troubleshooting GL Bank Account Set Up (P0030G)Delete Reference
- Same issue can be arisen in P4101 (when F4101 contains a record with F4101.ITM has = 0) or P01012 (when F0101 contains a row with F0101.AN8 = 0)

P0030G Updating Records Incorrectly by Recognizing Form Mode as Update Mode in Clicking Add Button

Purpose of Document