7044. Downloaded 5,700 share stock transactions and exported them to a csv file using StockReader, within 6 minutes.
8025. The first post-installation revision of WEB241 custom search engine was done, a minor one just adjusting the spelling for an expression. More database updates were carried out later in the month. On a particular day, we noted there were 23 views of the page within a period of 4 days.
8051. When someone saved the layout for a user table in MoneyBooks DM, it was ignored later when the table was displayed, so we investigated and put a stop to the issue, and also implemented multi-row assigns for access level and owner group on the Document List, producing the executable as v3.10.
8062. After going through the revision log in MoneyBooks we settled for General Ledger, doing the first revision since 2022 compiling as MBGL v3.3: Addressed occasional inability to save changes on the Recurring Transactions List, adjusted the presentation format for logical (yes/no) columns on transaction and budget lists, looked into the issue of a wrong opening balance for an unreconciled-transactions statement of account, seeing that it only happened when the starting date was not sufficient.
8084. We implemented 3-value period code types as part of MBGL v3.3, so that financial periods could be closed on monthly as well as yearly or user-determined basis. We started converting a user’s LeMIS accounting data from 1992 to MoneyBooks, setting up a new database and getting things ready to start porting the GL transactions. (LeMIS is our legacy MSDOS accounting application, being run on MS Windows™ using an emulator.)
For the migration we first created a new MoneyBooks database file, using code from an existing database as basis. Then we transferred the LeMIS accounts chart without figures and set up essential tables and resources to get MoneyBooks running against the database. Later we began handling the LeMIS GL transactions, exporting the ones for the first recorded month of August 1992 in the LeMIS data, and then attempting to import them into the new MoneyBooks database. The transactions would be transferred and closed in the new database on monthly basis, just like was done in LeMIS, and this was one of the reasons we implemented the new period code type in MBGL earlier today.
8095. We added another feature to MBGL v3.3, checking for existence of accounts when importing from a LeMIS transaction file and creating those not found with default values. On the LeMIS migration, we posted the first set of GL transactions for August 1992, after creating and posting a journal with the opening balances for some accounts. The account opening amounts from LeMIS were not balanced (debit and credit totals varying by 33.50), so we created a new “Profit/Loss Adjustments” account to balance them up.
8110. LeMIS accounting migration: We imported, posted and closed three more months, September to November of 1992. Two days later we migrated more GL transaction months, completing the first 1992-93 year in LeMIS and doing the annual closing.
8143. LeMIS accounting migration: We decided to switch from monthly to annual transactions closing to save time, importing and closing 1994 and 1995 and closed 1994, after first removing the monthly closing journals from them.
8154. We effected more needed changes to MBGL, to help in the LeMIS migration work: Resolving an issue with the Transaction Form, revising the Accounting Period list, removing a restriction when querying the Chart of Accounts list, showing the number of records on the Transaction List.
8176. LeMIS accounting migration: We completed migration of the LeMIS GL data to MoneyBooks including current month’s unposted transactions, shifting the period type from yearly back to monthly.
8180. LeMIS accounting migration: Began the migration of Inventory data from LeMIS to MoneyBooks, completing the master data tables, remaining the transactions. The next day, we migrated the inventory transactions from LeMIS to the database and then posted them on yearly basis, doing the monthly/quarterly/yearly zeroing of totals each year.
8202. LeMIS accounting migration: We used code to generate the next set of stock transaction numbers for the new MoneyBooks database, as the automatically-generated ones where not all correct. Completed the migration of the LeMIS Inventory data and transactions to MoneyBooks, ensuring the quantities and values of nonzero items were the same in both. Added a new feature to MBGL v3.3, the Transaction Type List, so users could add new transaction types as needed.
8213. Did the first revision of MoneyBooks Inventory Control since 2021 as v1.62, implementing the transaction copy feature that would speed up data entry, like in GL and some other modules. We completed the migration of the LeMIS accounting data to MoneyBooks that began almost two weeks earlier on the 8th, with the Fixed Assets module which was very simple to do as the data wasn’t much or complex. We also enabled the Data Manager module though without any data so mainly for using the SQL command execution feature.
8224. Implemented MoneyBooks Data Manager v3.2 revision, improving on the SQL Query feature, and addressing multi-row assign, user table and other issues from prior changes. The SQL Query processor now makes saving of SQL commands optional, with access to the list of saved commands, in case one may wish to recall something.
8235. First revisions were made to MBPA and MBSA since 2021, as well as to Gerian where we added display of balance to the TCurrency Ledger. For MBPA we did formatting changes for several grid data display windows, while for MBSA we implemented direct GL account code entry—rather than just picking from a dropdown—for some forms.
8246. In LeMIS we have a means of importing GL transactions from a spreadsheet of monthly petty cash expenses as well as from MoneyBooks of transactions for a specific account. For the migrated system, we considered how to handle the imports, settling for implementing two new transaction import CSV formats in MBGL, completed after two days. The first format has at least three columns in the CSV file, for the date, description and amount, while the second one for CSV exported from another MoneyBooks database has at least 24 columns.
8316. Earlier in the week a web client whose website went offline over a year ago for non-renewal, requested through our Abuja-based associate for it to be resuscitated. Work on this began yesterday and was rounded up today.