Reports → Debtors → Outstanding at date and Reports → Creditors → Outstanding at date reports:

Cost centres are available on the parameters screen, but not implemented. 

This report will list all the transactions before and on a selected period (date). It will list the details for each transaction (i.e. Reference No., Date, Due date, Debit, Credit and the accumulative balance for each of the debtor (customer / client) accounts.

If a debtor (customer / client) account is set as an “Open item” account (Debtor - Accounting information tab on the Action ribbon) , it will list only those transactions with outstanding amounts. Any credit amounts, which are not linked to debit transactions, should be processed in the Open item link on the Action ribbon.

To print Debtor - Due date reports: 

1.On the Reports ribbon, select Reports → Debtors → Outstanding. 

2.Select "Due date" report.

cost-centre-debtor-due-date-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. All the transactions which are outstanding on or before the end date of the periods will be listed. 

b)From account ...To account  - 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)Show contact details - If this option is not selected (not ticked), it will list only the transactions. Tick this option to include the details  (i.e. postal address, delivery address, and contact details). 

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

f)Cost centre 1 - Will be listed, as Cost centres have been added to “Cost centre 1” (Groups (Setup ribbon)). You may select these Cost centres, to include in the report. 

g)Cost centre 2 – The “Empty” tick box and no cost centres will be listed, since no Cost centres were added in ”Cost centre 2” (Groups (Setup ribbon)). 

4.Click on the OK button. 

The printed “Debtors – Due date” report (no Cost centres selected), should be displayed as follows:

cost-centre-debtor-due-date-print-all

Balances – Debtor Transactions 

The “Debtor's control” account balance for the actual posted (updated to the ledger) transactions (in Batches and Documents); is as follows:

Total Debtor's control (including “Cost centre A1” and “Cost centre B1”)        14 250

Only “Cost centre A1”                                                                                       8 550

Only “Cost centre B1”                                                                                       5 700

The printed “Debtors – Due date” report, for “Cost centre A1” selected, should be displayed as follows: 

cost-centre-debtor-due-date-print-A1

Balances – Debtor Transactions - “Cost centre A1”

The account balances for the actual posted (updated to the ledger) transactions (in Batches and Documents); is as follows:

Total Debtor's transactions for “Cost centre A1”         8 550

 “Mike Davies”                                                            2 850

 “Roger Smith”                                                            5 700

The printed “Debtors – Due date” report, for “Cost centre B1” selected, should be displayed as follows: 

cost-centre-debtor-due-date-print-B1

Balances – Debtor Transactions - “Cost centre B1”

The account balances for the actual posted (updated to the ledger) transactions (in Batches and Documents); is as follows:

Total Debtor's transactions for “Cost centre B1”         5 700

 “AB Green”                                                                 2 280

 “MAC Decor Specialists”                                            1 710

 “Mike Davies”                                                            1 710