8INL01-- INVOICES

See reprinting invoices.
This layout is for A4 paper - various forms are catered for. Invoices can also be e-mailed as PDFs.
There are many setups to control the way a document is printed and the same document can be printed "domiciled" (on own letterhead) or not.

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

 Invoiced to:                           Delivered to:

 FSI Ltd.

 P O Box 12

 METHVEN

  GST No.    71-494-888                                      TAX INVOICE     No.   4251

________________________________________________________________________________________________
   Your Ref.        Our Ref                           Sent by:                    Date    Page
                    CH  Mark               FSI                                 13/01/2002   1
________________________________________________________________________________________________

Description                                         Unit      Qty       Price           TOTAL
________________________________________________________________________________________________
Anti-Glare Screen                                  Each        1        79.00          79.00
CMOS Battery                                       Each        1        20.00          20.00
Imation Recordable CD 650 MB                       Each        1        10.00          10.00
Floppy disk drive                                  Each        1        35.00          35.00

...

________________________________________________________________________________________________

                                                                     _________________________
                                                                      Net            144.00

                                                                      Plus GST        18.01
                                                                     _________________________
                                                                      TOTAL          162.01
                                                                     _________________________

8INP01C2 - Standard

See running Invoice Registers. They have default settings to reflect their use but these can be overridden.

Invoice Disc.     Tax       Cost   Sale Value   ---$---GP--%--    TOTAL   Status    Run    Date   Customer
------------------------------------------------------------------------------------------------------------------------------------
*** INVOICES ***
  4235           500.00               4000.00    4000.00  100    4,500.00 Canc.   CH     30/11/01 CODE   NAME
  4236  216.00   269.00               2152.00    2152.00  100    2,421.00 Proc.   CH 231 30/11/01 CODE   NAME
  4237   60.00   102.50                820.00     820.00  100      922.50 Proc.      231 30/11/01 CODE   NAME
...
  4243            42.50                340.00     340.00  100      382.50 Proc.   CH 231 30/11/01 CODE   NAME
  4244            30.00-               240.00-    240.00- 100      270.00-Proc.   CH 232 13/11/01 CODE   NAME
*** ORDERS ***
 20347                                               .00    0             Order           4/05/98 CODE   NAME
 20348                                               .00    0             Order/P    233  4/05/98 CODE   NAME
 20369                                               .00    0             Done    CH 231 29/07/98 CODE   NAME
 20375                                               .00    0             Order   CH     14/08/98 CODE   NAME
** CASH SALES **
  4501            61.09     268.48     488.75     220.27   45      549.84 Future  CH     12/12/01 CODE   NAME
  4502            48.00     348.00     384.00      36.00    9      432.00 Future  CH     12/12/01 CODE   NAME
  4503             5.00      19.00      40.00      21.00   53       45.00 P/Slip  CH     12/12/01 CODE   NAME
*** QUOTES ***
 50095           231.25    1314.70    1850.00     535.30   29    2,081.25 Quote   CH      9/10/01 CODE   NAME
 50096           245.25    1347.92    1962.00     614.08   31    2,207.25 Canc.   CH 226  9/10/01 CODE   NAME
 50097           245.25    1347.92    1962.00     614.08   31    2,207.25 Quote   CH      9/10/01 CODE   NAME

------------------------------------------------------------------------------------------------------------------------------------
        Disc.     Tax       Cost   Sale Value   ---$---GP--%--    TOTAL   Status     *** Run Totals ***

------------------------------------------------------------------------------------------------------------------------------------

        276.00   670.46      74.39    5363.69    5289.30   99    6,034.15          = Updated Invoices
                 745.25    1347.92    5962.00    4614.08   77    6,707.25          = Cancelled Invoices
                   5.00      19.00      40.00      21.00   53       45.00          = Packing slips
                 476.50    2662.62    3812.00    1149.38   30    4,288.50          = Quotes
                                                     .00                           = Future Period
------------------------------------------------------------------------------------------------------------------------------------

          20 documents    $902.84  avg.;        84 lines   4.2 /doc.

8INP01C4 - Includes Customer Orders

Invoice Disc.     Tax       Cost   Sale Value   ---$---GP--%--    TOTAL   Status    Run    Date   Customer

8INP01C5 - Cogito layout

Invoice Cust.     Date   Sold by    ---$---GP--%--    TOTAL  St. Sale Value   Tax   Run  Customer

8INP01C7 - Credits register x salesman

Invoice Cust.     Date   Sold by    ---$---GP--%--    TOTAL  St. Sale Value   Tax   Run  Customer

8INP01C8 - GP / Bottom Line - Details

N.B. Defaults to a detailed report. GP range can be set to a default so that only "exceptions" outside the range are reported.

Invoice           Sale     Tax     GP%     TOTAL  St   Date   Customer Rep
          Qty     Sell     Cost                       Product

8INP01D1 - Invoice Register with Time Analysis

Option to Sub-total every nn hours.

