Cogito - Debtors Reports

See reports for general information and running.

8DTL03 PAYMENTS

Note Batch reference No.

Name                 Bank/Branch    Chq.    Value     A/c      Name

 03 P Payment    485 13/01/09 Jill
SMITH     261100      45.00              1    Smith NZ Ltd  (Payment reference, value and Method
          4664        45.00 Invoice                          Invoice No.s)
BROWN     524200     450.00 NAT SYDENHAM 1    Browns Bros
          4786       450.00 Invoice
JONES     135300     114.66              2    Jones Ltd
          4715       114.66 Invoice
POLLY       2400     135.00              2    Polly Glot Ltd.
          4787       135.00 Invoice
HAMISH     11500     135.00 WPC CHCH     3    Hamish G J
          4752       135.00 Invoice
HAMISH     12600     180.00 WPC CHCH     5    Hamish G J
          4753       180.00 Invoice
JULIEA     13700      22.50 ANZ CHCH     5    Julie Anne
          4460        22.50 Invoice
MISC       11800      81.00 WPT          4    Miscellaneous
          4734        81.00 Invoice
ANNLEY     12900   1,372.50 WPT CHRISTCH 4    Ann Ley + Co
          4792       900.00 Invoice
          4793       472.50 Invoice
     Total Value   2,535.66

Usually followed by a Debtors Control Report

Checks that Debtors Transactions equal Debtors balances and can be run any time.
Optionally Print or Stop on errors and Enter to continue.
An error will occur if a customer with a balance has a Cancelled status, or if a "Deliver to" has a balance etc.
If there is an error, fax the report to Cogito - do not carry on with the rest of the Month End procedures.

Account         Name                        O/bal     C/bal    Change     Trans      Diff

COG      COGITO                          4860.00             4860.00-  2250.00   2250.00-

AGED TRIAL BALANCE

Run as part of the End of Month procedures for all Customers with a Balance or accounts overdue by 1, 2 or 3 months and over.
The Balance changes throughout the month as payments are made and invoices updated.
To reprint the Opening balances change B to I for this run.

DTP04B

See formats for more.

8DTP04BM - AGED TRIAL BALANCE

Account     Name                        TOTAL    Current    1 Month    2 Mths    3 Mths   -$MTD---Payment---on-  Sales YTD

CODE     Name                         6,436.13              1980.00   1192.50   3263.63          .00  28/07/01    4,450.50  **3
CODE     Name                         3,766.50              2416.50             1350.00          .00  25/07/01    7,139.41  **3
CODE     Name                         3,843.45              3843.45                         2,641.69- 13/08/01   48,570.99
...
CODE     Name                           801.72               261.72              540.00        45.00- 08/08/01    2,733.72  **3
CODE     Name                         2,430.00               270.00    270.00   1890.00          .00  01/02/01    1,080.00  **3
CODE     Name                         2,700.00               675.00    675.00   1350.00          .00  27/05/01    2,700.00  **3

Sub total                            48,922.58             29485.45   6102.71  13334.42     9,207.02-           139,608.04
     ** Percentages **                  100.00                60.27     12.47     27.26

8DTP04BM - AGED TRIAL BALANCE

All Transactions for a single customer over a selected date range.

Account         Name                        TOTAL    Current    1 Month    2 Mths    3 Mths   -$MTD---Payment---on-  Sales YTD

CODE     NAME
  31/07/97 Invoice    1656        20.25
  18/08/97 Payment  102671           20.25-
  30/09/98 Invoice    2312       112.50
  21/10/98 Payment  103433          112.50-
  31/10/98 Invoice    2367       225.00
  11/11/98 Payment  000000          225.00-
  30/11/98 Invoice    2412        22.50
  17/12/98 Payment  103538           22.50-
  30/04/99 Invoice    2674       180.00
     04/99  * Balance *                     180.00     180.00
  17/05/99 Payment  103858          180.00-
  31/10/99 Invoice    2994     2,612.26        (paid)
  13/11/99 Payment  104157        2,612.26-    (paid)
  30/11/99 Invoice    3034        45.00        (paid)
     11/99  * Balance *                   2,612.26   2,612.26
  11/12/99 Payment  1041901          45.00-    (paid)
     12/99  * Balance *                      45.00      45.00
              Current balance                  .00                                                   .00  11/12/99        .00

Sub total                                      .00                                                   .00                   .00
         ** Percentages **                  100.00     100.00

8DTP04BL - AGED TRIAL BALANCE - LAST PAYMENT

