Monday, 11 October 2021 - 05:10:58 

TurboCASH5 / osFinancials4 

TurboCASH5 (969) was built from the source of osFinancials4 (969. osFinancials4 (1093) was not used as source, since the Register your TurboCASH unlocking codes screen differs from osFinancials4 (1093).  The features and differences in TurboCASH5 (969) is mainly as follows:  

The default install of TurboCASH5 (969) and documentation screenshots is based on the material theme. You may switch to the classic theme. 

More languages and Sets of Books is included in the Repository folder for the TurboCASH market and tidied for the multi-country / language install

Layout files - More options and variants included to print documents and delivery notes.

Reports translations and labels stretched and resized to accommodate most languages when reports are saved as a metafile to html, spreadsheets, etc. 

User reports - Some basic  reports is added and some documentation to build reports is included for the report designer.

T-Account viewer - in TurboCASH5 (969)  - Show contra option to list contra account transactions is only implemented in TurboCASH5.2.  

Fixes after the following releases on Sourceforge

2021-03-28-TC5-400969-setup.exe 

2021-03-28-TC5-400969-US-setup.exe 

Language files

LabelID 3104 = T-Ledger analyser changed to Ledger analyser 

Debtor / Creditor Transactions Standard / Extra Details Parameters

WORK AROUND FOR Debtor transactions reports

BUG - Link = https://sourceforge.net/p/turbocash/bugs/625/ 

Reports → Debtors → Transactions - Debtor transactions - Standard

Reports → Debtors → Transactions - Debtor transactions - Extra details 

This is replicated in the following releases on Sourceforge: 

2021-03-28-TC5-400969-setup.exe 

2021-03-28-TC5-400969-US-setup.exe 

Fixed after these releases on Sourceforge

The parameters Type of Control referred to General ledger account type instead of Debtor account type
Download TRN_906106.zip file from Sourceforge 

Unzip and replace  the following 4 files in folder:
... \ plug_ins\reports\systemreports\TRN_160\TRN_74
TRN_906106.rep and TRN_906106.dfm = Debtor transactions - Standard
TRN_906107.rep and TRN_906107.dfm = Debtor transactions - Extra details

Fixed Parameters - SQL

ALL and WAccountTypeid in (1)

ALL and WAccountTypeid = 1 

Fixed Parameters - Type of Control  

OA Lookup all GL accounts

OD Lookup Debtors / Creditors

Fixed Column origin

SACCOUNTCODE

FROMACCOUNT

SACCOUNTCODETO

TOACCOUNT

WORK AROUND FOR Creditor transactions reports

BUG - Link = https://sourceforge.net/p/turbocash/bugs/625/ 

Reports → Creditors → Transactions - Creditor transactions - Standard

Reports → Creditors → Transactions - Creditor transactions - Extra details

This is replicated in the following releases on Sourceforge: 

2021-03-28-TC5-400969-setup.exe 

2021-03-28-TC5-400969-US-setup.exe 

Fixed after these releases on Sourceforge

The parameters Type of Control referred to General ledger account type instead of Creditor account type
Download TRN_906108.zip file from Sourceforge 

Unzip and replace  the following 4 files in folder:
... \ plug_ins\reports\systemreports\TRN_161\TRN_74
TRN_906108.rep and TRN_906108.dfm = Creditor transactions - Standard
TRN_906109.rep and TRN_906109.dfm = Creditor transactions - Extra details

Ledger analyser : Nett profit/Loss total not exported

Ledger analyser - Export button - Net Profit/Loss is not Exported for the Trial balance, Income statement, etc. in TurboCASH5 (969):

Changed the Regional Settings in Windows - to different formats does not solve the Net Profit / Loss to export.

TurboCASH4 - export the Net Profit/Loss

 

Outstanding - documented

Most of these issues is addressed in TurboCASH5.2.

T-Account viewer - Show contra

"Show contra" option is implemented in TurboCASH5.2.  

Documents 

Convert documents to single document - This will convert selected unposted Quotes to a single document.  

WARNING - CONVERT POSTED DOCUMENTS TO A SINGLE DOCUMENT

In the case of Purchases and Supplier returns, DO NOT SELECT THE POSTED documents. 

Stock items 

BOM (Production) stock item type

WARNING - BOM (Production) stock item type

 Backup your Set of Books before using the BOM (Production) stock item type.

If you assemble or disassemble the BOM (Production) stock item type, you may find Index out of bounds errors which may corrupt your Set of Books.  

Stock item context menu - Copy / Paste

Stock item context menu - Copy / Paste 

Dummy price 

Copy Dummy price produce the following SQL error:

Dynamic SQL Error
SQL error code = -204
Table unknown
STOCK_EXTRADATA
At line 1, column 39
Select FDUMMYQTY from STOCK_EXTRADATA where WStockid = 4

Mark copy 

Copy Mark copy produce the following SQL error:

Dynamic SQL Error
SQL error code = -204
Table unknown
STOCK_EXTRADATA
At line 1, column 37
Select WMERKID from STOCK_EXTRADATA where WStockid = 4

Backorders to deliver - Quotes 

Backorders to deliver - Quotes

WARNING - INVOICE under Quotes document type

This process is not recommended, as it will create an Invoice on the Quotes document type.

backorders-to-deliver-quote-list


Batches

F9:Creditor balances at date option SQL Error - Payments batches

http://sourceforge.net/p/turbocash/bugs/477/

violation of PRIMARY or UNIQUE KEY constraint "INTEG_249" on table "BAT0T3" 

Need to delete the line 2x before the batch can be closed.