CITADEL BUSINESS SYSTEM DOCUMENTATION
ACCOUNTS RECEIVABLE
TRAINING REFERENCE NOTES v14.1
Table of Contents AR CASH RECEIPTS AR CASH RECEIPTS 2 AR CASH RECEIPTS - CHANGE CREDIT LIMIT AR CASH RECEIPTS BY INVOICE RECEIPT CASH TO MULTI CUSTOMERS BANK DEPOSIT PRINT BANK DEPOSIT REPRINT CASH SALES DEPOSIT SCHEDULE PRINT AR JOURNAL ENTRY WRITEOFF SMALL BALANCES DIARY NOTE ENTRY DIARY NOTE MAINTENANCE DIARY NOTE LIST INVOICE MESSAGE MAINTENANCE STATEMENT MESSAGE MAINTENANCE STATEMENTS STATEMENT REPRINT STAND ALONE STATEMENT RUN AR ENQUIRY AR ONE CHEQUE TO MULTIPLE CUSTOMER ENQUIRY CUSTOMER ENQUIRY INVOICE REPRINT AR OPEN ITEM TRIAL BALANCE AR SUMMARY TRIAL BALANCE BRANCH AR SUMMARY SUMMARY TRIAL BALANCE (12 MTH) SUMMARY TRAIL BALANCE WITH INSTALMENTS SUMMARY TRAIL BALANCE BY REP BRANCH AR SUMMARY BY ORDER LINE AR TRANSACTION LIST AR HISTORY REPORT ON ACCOUNT CASH LIST ON ACCOUNT TRANSFER HISTORY CUSTOMER ABC ANALYSIS SUMMARY TB BY OVERDUE DAYS AR OVERDUE DAYS MAINTENANCE PRINT AR LETTERS
Printed on 3/26/2004
DD.ARCASHREC1 ............. 2 DD.ARCASHREC2 ............. 4 DD.ARCASHREC5 ............. 5 DD.ARINVCASH................. 6 DD.MULTICASHREC........ 8 DD.BANKDEPRINT ......... 10 DD.BDREPRINT ............... 11 DD.BANKCASH ................ 12 DD.ARJNLENTRY ........... 13 DD.ARWRITEOFF ........... 15 DD.CUSTDIARYENTRY . 17 DD.CUSTDIARYMAINT . 18 DD.CUSTDIARYLIST...... 19 DD.INVMSGMAINT......... 20 DD.STATMSGMAINT ..... 21 DD.STATEMENT.............. 22 DD.STATREPRINT .......... 23 DD.STATRUN.................... 24 DD.ARENQ ........................ 25 DD.MLTCHQENQ............ 27 DD.CUSTENQ1 ................. 28 DD.REPRINTINV ............. 29 DD.OITB............................. 30 DD.ARSUMMTB ............... 31 DD.ARBRSUMM............... 33 DD.ARTB............................ 34 DD.ARITB .......................... 35 DD.ARREPTB.................... 36 DD.AROTSUMM............... 37 DD.ARTRANSLIST .......... 38 DD.ARCUSTENQ.............. 39 DD.OALIST........................ 40 DD.OATFRLIST................ 41 DD.ABCCUST.................... 42 DD.ARSUMMTBD ............ 43 DD.ARODAYSMAINT ..... 45 DD.ARLETTER................. 46
Accounts Receivable Training Reference Notes v14.1
i
AR cash receipts
DD.ARCASHREC1
Testing & Development Pty Ltd 29 JAN 98 10:27 DD.ARCASHREC1 Kyocera 76 peter DD 1999 Bank number __ ______________________________ Source branch ________ Operator ___ ______________________________ ____________________________ Customer ________ Credit limit 999999999 ______________________________ Br# ______ _______________________ ______________________________ ______________________________ ______________________________ ______________________________ ___________ 9999999.99___________ 9999999.99___________ 9999999.99___________ 9999999.99___________ 9999999.99___________ 9999999.99___________ 9999999.99___________ 9999999.99Cheque number __________ Receipt date ________ Drawer ______________________________ Bank ______ Branch ______________________________ Cheque amount 1111111.11** DEVELOPMENT ** COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
Accounts receivable cash entry allows bank deposit schedule detail to be entered and the cash to be applied to outstanding invoices. The front screen allows the detail to be entered for the bank deposit slip and for the customer to be identified. Each cheque entered must be fully applied on screen two. The total of all cheques entered is kept to balance back to control add tapes. On exiting from the process the bank deposit schedule can be automatically produced or printed on demand using the print bank deposit slip process. Interface entries to the general ledger are: debit bank account credit trade debtors The front screen is also used to specify that "on account" amounts are to be applied to outstanding invoices or transfers to another customer. This is done by not inserting a cheque number in the cheque number field. No interface entry or bank deposit schedule entry occur unless the amount nominated to be allocated is transferred to another debtor account which is held in a different branch in which case general ledger interface entries are generated. Bank number: Enter the bank account that the cash is being deposited in. A "?" will display all codes. If the bank account entered is a foreign currency bank account then banking can only be done for debtors with the same currency. Source branch: The branch that is the source of the transaction can be specified and then used for reference purposes. Operator: Enter the operator. A “?” will display all operators Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 2
Customer: Enter the customer the cash is received from. Note that the customer's currency and the bank currency must be identical for the customer to be valid. If the process is to be exited RETURN. Cheque number: Enter the cheque number of the cheque being banked. If no cheque number is entered the user is given an option to allocate cash already banked and held "on account". Drawer: This field defaults to the customers name. If the cheque being banked has been drawn by a third party this may be overwritten. The name entered will appear on the bank deposit schedule. Bank: Enter the name of the bank of the cheque being banked. This will appear on the bank deposit schedule. The field will default to the bank account last entered for the debtor but may be overridden. Branch: Enter the branch of the bank of the cheque being banked. This will appear on the bank deposit schedule. The field will default to the branch last entered for the debtor but maybe overridden. Cheque amount: Enter the value of cheque being banked. This will appear on the bank deposit schedule.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 3
AR cash receipts 2
DD.ARCASHREC2
Citadel Service, Distribution & Financial systems 24 JAN 01 11:21 TCL MAIL Kyocera 50 bertw DD 1023 Customer 99999999 Currency ___ Chq amt 1111111.11 A/r balance 9999999.99 ______________________________ Applied 1111111.11 On account 9999999.99 Balance 1111111.11 Batch total 9999999.99 Date Trn Invoice Reference Amount Balance Applied __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ __________________________________________________ 9999999.99- __________ ** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The back screen of accounts receivable cash receipts lists all outstanding invoices, plus transactions already entered against them, for the debtor nominated on the front screen. It allows the cheque amount as entered on the front screen to be applied against specific invoices or put "on account" for the debtor. Until the total amount of the cheque is applied there is no exit from the screen unless the cheque is totally bypassed. The amount applied plus the balance to be applied are continuously updated to inform the user of his position. The batch total indicates the value of the bank deposit schedule inclusive of the cheque being applied. The accounts receivable balance are updated on exit from the screen. When applying the cheque available facilities for the user are to apply the cheque to individual transactions or to automatically apply amounts to outstanding invoices. This is however, dependant on the program parameter settings. Amount: Enter the amount to be applied against each invoice. Continue until the total amount applied equals the value of the cheque. A "." will pick up the balance outstanding on the invoice.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 4
AR cash receipts - change credit limit Citadel Service, Distribution & Financial systems TCL MAIL Customer 99999999 ______________________________ Currency
DD.ARCASHREC5 24 JAN 01 11:23 Kyocera 50 bertw DD 1023
___
Old credit limit
999999999
New credit limit
999999999
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The change credit limit screen that is accessed during the AR cash receipts process displays the customers current credit limit and allows maintenance to be done to this figure. Any changes made update the customer database automatically. New credit limit: Enter the new credit limit that is to apply to the customer. The customer database will be maintained to reflect the limit entered.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 5
AR cash receipts by invoice
DD.ARINVCASH
Testing & Development Pty Ltd 29 JAN 98 11:41 DD.ARINVCASH Kyocera 87 peter DD 1999 Bank number __ ______________________________ Batch total 9999999.99Source branch ________ ______________________________ Cheque number __________ Cheque receipt date ________ Invoice number __________ Customer ________ ______________________________ On account 9999999.99Current 9999999.991-month 9999999.992-months 9999999.993-months 9999999.99Balance due 9999999.99Drawer ______________________________ Bank ______ Branch ______________________________ Invoice date ________ Amount due 1111111.11Applied amount 1111111.11** DEVELOPMENT **
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The A/R cash receipts by invoice screen allows cash received to be entered by referencing the invoice being paid in the first instance. This then determines the customer that the payment is from. The banking then proceeds in the normal manner with the amount input put on the bank deposit schedule and the general ledger updates done. The process is useful where cash received is identified by an invoice that is being paid rather than who is paying it. Each invoice paid will normally become an entry on the bank deposit schedule. This happens if the bank deposit schedules are produced using the option “bank deposit print” or “bank deposit print by cheque number”. However, if the option bank deposit print with cheque totals is taken each cheque is totalled in addition to showing its detail. This means that more than one customer's account can be updated with one cheque. Bank account: Enter the bank account that the cash is being deposited into. A "?" will display all codes. If the bank account entered is a foreign currency bank account then banking can only be done for debtors with the same currency. Source branch:
Cheque number: Enter the cheque number of the cheque being banked. If the cheque has already been banked for the customer the user will be warned. The customer is determined following invoice entry. To exit RETURN and take the option (Y)es.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 6
Cheque receipt date:
Invoice number: Enter the invoice number that the cheque being entered is in payment of. The invoice must exist and still be owing. If just the order number is entered the first delivery of the order is used to determine the invoice number. If payment is for any delivery other than the first delivery the full invoice number must be entered. After the invoice number is entered detail of the amount owing on the customer's account is displayed along with the amount owing on the invoice being paid. Drawer: This field defaults to the customers name. If the cheque being banked has been drawn by a third party this maybe overwritten. The name entered will appear on the bank deposit schedule. Bank: Enter the name of the bank of the cheque being banked. This will appear on the bank deposit schedule. The field will default to the bank account last used for the debtor but maybe overridden. Branch: Enter the branch of the bank of the cheque being entered. This will appear on the bank deposit schedule. The field will default to the branch last entered for the debtor but maybe overridden. Applied amount: The amount will default to the outstanding value of the invoice that is being paid. This maybe accepted by RETURN or the amount entered as required.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 7
Receipt cash to multi customers
DD.MULTICASHREC
Citadel Service, Distribution & Financial systems 21 JAN 01 15:47 TCL MAIL Kyocera 12 bertw DD 1023 Bank number ___ _______________________________________________ Operator ___ _______________________________________________ Drawer ____________________________________________________ Bank _______________________ Branch _______________________ Cheque number ____________ Receipt date __________ Cheque amount 111111111.11- Entered amount 1111111.11Balance 1111111.11Customer ______ ___________________________________ ___________________________________ ___________________________________ ___________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ Customer amount to apply 111111.11** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The accounts receivable one cheque to multiple customers process allows one cheque to be entered and invoices from multiple customer accounts to be marked as paid. Only one entry is printed on the bank deposit schedule. General ledger entries for cash receipted are debit bank account credit trade debtors (by branch) Controls are kept during the entry process to ensure the full amount of the cheque is allocated to customers accounts. The process consists of 2 screens - one to enter details of the cheque and the second to allocate cash against specific customers invoices. Bank number: Enter the bank account that the cash is being deposited in. A “?” will display all codes. If the bank account entered is a foreign currency bank account then banking can only be done for debtors with the same currency. Operator: Enter the operators number. A “?” will display all codes. Drawer: Enter the drawers name. The name entered will appear on the bank deposit schedule. Bank: Enter the name of the bank of the cheque being banked. This will appear on the bank deposit schedule.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 8
Branch: Enter the branch of the bank of the cheque being banked. This will appear on the bank deposit schedule. Cheque number: Enter the cheque number of the cheque being banked. Receipt date: Enter the receipt date. This field defaults to the system date. Cheque amount: Enter the value of cheque being banked. This will appear on the bank deposit schedule. Customer: Enter the customers number or an alpha string to access the required customer by the search key. Note the customers currency and the bank currency must be identical for the customer to be valid. Customer amount to apply: Enter the amount of cash received from the customer referenced.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 9
Bank deposit print
DD.BANKDEPRINT
Citadel Service, Distribution & Financial systems TCL MAIL Bank number __ ______________________________ User id
____ ____ ____ ____ ____
____________________ ____________________ ____________________ ____________________ ____________________
Branch
______
______________________________
Dep. date
________
** DEVELOPMENT **
24 JAN 01 11:27 Kyocera 50 bertw DD 1023
(ONLY FOR RETAIL)
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The bank deposit print screen is used to print the bank deposit schedules that have been accumulating. Counter sales cash receipts automatically accumulate with other bank deposits accumulating if the function parameter is so set. Bank deposit schedules are printed by reference to the user who initiated the entries on the schedule. Bank number: The bank account will default from the program parameter setting but may be changed to the bank that the deposit schedule is being printed for. User id: Enter the id of the user that the bank deposit schedule is to be printed for. This id relates to the user id who was responsible for the entries on the bank deposit schedule through a/r cash entry, or counter sales cash entry. Branch:
Dep. Date:
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 10
Bank Deposit Reprint
DD.BDREPRINT
Citadel Service, Distribution & Financial systems TCL MAIL Bank deposit# ______ Bank
__
Date
________
Amount
9999999.99-
______________________________
(P)rinter or (S)creen
** DEVELOPMENT **
24 JAN 01 11:28 Kyocera 50 bertw DD 1023
_
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The bank deposit reprint facility allows bank deposit schedules to be reprinted. Bank Deposit: Enter the bank deposit number to be reprinted.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 11
Cash sales deposit schedule print Testing & Development Pty Ltd DD.BANKCASH Bank account
___
Customer account#
________
(P)rinter or (S)creen
** DEVELOPMENT **
DD.BANKCASH 29 JAN 98 11:52 Kyocera 87 peter DD 1999
______________________________ ______________________________
_
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The cash sales deposit schedule print is used to print bank deposit schedules for customers flagged as “cash sales”. These automatically accumulate in sales order processing. Bank number: The bank account will default to the account nominated but may be changed to reflect the required bank that the deposit schedule is being printed for. Customer no.: Enter the customer number or use the search facilities to access the required customer. Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 12
AR journal entry
DD.ARJNLENTRY
Citadel Service, Distribution & Financial systems 24 JAN 01 11:35 TCL MAIL Kyocera 50 bertw DD 1023 Customer ________ ____________________________________________________ Date ________ Reference __________ Open amount 9999999.99- ___ AR amount 9999999.99- ___ Posting amt 9999999.99- ___ Applied 9999999.99- ___ Balance 9999999.99- ___ GL code Amount Detail ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ______________________ 1111111.11- ______________________________ ** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The accounts receivable journal entry screen allows adjustments to be made to debtors accounts. Adjustments would include the writing off of invoices to bad debts, reversing dishonoured cheques etc. The user is prompted for a reference number which must be a valid invoice for that debtor. The accounts receivable amount entered (positive or negative) updates the debtors account and the general ledger (accounts receivable). The double entry to the general leger is done by entering an appropriate general ledger code ie. bad debts. Comments entered are shown in the general ledger. A journal entry number is allocated to the transaction. The journal appears on the journal audit report. If the customer's account is held in a foreign currency then the A/R amount entered must also be in that currency. This value will be converted to local currency at the file exchange rate for general ledger posting purposes. Customer: Enter the customer number or use the search facilities to access the required customer. Date: Enter to accept the system date. This can be overwritten in the format dd.mm. Reference: Enter a valid invoice reference for the debtor nominated. The journal will attach itself to this reference. If a reference is entered that is not a valid invoice the journal will sit in the customers A/R file as an independent transaction. The operator is prompted for this to be allowed.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 13
Accounts receivable amount: Enter the amount the accounts receivable record is to be adjusted by. This can be positive or negative. The amount is entered in the currency of the debtor. The subsidiary ledger will be updated by the value entered. The general ledger will be updated by the value entered converted by the file exchange rate. If applicable, realised and unrealised gains/loss entries are also posted to the general ledger (these entries occur when a entry is being matched with a transaction already on file and the transaction was entered at a different exchange rate). General ledger code: Enter the general ledger code that is to form the double entry in the general ledger. The format is defined in the G/L code definition file. Amount: Enter the amount that is to be posted to the General Ledger account nominated. This is entered in local currency. Detail: Enter a narrative comment for the journal. This will appear on the journal audit report and in the general ledger.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 14
Writeoff small balances
DD.ARWRITEOFF
Testing & Development Pty Ltd 29 JAN 98 12:00 DD.ARWRITEOFF Kyocera 87 peter DD 1999 For all customers with currency ___ ______________________________ and with a balance in the range 111.11- to 111.11- write off the balance to GL account __________ ______________________________ Branch
________ ________ ________ ________ ________
______________________________ ______________________________ ______________________________ ______________________________ ______________________________
(P)rinter or (S)creen
** DEVELOPMENT **
_
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The write off small A\R balance facility allows A\R balances that are between specified amounts to be written off automatically. An AR journal is done to each account affected. The double entry account is nominated each time the process is run. Currency: Specify the currency that the small balances are to be written off for. The search facilities can be used to access the required currency code. Start balance: Enter the start of the range of the small balances that are to be written off. This should relate to the currency that has been specified. End balance: Enter the amount that specifies the end of the range of the small balances that are to be written off. The value entered should relate to the currency specified. General ledger account: Enter the general ledger account code that the small balances that are to be written off are to be coded to. Branch:
Printer or screen:
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 15
Write off small transactions
DD.ARTWRITEOFF
Testing & Development Pty Ltd 29 JAN 98 12:33 DD.ARTWRITEOFF Kyocera 87 peter DD 1999 For all customers with currency ___ ______________________________ write off all AR transaction balances in the range 111.11- to 111.11- to GL account __________ ______________________________ For transactions older than ________ Branches
________ ________ ________ ________ ________
______________________________ ______________________________ ______________________________ ______________________________ ______________________________
(P)rinter or (S)creen
** DEVELOPMENT **
_
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The write off small AR transaction facility allows AR transactions that are between specified amounts to be written off automatically. An AR journal is done to each account affected. The double entry is nominated each time the process is run. Currency: Specify the currency that the small transactions are to be written off for. The search facilities can be used to access the required codes. Start Balance: Enter the start of the range of the small transactions that are to be written off. This should relate to the currency that has been specified. End Balance: Enter the amount that specifies the end of the range of the small transactions that are to be written off. This should relate to the currency specified. General ledger account: Enter the general account code that the small transactions that are to be written off are to be coded to. Branches:
Printer or screen:
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 16
Diary note entry
DD.CUSTDIARYENTRY
Citadel Service, Distribution & Financial systems 24 JAN 01 11:40 TCL MAIL Kyocera 50 bertw DD 1023 Customer ________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ Recall date ________ (H)old _ Text : ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The diary note entry screen allows diary notes to be entered for a specified customer. Each note entered is allocated a number on update for maintenance and reference purposes. These notes can be accessed via the diary note recall process or accessed from AR enquiry. The recall process allows customers and recall dates to be specified. The option at AR enquiry recalls all the notes pertaining to the customer. Customer: Enter the customer code or use the search facilities to access the required customer. The customer's name and address will display. Recall date: Enter the date that the diary note is required to be recalled on. The format is dd.mm.yy. Hold option: Specify if the diary note is to be held in the event of the diary note purge processes being run. The hold flag must be removed before the diary note can be purged. Text: Enter the text or narrative detail of the diary note. This can be unlimited. A "." at the start of a line signals the end of text entry and allows the note to be updated.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 17
Diary note maintenance
DD.CUSTDIARYMAINT
Citadel Service, Distribution & Financial systems 24 JAN 01 11:41 TCL MAIL Kyocera 50 bertw DD 1023 Diary note# 999999 Entered by 9999 ______________________________ ________ _____ Customer ________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ Recall date ________ (H)old _ Text : ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The diary note maintenance screen allows maintenance to be done on diary notes. This maintenance can cover text, the diary notes recall date, and whether the diary note is to be held (ie. excluded from the diary note purge process). Diary note number: Enter the number of the diary note that maintenance is required for. The diary note will display. All fields can be maintained. Recall date: Enter the date that the diary note is to be recalled on. The format is dd.mm.yy. Hold option: Specify if the diary note is to be held in the event of the diary note purge process being run. The hold flag must be removed before the diary note can be purged. Text: Enter the text or narrative detail of the diary note. This can be unlimited. A "." at the start of a line signals the end of text entry and allows the note to be updated.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 18
Diary note list
DD.CUSTDIARYLIST
Citadel Service, Distribution & Financial systems TCL MAIL Entered by user 9999 ______________________________ Recall date range Customers
________
________ ________ ________ ________ ________ ________ ________ ________ ________ ________
(P)rinter or (S)creen
** DEVELOPMENT **
to
24 JAN 01 11:42 Kyocera 50 bertw DD 1023
________
______________________________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ _
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The diary note list screen is used to initiate a list of diary notes. Selection parameters for inclusion of diary notes in the list are who the note was entered by, the recall date of the diary note, and customer(s). The list can be viewed on the screen or printed. User id: Enter the user id that the diary notes are to be recalled for. If notes for all system users are to be recalled RETURN. The search facilities can be used to access the required user. Recall date range from: Specify the date that the diary notes are to be recalled from. The format is dd.mm.yy. Diary notes with a recall date after the date entered will be included in the list of notes being recalled. Recall date range to: Specify the date that the diary notes are to be recalled to. Diary notes with a recall date prior to the date entered will be included in the list of notes being recalled. Customers: Specify which customers are to have their diary notes included in the list of notes being recalled. Enter the codes of the customers required or use the search facilities to access the required customers. If all customers are required RETURN. Printer or screen: Select where the list of diary notes being recalled is to display.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 19
Invoice message maintenance
DD.INVMSGMAINT
Citadel Service, Distribution & Financial systems TCL MAIL Branch ______ ______________________________
24 JAN 01 11:44 Kyocera 50 bertw DD 1023
Text: ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The invoice message maintenance screen is used to input the message that is to be printed on invoices raised. The message is input by branch in order that each branch can have a unique message. Branch: Enter the branch that the invoice message relates to. The search facilities can be used to access the required branch. If all branches are required RETURN. Text: Enter the invoice message. This will print on invoices raised by the branches nominated. A “.” at the start of a line signals the end of the text.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 20
Statement message maintenance Citadel Service, Distribution & Financial systems TCL MAIL Branch ______ ______________________________
DD.STATMSGMAINT 24 JAN 01 11:45 Kyocera 50 bertw DD 1023
Text: ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The statement message maintenance screen is used to input the message that is to be printed on debtors statements. The message prints after statement line detail. It will continue to be printed on statements produced until deleted. To delete a message the same screen should be used and the delete option taken. Branch: Enter the branch that the statement message relates to. If all branches are required RETURN. The search facilities can be used to access the required branch. Text: Enter the statement message. This message will print on debtors statements until removed. It will print after statement line detail. A "." at the start of a line signals the end of the text.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 21
Statements
DD.STATEMENT
Testing & Development Pty Ltd DD.STATEMENT Date to print on statements ________
29 JAN 98 13:04 Kyocera 87 peter DD 1999
Print from (T)his month or (L)ast month file _ AR type Branch Customer
____
______________________________
______
______________________________
________
______________________________ ______________________________ ______________________________ ______________________________ ______________________________
Exclude periods greater then Sort by (AR) type ** DEVELOPMENT **
or
______
(B)ranch
____________________________
__
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The statement process allows statements to be printed based on date, period number, branch and customer number. Date: Enter the date that is to print on each statement. Month: Specify if the statement print run is to be taken from detail held this month or from last months statements file. AR type:
Branch: Enter the branch code to specify which branches are to have their debtors statements printed. A “?” will display all branch codes. Customer: Enter the customer that is to have their statement printed. If statements are required for all customers RETURN. Exclude periods greater than: Specify the last period transactions are to be included. Sort by (AR)type or (B)ranch:
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 22
Statement reprint
DD.STATREPRINT
Testing & Development Pty Ltd Statement reprint
25 MAY 01 11:19 Kyocera 27 bertww DEV.DD 1072
Branches
All branches
Customers
All customers
AR type
TNS DIST
TNS business group Distribution
Balance 2 months or older Statement date Exclude periods greater than (P)rinter or (S)creen P
200105
May
DEVELOPMENT COPYRIGHT(C) 1989-2001 Citadel Computer Systems V11.1a [FEDIT] (B)ypass or (C)ontinue :
The specific statement reprint process allows specific customers statements to be reprinted. The statement is a reprint of the previous months statement. Branches: Enter the branch codes to specify which branches are to have their debtors statements reprinted. A "?" will display all branch codes. Customers: Enter the customers that are to have their statement reprinted. AR type: Enter the accounts receivable type(s) to be printed Balance ____ months or older: Enter the number of months of outstanding balance required Statement date: Enter the statement date to print on the statements Exclude periods greater than: Specify the last period transactions are to be included. (P)rinter or (S)creen: Choose the output format
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 23
Stand alone statement run
DD.STATRUN
Citadel Service, Distribution & Financial systems TCL MAIL Run the statement jobstream displayed below Statement date
24 JAN 01 11:50 Kyocera 50 bertw DD 1023
________
Sleep until
_____
Jobstream :
______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________ ______________________________________________________________
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The standalone statement run process allows statements to be run independently to the AR month end process. It is normally used where the organisation is using 13 financial periods and wish to roll the AR month end at a different time to the monthly statement run ie. the financial period might end on the 28th August (4 weeks) but statements (and debtors ageing) is not required until 31st August. Statement date: Enter the date to appear on the statement. Sleep until: Enter the time that the statement job stream will run.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 24
AR enquiry
DD.ARENQ
(First screen) Citadel Service, Distribution & Financial systems TCL MAIL Customer ________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________
** DEVELOPMENT **
(Second screen)
24 JAN 01 11:52 Kyocera 50 bertw DD 1023
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
(DD.ARENQ1)
Citadel Service, Distribution & Financial systems 24 JAN 01 11:53 TCL MAIL Kyocera 50 bertw DD 1023 Debtor ________ Currency ___ Branch ______ ___________ 999999999.99______________________________ Rep ____ ___________ 999999999.99______________________________ Debtor ________ ___________ 999999999.99______________________________ Cr lim 999999999 ___________ 999999999.99______________________________ Ph _______________ ___________ 999999999.99______________________________ B/o 99999999.99 ___________ 999999999.99Date Trn Invoice Reference PO# Amount Balance ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________ ** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The accounts receivable enquiry facility provides the means to enquire on the state of a customers account. After selecting a customer all outstanding transactions are displayed with detail of amounts owing including their ref, customers purchase order number, and transaction date. In addition the debt is aged and the summary aging shown. Further options available from this screen are instalment detail, invoice print, on account detail, payment detail and the ability to see and write diary notes. The detail displayed can also be printed.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 25
A function option allows specific invoice numbers or dates to be entered and then to go direct to that page of the enquiry. In addition there is an option to see all invoices for the customer or only those invoices with a balance still owing. Note: paid invoices are held for the customer for a period of time determined by the setting on the customer file. Customer: Enter the customer that the enquiry is for. The search facilities can be used to access the required customer.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 26
AR one cheque to multiple customer enquiry Citadel Service, Distribution & Financial systems TCL MAIL Cheque number _________ Drawer ___________________________________ Date entered __________ Cheque total 9999999.99
DD.MLTCHQENQ 24 JAN 01 11:55 Kyocera 50 bertw DD 1023
Customer# Customer name Customer Total _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ _______________________________________________________________________________ ** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The accounts receivable one cheque to multiple customer enquiry facility shows the detail of where a specific cheque has been allocated. After selecting a cheque number all customers are displayed with totals. After selecting a customer all outstanding transactions are displayed with detail of amounts, reference, customers purchase order number and transaction date. Cheque number: Enter the cheque number the enquiry is for. Customer: Enter the customer that the enquiry is for. The search facilities can be used to access the required customer.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 27
Customer enquiry
DD.CUSTENQ1
Screen 1: Testing & Development Pty Ltd 12 AUG 97 16:21 DD.CUSTENQ1 MAIL =Kyocera (Slaved) 58 bertw DD 1023 Customer number ________ Screen1 Name & address ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ Delivery address ______________________________ ______________________________ ______________________________ ______________________________ Delivery method __ ______________________________ Del instructions ______________________________ ______________________________ Branch ______ ______________________ Territory ___ _________________ Representative ___ ______________________________ Analysis keys __ ______________________________ __ ______________________________ __ ______________________________ __ ______________________________ Customer type ____ ______ AR type ____ ______ ** DEVELOPMENT ** COPYRIGHT (C) 1989-2001 Citadel Computer Systems V10 [FEDIT]
The customer enquiry facility is used to enquire on the detail on the customer database. All detail can be viewed but not altered. Customer: Enter the customer number or use the search facilities to access the customer required. Screen2: (DD.CUSTENQ2) Testing & Development Pty Ltd 12 AUG 97 16:24 DD.CUSTENQ2 MAIL =Kyocera (Slaved) 58 bertw DD 1023 Customer 99999999 ______________________________ Screen2 Debtor ________ ______________________________ Statement to ________ ______________________________ Telephone _______________ Mobile _______________ Fax _______________ Search key ________ Price number 9 Currency ___ ______________________________ Payment terms __ ______________________________ Credit limit 999999999 Ageing limit 9 Tax exemption # ____________ Create date ________ Supp Br ______ ____________________________ Bal fwd or Open item _ Credit controller hold _ Backorders _ Point of sale _ Delivery date range _ Substitutes _ Detail analysis _ PO# required _ Product analysis _ Pricing basis _ Mail invoice _ Surcharge _ Doubtful debtor _ Invoice _ Cash sale account _ Ticket print _ Statement _ Bal fwd statement _ Project customer _ ** DEVELOPMENT ** COPYRIGHT (C) 1989-2001 Citadel Computer Systems V10 [FEDIT]
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 28
Invoice reprint
DD.REPRINTINV
Testing & Development Pty Ltd DD.REPRINTINV Invoice number __________
** DEVELOPMENT **
MAIL
12 AUG 97 16:27 =Kyocera (Slaved) 58 bertw DD 1023
COPYRIGHT (C) 1989-2001 Citadel Computer Systems V10 [FEDIT]
The invoice and credit note reprint facility allows any invoice or credit note to be reprinted. Invoice number: Enter the invoice number required to be reprinted. Printer or screen: Specify where the invoice is to be reprinted.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 29
AR open item trial balance Citadel Service, TCL Currencies ___ ___ ___ Branches
DD.OITB
Distribution & Financial systems MAIL
24 JAN 01 12:00 Kyocera 50 bertw DD 1023
______________________________ ______________________________ ______________________________
______ ______ ______ ______ ______
______________________________ ______________________________ ______________________________ ______________________________ ______________________________
Sequenced by (B)ranch or (C)urrency
___
Exclude transactions for periods greater than ______ __________________________ Report on doubtful debtors only (Y/N) (S)ummary or (D)etail
** DEVELOPMENT **
_
___
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The accounts receivable open item trial balance is a report that displays the current status of each debtor account in detail. In addition the age of each account is shown. The report can be run as a summary report or show the detail of all outstanding transactions. The detail by debtor includes all transactions not purged with their reference, amount and the nett amount. The report can be run for all branches or a selected branch. This report is normally part of month end and is in effect a print of the debtor statements. Currencies: Enter the currency code or “?” to display all currencies. Branch: Enter the branch code or "?" to display all branches. If all branches are required RETURN. Sequenced by: Specify the sequence of the report. Exclude transactions for periods greater than: Enter the last period for which transactions should be printed. Report on doubtful debtors only: Specify if the report is only to contain customers flagged as doubtful debtors. Summary or detail: Specify if the report is to print in summary form or to include all detail of each customers outstanding transactions.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 30
AR summary trial balance
DD.ARSUMMTB
Testing & Development Pty Ltd DD.ARSUMMTB Balance 9 months or older Currencies
___ ___ ___
______________________________ ______________________________ ______________________________
__ __ __
______________________________ ______________________________ ______________________________
______ ______ ______
______________________________ ______________________________ ______________________________
Customer types
Branches
29 JAN 98 13:47 Kyocera 87 peter DD 1999
Sequenced by (B)ranch or (C)urrency _ Sequenced by (C)ustomer# (N)ame or (S)earch key As at last month end _
_
(P)rinter or (S)creen _ ** DEVELOPMENT ** COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The accounts receivable summary trial balance is a listing of debtors with the status of their account. It can be run for a selected branch or for all branches. The debtors are listed by branch in alpha order. Detail by debtor is "on account" amount, current amount, 1 month, 2 months, 3 months and the total amount owing. In addition accounts are flagged if they are over their credit terms. This report is normally run at month end to provide a summary of the debtors control account. If run during the month it will include all transactions up to the time of running (ie. current month will be that months transactions). Number of months: Enter the number of months that represents the outstanding age the report is to be for. Only debtors with outstanding transactions equal to or greater than the number of months specified will be included on the report (note: their whole balance will be displayed). Branch: Enter the branch code or "?" to display all branches. If all branches are required on the report RETURN. Customer type:
Branches: Enter the branches the report is for. Sequenced by: Specify the sequence of the report. Sequenced by: Specify the secondary sequence of the report. Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 31
At last month end: Specify if the report is to be based on the last month end or the current situation. Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 32
Branch AR Summary
DD.ARBRSUMM
Citadel Service, Distribution & Financial systems TCL MAIL Branches ______ ______________________________ ______ ______________________________ ______ ______________________________ ______ ______________________________ ______ ______________________________ Exclude transactions for periods greater than 999999 (P)rinter or (S)creen
** DEVELOPMENT **
24 JAN 01 12:04 Kyocera 50 bertw DD 1023
_______________________
_
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The branch AR summary is a listing of debtors with the status of their account. Detail by debtor is “on account” amount, current amount, 1 month, 2 months, 3 months and the total amount owing analysed by branch. Branches: Enter the branches the report is for. Exclude transactions: Specify the last period transactions are to be included. Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 33
Summary Trial Balance (12 mth) Testing & Development Pty Ltd DD.ARTB Balance 99 months or older
29 JAN 98 13:54 Kyocera 87 peter DD 1999
Currencies
___ ___ ___
______________________________ ______________________________ ______________________________
Branches
______ ______ ______ ______ ______
______________________________ ______________________________ ______________________________ ______________________________ ______________________________
Sequenced by (B)ranch or (C)urrency
DD.ARTB
_
Exclude transactions for periods greater then 999999 __________________________ (P)rinter or (S)creen ** DEVELOPMENT **
_
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The summary trial balance (12 month) is a listing of debtors with a status of their account analysed over 12 months. It can be run for a selected branch or for all branches. Detail by debtor is “on account” amount, current amount and the previous 11 months. The report is normally run at month end to provide a breakdown of the debtors control account. If run during the month it will include all transactions up to the time of running ie. current month will be that months transactions. Number of months: Enter the number of months that represents the outstanding age the report is to be for. Only debtors with outstanding transactions equal to or greater than the number of months specified will be included on the report. (Note: their whole balance will be displayed). Currencies: Enter the currencies the report is to include. Branches: Enter the branches the report is for. Sequenced for: Specify the sequence of the report. Exclude transactions: Specify the last period transactions are to be included. Printer or screen: Specify where the report is to print
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 34
Summary Trail Balance with Instalments Testing & Development Pty Ltd DD.ARITB Summary trial balance for balances _ months or older Currency
___ ___ ___
DD.ARITB 29 JAN 98 13:57 Kyocera 87 peter DD 1999
______________________________ ______________________________ ______________________________
Exclude transactions for periods greater than 999999 __________________________ (P)rinter or (S)creen
** DEVELOPMENT **
_
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The summary trial balance with instalments is a listing of debtors with the status of their account. Detail by debtor is “on account” amount, current amount, 1 month, 2 months, 3 months, instalment and total amount. Months overdue: Enter the number of months that represents the outstanding age the report is for. Only debtors with outstanding transactions equal to or greater than the number of months specified will be included on the report. (Note: their whole balance will be displayed). Currency: Enter the currencies the report is to include. Exclude transactions: Specify the last period transactions are to be included. Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 35
Summary trail balance by rep
DD.ARREPTB
Testing & Development Pty Ltd DD.ARREPTB Reps ___ ______________________________ ___ ______________________________ ___ ______________________________ ___ ______________________________ ___ ______________________________
29 JAN 98 14:07 Kyocera 87 peter DD 1999
Credit holds only Y/N _ (P)rinter (S)creen
** DEVELOPMENT **
_
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The summary trial balance by rep is a listing of debtors with a status of their account. Detail by debtor is “on account” amount, current amount, 1 month, 2 months, 3 months and the total amount owing. Only debtors attached to the reps specified are included on the report. Reps: Enter the reps the report is to include. Credit holds only Y/N:
Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 36
Branch AR summary by order line Citadel Service, Distribution & Financial systems TCL MAIL Currencies ___ ______________________________ ___ ______________________________ ___ ______________________________ Branches
______ ______ ______ ______ ______
DD.AROTSUMM 24 JAN 01 11:00 Kyocera 50 bertw DD 1023
______________________________ ______________________________ ______________________________ ______________________________ ______________________________
Exclude transactions for periods greater than 999999 ______________ _____________
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The branch AR summary by order type is a listing of debtors with a status of their account. Detail by debtor is total amount owing unspecified invoices, service invoices, contract invoices, sales invoices and project invoices analysed by branch. Currency: Enter the currencies the report is for. Branches: Enter the branches the report is to include. Exclude transactions: Specify the last period transactions are to be included.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 37
AR transaction list
DD.ARTRANSLIST
Citadel Service, Distribution & Financial systems TCL MAIL Branches ______ ______________________________ ______ ______________________________ ______ ______________________________ ______ ______________________________ ______ ______________________________ From date
________
to date
________
Sequenced by (D)ate or (T)ransaction type (P)rinter or (S)creen
** DEVELOPMENT **
24 JAN 01 11:03 Kyocera 50 bertw DD 1023
_
_
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The AR transaction list is a listing of all AR transactions within a given time period. Detail is by type, date, ref no., TNX Ref, value, customer. Branches: Enter the branches the report is for Date range: Specify the date range the report is for. Sequenced by: Specify the sequence of the report. Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 38
AR history report
DD.ARCUSTENQ
Testing & Development Pty Ltd DD.ARCUSTENQ Customer ________ ______________________________ ______________________________ ______________________________ ______________________________ ______________________________ Currency
___
Invoice date from
__________
Invoice date to
__________
(P)rinter or (S)creen
** DEVELOPMENT **
29 JAN 98 14:10 Kyocera 87 peter DD 1999
_
COPYRIGHT(C) 1989-1998 Citadel Computer Systems V8. [FEDIT]
The AR history report shows detail of product lines on invoices within the specified date range. Data shown includes quantity, nett price, the invoice amount, the amount paid and the date it was paid, any balance owing and the number of days for which the amount has been owing. Customer: Enter the customer the report is for or use the search facilities to access the required customer. Date range: Enter the date range the report is for. Printer or screen:
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 39
On account cash list Testing & Development Pty Ltd DD.OALIST
DD.OALIST 09 OCT 00 11:38 Kyocera 35 bertww DEV.DD 1072
Branches
(P)rinter or (S)creen
# DEVELOPMENT # COPYRIGHT(C) 1989-2000 Citadel Computer Systems V14.1a [FEDIT]
The report is a selected list of amounts held “on account” for customers. Detail covers each on account amount held, by reference. Branches: Enter required branch numbers (P)rinter or (S)creen: Choose output format
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 40
On account transfer history
DD.OATFRLIST
Citadel Service, Distribution & Financial systems 24 JAN 01 12:07 TCL MAIL Kyocera 50 bertw DD 1023 From customers ________ ______________________________ ________ ______________________________ ________ ______________________________ ________ ______________________________ ________ ______________________________ To customers
________ ________ ________ ________ ________
Date range from
________
Sequenced by date
_
(P)rinter or (S)creen
** DEVELOPMENT **
______________________________ ______________________________ ______________________________ ______________________________ ______________________________ to
________
(or customer) _
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The on account transfer history report lists transfers of cash held on account between selected customers between selected dates. It is used to trace transfers of cash between customer accounts. From customers: Enter the customer code to specify the start of the customer range to be included in the report. The search facilities can be used to access the required customer. If all customers are to be included RETURN. To customers: Enter the customer code to specify the end of the customer range to be included in the report. The search facilities can be used to access the required code. If all customers are to be included in the report RETURN. Date range from: Specify the start date for on account transfer detail to be included in the report. Date range to: Enter the date that specifies the period that on account transfer history is required to. The format is dd.mm.yy. Report sequence: Specify the sequence of the report. This can be by the date of the on account transfer or by customer. Printer or screen: Select where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 41
Customer ABC analysis
DD.ABCCUST
Citadel Service, Distribution & Financial systems 24 JAN 01 12:08 TCL MAIL Kyocera 50 bertw DD 1023 Branch _____ ______________________________ Minimum 12mth $sales
999999
(P)rinter or (S)creen
_
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The customer ABC analysis is a report on customer profitability in sequence of gross profit. The report is parameter driven. It can be run for a single branch or all branches and can exclude customers that have not achieved a minimum level of sales over the last twelve months. The report is by branch and displays the customer, the last twelve months sales, the last twelve months gross profit and the last twelve months gross profit percentage. The customers are listed in sequence of gross profit. Branch: Enter the branch the report is for. If all branches are to be selected RETURN. Minimum 12 month dollar sales: Enter a dollar amount. Customers with sales of less than this figure for the last twelve month period will not be included in the report. If all customers are to be included RETURN. Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 42
Summary TB by overdue days
DD.ARSUMMTBD
Citadel Service, Distribution & Financial systems TCL MAIL Balance 99 ______ or older Currencies
___ ___ ___
______________________________ ______________________________ ______________________________
Branches
______ ______ ______
______________________________ ______________________________ ______________________________
Sequenced by (B)ranch or (C)urrency
___
Sequenced by (C)ustomer# (N)ame or (S)earch key Exclude periods greater than Show diary notes (Y/N)
___
(P)rinter or (S)creen
___
** DEVELOPMENT **
999999
24 JAN 01 11:08 Kyocera 50 bertw DD 1023
___
______________________________
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The summary trail balance by overdue days is a listing of debtors with the status of their account. It can be run for a selected branch or for all branches. The debtors are listed by branch in alpha order. Detail by debtor is “on account” amount, and overdue day buckets based on the buckets defined in the AR bucket maintenance process (DD.ARBUCKETMAINT). The report is only used if ageing is done by overdue days. Number of days: Enter the number of days that represents the outstanding age the report is to be for. Only debtors with outstanding transactions equal to or greater than the number of days specified will be included on the report (note: their whole balance will be displayed). Currencies: Enter the currencies the report is for. Branches: Enter the branches the report is to include. Sequenced by: Specify the sequence of the report. Sequenced by: Specify the secondary sequence of the report. Exclude periods: Specify the last period transactions are to be included.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 43
Show diary notes: Specify if diary notes are to be shown on the report for each customer listed. Printer or screen: Specify where the report is to print.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 44
AR Overdue days maintenance
DD.ARODAYSMAINT
Citadel Service, Distribution & Financial systems 24 JAN 01 12:10 TCL MAIL Kyocera 50 bertw DD 1023 Define the AR letter text to be used based on the days overdue More than 999 days overdue Use letter text __ Combinations already set up # of days
Text code
999 999 999 999 999 999 999 999 ** DEVELOPMENT **
__ __ __ __ __ __ __ __
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The AR overdue days maintenance process defines the text that is to be printed on overdue letters. Text is based on the average number of days the account is overdue. More than ____ days overdue: Enter the number of days overdue. Use letter text: Enter the text code that is to be printed for the nominated number of days. (Note: the same text code cannot be used twice).
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 45
Print AR letters
DD.ARLETTER
Citadel Service, Distribution & Financial systems TCL MAIL Customer ________ ______________________________ ________ ______________________________ ________ ______________________________ ________ ______________________________ ________ ______________________________ ________ ______________________________ ________ ______________________________
24 JAN 01 12:12 Kyocera 50 bertw DD 1023
Overdue from date ________ Date to print on letter ________
** DEVELOPMENT **
COPYRIGHT (C) 1989 2001 Citadel Computer Systems V14.1a
The print AR letter process prints the reminder letters. The relevant text will print depending on the average number of days the account is overdue. A program parameter can be set to nominate the printer that the letters are to be printed on. There is also a program parameter to set the default calculation method (whether from invoice or statement). Customer: Enter the customers letters are to be printed for. RETURN at this field will select all customers. Searches can be used to select the customers required. Last statement date: Enter the last statement date. Debtors that have their credit days calculated from statement date will have overdue days calculated and averaged from this date. This field is mandatory. Calculate invoice overdue from date: Enter the date overdue invoices are to be calculated from. Debtors that have their credit days calculated from invoice date will have overdue days calculated and averaged from this date. This field is mandatory. Date to print on letter: Enter the date to print on the letters.
Printed on 3/26/2004
Accounts Receivable Training Reference Notes v14.1
Page 46