Account     Name                        TOTAL    Current    1 Month    2 Mths    3 Mths   Last Pmt $  Last Pmt   Sales YTD

CODE     Name                         6,436.13              1980.00   1192.50   3263.63       650.00- 28/07/01   4,450.50  **3
CODE     Name                         3,766.50              2416.50             1350.00       450.00- 25/07/01   7,139.41  **3
CODE     Name                         3,843.45              3843.45                           720.00- 13/08/01  48,570.99
...
CODE     Name                           801.72               261.72              540.00       270.00- 08/08/01   2,733.72  **3
CODE     Name                         2,430.00               270.00    270.00   1890.00     2,174.63- 01/02/01   1,080.00  **3
CODE     Name                         2,700.00               675.00    675.00   1,350.00     1,910.41- 27/05/01   2,700.00  **3

Sub total                            48,922.58             29485.45   6102.71  13334.42     9,207.02-          139,608.04
     ** Percentages **                  100.00                60.27     12.47     27.26

8DTP04BS - TRIAL BALANCE SUMMARY - AFTER CONTROL REPORT

                TOTAL      Current      1 Month      2 Mths      3 Mths
TOTALS         48,922.58          .00   29,485.45    6,102.71   13,334.42
Percentages       100.00          .00       60.27       12.47       27.26

8DTP04B2 AGED TRIAL BALANCE - FOR LARGER VALUES

Account         Name                                 TOTAL       Current      1 Month       2 Mths        3 Mths  --$--Last Payment--on--     Sales YTD

CODE     Name                                    12,463.22        495.79     11,967.43                                      .00  22/09/00     15,064.96
CODE     Name                                    23,523.41      4,342.66     19,202.69         21.94-                       .00  29/09/00     49,358.63
CODE     Name                                    26,468.84                   18,216.00         31.34      8,221.50          .00   9/03/00     26,468.84  **3
...
CODE     Name                                     7,290.08      2,786.81      4,503.27                                 4,493.13-  2/10/00     29,489.40
CODE     Name                                     3,719.43                    3,719.43                                      .00  18/08/00      4,883.81
CODE     Name                                    11,519.17                                               11,519.17          .00  15/03/00      1,800.00  **3
                                                 11,381.04        154.13      3,721.63      7,505.28                        .00  26/09/00     21,145.92  *2

Sub total                                     1,614,174.78    264,999.92  1,001,430.80    225,002.30    122,741.76   343,623.60-           5,453,023.80
         ** Percentages **                          100.00         16.42         62.04         13.94          7.60

TRANSACTION REPORTS

8DTP01C1 - ALL LIVE TRANSACTIONS

ccDTT      Date  Code/Tp  Ref    M/Ag      Due      Pd MTD     Pd Future     Value      Batch

CODE     13/10/00  4 P        2     9                 151.19-                 151.19-    1178
CODE      6/09/00  1 I 278101     S 1      14.97                               14.97          R
         29/09/00  1 I 280865     S 1      38.54                               38.54          R
          3/10/00 19 U              1       8.65                                8.65          R
          3/10/00  4 P        4   P 9                 208.19-                 208.19-    1134 R
          2/09/01 19 U   3521       F                                         652.81-
          2/09/01  4 P   3521 4     F                             652.81-     652.81-     200
CODE      9/10/00  1 I 281746              32.44                               32.44
...
CODE      2/10/00  4 P        2     9               1,366.02-               1,366.02-    1127
CODE     12/10/00  4 P        2     9                 135.00-                 135.00-    1172
CODE      3/10/00  4 P        2     9                  68.03-                  68.03-    1135
          5/10/00  2 C 281493       1       5.43-                               5.43-

                       TOTALS          48,620.60   16,780.24-     654.46-  29,182.95


Export version 8DTP01E1
	* Format:	ASCII comma delimited
	* Output:	"Customer","Date","Tr Code","Tp","Ref","Due","Age",
	  		"Value","Cust Ref","Batch","Balance",

8DTP01C3 - TRANSACTION SUMMARY BY TYPE

Totals by Transaction Type.

Account         O/bal         C/bal        Change         Trans          Diff

TOTALS:      97,451.81     73,940.83     23,510.98-    23,510.98-

 Code  Desc.             Orig        Due         Pd MTD        Future

 1 I Inv.           13,557.20     13,557.20           .00           .00
 2 C Credit            225.91-       225.91-          .00           .00
 4 P Pymnt          37,330.76-    37,330.76-          .00           .00
 6 I Cash Sale         488.49        488.49           .00           .00

         TOTALS     23,510.98-    23,510.98-          .00           .00

