Release notes (Build 969) - Reports

Parent Previous Next

NEW REPORTS

Company Information

TRN_320 - Company info

TRN_183 - Company info – Bank accounts List the details of the company bank accounts details List Bank accounts

TRN_629 - Company info – Information – Lists the details of the following:

oInformation - Document heading and messages (up to 3 lines) as entered in the Documents setup (Setup ribbon) for each of the Sales documents (i.e. Invoices, Credit notes and Quotes tabs) as well as Purchase documents (i.e. Purchases, Supplier returns and Orders tabs). This information is standard and will be printed on all documents.

oGlobal statement message (up to 3 lines) as entered on the Statement setup tab on Documents setup (Setup ribbon). This information will print standard on all Statements (Reports → Debtors – Outstanding (Reports ribbon)). This is in addition to the specific messages (up to 4 lines) that can be entered in the Delivery address tab individual debtor accounts (Debtors - Action ribbon).

oSelling price descriptions – The descriptions of Selling price 1, Selling price 2 and Selling price 3 as entered in the Selling price descriptions fields (Stock information - Setup ribbon).

oCost of Sales

Create Cost of Sales - Yes - Cost of Sales is activated.

          - No - Cost of Sales is not activated.

Average cost - Yes – Average Cost of Sales is activated.

- No – Latest Cost of Sales is activated.


Currencies

Currency listing report  

https://sourceforge.net/p/turbocash/bugs/594/

See https://sourceforge.net/p/turbocash/feature-requests/98/ - #98 Multiple currencies creditor.

Multi-currency listing report will list the Currency ID, Description (Name), Currency symbol and Currency rate.

The Currencies my be listed according to ID, Description or Rate
The Currencies are added / edited or deleted in the Setup Currencies menu on the Setup ribbon.

Multi-currency in TurboCASH Read more ... http://www.turbocashlive.com/digidan/tc5-web-help/MultiCurrency.html

Stock Listing - Tax classes

Stock Tax Class report

https://sourceforge.net/p/turbocash/bugs/593/

