osFinancials Changelog

What's new in osFinancials 4..0.0.412

Apr 23, 2014
  • Program and Plugins
  • Program and Plugins are smaller in size
  • Zeos component is all written out it will make the program more stable - opensource database components that does not like Delphi 15.
  • Delete the obsolete reportman.dll and reports.dll in the plug_ins\reports\reports directory.
  • Reports
  • Net Profit / Loss added to Trial Balance
  • Only the totals were displayed in the Trial Balance - The Net Profit / Loss was not displayed. This is now added and will display the totals Debits / Credits of the Income / Expense accounts and Net Profit label (LabelID1023) as well as the net profit figure or the Net Loss label (LabelID1025) as well as the net loss figure.
  • A Totals label in the first Debit / Credit columns is added as it was said to be a bit confusing - The first Debit / Credit column displays the totals for Groups and Accounts (if an account has sub-accounts).
  • This is also added to the Income / Expenses report (Income Statement and Balance Sheet).
  • Not Displaying Retained Earnings / Income in the Correct Columns
  • For example the retained earnings display in the Credit column correctly on the Trial Balance, Income Statement and Balance Sheet (also a credit figure in the Column Balances). On other reports (i.e. This Year vs Last Year, Budget vs Actual and Standard Columns), it displayed incorrectly in the debit column. This is fixed.
  • This Year vs Last Year and Budget vs Actual Reports
  • The Budget vs Actual and the This Year vs Last Year report totals are fixed - It will now display similar results in TurboCASH3 and osFinancials3 (Tools → Old Reports menu).
  • Invoices in Sales and Sales Analysis Reports - Expression Errors “ Division by zero:Expression TrpExpression12”, etc.
  • These errors are not replicated in all Sets of Books.
  • The errors with the errors on Expressions “ Division by zero:Expression TrpExpression12”, etc. have been resolved – This will be included in the next release (build 412 onwards):
  • Changed the SQL of all the applicable expressions in all sales reports from
  • “ 100 +( - DOCUMENTLINE.FUNITCOST * DOCUMENTLINE.QtyShipped / DOCUMENTLINE.TOTALEXC * 100) “ to
  • “ IIF(DOCUMENTLINE.TOTALEXC=0,0, 100 +( - DOCUMENTLINE.FUNITCOST * DOCUMENTLINE.QtyShipped / DOCUMENTLINE.TOTALEXC * 100)) “
  • Obsolete Reports Deleted from Install
  • The reports in the ...\plug_ins\reports\REPORTS\ folder not used in osFinancials4 were deleted from the install. The reports in the following folders are deleted:
  • BATCHREPORT
  • COSTCENTER
  • TAX
  • E-Mail option from Reportman Print Preview screen
  • The e-mail icon on the Reportman Print Preview (send reports to screen) will launch the E-mail address screen (Send from and Send to) with the default e-mail address as entered in the Setup → Setup → Internet menu. It uses the SMTP Settings (UserAccount, Server Address, E-mail Address and Password).
  • You may enter (overtype) that e-mail address with an valid e-mail address of another recipient or add other e-mail addresses in your system's default e-mail program.
  • It will automatically include the report as a pdf file in your system's default e-mail program.
  • Batch Entry
  • Smaller issues found for example, making new debtor in batches did not show full account code and name just account code until the program was restarted.
  • Bank Import Plugin
  • The old OFC (Microsoft Money) worked in osFinancials3 - It is not working on osFinancials4 Bank Import.