8DTP01C4 - CURRENT MOVEMENT (NOT PAYMENTS)

Movement totals by debtor, apart from payments.

 
         Name                               TOTAL    Current    1 Month    2 Mths    3 Mths

CODE     NAME                               652.81-    652.81-
CODE     NAME                                24.78      24.78
CODE     NAME                               155.49     155.49
CODE     NAME                               660.83     660.83
CODE     NAME                               121.27     121.27
CODE     NAME                               216.93     216.93

8DTP01C5 - PART-PAID / UNALLOCATED TRANSACTION

Highlights journals, unallocated payments etc. with batch number.

ccDTT      Date  Code/Tp  Ref    M/Ag      Due      Pd MTD     Pd Future     Value

CODE     11/10/00  2 C 282104               9.04-                               9.04-
CODE     22/08/01 19 U     54               5.96-                               5.96-
CODE      9/10/00 19 U                       .08-                                .08-
...
CODE      5/10/00  2 C 281499       1     208.44-                             208.44-
          6/10/00  2 C 281646       1       3.00-                               3.00-
CODE      5/10/00  2 C 281493       1       5.43-                               5.43-

                       TOTALS             231.95-                             231.95-

8DTP01C6 - TRANSACTIONS BY REFERENCE

 Ref    Cust      DateCode/Tp    Due        Value

 310738 COGITO   23/08/06  1 I     406.44       406.44
 310739 NAME     23/08/06  1 I   1,051.09     1,051.09
 310740 CUST     23/08/06  1 I      70.20        70.20
 310741 CASH     23/08/06  1 I      11.99        11.99
 310742 SALES    23/08/06  1 I      22.73        22.73
 310744 XYZ      23/08/06  1 I     135.00       135.00
 310745 COLES    23/08/06  1 I      29.70        29.70
 310746 SPOOK    23/08/06  1 I     652.50       652.50
 310747 TAGET    23/08/06  1 I     434.93       434.93
 310748 SCARLET  23/08/06  1 I     350.55       350.55
 310749 HRH      23/08/06  1 I     614.29       614.29

8DTP01C7 - TRANSACTIONS BY ACCOUNT TYPE

 
     Transaction     Type A        Type B        TOTAL


Inv 			.00 	 313,839.17 	313,839.17
CREDIT 			.00 	  23,985.60- 	 23,985.60-
Paid			.00      224,934.51- 	224,934.51-
JOURNAL 		.00 	       5.85 	      5.85
Quote 			.00 	   2,728.07 	  2,728.07
C/SALE 			.00 	  25,236.25 	 25,236.25

TOTALS                  .00       92,889.23      92,889.23

8DTP01B1 BANKINGS REPORT

Customer                       Bank A/c                Ref.        Paid

Customer Name                  BNZ    PAPANUI         500856      34.84-
Customer Name                  D/C    D/CREDIT         91209      97.95-
Customer Name                  EFT    EFTPOS           41209     891.88-
Customer Name                  D/C    D/CREDIT           412   1,468.56-
Customer Name                  CSH    CASH            151209   1,831.19-
Customer Name                  D/C    D/CREDIT         71209     286.26-
Customer Name                  D/C    D/CREDIT         31209     203.63-

8DTP01EX - EXPORT - FULLER VERSION OF 8DTP01C1

     * Format: ASCII, Comma-delimited, Quotes
     * Output: Code, Date, Seq, Trans. Code, Trans. Type, Inv/Chq Ref,
       Pay't Method, Due, Value, Bal, Pd MTD, Match Ref. No.,
       Pd Future, Pd By, Matched, Age, Future, S/M, Branch,
       Source, Cust Ref, Batch Ref, GL Update, Branch, PP Disc Rate,
       PP Val, Area, Cust Type, Comment, Bank Code, Due Date, Tax,
       Inv Cust, A/c Type, Pay Sch, Rolled, Period.

CONTACT REPORTS

8DTP04C1 - Name and Address

x Bal. Type x Status

Account  Name                               Address                                                    Contact            Phone

Bal Type       B
Status         N         Normal A/C
CODE     NAME                           P O Box 1234, 17 Banks Rd Riccarton CHRISTCHURCH           Peter Ford       343-3091
CODE     NAME                           P O Box 76543, 92 Washhouse Rd Sydenham CHRISTCHURCH       Paul             311-5502

