| Subject: | Cannot save changes to GL Accounts | | Summary: | In General Ledger Maintenance, we are unable to save changes to Account descriptions. We cannot save changes to the account categories as well. This problem seems to be related to data imported as changes can be made to accounts created from the JIWA application. | | Audit Notes: | | | 24 Mar 2011 | 08:37PM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-08-2021 02:33 PM | | The problem is t do with the way GL transaction data is stored in the database. The database stores the LAST_SAVED_DATETIME in SQL Datetime format which includes the Milisecond portion of the datetime.
The account codes imported has a timestamp which included milliseconds, however when saving a change from JIWA Screen, it was ignoring the milliseconds part of the date, therefore the JIWA screen could not find the record to update so the change was not saved.
To resolve the issue, import 000 in the milisecond part of the LAST_SAVED_DATETIME when importing data into JIWA. For data that has been imported, use this script to update the datetime. Do this for all tables that store datetime values.
THIS EXAMPLE RESOLVES THE PROBLEM ON THE GL_LEDGER table.
update GL_Ledger set LastSavedDateTime = CONVERT(varchar(20),LastSavedDateTime,120) |
|
|