New in osFinancials 4..0.0.386 (Apr 23, 2014)

  • Open Set of Books - Field Length (Number of Characters)
  • In the Set of Books (Open) screen the books name length was just showing first 20 characters in the list changed to a maximum of 50 characters.
  • When Saving a Set of Books (Start → Save As) with more than 50 characters, the following error is replicated.
  • "Books not found. Please check rights!" Save As (Start tab) Unlimited characters more than 50 gives that error. This is fixed and will display all characters in your system's file browser. Only 50 characters will be displayed in the file list on the Open (Set of Books screen).
  • Batches
  • Lookups and Account / Tax Account Columns
  • Lookups improved and the Account Code and Description is displayed in the Account column of the Batch Entry screen.
  • Batch Entry Rows - Debtor / Creditor Account Information
  • The Account code and Account Description is by default displayed on the Batch Entry screen's line information field. The postal address details are displayed in the top section of the Batch Entry screen if a debtor / creditor account is selected in the batch lines.
  • Documents
  • Statement Setup
  • Statement Setup tab added on Setup → Documents menu.
  • Document Processing - Fast Add fixed.
  • Reports
  • New Reports Added
  • Debtor Statements
  • Debtor Statements added to the Reports → Debtor → Outstanding menu. (The Global Statement Message need to be entered on the Statement Setup tab on Setup → Documents menu).
  • Creditor Remittance Advises
  • Creditor Remittance Advises added to the Reports → Creditor → Outstanding menu.
  • List of Tax and Company Registration Numbers
  • Reports → Debtor → Listing
  • Reports → Creditor → Listing
  • List of Credit Limits vs Current Balance at date
  • This report will list the credit limit minus current balances and will display the available balances as at a specific date
  • Reports → Debtor → Listing
  • Reports → Creditor → Listing
  • Reports Moved from New Reports to systemreports folder
  • The Reports on the Reports → Reports menu was stored in the ...\plug_ins\reports\Newreports folder. The default path for the Reports on the Reports → Reports menu is changed to ...\plug_ins\reports\systemreports
  • Reports not included in systemreports osFinancials4.0.0.383
  • The following reports were included in the Newreports folder and is not included in the systemreports folder in osFinancials4.0.0.383.
  • Sales Analysis Reports
  • ...\plug_ins\reports\systemreports\TRN_85\TRN_1792 Sales Analysis Reports for both Invoices and Credit Notes.
  • Changed folder name of TRN_1792 – Sales to TRN_906122 – Sales per period.
  • The following five (5) reports are available to analyse posted invoices and credit notes:
  • 1. Sales per period - Debtor Group 1 - List the invoices by debtor (customer / client) reporting group 1 linked to debtor (customer / client) accounts on the Edit - Debtors menu.
  • 2. Sales per period - Debtor Group 2 - List the invoices by debtor (customer / client) reporting group 2 linked to debtor (customer / client) accounts on the Edit - Debtors menu.
  • 3. Sales per period - Document Group 1 - List the invoices by document reporting group 1.
  • 4. Sales per period - Document Group 2 - List the invoices by document reporting group 2.
  • 5. Sales per period - Salesperson - List the invoices by salesperson (person who processed the invoice).
  • This report only includes Invoices and Credit Notes which are posted. Unposted Invoices and Credit Notes will be NOT be included in this report.
  • Purchase Analysis Reports
  • ...\plug_ins\reports\systemreports\TRN_977\TRN_906337 Purchase Analysis for both Purchase documents and Supplier Return documents.
  • The following five (5) reports are available to analyse posted purchase and supplier return documents:
  • 1. Purchase Documents per period - Creditor Group 1 - List the purchase and supplier return documents by creditor (supplier) reporting group 1 linked to creditor (supplier) accounts on the Edit - Creditors menu.
  • 2. Purchase Documents per period - Creditor Group 2 - List the purchase and supplier return documents by creditor (supplier) reporting group 2 linked to creditor (supplier) accounts on the Edit - Creditors menu.
  • 3. Purchase Documents per period - Document Group 1 - List the purchase and supplier return documents by document reporting group 1.
  • 4. Purchase Documents per period - Document Group 2 - List the purchase and supplier return documents by document reporting group 2.
  • 5. Purchase Documents per period - Salesperson - List the purchase and supplier return documents by salesperson (person who processed the purchase document).
  • Batch Entry Reports
  • The Posted Batch now includes the Account code pre-fix (e.g. D for Debtors, Creditors, B for Bank Account, G for General Ledger Accounts and T for Tax Codes). The Account description is also added to make the report more user-friendly. The report should improve the audit trial.
  • Still need to implement these features on the F8:List of the Batch Entry screen and the Reports → Batch Entry reports.
  • Tax Reports
  • Tax reports on the Reports → Tax menu include Account code prefixes (e.g. D for Debtors, Creditors, B for Bank Account, G for General Ledger Accounts and T for Tax Codes).
  • Reportman Translations
  • Most of the labels are translated - Also the Mouse-over on icons. The labels reserved for Reportman starts from 21000 label Id's. Most of the Reportman Edit screen is translatable.
  • Reportman - Preview Screen
  • E-mail
  • Fixed and resolved the access violation and program crash errors errors when clicking on the E-mail icon of the Report man Preview screen.
  • Save As and Improved PDF Export
  • Save the report to various file formats does not replicate Access Violation errors or Application Crashes.
  • Plugins
  • All plugins have been updated - also load faster.
  • Bankimport Plugin
  • Quicken Interchange Format (*.QIF) file format added.