Bal Type       O
Status         N         Normal A/C
CODE     NAME                             81 Champion St Riccarton CHRISTCHURCH                                     372 2554
CODE     NAME                           P O Box 1178, 14 George St  SYDNEY NSW 2150                Penny Jones     0061-2-7869-3342

8DTP04C2 - DEBT REPORT - BALANCES AND CONTACT


Account  Name                               Contact          Called   Phone / Cell Phone / Fax
SALES: M.T.D.   Y.T.D.  Current   1 Mth  2 Mths  3 Mths       TOTAL    Limit       Payment           Performance      Avg Debt/Age

CODE     NAME                           Mr P Smith           Paul     323-1702 /  / 323-5568                       Manager
        810    5,260       810    1980    1192    3263    7,246.13        0     720.00 28/07/01  3 3 3 3 3 2 3 3 3 3 3 3   3791  3
CODE     NAME                           Ms G Deans           Gayle    377-9876 / 021-555-1234/ 379-2314
        916   49,487       916    3843                    4,760.33        0   2,641.69 13/08/01  1 1 1 1 1 1 1 1 1 3 3 3   4268  2
...
CODE     NAME                           Mr T Brown           Tom      376-2899 /  / 376-5671
          0      101                                90       90.00        0        .80 10/08/01  3 3 3 3 3 3 3 3 3 3 3 3     98  3

Sub total                 3603   29335    6102   13334   52,375.98

8DTP04C4 - Check e-mail Settings

Check settings on Debtors Sales and Contacts.

Account  Name                           Job  In,      Qt,      St       e-mail

COGITO   Cogito Services Ltd            OWN  P C N U  P C   I  P   N U  jill@cogito.co.nz

8DTP04C6 - CHARGE-TO DELIVER-TO STATMENT-TO

By Status

Account  Charge to:                     Deliver to:                    Statement to:                  Phone

Status         D         Deliver To. Cannot Charge To.
COGHQ    Cogito Services                Cogito Services                                               366-8543
COGHQ    P O Box 25-071                 P O Box 25-071
         Victoria                       Victoria
         CHRISTCHURCH                   CHRISTCHURCH

Status         N         Normal A/C
COGAK    Cogito Services                Cogito Services                Cogito Services                09-466-8543
COGHQ    P O Box 25-071                 22 Peter Tce                   P O Box 25-071
COGHQ    Victoria                       Nth Shore                      Victoria
         CHRISTCHURCH                   AUCKLAND                       CHRISTCHURCH

COGCH    Cogito Services                Cogito Services                Cogito Services                366-8543
COGHQ    P O Box 25-071                 390 Montreal St                P O Box 25-071
COGHQ    Victoria                       CHRISTCHURCH                   Victoria
         CHRISTCHURCH                                                  CHRISTCHURCH

8DTP04C9 - OUTSIDE TRADING TERMS

x Salesperson


Account         Name                   Message                           TOTAL     Current    1 Month    2 Mths    3 Mths  -$MTD---Payment---on-  Terms

Salesperson    JS        JOHN SMITH
CODE     NAME                         Account Overdue                  2,632.50    2,070.00              562.50                 .00  11/06/01       *2  A
CODE     NAME                         Account Overdue                  9,570.36      383.86   9101.00     85.50                 .00  21/03/01       *2  A
CODE     NAME                         No Services - See Paul           1,189.26                                   1189.26       .00  28/04/01       **3 C
...
CODE     NAME                         Account Overdue                  5,446.64               4449.38    997.26                 .00  30/06/01       *2  A
CODE     NAME                         No Services - See Paul           4,950.73      453.38   1550.26             2947.09       .00  08/06/01       **3 A
CODE     NAME                         No Services - See Paul          11,519.17                                  11519.17       .00  15/03/01       **3 C

Sub total      JS        JOHN SMITH                                  154,957.23   21,756.17  85398.70  24260.87  23541.49  31033.36-

Total                                                                720,370.93   94,448.39 313743.97 189480.20 122698.37 118121.49-
                                               1,350.14- Paid Since  719,020.79  = new balance

CODES

8DTP04D1 - PRICE AND DISCOUNT

by Status


Account  Name                           Address                                  Town                  Pr Ds Phone        Fax           Contact

