Release notes (Build 969) - Reports
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 Estimates 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 → Customers – 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 customer accounts (Customers - 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 (Inventory 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.
https://sourceforge.net/p/turbocash/bugs/594/
See https://sourceforge.net/p/turbocash/feature-requests/98/ - #98 Multiple currencies vendor.
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.
https://sourceforge.net/p/turbocash/bugs/593/
Inventory Tax Class report lists (Reports → Inventory item listing - Tax classes (Reports ribbon) (the Tax classes added inInventory information (Setup ribbon). You may select on the parameters to list the Inventory classes by ID or Description.
Customer / Vendor listing reports Reporting group 1 added. Once you have selected the accounts, you may select to print the report for Customer vendor 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).
Zip code and Account codes overlapped.
The following five (5) reports for posted invoices and credit notes does not support 15 characters in the inventory code when Credit notes are included:
1.Sales per period - Customer group 1 -
2.Sales per period - Customer group 2 -
3.Sales per period - Document group 1 -
4.Sales per period - Document group 2 -
5.Sales per period - Salesperson -
Added the following reports to print Customer statements and Vendor remittance advices with linked transactions (Open item link) - It now prints only the outstanding (unlinked transactions).
Added: Customers statements - Outstanding
Added: Vendor remittance advices - Outstanding
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 Journals references.
•Tax list customer / vendor with taxid changed the language label - TRN_3675 to Tax list customer with tax id (Only displays the Customer documents for type 10 Invoices and 11 Credit notes). and added a new language label 906553 Tax list vendor with tax id and added a new report to show the vendor account and transaction / tax details (documents for type 12 Purchases and 11 Supplier returns).
FIXES -
•Standadized parameters FROMSTOCKCODE … TOSTOCKCODE on printout with other Inventory 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 - Inventory group 1
•TRN_906175 - Sales per product - Inventory group 2
FIXES -
•Standadized parameters FROMSTOCKCODE … TOSTOCKCODE on printout with other Inventory 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 - Inventory group 1
•TRN_906173 - Purchases per product - Inventory group 2
TRN_302 Purchases
TRN_1269 Purchase documents
TRN_161 Vendors
TRN_906150.rep Purchases per period - Quantities
Set the total font from 9 to 10 to be in line with other reports
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 Customers
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 Vendors
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 Estimates
TRN_160 Customers
TRN_906315.rep Estimates per period - Quantities
TRN_300 Invoices
TRN_160 Customers
TRN_906155.rep Invoices per period - Quantities
TRN_47 Credit notes
TRN_160 Customers
TRN_906311.rep Credit notes per period - Quantities
TRN_302 Purchases
TRN_1269 Purchase documents
TRN_161 Vendors
TRN_906150.rep Purchases per period - Quantities
TRN_1871 Orders
TRN_161 Vendors
TRN_906317.rep Orders per period - Quantities
TRN_303 Supplier returns
TRN_161 Vendors
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 Estimates
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 Estimates
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 - Inventory group 1
TRN_906175.rep Sales per product - Inventory group 2
TRN_977 Purchase Analysis
TRN_3575 Purchases per product
TRN_906172.rep Purchases per product - Inventory group 1
TRN_906173.rep Purchases per product - Inventory group 2
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!”
https://sourceforge.net/p/turbocash/bugs/599/
Report print layout in different file types overlapping.
Headers and Footers
Standardized 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.
journal.rep – Location (...\plugins\reports\GENERAL\documents\)
Printed frames around Account expressions
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 ,
•SInventoryReportName2 ,
Old COMANYSATA Dataset |
Updated COMANYSATA Dataset |
|
Select a.*, SCompanyName , SCompanyRegNo , SEmailAddress , SAddress1 , SAddress2 , SAddress3 , SPostCode , SPhoneNumber , SFaxNumber , STaxRegNo , SAccountReportName1 , SAccountReportName1 , SCustomerReportName1 , SCustomerReportName2 , SVendorReportName1 , SVendorReportName2 , SInventoryReportName1 , SInventoryReportName1 , 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 , SCustomerReportName1 , SCustomerReportName2 , SVendorReportName1 , SVendorReportName2 , SInventoryReportName1 , SInventoryReportName2 , SBANKNAME1, SBANKNAME2, SBANKNUMBER2, SBANKNUMBER1, SBANKSWIFT1, SBANKIBAN1, SBANKSWIFT2, SBANKIBAN2, SBANKACCOUNTNAME1, SBANKACCOUNTNAME2, SBANKBIC1, SBANKBIC2 from Sysvars , sysvarsext a |
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).
Split Account code and Description parameters to separate expressions in reports. It is easier to sort the data (Code and Description) columns in spreadsheets.
https://sourceforge.net/p/turbocash/bugs/598/
Aligned the Properties of parameters to have the same top, left, height and width sizes. Should standardize the report parameter screens.
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).
https://sourceforge.net/p/turbocash/bugs/596/
Removed duplicated From account hidden parameters.
•Customer statements – TRN_1091.dfm (...\plug_ins\reports\systemreports\TRN_160\TRN_947\)
•Customer age analysis - Balances detail 1 – TRN_906148.dfm (...\plug_ins\reports\systemreports\TRN_160\TRN_65)
•Vendor remittance advices – TRN_1089.dfm (...\plug_ins\reports\systemreports\TRN_161\TRN_947\)
•Vendor Age Analysis – Balances detail 1 - TRN_906148.dfm (...\plug_ins\reports\systemreports\TRN_161\TRN_65) - Balances detail 1.
https://sourceforge.net/p/turbocash/bugs/597/
Date label missing in the Tax report parameters
(...\plug_ins\reports\systemreports\TRN_906020)
Tax list customer / vendor with tax id - TRN_3675.dfm
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.
Userlog.rep (Location : \...plug_ins\reports\GENERAL\documents\)
Changed label 906051 - Log on report Title for the log report print out.
•Customers – Transactions – Transactions – (...\plug_ins\reports\systemreports\TRN_160\TRN_74\TRN_74)
•Vendors – Transactions – Transactions – (...\plug_ins\reports\systemreports\TRN_161\TRN_74\TRN_74)
•Reports → Customers → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_2222)
•Reports → Customers → Outstanding – Customers outstanding at date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_906104)
•Reports → Vendors → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_2222)
•Reports → Vendors → Outstanding – Vendors 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.
postedbatch.rep (Location : \...plug_ins\reports\GENERAL\documents\)
•Moved and resized fields to display properly on PDF and HTML formats.
journal.rep (Location : \...plug_ins\reports\GENERAL\documents\)
•On multi-page Journal listing – Unposted journals, the Report name and Journal 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 Journal 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.
Journal 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.
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.
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 Customer / Vendor – Transaction reports
Added - Show contact details as an option on the report parameters for:
•Customers - Credit control listing (Credit limit vs Current balance) as at
•Vendors - Credit control listing (Credit limit vs Current balance) as at
https://sourceforge.net/p/turbocash/bugs/595/
Added Reporting group 1 check list report parameters - To print only labels for Inventory item barcodes linked to specific reporting group(s).
Reports → Inventory → Print labels
...\plug_ins\reports\systemreports\TRN_1999\TRN_68\
oTRN_1774 – Barcode
oTRN_906040 – Yagoda barcode
You may select the From inventory item and To inventory 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.
Print labels - Delivery address and Postal address labels
•Customers - Postal address labels - Added Reporting group 1 check list report parameters - To print only labels for Customers linked to specific reporting group(s).
Reports → Customers → 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 customer account ... To customer 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.
•Vendors - Postal address labels - Added Reporting group 1 check list report parameters - To print only labels for Vendors linked to specific reporting group(s).
Reports → Vendors → 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 vendor account ... To vendor 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.
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.
•Customers - Balances detail 1 (...\plug_ins\reports\systemreports\TRN_161\TRN_65\TRN_906148.rep)
•Vendors - Balances detail 1 (...\plug_ins\reports\systemreports\TRN_161\TRN_65\TRN_906148.rep)
A list of transaction more than 1 for each customer / vendor account was listed. Grouped these transactions for each customer / vendor account with a total.
•Customers – Outstanding open item transaction totals (...\plug_ins\reports\systemreports\TRN_160\TRN_65\TRN_906144)
•Vendors – Outstanding open item transaction totals (...\plug_ins\reports\systemreports\TRN_161\TRN_65\TRN_906144)
•Customers – 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.
•Vendors – 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.
•Customers - OutstandingCustomer statements (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_1090)
•Vendors - Outstanding -Vendor remittance advices (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_1089)
•Customers – 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.
•Vendors – 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:
•Customers – Transactions - Transaction list - Open item (...\plug_ins\reports\systemreports\TRN_160\TRN_66\TRN_906061)
•Vendors – Transactions - Transaction list - Open item (...\plug_ins\reports\systemreports\TRN_161\TRN_66\TRN_906061)
•Customers - Outstanding - Customers statements - Outstanding (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_1090)
•Vendors - Outstanding -Vendor remittance advices - Outstanding (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_1089)
•Reports → Customers → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_2222)
•Reports → Customers → Outstanding – Customers outstanding at date – (...\plug_ins\reports\systemreports\TRN_160\TRN_947\TRN_906104)
•Reports → Vendors → Outstanding – Due date – (...\plug_ins\reports\systemreports\TRN_161\TRN_947\TRN_2222)
•Reports → Vendors → Outstanding – Vendors 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