New in osFinancials 4..0.0.315 (Apr 23, 2014)

  • Backup / Restore
  • This is a critical error - The books.fdb Set of Books file not include in the Backups files and a Set of Books could as a result not be restored.
  • Applicable to http://sourceforge.net/projects/turbocash/files/TurboCASH5/Development-Beta/TurboCASH-500307-setup.exe/download only. The http://sourceforge.net/projects/turbocash/files/TurboCASH5/Development-Beta/TurboCASH-500315-setup.exe/download fixed this.
  • Registration Error on osFinancials4.0.0.293
  • The osFinancials4.0.0.293 Version downloaded at http://sourceforge.net/projects/turbocash/files/TurboCASH5/Development-Beta/TurboCASH-500293-setup.exe/download could not be registered. "HTTP/1.1 404 Not Found error" on replicated on registration.
  • osFinancials4 Bug Reporting
  • Please use the http://sourceforge.net/p/turbocash/bugs/milestone/TurboCASH5/ for adding Bugs.
  • Help File
  • The Compiled Help File EngHelp.chm supports the F1 key (Context Sensitive Help). It will be included in the osFinancials4 installations.
  • Updated
  • Updated Books
  • Updated Sets of Books in the Repository folder to 2013.
  • Updated Tutorials
  • Updated HANDYMAN-A, HANDYMAN-B and HANDYMAN-C Books in the ...\Bin\Tutorials\EN-TUTORIALS folder.
  • Batch Entry Report Added
  • Batch Type report added Documents Batch Transactions printed from the Reports → Batch Entry menu.
  • FIXED
  • HandyTools Plugin Updated to Fix Databases
  • The function to correct books does it by day. Solves Fixes problems on a database - correction of lines for every day out of balance (balance ledger).
  • Batch Entry - Contra Account per Line
  • The accounts as selected in the Contra Account column of the Batch Entry screen were replaced incorrectly by the Contra Account as set in the F10:Setup when balancing the batches. This would cause incorrect posting to the Purchase Journal and Purchase Returns Journal.
  • Batch Entry - Tax Setting
  • Bug-fix tax was not always saved - so tax reports showed 0 tax.
  • Reporting the batch will redo it correct.
  • Batch Entry Balancing Transactions - Differences
  • F10: Batches Standard tab Not working
  • The following settings on the F10: Batches - Standard tab cannot tick and untick:
  • Increment Reference Number
  • Consolidate Balancing
  • Contra Account per Line
  • Inclusive Mode
  • Repeat Details
  • Posting to Retained Earning - Extra Confirmation Message
  • Extra check that when retained earnings is posted to is added. It must be a opening balance batch.
  • Calendar
  • Calendar – Cannot Create Edit / Appointments / Invoices, etc.
  • Appointments is set created in the Calendar – but it only displays the underlined date e.g. 28 indicating that there are events. On the Dayview it does not display the events. The Reminder does pop up correctly.
  • Also Events in osFinancials3 Sets of Books does not display in the dayview.
  • Categories for Debtor Appointments
  • Added 5 additional Categories of Debtor Appointments 2 / 3 / 4 / 5 / 6. Up to 6 Categories of Debtor Appointments can be created as events in the Calendar.
  • The Hours report (Reports → Calendar) is also updated to display the different colours.
  • Oversized Screens Fixed
  • Create Invoice Context menu on Calendar - Invoicing screen resized
  • The Invoicing screen Create Invoice is launched too big on a 1024 x 768 screen resolution.
  • Adjust Stock
  • When launched from the Action → Input → Adjust Stock Stock Items screen too large for a 1024 x 768 screen resolution.
  • T-Ledger Analyser 1 /2 Opening Balancing Only Setting
  • The Opening Balances Only setting saves the tick not visible. It causes some confusion as the Include Opening Balances field is not ticked.
  • If the Include Opening Balances field is not ticked, it should turn the Opening Balances Only field off.
  • Backup / Restore
  • Backup Path on Backup / Restore screen
  • Backup Path on Backup / Restore screen resized - to display the full path of the Set of Books.
  • Restore from EXE - Backup Reports – No Folders
  • The progress screen displays the correct paths for reports. When opening the Set of Books folder all reports files are restored in the BOOKS root folder.
  • Restored Reports is not structured in folders.
  • Uni Dump – Backup / Restore
  • The uni backup is actually for multi user purposes and should only be restored in the same database. It can backup a production database as it uses transactions to get the data of that moment.
  • Warning is added to the restore process.
  • #451 Uni dump Input / Output error
  • http://sourceforge.net/p/turbocash/bugs/451/
  • Uni dump Input / Output error – Error produces a blank SQL file
  • This is fixed in osFinancials4.0.0.211
  • Uni Dump – No Backup Completed Message
  • The Message “The Backup process is completed” is not displayed when the Uni dump backup is completed. (do not know if the process is finished).
  • The Message “The Restore process is completed” is displayed when the Uni dump restore is completed.
  • Documents
  • Document Ctrl + Function Keys
  • Function Keys (Ctrl + F8 Key, etc.) in Document Entry Screens launched the Enter overall discount screen when Document Entry screen was closed.
  • Document Layout Files
  • Invoice Bank Details (10 Code) has no description
  • http://sourceforge.net/p/turbocash/bugs/460/
  • The Description of Invoice Bank Details (10 Code) (LabelID906260), description displayed as 0.00.
  • To Fix that, remove 0.00% in the Display format of TRpExpression10.
  • Fixed - scheduled for the next release / update. You may download this fixed layout file Invoice Bank Details (10 Code) and copy it to the ...\plug_ins\reports\DOCUMENTS\DOCUMENTS folder.
  • http://sourceforge.net/p/turbocash/bugs/_discuss/thread/f22ddb76/6e14/attachment/TRN_906260.rep
  • LAYOUT FILES – ADD UNIT DESCRIPTION
  • Added the Unit Description (SUNIT dataset) SUNIT.SDESCRIPTION to the Test Invoice (LanguageID906190) layout file.
  • Added Unit Description to the Delivery Notes (No Codes) (LanguageID906181) and Delivery Note (15 Code) (LanguageID906182) layout files.
  • Note The Unit Descriptions will only display on new Invoices processed.
  • See Reportman - Add Unit Descriptions to Layout Files.
  • LAYOUT FILES - CREDITOR (SUPPLIERS)
  • Added Salesperson to all Creditor (Supplier) Layout files. This will indicate who processes orders, purchases and supplier return documents.
  • Reports
  • Reportman Preview screen Icons
  • The icons on the Reportman Preview screen is more consistent with the program interface (Classic theme).
  • Stock Item Listing Report
  • ...\plug_ins\reports\Newreports\TRN_1999\TRN_84\TRN_84.rep
  • Added Unit Descriptions to the main report and removed it from the detail section. It now displays Stock Code Description, Unit Size, Quantity and Value on the Show details not selected report.
  • Stock Reorder Reports - SQL Errors selecting Stock Groups
  • Error
  • STOCK:
  • Dynamic SQL Error
  • SQL error code = -204
  • Ambiguous field name between table STOCK and table ACCOUNT
  • WREPORTINGGROUP1ID
  • Fixed Stock Item Listing Before
  • plug_ins\reports\Newreports\TRN_1999\TRN_84
  • TRN_84 Stock item Listing
  • TRN_1056 All Selling Prices
  • Fixed Stock Reorder Reports
  • plug_ins\reports\Newreports\TRN_1999\TRN_1778
  • TRN_83 Reorder
  • TRN_906268 Current Stock Levels
  • MENU - POS
  • Point of Sales is available in a menu list (Action → Input → POS Invoice menu) but on the Setup → Setup → Point of Sale is directly visible in the Setup ribbon. Moved Point-of-Sale to the Setup → Setup → Point-of-Sale menu list and Setup → Setup → Salesperson moved to Setup → Salesperson menu. Salesman.ico added.
  • Export / Import
  • Export to Lotus Spreasheet *.Wk1 Crash
  • In TurboCASH451-838 the Lotus SpreadSheet File (*.Wk1) export and import works.
  • Causes osFinancials4 to crash - possibly caused by unicode.
  • Export to TurboCASH Exchange File *.TXF
  • In TurboCASH451-838 the TurboCASH Exchange File (*.TXF) export and import works.
  • The TurboCASH Exchange File (*.TXF) exported in TurboCASH451-838, can be imported to osFinancials4.
  • The TurboCASH Exchange File (*.TXF) exported in osFinancials4, can not be imported to osFinancials4 - produces error - "Invalide Xml File".
  • Export Files
  • Export cliëop : Drop-down value is saved and restored now.
  • Performance and Plugins
  • Share more data and all plugins, etc. are smaller and load faster.