Status         N         Normal
CODE     NAME                           P O Box 11234, Avondale                  AUCKLAND               1 3  09-828-6063                Mr J Martin
CODE     NAME                           P O Box 3451, Riccarton                  CHRISTCHURCH           1                 337-9215
CODE     NAME                           P O Box 99871, Penrose                   CHRISTCHURCH           1 1  379-1271
CODE     NAME                           P O Box 66754, Sydenham                  CHRISTCHURCH           2 1
CODE     NAME                           P O Box 12112, Riccarton                 CHRISTCHURCH           1 1  358-3407
CODE     NAME                           P O Box 32058, Sockburn                  CHRISTCHURCH           1 3  389-0105                   Cath Henderson
CODE     NAME                           P O Box 9876, Hornby                     CHRISTCHURCH           1    03-308-5169                Mark Caller
CODE     NAME                           P O Box 11151, Sockburn                  CHRISTCHURCH           1 3  348-7778
CODE     NAME                           P O Box 184,                             LAVERTON               4 2  0061-890-311 890-311-      Richard Wright
CODE     NAME                           Box 81,                                  KAIAPOI                2 1  327-6389     327-6389      Mr D Fitzpatrick
CODE     NAME                           P O Box 35049, Armagh                    CHRISTCHURCH           1 1                             Carol Young

8DTP04D2 - CODES

Account  Name                                 Tp   Dept  Area   Region Rep Bal  Pr Ds  St.  Terms  Msg  Mail Codes

COGCHR   Cogito Services                      S-GE CHG   29CH          MS   B    1      N              111  222  333  444

EXPORTS

All reports may be exported, these create files especially suitable for opening into Word Processing, Spreadsheet or Data Base applications.
Use to merge letters with Customer details for such purposes as:
debt collection, Marketing, Newsletters, Servicing / Warranty reminders, Change of address notices and Surveys etc.
Some exports are designed to be exported for editing and then re-importing back into Cogito.

8DTP04E1 - SCREEN 1 - NAME AND ADDRESS

Can be re-imported to DTM with 8DTX41E1:
Use Duplicate Option "U" which will update DTM with any non-blank field in the spreadsheet.
Option "R" will replace all the fields on DTM by those on the spreadsheet - including blank ones.

                        Input Files            New Files
           Master.......EMAIL.CSV              OLDTM

    Process option..... P  Update (def), Print or Both
    File option........ M  Create new file OR Merge.
    Duplicate action... U  Replace, Update, Check or Ignore a duplicate key.
    Use Translation....    Use code translator (if present), else don't.
    File source........ O  Open Office (best) or eXcel (check commas!)
    Old Account range..          to: zzzzzzzz

   NOTE: Extreme care must be taken when the .CSV file has been built
         from Excel - you MUST ensure that NO field (cell) contains a comma.

8CRP04EX now has all the new fields (including "C" costed orders)
Also new program 8CRP04E5 - a "cut-down" version of above which can be re-loaded with 8CRX41E5.


	* Format:	ASCII, Comma-delimited, Quotes
	* Output:	Account	name, In-Sw, CSV, Ver, prt, Qt-Sw, CSV, Ver, prt, Or-Sw, CSV, Ver, prt, St-Sw, CSV, Ver,
	*	 	prt, CONTACT-1-accts, e-mail, d1, d2, d3, d4, d5, cell,	called,	job, CONTACT-2-sales, e-mail, d1,
	*		d2, d3,	d4, d5, cell, called, job, CONTACT-3-parts, e-mail, d1,	d2, d3,	d4, d5,	cell, called, job,
	*		CONTACT-4-other, e-mail, d1, d2, d3, d4, d5, cell, called, job, E-Mail-5, d1, d2, d3, d4, d5, 
	*		E-Mail-6, d1, d2, d3, d4, d5, balance, trans, Group-1, Group-2,

8DTP04E2 - CODES

Can be re-imported with 8DTX41X2

	* Format:	ASCII, Comma-delimited, Quotes
	* Output:	Code, Cust type, Branch, Area, Salesman, Act. type,
	* 		status, terms, mail codes (6)

8DTP04E3 - SCREEN 1 - NAME AND ADDRESS

	* Format:	ASCII, Comma-delimited, Quotes
	* Output:       Name, Name-2, Address 1-3, Town, Country, Post-code, Attention,
	*               Short name, Code, Message