Invoice Cust.     Date    by   ---$--GP--%--     TOTAL    Disc. St. Customer                 Time

----  6:00 ------------------------------------------------------
  4235 CODE     30/11/01 DM     4000.00 100    4,500.00          C NAME                        6:00
  4501 CODE     12/12/01 RL      220.27  45      549.84            NAME                        6:00
...
         Sub-total     47.8%    4277.27  87    5,526.84
                                        avg.   1,381.71     5 lines    4 docs  1.2/doc.
---- 11:00 ------------------------------------------------------
  4237 CODE     30/11/01 MS      820.00  87      922.50    60.00 P NAME                       11:18
         Sub-total      8.0%     820.00 100      922.50    60.00
                                        avg.     922.50     2 lines    1 docs  2.0/doc.
---- 13:00 ------------------------------------------------------
  4238 CODE     30/11/01 MS      600.00 100      675.00          P NAME                       13:30
  4239 CODE     30/11/01 MS      800.00 100      900.00          P NAME                       13:32
...
         Sub-total     44.2%    4469.30  98    5,111.65   216.00
                                        avg.     638.96    15 lines    8 docs  1.8/doc.

---- Summary: ---------------------------------------------------
                      % sales  ---$--GP--%--     TOTAL

         Charge sales  93.5%    9529.30  99   10,804.15   276.00
         Cash Sales     8.9%     277.27  30    1,026.84
         Credits        2.3%     240.00-100      270.00-
         Run Totals...100.0%    9566.57  93   11,560.99   276.00

         Stats........                  avg.     889.31    22 lines   13 docs  1.6/doc.

8INP01D2 - Departmental / by Account Type

Sorts by Account Type.

Invoice  Disc.     Tax      Cost   Sale Value   ---$---GP--%--    TOTAL   Status    Run    Date   Customer

8INP01P1 - CASH SALES REGISTER

Invoice Date   Sold by      TOTAL  St.Paid by      Name                  Cheque #
------------------------------------------------------------------------------------------------------------------------------------
439616  6/12/00 SM         1,298.29   Chq          COGITO SERVICES       112233    COGITO
439617  6/12/00 JS            15.86   Cash                                         CASH
439618  6/12/00 MS            23.39   Cash                                         CASH
439619  6/12/00 RT             3.00   Cash                                         CASH
...
439633  6/12/00 JS           159.01   Visa                                         CASH
439634  6/12/00 JS            38.13   EftPos                                       3519
439635  6/12/00 MG           168.75   Visa                                         CASH

------------------------------------------------------------------------------------------------------------------------------------
         *** Run Totals ***        St.Paid by      Name                  Cheque #

------------------------------------------------------------------------------------------------------------------------------------

8INP01Q5 - Quotes summary

Quote  Cust.     Date   Sold by    ---$---GP--%--    TOTAL  St. Sale Value   Tax   Run  Customer

8INP01EM - E-Mailed invoices (from daily update)

This register is automatically run with the Update for Invoices and Credits to be e-mailed. If the process should fail this register can be run to re-send the batch of e-mails and / or Mark as "copy". See E-Mail Batch Update

378534 COGITO   sent
378536 ELMARI   No e-mail address

8INP01RP - Mailed invoices

Uses your own invoice program to print the non e-mail invoices to a file for posting.
See E-Mail Batch Update

8INL03 - INVOICE UPDATE - STOCK OUT REPORT

This report can be included with the Update.

  Inv  Cust     Product          Message               Qty   O/h   Rec.  Iss

 31067 CASH     77876            negative stock          1     2-
 31067 CASH     77876A           negative stock          1     3-
 31068 CASH     78657            negative stock          3     1-   11
 31068 CASH     78672            negative stock          2     2-    6
 31070 CASH     79011            negative stock          1     1-

OR

8INL10 - INVOICE UPDATE - HELD STOCK REPORT

Invoices can be "held" until stock is costed.

  Inv  Cust     Product          Message               Qty   O/h   Rec.  Iss  S/O  Sman.

  4247 SW       HW-AGSCR         Held for costing        1                 1       MS
  4248 SW       HS-INV2          Held for costing        1                 1       MS

Invoice Disc.    Freight   Tax       Cost   Sale Value    ---$---GP--%--   TOTAL   Stat. Area  Date   Customer
------------------------------------------------------------------------------------------------------------------------------------
              *** INVOICES ***
  4247                                75.00                 75.00-   0             HELD  29CH 27/12 SW       Software Development
  4248                               174.00                174.00-   0             HELD  29CH 27/12 SW       Software Development
              *** ORDERS ***
------------------------------------------------------------------------------------------------------------------------------------
        Disc.    Freight   Tax       Cost   Sale Value    ---$---GP--%--   TOTAL     *** Run Totals ***
------------------------------------------------------------------------------------------------------------------------------------

8INP01I2 - Issued stock

Not yet processed - useful for Stocktake.