Stock Tax Class report lists (Reports → Stock item listing - Tax classes (Reports ribbon) (the Tax classes added in Stock information (Setup ribbon). You may select on the parameters to list the Stock classes by ID or Description.  

Debtor / Creditor listing reports Reporting group 1 added

Debtor / Creditor listing reports Reporting group 1 added. Once you have selected the accounts, you may select to print the report for Debtor creditor accounts linked to a specific reporting group 1 or reporting groups 1.

1.Contacts

2.Listing

3.List delivery address

4.List postal address

5.List details

6.Tax and company registration numbers

7.Credit control listing (Credit limit vs current balance and available balances as at the date and time of printing).

FIXED - Creditor - Print labels

Postal code and Account codes overlapped.

FIXED - Sales analysis - Sales per period - 15 character stock codes for Credit notes

The following five (5) reports for posted invoices and credit notes does not support 15 characters in the stock code when Credit notes are included:

1.Sales per period - Debtor group 1 -

2.Sales per period - Debtor group 2 -

3.Sales per period - Document group 1 -

4.Sales per period - Document group 2 -

5.Sales per period - Salesperson -


Debtors / Creditors - Age analysis

Added the following reports to print Debtor statements and Creditor remittance advises with linked transactions (Open item link) - It now prints only the outstanding (unlinked transactions).    

Added: Debtors statements - Outstanding

Added: Creditor remittance advises - Outstanding

Tax reports

Tax reports added after Build 600

Reports Tax on Reports ribbon.

Tax per period report was the only tax report in the most downloaded release (Build 600) on sourceforge.

Tax reports added after the Build 600, is the following:

Document groups - Changed label description TRN_906550 Document groups - report name - to  Tax report - Reference / Document no. as this report does not only include Documents, but also Batches references.

Tax list debtor / creditor with taxid changed the language label - TRN_3675 to Tax list debtor with tax id (Only displays the Debtor documents for type 10 Invoices and 11 Credit notes). and added a new language label 906553 Tax list creditor with tax id and added a new report to show the creditor (supplier) account and transaction / tax details (documents for type 12 Purchases and 11 Supplier returns).

FIXED REPORTS

Reports → Sales analysis → Sales per product → Stock group 1 / 2

FIXES -

Standadised parameters FROMSTOCKCODE … TOSTOCKCODE on printout with other Stock reports.

Set Font - Invoice and Credit note totals from 8 to 9

Folder name ...\plug_ins\reports\systemreports\TRN_85\TRN_3571

TRN_906174 - Sales per product - Stock group 1

TRN_906175 - Sales per product - Stock group 2

Reports → Purchases per product - Stock group 1 / 2

FIXES -

Standadised parameters FROMSTOCKCODE … TOSTOCKCODE on printout with other Stock reports.

Set Font - Purchase and Supplier return totals from 8 to 9

Folder name  ...\plug_ins\reports\systemreports\TRN_977\TRN_3575

TRN_906172 - Purchases per product - Stock group 1

TRN_906173 - Purchases per product - Stock group 2

Reports → Purchases → Creditors - Purchases per period - Quantities

TRN_302        Purchases

TRN_1269        Purchase documents

TRN_161        Creditors

TRN_906150.rep        Purchases per period - Quantities

Set the total font from 9 to 10 to be in line with other reports

POSTGRESS FIXES TurboCASH5 (BUILD 913 and BUILD 969 only)

Account lookup is one off – The first account selected on the Accounts lookup is not included in the printed report.

TRN_1372        Ledger

TRN_74        Transactions

TRN_74.rep                Transactions


TRN_160        Debtors

TRN_74        Transactions

       TRN_74.rep                Transactions

TRN_906061.rep        Transaction List - Open item

TRN_906106.rep        Transactions - Standard

TRN_906107.rep        Transactions - Extra details

TRN_906440.rep        Transaction List

TRN_161        Creditors

TRN_74        Transactions

TRN_74.rep                Transactions

TRN_906061.rep        Transaction List - Open item

TRN_906108.rep        Transactions - Standard

TRN_906109.rep        Transactions - Extra details

TRN_906440.rep        Transaction List



TRN_1792        Sales

TRN_1870        Quotes

TRN_160        Debtors

TRN_906315.rep        Quotes per period - Quantities

TRN_300        Invoices

TRN_160        Debtors

TRN_906155.rep        Invoices per period - Quantities

TRN_47        Credit notes

TRN_160        Debtors

TRN_906311.rep        Credit notes per period - Quantities


TRN_302        Purchases

TRN_1269        Purchase documents

TRN_161        Creditors

TRN_906150.rep        Purchases per period - Quantities

TRN_1871        Orders

TRN_161        Creditors

TRN_906317.rep        Orders per period - Quantities

TRN_303        Supplier returns

TRN_161        Creditors

TRN_906313.rep        Supplier returns per period - Quantities


TRN_38        Documents

TRN_906161        Document listing per account

TRN_1268        Sales documents

TRN_300.rep                Invoices

TRN_418.rep                Quotes

TRN_706.rep                Credit notes

TRN_1269        Purchase documents

TRN_302.rep                Purchases        

TRN_303.rep                Supplier returns

TRN_798.rep                Orders

TRN_906162        Unprinted document listing

TRN_1268        Sales documents

TRN_300.rep                Invoices

TRN_418.rep                Quotes

TRN_706.rep                Credit notes

TRN_1269        Purchase documents

TRN_302.rep                Purchases        

TRN_303.rep                Supplier returns

TRN_798.rep                Orders


TRN_85        Sales analysis

TRN_3571        Sales per product

TRN_906174.rep        Sales per product - Stock group 1

TRN_906175.rep        Sales per product - Stock group 2


TRN_977        Purchase Analysis

TRN_3575        Purchases per product

TRN_906172.rep        Purchases per product - Stock group 1

TRN_906173.rep        Purchases per product - Stock group 2



GENERAL FIXES TO REPORTS

No data is is available - printing blank reports

https://sourceforge.net/p/turbocash/bugs/583/ - See Attached document on https://sourceforge.net/p/turbocash/bugs/583/ for list of reports and details.

The reports that are fixed, is located in the following folders:

...\plug_ins\reports\systemreports

...\plugins\reports\GENERAL\documents

...\plugins\reports\REPORTS

The P.Only data avail. (Print only data available) set to “False”, the report will print only the page headers and footers if no data is available on the Dataset.

P.Only data avail. (Print only data available) set to “True”. If an invalid selection is made on the parameters or if there is no data in the Datasets to print, the following error message will be produced:

No data available to print!

Report print layout in different file types overlapping (Reports)

https://sourceforge.net/p/turbocash/bugs/599/

Report print layout in different file types overlapping.

Headers and Footers

Standardised the Page headers and Page footers to print correct in all reports in the ...\plugins\reports folder. This solves the print layout of reports in Pdf and Html formats.

Detail

In the report detail section almost all reports needed work. Large amounts and long descriptions on reports does not display properly on printouts on screen, pdf and html formats.

Stretch, resize and set the auto-expand, auto-contract, etc., where necessary on all expressions (data and label fields).

Reportman - Save reports – HTML not displayed correctly

https://sourceforge.net/p/turbocash/bugs/481/ Document layout files in the ...\plugins\reports\DOCUMENTS\DOCUMENTS\ folder.

Set Transparent setting for Expressions to True

batch.rep – Location (...\plugins\reports\GENERAL\documents\)

Printed frames around Account expressions

Standardised the COMPANYDATA Dataset on all reports and layout files

https://sourceforge.net/p/turbocash/bugs/590/

https://sourceforge.net/p/turbocash/bugs/562/

Added

SBANKBIC1 and SBANKBIC2 (Bank Identifier Code) fields (see - Swift Code & BIC Code for all Banks in the World - http://www.theswiftcodes.com/south-africa/ , etc.

BBLOBLOGO ,

Fixed Groups 1 changed to 2

SaccountReportName2 ,

SStockReportName2 ,

Old COMANYSATA Dataset

Updated COMANYSATA Dataset


Select a.*, SCompanyName  ,

SCompanyRegNo ,

SEmailAddress ,

SAddress1 ,

SAddress2 ,

SAddress3 ,

SPostCode ,

SPhoneNumber ,

SFaxNumber ,

STaxRegNo ,


SAccountReportName1 ,

SAccountReportName1 ,

SDebtorReportName1 ,

SDebtorReportName2 ,

SCreditorReportName1 ,

SCreditorReportName2 ,

SStockReportName1 ,

SStockReportName1 ,

SBANKNAME1,

SBANKNAME2,

SBANKNUMBER2,

SBANKNUMBER1,

SBANKSWIFT1,

SBANKIBAN1,

SBANKSWIFT2,

SBANKIBAN2,

SBANKACCOUNTNAME1,

SBANKACCOUNTNAME2



from Sysvars

, sysvarsext a

Select a.*, SCompanyName  ,

SCompanyRegNo ,

SEmailAddress ,

SAddress1 ,

SAddress2 ,

SAddress3 ,

SPostCode ,

SPhoneNumber ,

SFaxNumber ,

STaxRegNo ,

BLOBLOGO,

SAccountReportName1 ,

SAccountReportName2 ,

SDebtorReportName1 ,

SDebtorReportName2 ,

SCreditorReportName1 ,

SCreditorReportName2 ,

SStockReportName1 ,

SStockReportName2 ,

SBANKNAME1,

SBANKNAME2,

SBANKNUMBER2,

SBANKNUMBER1,

SBANKSWIFT1,

SBANKIBAN1,

SBANKSWIFT2,

SBANKIBAN2,

SBANKACCOUNTNAME1,

SBANKACCOUNTNAME2,

SBANKBIC1,

SBANKBIC2

from Sysvars

, sysvarsext a


NEW.rep and EMPTY.rep

https://sourceforge.net/p/turbocash/bugs/591/

The New.rep contains no datasets and only a Page header, Detail and Page footer.

The Empty.rep contains the COMANYDATA dataset on the Page header. Added the following to the Page footer:

Company name

Data path – Location and name of the Set of Books.

System user – Operating system user

TurboCASH user

Printed - Date and time stamp.

Page – Page number / last of page of report.  (Print setup – Two pass report selected).

Save as Xls Spreadsheet

Split Account code and Description parameters to separate expressions in reports. It is easier to sort the data (Code and Description) columns in spreadsheets.


PARAMETERS

Tidied parameter screens

https://sourceforge.net/p/turbocash/bugs/598/

Aligned the Properties of parameters to have the same top, left, height and width sizes. Should standardise the report parameter screens.

Fixed Tick box fields - Report parameters

Added 0 in the SQL section on report parameters (Report designer - Parameters button) for all tick boxes, where necessary. Some Reports produced an SQL error, where the tick box value is not in the parameter.  (This is when the tick box is not 0 (No) or 1 (Yes). Set all tick boxes to 0 (not ticked - blank).

Fixed duplicated From account hidden parameters

https://sourceforge.net/p/turbocash/bugs/596/

Removed duplicated From account hidden parameters.  

Debtor statements – TRN_1091.dfm (...\plug_ins\reports\systemreports\TRN_160\TRN_947\)

Debtor age analysis - Balances detail 1 – TRN_906148.dfm (...\plug_ins\reports\systemreports\TRN_160\TRN_65)

Creditor remittance advises – TRN_1089.dfm (...\plug_ins\reports\systemreports\TRN_161\TRN_947\)

Creditor Age Analysis – Balances detail 1 - TRN_906148.dfm (...\plug_ins\reports\systemreports\TRN_161\TRN_65) - Balances detail 1.

Added missing Date label translation in report parameters

https://sourceforge.net/p/turbocash/bugs/597/

Date label missing in the Tax report parameters

(...\plug_ins\reports\systemreports\TRN_906020)

Tax list debtor / creditor with tax id - TRN_3675.dfm

SPECIFIC FIXES TO REPORT

FIXED T-LEDGER ANALYSER - Save as Text Heading Totals – Debit / Credit

https://sourceforge.net/p/turbocash/bugs/580/
Save the Income Statement, Trial Balance, Balance sheet to a Text (.*txt) file type, the headings (i.e. Totals – Debit / Credit) are not displayed correctly in a Text file.

Report location : plug_ins\reports\GENERAL\ledgerview\detail.rep

Moved the Heading fields a bit for more space.

The headings are now formatted Correct in the text files.

Also set the vertical lines between debit and credit a bit narrower Width reduced from 0.049 to 0.031.

Log report

Userlog.rep (Location : \...plug_ins\reports\GENERAL\documents\)

Changed label 906051 - Log on report Title for the log report print out.

Cost centres 1 / 2 added to reports

Debtors – Transactions – Transactions – (...\plug_ins\reports\systemreports\TRN_160\TRN_74\TRN_74)

Creditors – Transactions – Transactions – (...\plug_ins\reports\systemreports\TRN_161\TRN_74\TRN_74)

Reports → Debtors → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_2222)

Reports → Debtors → Outstanding – Debtors outstanding at date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_906104)

Reports → Creditors → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_2222)

Reports → Creditors → Outstanding – Creditors outstanding at date – (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_906103)

Bank reconciliation report untranslatable labels

https://sourceforge.net/p/turbocash/bugs/487/

Unposted payments and Unposted receipts duplicated labels not translatable in bank reconciliation report.

Batch reports

Posted batches tab - Print

postedbatch.rep (Location : \...plug_ins\reports\GENERAL\documents\)

Moved and resized fields to display properly on PDF and HTML formats.

Batch list F8:List

batch.rep (Location : \...plug_ins\reports\GENERAL\documents\)

On multi-page Batch listing – Unposted batches, the Report name and Batch name and alias was only printing on the first page. On the second page and thereafter, only the Field labels were printing.  

Moved Report name and Batch name and alias From the Page header to Header – MAINGROUP.

It now prints on the second and pages thereafter.

Added a horizontal line for Totals

Moved and resized fields to display properly on PDF and HTML formats.

Added the Contra account description (account name) to Details report section.

Batch per period report

Batch per period - (Location : \...plug_ins\reports\systemreports\TRN_298\TRN_906141)

Too cramped for large amounts – moved and spaced the labels and expressions to read large amounts.

Added the Contra account description (account name) to Details report section.  


Data integrity check - Application Error

https://sourceforge.net/p/turbocash/bugs/585/

In the COMANYDATA Dataset is linked to SubReport-0. The P.Only data avail. (Print only data available) set to “False”.  

If it is changed to set to “True”, Application errors and or a crash and close of the Accounting.exe will occur. This will occur the first time, and thereafter, each time for the specific Set of Books (database) if the Data integrity is run.

If the P.Only data avail. (Print only data available) set to “False” in Report manager designer, the errors will only be replicated for that Set of Books. The other Sets of Books will not replicate these errors

Application Error -  Data integrity check

Exception TFieldDef in module unidac150.bpl at 0000AA94.

Application Crash -  Data integrity check

Sometimes it asks for the Password when running the Data integrity check and get a program crash. Close program automatically.

Ledger transaction reports – Ref.no label

The Ref. no label changed to Reference in Expressions of all General ledger transactions reports.

CUSTOM('GETTEXTLANG',906443,'Ref.No.',0,0,0)

Changed to

CUSTOM('GETTEXTLANG',607,'Reference',0,0,0)

This is done to be consistent with the Debtor / Creditor – Transaction reports

Debtors / Creditors

Debtors / Creditors listing

Added - Show contact details as an option on the report parameters for:

Debtors - Credit control listing (Credit limit vs Current balance) as at

Creditors - Credit control listing (Credit limit vs Current balance) as at

Added Reporting group 1 (List check box) to the parameters

https://sourceforge.net/p/turbocash/bugs/595/

Stock - Print labels

Added Reporting group 1 check list report parameters - To print only labels for Stock item barcodes linked to specific reporting group(s).

Reports Stock Print labels

...\plug_ins\reports\systemreports\TRN_1999\TRN_68\

oTRN_1774 – Barcode  

oTRN_906040 – Yagoda barcode

You may select the From stock item and To stock item on the parameters. In addition to this, you may select to print labels for a specific Reporting group 1 or selected Reporting groups 1.

Debtors / Creditors listing - Labels

Print labels - Delivery address and Postal address labels

Debtors - Postal address labels - Added Reporting group 1 check list report parameters - To print only labels for Debtors linked to specific reporting group(s).

Reports Debtors → Print labels 

...\plug_ins\reports\systemreports\TRN_160\TRN_68\

oTRN_906064 – Delivery address labels

oTRN_906137 – Postal address labels

You may select the From debtor account ... To debtor account on the parameters. In addition to this, you may select to print labels for a specific Reporting group 1 or selected Reporting groups 1.

Creditors - Postal address labels - Added Reporting group 1 check list report parameters - To print only labels for Creditors linked to specific reporting group(s).

Reports Creditors Print labels  

...\plug_ins\reports\systemreports\TRN_161\TRN_68\

oTRN_906064 - Delivery address labels

oTRN_906137 – Postal address labels

You may select the From creditor account ... To creditor account on the parameters. In addition to this, you may select to print labels for a specific Reporting group 1 or selected Reporting groups 1.

Debtors / Creditors Age analysis

NO LOOKUP parameters Debtor / Creditor - Age analysis – Balances detail 1

https://sourceforge.net/p/turbocash/bugs/589/

All Age analysis parameters included the From account and To account parameters in all versions of TurboCASH.

In later builds (after build 600) the Account lookup features, as well as the DAYS3 parameter, were not included in the report and parameters the Age analysis – Balances detail1 reports.  

Debtors - Balances detail 1 (...\plug_ins\reports\systemreports\TRN_161\TRN_65\TRN_906148.rep)  

Creditors - Balances detail 1 (...\plug_ins\reports\systemreports\TRN_161\TRN_65\TRN_906148.rep)  

Outstanding open item transaction totals

A list of transaction more than 1 for each debtor / creditor account was listed. Grouped these transactions for each debtor / creditor account with a total.

Debtors – Outstanding open item transaction totals (...\plug_ins\reports\systemreports\TRN_160\TRN_65\TRN_906144)

Creditors – Outstanding open item transaction totals (...\plug_ins\reports\systemreports\TRN_161\TRN_65\TRN_906144)

Age analysis reports


Normal Age analysis reports

Debtors – Age analysis - Balances detail (...\plug_ins\reports\systemreports\TRN_160\TRN_66\TRN_906142)

Added: Show transactions option - Can print balances only or balances and transactions or balances only with contact details or transactions and contact details.

Creditors – Age analysis - Balances detail (...\plug_ins\reports\systemreports\TRN_161\TRN_66\TRN_906142)

Added: Show transactions option - Can print balances only or balances and transactions or balances only with contact details or transactions and contact details.

Debtors - Outstanding Debtor statements (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_1090)

Creditors - Outstanding - Creditor remittance advises (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_1089)

Open item - Age analysis reports

Debtors – Age analysis - Balances detail history (open item) (...\plug_ins\reports\systemreports\TRN_160\TRN_66\TRN_906143) Added: Show transactions option - Can print balances only or balances and transactions or balances only with contact details or transactions and contact details.

Creditors – Age analysis - Balances detail history (open item) (...\plug_ins\reports\systemreports\TRN_161\TRN_66\TRN_906143) Added: Show transactions option - Can print balances only or balances and transactions or balances only with contact details or transactions and contact details.  

You may also print Transaction list - Open item reports:

Debtors – Transactions - Transaction list - Open item (...\plug_ins\reports\systemreports\TRN_160\TRN_66\TRN_906061)

Creditors – Transactions - Transaction list - Open item (...\plug_ins\reports\systemreports\TRN_161\TRN_66\TRN_906061)

Debtors - Outstanding - Debtors statements - Outstanding (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_1090)

Creditors - Outstanding - Creditor remittance advises - Outstanding (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_1089)

Debtor / Creditor - Outstanding

Debtors

Reports → Debtors → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_2222)

Reports → Debtors → Outstanding – Debtors outstanding at date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_906104)

Creditors

Reports → Creditors → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_2222)

Reports → Creditors → Outstanding – Creditors outstanding at date – (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_906103)

Created with the Personal Edition of HelpNDoc: Easy EPub and documentation editor