New in osFinancials 4..0.0.184 (Apr 23, 2014)

  • Tooltips to the menu items
  • It shows shortcut if you hover over a button in the ribbon.
  • TrayIcon / Notification Area
  • Displays the osFinancials Logo and the Name of the Opened Set of Books
  • Documents / Calendar
  • Context menu – Create Invoice added to create an Invoice for any appointment on the Calendar.
  • Disabled Debtors / Creditors on Debtors / Creditors list screens
  • Tick box added to Hide or Show Disabled Debtor / Creditor Accounts
  • Batches
  • Balance Batches – New Feature added to display balancing entries – default now set to display balancing entries – User can tick the the Balance = balance filter at the bottom of the batch entry screen to hide the balancing entries.
  • Ticked – Hide Balancing Entries – Not ticked (default) Show Balancing Entries
  • Budgets Added for Projects
  • Budgets may be entered in the Action → Accounts screen for projects. Still need to add them to the Project Reports in the plug_ins\reports\REPORTS\PROJECTS folder.
  • Horizontal Logo
  • logohor.jpg – added to the root directory - Implemented on the Creation Wizard (F10) Create Set of Books.
  • Icons
  • Ruby
  • Added the 16px icon to fix the oversized Search icon on the Browse buttons on Creation Wizard, etc.
  • Open Item screen - Some Classic icons were displaying on the Open Item main screen -Added removelinks, linkoff, openhistory, openitem and close icons.
  • Classic
  • Creation Wizard - End icon replaced to blend in with the Next and Back buttons.
  • New icons added for reports and updated icons to match the new osFinancials4 look.
  • Updated Plugin Icons
  • Old Icons on OK and Cancel Buttons
  • The old OK and Cancel buttons on the following screens replaced by icons used on most screens:
  • Repeating Transactions
  • Change Stock Code
  • Close Icons Standardised
  • Different icons displayed on closed buttons are now the same.