8DTP04E4 - Contact details

	* Format:	ASCII, Comma-delimited, Quotes
	*  Output:   code, check, related, status, rep, type, 
	*            name,  postal, street, suburb, town, post code, area, region, message,
	*            phone, fax, web, Promo,Inv when,Inv Prt,Inv Eml,Qt when,Qt Prt,
	*	     Qt Eml,Stmt when,Stmt Prt,Stmt Eml,SALES called-1,name-1,job-1,e-mail-1,cell-1,promo-1,
	*	     ADMIN called-2,name-2,job-2,e-mail-2,cell-2,promo-2,
	*	     PARTS called-3,name-3,job-3,e-mail-3,cell-3,promo-3,
	*	     OTHER called-4,name-4,job-4,e-mail-4,cell-4,promo-4,
	*	     OTHER called-5,name-5,job-5,e-mail-5,

8DTP04E5 - DETAILS AND FINANCIALS

	* Format:	ASCII, Comma-delimited, Quotes
        * Output:       Code, Name, Address 1-4, Contact 1, "Known as"-2,
        *               total balance, current, 1 mth, 2 mth, 3 mth
        *               last payment $, date, $ over limit, limit

8DTP04E6 - CLIENT LIST

        * Format:	ASCII, Comma-delimited, Quotes,
        * Output:       Code, Name, Address 1-4, Phone,
        *               Fax, Contact, Mail codes

8DTP04E7 - SERVICES

        * Format:	ASCII, Comma-delimited, Quotes
        * Output:       Code, Name, Address 1-4, post code, phone,
                        fax, Contact 1, other 1,
                        Date of commencement, Last invoice date, Status,
                        Type, Area, Salesman, Mail Codes

8DTP04E8 - COGFAX


	* Format:	ASCII, Comma-delimited, Quotes
	* Output:	Name, Phone, Fax, Contact 2, Acct.

8DTP04EC - NEW ACCOUNT CODE

Can be re-imported with 8DTX41XC

	* Format:	ASCII comma delimited
	* Output:	Code, Name, New Account code

8DTP04ED - FOR DTX

Can be re-imported with 8DTX44L1


	*  Format:	ASCII comma delimited
        *  Output:      Old A/c No., name,
        *               Short code, New Cust code,
        *               Cust. type:  Old, New,
        *               Area:        Old, New,
        *               Acct. type:  Old, New,

8DTP04EE - Contact / Discount

	*  Format:	ASCII comma delimited
        *  Output:      Code, name, Address, City, Discount Code, Phone, Fax, Contact

8DTP04EF - FIX ADDRESSES WITH ASTERISKS

	* Format:	ASCII, Comma-delimited, Quotes
	* Output:	Name, Name-2, Address 1-3, Town, Country, Post-code, Attention,
	*               Short name, Code, Status, Message Code, Balance, Message

8DTP04EH - PRODUCT SALES

Designed to be run after 8SMP02GH.
This creates a report of only those customers.

        * Format:	ASCII, Comma-delimited, Quotes
        * Output:       Code, Name, Add 1, 2, 3 OR town, Contact sales,
	*               Postcode, Phone, Area, Chg-to, Fax, Mobile, E-mail

8DTP04ET - Area / Balance / Sales

        * Format:	ASCII, Comma-delimited, Quotes
        * Output:	Account,Cust Type,Area,Region,Acct Type,name,balance,sales YTD,

8DTP04EX - FILE EXPORT

        * Format:	ASCII, Comma-delimited, Quotes
        * Output:	Everything!

LABELS

Mailing labels can be printed for despatch, for statements and credit control letters,
for specific customer category for a sales campaign or for files etc.

8DTP04L1 - STD NAME AND ADDRESS LABEL (3.5" x 1")

Name, Postal, Address 3, Town.

Doesn't print Street Address if Postal present.

8DTP04L3 - DESPATCH LABEL

Name, Street, Address 3, Town - Ref.

8DTP04L4 - LARGE DESPATCH LABEL

Name, Address 3, Town - Invoice No and Customer Ref.

8DTP04L5 - LASER NAME AND ADDRESS

Name, Postal, Address 3, Town.

STATEMENTS

There are several versions - for 10" or 15" forms or A4 paper, there is also an e-mail version.
They can be printed any time - for e.g. one branch or a single customer. Messages can be printed on most versions.

8DTP04S1 - STD STATEMENT

 OFFICE COPY                                      STATEMENT                                         REMITTANCE


        COGITO Services Ltd                               COGITO Services Ltd                       COGITO Services Ltd
                                                                                                    390 Montreal St
