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

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

This is replicated in the following releases on Sourceforge 

Fixes after the following releases on Sourceforge

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

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


The parameters Type of Control referred to General ledger account type instead of Debtor account type
Debtor transaction reports TRN_906106.zip attached - Unzip and replace 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

The parameters Type of Control referred to General ledger account type instead of Debtor account type
Creditor transaction reports TRN_906108.zip attached - Unzip and replace 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

Fixes in the Parameters
ALL and WAccountTypeid in (1)
ALL and WAccountTypeid = 1

Type of Control
OA Lookup all GL accounts
OD Lookup Debtors
Column origin
SACCOUNTCODE
FROMACCOUNT
SACCOUNTCODETO
TOACCOUNT

2 Attachments

TRN_906106.zip

TRN_906108.zip

The "Debtor transactions - Standard" and "Debtor transactions - Extra details" report lists all the transactions in documents and batches which are posted (updated) to the ledger. 

The "Debtor transactions - Extra details" report is similar to the "Debtor transactions - Standard" report, but displays extra details of the Contra accounts (i.e. Account code, Account description, Contra account code and Description as well as the Tax account code and Description). For example; 

" G010000  Sales,T860010,  Output VAT - 15% ", etc. 

Report options

To print Debtor transactions - Standard /  Debtor transactions - Extra details reports: 

1.On the Reports ribbon, select Reports → Debtors → Transactions. The "Transactions" report options will be displayed.

2.Select the "Debtor transactions - Standard" or "Debtor transactions - Extra details" report.

debtor-transactions-standard-report-options

3.Select the following options:  

a)Period - Select a period on the Per period tab. You may click on the Free selection tab to select a specific date or a range of dates to include transactions in the report. 

b)From ... To - Select a debtor (customer / client) account or a range of debtor (customer / client) accounts, to include in the report. 

c)Sequence - Select "Debtor code" to print the report by account code or "Description" to print the report by account description (name).

d)Include zero balances - If this option is not selected (not ticked), it will list only the transactions for accounts which has transactions and / or balances. Tick this option to include opening balances (closing balances before the selected periods / dates). 

f)New page per account - If this option is selected (ticked), it will print the transactions for each account on a new page.

The Company details will not be printed as in the Page header. The company name is displayed in the Page footer.

g)Cost centre 1 / 2 - If you have activated Cost centres, you may select the Cost centres.

4.Click on the OK button. 

Printed example : Debtor transactions - Standard

An example of the "Debtor transactions - Standard" report, is as follows:

debtor-transactions-standard-report-print

Printed example : Debtor transactions - Standard - Balances

An example of the "Debtor transactions - Standard" report, showing balances, is as follows:

debtor-transactions-standard-report-balances


Printed example : Debtor transactions - Extra details

An example of the "Debtor transactions - Extra details" report, is as follows:

debtor-transactions-extra-detail-report-print

Printed example : Debtor transactions - Extra details - Balances

An example of the "Debtor transactions - Extra details" report, showing balances, is as follows:

debtor-transactions-extra-detail-balances

The details on the report, is as follows:

1.Page header 1 - Company details - This will only print on the fist page. 

If the New page per account option on the report parameters is selected (ticked), the Company details will not be printed in the Page header of the first page. The company name is displayed in the Page footer of all pages.

2.Page header 2 - Report Name and Parameters as selected on the Report options will display below the Company details on the first page and at the top of each subsequent page. 

3.Header group - The Account code and Name (description). It also displays the date and opening balances of the previous year. 

4.Detail - List the transaction details for each account. 

a)Date - The date of the transaction or document. 

b)Reference - The reference number of the document (i.e. Invoices and Credit notes) or the reference number entered in the reference column on the "Batch entry" screen. 

c)Description - The stock item code or the account description (if the Financial entry stock item type was selected on a document) of the document (i.e. Invoices and Credit notes) or the description entered in the description column on the "Batch entry" screen. 

d)Debit - The debit transaction amount.

e)Credit - The credit transaction amount. 

f)Cum - The accumulative total of the transactions included in the account. 

5.Footer - Groups - Total / Balance - Displays the total of the transactions and the closing balance for each account. 

6.Page Footer - List the following: 

a)Data - Name of the Set of Books and the full path of the Set of Books (e.g. ...\books\BOOKSNAME\Books.fdb) 

b)System user and TurboCASH user (Access control on the Setup ribbon). 

c)Printed: The date and time of the system (computer) on which the report is printed. 

d)Page: Page number and the last page number of the report.