New in osFinancials 3.0.1.3 (Apr 8, 2009)

  • Fixed
  • F3 process document select all posted also the quotes.
  • Creating a tax account from a tax linked ledger would result in that link being retained in the new tax account.
  • Remark in documents now handling enters ans spaces better.
  • Linking a debtor while having a debtor open and looking at there links could give a error message that the linked amount was wrong.
  • Export to Excel from the TLedgerviewer had wrong amounts for groups. Export for column balances did not have the debtors creditors account.
  • Added
  • New report in TLedgerviewer Column balances debit / credit also for debtors and creditors.
  • New stock type Financials that allows you to select a ledger account after selecting it. The general contra account will be ignored for theses transaction.
  • Default output selection per user
  • Lookup for projects costgroup1 and 2 now uses the left bottom search screen with all options (like search etc).
  • Projects can now have free fields and multimedia.
  • Payments can now be entered at a invoice if payment types has been setup (there is a interface for it in the new horeca pos)
  • Project code size can by changed in the database.
  • Plugins
  • HORECAPOS
  • Restaurant pos system for waiting tables.
  • Allowing just the divergence on the last bill to be printed at a kitchen or bar printer. (depending on the item)
  • Works also on hand-held's that can log in to terminal server.
  • Pospoint
  • Returning customer pospoints allows you to give a discount based on previous sales.
  • osCommercial
  • Imports of multi shop improved now theres no need to have divergent stock id in osCommerce just a good prefix.
  • All
  • unregistered is now shown in set-up of most plug ins.