390 Montreal St         Phone (03) 366-8543       390 Montreal St         Phone (03) 366-8543       P O Box 25-071
P O Box 25-071          Fax   (03) 365-5455       P O Box 25-071          Fax   (03) 365-5455       Phone (03) 366-8543
CHRISTCHURCH                                      CHRISTCHURCH                                      Fax   (03) 365-5455

  Cust: COMPNY          To: 25/08/2001  Page 1      Cust: COMPNY          To: 25/08/2001  Page 1    Cust: COMPNY   To: 25/08/2001  1

      Company Ltd                                       Company Ltd                                 Company Ltd
      P O Box 12312                                     P O Box 12312                               P O Box 12312
      CHRISTCHURCH                                      CHRISTCHURCH                                CHRISTCHURCH


  Date        Reference    Debits      Credits      Date        Reference    Debits      Credits    Date       Ref.          Amount

18/07/01 Invoice  4015   2,323.13                 18/07/01 Invoice  4015   2,323.13                 18/07/01 Invoi  4015   2,323.13
 1/07/01 Invoice  4016     838.13                 31/07/01 Invoice  4016     838.13                 31/07/01 Invoi  4016     838.13
31/07/01 Invoice  4023       0.08                 31/07/01 Invoice  4023       0.08                 31/07/01 Invoi  4023       0.08
31/07/01 Invoice  4042       5.00                 31/07/01 Invoice  4042       5.00                 31/07/01 Invoi  4042       5.00
31/07/01 Invoice  4043   2,025.00                 31/07/01 Invoice  4043   2,025.00                 31/07/01 Invoi  4043   2,025.00
31/07/01 Invoice  4049   2,373.75                 31/07/01 Invoice  4049   2,373.75                 31/07/01 Invoi  4049   2,373.75
 8/08/01 Invoice  4055     180.00                  8/08/01 Invoice  4055     180.00                  8/08/01 Invoi  4055     180.00
21/08/01 Invoice  4060     335.25                 21/08/01 Invoice  4060     335.25                 21/08/01 Invoi  4060     335.25
23/08/01 Unall B001001                   0.08-    23/08/01 Unall B001001                   0.08-    23/08/01 Unall001001       0.08-
23/08/01 Unall B002001                   5.00-    23/08/01 Unall B002001                   5.00-    23/08/01 Unall002001       5.00-





                       BALANCE DUE  $8,075.26                            BALANCE DUE  $8,075.26              BALANCE DUE   8,075.26

3 mths + over  2 months   1 month     Current                               Overdue     Current
                         7,565.09     $510.17                              7,565.09     $510.17

OFFICE COPY STATEMENT REMITTANCE

                         COGITO Services Ltd


              390 Montreal St         Phone (03) 366-8543
              P O Box 25-071          Fax   (03) 365-5455
              CHRISTCHURCH



      Company Ltd
      P O Box 12312
      56 Work St
      Riccarton                                                 STATEMENT
      CHRISTCHURCH
_______________________________________________________________________________________

          Customer Code: COMPNY                   To: 25/08/2001  Page  1
     Date     Reference             Debits      Credits      Balance
_______________________________________________________________________________________

   18/07/01   Invoice    4015       2,323.13                  2,323.13
   31/07/01   Invoice    4016         838.13                  3,161.26
   31/07/01   Invoice    4023            .08                  3,161.34
   31/07/01   Invoice    4042           5.00                  3,166.34
   31/07/01   Invoice    4043       2,025.00                  5,191.34
   31/07/01   Invoice    4049       2,373.75                  7,565.09
    8/08/01   Invoice    4055         180.00                  7,745.09
   21/08/01   Invoice    4060         335.25                  8,080.34
   23/08/01   Unall Ba 001001                         .08-    8,080.26
   23/08/01   Unall Ba 002001                        5.00-    8,075.26




_______________________________________________________________________________

                                    Overdue      Current      BALANCE
                                    7,565.09      $510.17    $8,075.26
_______________________________________________________________________________

8DTP04S2 - A4 / E-mail STATEMENT

You will probably have some customers who receive printed and some who have e-mailed statements. Use E-mail report selections to print the statements for customers with AND without "U" in their setups.

DTP04S2

8DTP04S5 - WICKLIFFE STATEMENT

COGITO Services Ltd                   COGITO Services Ltd
390 Montreal St                       390 Montreal St
P O Box 25-071                        P O Box 25-071
Phone (03) 366-8543                   Phone (03) 366-8543

   COMPNY    25/08/20   1            COMPNY            25/08/2001             1
                                      COGITO Services Ltd

Company Ltd                                 Company Ltd
P O Box 12312                               P O Box 12312
Riccarton                                   Riccarton
CHRISTCHURCH                                CHRISTCHURCH