Invoice Disc.     Tax       Cost   Sale Value   ---$---GP--%--    TOTAL   Status    Run    Date   Customer
Product         Description                                       Qty.   P/slip Cust.      Price    Cost       Gross      Total
------------------------------------------------------------------------------------------------------------------------------------
ADMIFG          Courier                                             1.00    4324 SW           7.39     7.39       7.39        8.31
HS-INV2         Invoice Forms                            2.00       2.00    4324 SW         192.00   174.00     192.00      216.00
HW-F6           Fan                                      1.00       1.00    4323 MISC       560.00   449.00     560.00      630.00
HW-CRP          CRM - NEW                                           1.00    4323 MISC       550.00   414.00     550.00      618.75

------------------------------------------------------------------------------------------------------------------------------------
        Disc.     Tax       Cost   Sale Value   ---$---GP--%--    TOTAL   Status     *** Run Totals ***

------------------------------------------------------------------------------------------------------------------------------------

                 163.67    1044.39    1309.39     265.00   20    1,473.06          = Confirmed Invoices
------------------------------------------------------------------------------------------------------------------------------------

8INP01S1 - SALESMAN performance report

N.B. This uses Sales data and is updated from the Sale File.

        ================= TODAY ================  ============= This Month ===============  ============ Last 12 Months ==============
Rep      Docs.    Sales          GP$   GP% Contr   Docs.    Sales          GP$   GP% Contr   Docs.     Sales           GP$   GP% Contr
  AB        1      571.55       156.84  27  1.3      23    8,527.34     2,243.70  26  1.9      37     9,590.09      2,539.68  26  0.1 
  CD       17   25,714.46     4,427.44  17 35.9      76  100,215.61    16,823.22  17 14.5     685   848,222.69    137,854.42  16  8.0 
  EF       13    4,065.49       884.17  22  7.2     142   29,270.92     6,673.83  23  5.8   1,643   263,729.46     62,388.24  24  3.6 

...Totals

8INP01C6 - Order status list x Customer

Invoice Cust.     Date   Sm  St.  Done  Run  Customer                    TOTAL
 Product        Description                                    St  Qty   Total

8INP01O1 - Outstanding Orders X ProdUCT

Invoice Disc.     Tax       Cost   Sale Value   ---$---GP--%--    TOTAL   Status    Run    Date   Customer
Product         Description                                      Avail.Qty.    Order  Cust.     Price       Total    Due date

8INP01O2 - Outstanding Orders X ProdUCT (Available Stock)

Product         Description                                 Avail.     Qty.    Order  Cust.     Price       Total       Due    O/h

8INP01O3 - Outstanding Orders x CustOMER (usually with details)

Invoice Disc.     Tax       Cost   Sale Value   ---$---GP--%--    TOTAL   Status    Run    Date   Customer
Product         Description                                       Qty.   Order   Cust.      Price    Cost       Gross      Total

8INP01O4 Service Orders x Product (Cogito)

Product          Description                                                 Due date   By    Done    Order  Cust.

8INP01O6 - Ready Orders x Prod. (COGITO)

Prints only "update" text

Order   Cust.     Date   Sm  St.  Done
 Product        Description

8INP01OB - Outstanding "buy-in" Orders X Prod. (with "Available" and P/Order No.)

Product            Avail.   Description
                    Qty.    Order  Cust.      Price       Total     Due   S/Ord    Ref.

8INP01X1 - Reps Subtotals

N.B. Many of these reports are directed to print to specific .csv files - can be overridden.

	*  Format:	ASCII comma delimited
        *  Output:      "Rep","Invs.","Inv%","Sales","GP$",
        *               "GP%","GP contrib","Invs.","Inv%","Sales",
        *               "GP$","GP%","GP contrib"

8INP01X2 - Customer Details

                      A = Header. S = Detail line
	*  Format:	ASCII comma delimited
        *  Output:   "A","invoice","customer","date","ref","gross",
        *               "tax","total","trans desc","type","name","cust-ref","sold-by",
	*
        *            "S","invoice","product","qty","price","gross",  
        *               "tax","total","sell-price","units","description",              

8INP01XA - Invoice Totals, 8INP01XB - Invoice Details

Very full exports

8INP01XD - Delivery Details

	*  Format:	ASCII comma delimited
        *  Output:      "customer","invoice","date","deliv-1","deliv-2",
        *               "deliv-3","deliv-4","nett",

8INP01XG - GP Exception

	*  Format:	ASCII comma delimited
        *  Output:      "product","supp","qty","price","cost","GP%","total",
        *               "ind","Rep","Cust","invoice","date","description",

8INP01XS - Stock lines

	*  Format:	ASCII comma delimited
        *  Output:      "Cust","invoice","date","product","description","qty","price",
        *               "price-sw","price-code","file-price","retail","disc-code","disc-rate",
	*		"disc-rate-1","disc-rate-2","disc-sw","type","branch","seq",
	*		"status","category","sales-code","scm-status","text-flag","salesman",

8INL85T - Invoice File Audit / Repair

Select parameters - useful for checking an error such as duplicate invoice numbers.