18/07 Inv   4015  2323.13      18/07/01 Invoice     4015     2,323.13
31/07 Inv   4016   838.13      31/07/01 Invoice     4016       838.13
31/07 Inv   4023   293.78      31/07/01 Invoice     4023       293.78
31/07 Inv   4042   225.00      31/07/01 Invoice     4042       225.00
31/07 Inv   4043  2025.00      31/07/01 Invoice     4043     2,025.00
31/07 Inv   4049  2373.75      31/07/01 Invoice     4049     2,373.75
 8/08 Inv   4055   180.00       8/08/01 Invoice     4055       180.00
21/08 Inv   4060   335.25      21/08/01 Invoice     4060       335.25
23/08 Una 001001      .08-     23/08/01 Unall Ba  001001                    .08-
23/08 Una 002001     5.00-     23/08/01 Unall Ba  002001                   5.00-




                  8075.26                                              8,075.26

                   510.17                                 7,565.09      510.17

                  7565.09

8DTP12C1 - SPECIAL PRICE AND DISCOUNTS - STD

See running reports.

 
              Code      Description                       Rate               From     To     Jobs...

COGCHR   Cogito Services                    1  (Discount / Price codes)
       D C  P  8CR             Creditors                   10.00             1/09/01 31/08/02
       P C  I  8CRL29C0                                   500.00             1/08/01 31/08/01
       T C                 0000                Extra text page for notes

8DTP12C2 / C3 - SPECIAL PRICE AND DISCOUNTS

 
   Product            Price      Cost      GP%     From     To     Description

COGCHR   Cogito Services               Rep: MS   Prc: 1  Disc:
   8CR                10.00                       1/09/01 31/08/02 Creditors
   8CRL29C0          500.00                       1/08/01 31/08/01 Creditors Setup program

8DTP12KS - SPECIAL PRICE EXPORT

See running this report.

customer	product	Special 1	from ccyymmdd	to ccyymmdd	cost	Special 2	from	to	cost	price-1	price-2	price-3	price-4	price-5	last-cost	avg-cost	std-cost	St	description
OR branch       MOUSE       12.75            20100920    20100926       2.50        10.75     20100927 20101003  2.50
OR product

8DX03FV - FIND VALUE

Using file: accept current or change to history ccDTT01
Customer range:
Search for (value): 67.20

8DTP20 - CASH COLLECTION

Can be attached to a Trial Balance report - needs to be run every month
to build up percentages.

Collected  = % of O/Bal         L a s t   1 2   M o n t h s'   C o l l e c t i o n s
 24,217.45    47.89      % 1 48% 2 59% 3 75% 4 33% 5 47% 6 31% 7 66% 8 87% 9 54%10   %11   %12

8INP10C2 - CASH UP TILL

Also 8INP10C1 and 8INP10C3 See Cash Sales Payments

Bach No. e.g. Rep 236
--------------------------------------------------------------------------------
            Chq                    1,298.29
            Cash                $     52.42
            Visa                     790.66
            EftPos              $    293.18
                                  ---------
            Total Sales            2,434.55
                                  =========


            Change rounding             .04-
            Cash in till             345.64
            Total GST                270.52
            No. of Dockets            20
            First Docket #       439,616     (Invoice
            Last Dockt #        439,635       range)
            ** TILL CLEARED      ******      (If Z-off selected)

8SYP01CA - CREDIT RETURN ANALYSIS

Monthly totals are cleared with the Debtors Roll, annual totals are accumulated.

Code  Description      === This Month ===   === This Year ===   Ratio
                           Value    Qty         Value    Qty

CA    Cost Adjustment                         5,670.16-   42       4.1
CE    Customer Error                            173.07-    4        .1
DC    Double Charge                          21,273.37-  146      15.3
FG    Faulty Goods                              247.38-    4        .2
FR    Freight
GE    Too Expensive                             338.09-    3        .2
GR    Goods Returned                         40,942.35-  396      29.4
IC    Incorr. Code                               28.34-    4
IP    Incorr. Price                           1,189.48-   26        .9
IQ    Incorr. Quantity                        1,031.68-    6        .7
NR    Not Received                            3,490.57-   12       2.5
PP    P P Rebate           158.15-    1      47,170.76-  150      33.8
SE    Supplier Error                             29.37-    1
WC    Wrong Customer                         16,199.48-  159      11.6
WP    Wrong Product                           1,675.91-   25       1.2

        TOTALS             158.15-    1     139,460.01-  978

	Services Limited		Integrated Business Solutions
		DEBTORS REPORTS