Verify and Adjust Controls Transaction Listing - Financial Valid Transaction File

GL190

DATE   02/17/92                               ANDERSEN PC SOFTWARE - MULTINATIONAL                                        PAGE    37

TIME   15:33:20                               ANDERSEN PC SOFTWARE - BRUSSELS                                             CO     007

REPORT GL190                                                                                                              LOC    BRU

                                           VERIFY AND ADJUST CONTROLS TRANSACTION LISTING

                                                   FINANCIAL VALID TRANSACTION FILE

BASE CURRENCY   BEF   BELGIAN FRANC

                                                                                                                               CURR

YR  PD  ACCOUNT      CENTER    JOURNAL  JRN DATE     DEBIT AMOUNT       CREDIT AMOUNT      JRN DESCRIPTION     REF1   REF2     CODE

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

92   2 1AR                      GL0001  01/20/92                              15,102.00                                        DEM

92   2 1BUILD                   GL0001  01/20/92                              48,965.00                                        DEM

92   2 1CASH                    GL0001  01/20/92                               6,780.00                                        DEM

92   2 1DEP                     GL0001  01/20/92           32,185.00                                                           DEM

92   2 1EQUIP                   GL0001  01/20/92                              21,469.00                                        DEM

92   2 1INV                     IA0017  02/29/92               36.00                                                           BEF

92   2 1INV                     IA0017  02/29/92                                  36.00   DELETION REVERSAL                    BEF

92   2 1INV                     GL0001  01/20/92                              21,093.00                                        DEM

92   2 1LAND                    GL0001  01/20/92                               7,533.00                                        DEM

92   2 1PAT                     GL0001  01/20/92                                 528.00                                        DEM

92   2 1PPEXP                   GL0001  01/20/92                                 942.00                                        DEM

92   2 1PPEXP                   FRST01  02/12/92                               2,147.00                                        DEM

92   2 1UNGN                    GL0001  01/20/92           15,102.00                                                           DEM

92   2 1UNGN                    GL0001  01/20/92           48,965.00                                                           DEM

92   2 1UNGN                    GL0001  01/20/92            6,780.00                                                           DEM

92   2 2DP                      GL0001  01/20/92            3,013.00                                                           DEM

92   2 2ITD                     GL0001  01/20/92           11,376.00                                                           DEM

92   2 2LIA                     GL0001  01/20/92            5,274.00                                                           DEM

92   2 2LTD                     GL0001  01/20/92           15,340.00                                                           DEM

92   2 2UNLS                    GL0001  01/20/92                              32,185.00                                        DEM

92   2 2UNLS                    GL0001  01/20/92                              12,111.00                                        DEM

92   2 2UNLS                    GL0001  01/20/92                             114,601.00                                        DEM

92   2 2UNLS                    GL0001  01/20/92                               3,766.00                                        DEM

92   2 2UNLS                    GL0001  01/20/92                               3,013.00                                        DEM

92   2 2UNLS                    GL0001  01/20/92                              11,376.00                                        DEM

92   2 2UNLS                    GL0001  01/20/92                               5,274.00                                        DEM

92   2 2UNLS                    GL0001  01/20/92                              15,340.00                                        DEM

92   2 5SEXP                    FRST01  02/12/92            2,147.00                                                           DEM

92   2 9999999999               IA0017  02/29/92                                  36.00                                        BEF

92   2 9999999999               IA0017  02/29/92               36.00                      DELETION REVERSAL

Verify and Adjust Controls Transaction Listing - Statistical Cumulative Transaction File (GL190)

DATE   02/17/92                               ANDERSEN PC SOFTWARE - MULTINATIONAL                                        PAGE    44

TIME   15:33:20                               ANDERSEN PC SOFTWARE - BRUSSELS                                             CO     007

REPORT GL190                                                                                                              LOC    BRU

                                           VERIFY AND ADJUST CONTROLS TRANSACTION LISTING

                                              STATISTICAL CUMULATIVE TRANSACTION FILE

YR  PD  ACCOUNT      CENTER    JOURNAL  JRN DATE   INCREASE QUANTITY  DECREASE QUANTITY    JRN DESCRIPTION     REF1   REF2      UM

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

92   1 4SALES                   AR0001  01/14/92                                  89.10   SALES                                 EA

92   1 5ADEXP                   AP0001  01/31/92               70.50                      ADMINISTRATIVE EXP                    EA

92   1 5SEXP                    AP0001  01/31/92               34.90                      SELLING EXPENSES                      EA

Purpose

This report is used to verify that the transaction count debit amount totals of all transactions for all periods equal totals contained on control records for the transactions. Two versions of the report can be printed: a summary version and a detail version. A flag on Reference File category P01, Processing Options, controls the report print option. This option can be updated using the Reference File Maintenance Conversation. If the detail version is selected, the detail and summary versions of the report are printed.

Detail Listing

The detail version of the report lists all valid transactions. The report is produced for both financial and statistical transactions for the Valid and Cumulative Transaction Files.

Verify and Adjust Controls Transaction Listing - Financial Control Totals (GL190)

DATE   02/17/92                               ANDERSEN SOFTWARE EUROPE                                                    PAGE     1

TIME   15:33:20                               ANDERSEN SOFTWARE - BERLIN                                                  CO     001

REPORT GL190                                                                                                              LOC    BER

                                           VERIFY AND ADJUST CONTROLS TRANSACTION LISTING

                                                   FINANCIAL VALID TRANSACTION FILE

BASE CURRENCY   DEM   GERMAN MARK

                          CONTROL RECORD BALANCE             CALCULATED BALANCE                   DIFFERENCE

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

         YR  PD       TRANS           AMOUNT           TRANS           AMOUNT           TRANS           AMOUNT

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

         91   1        300               177,367.92     300               177,367.92       0                      .00

              2          3                66,989.71       3                66,989.71       0                      .00

              3          0                      .00       0                      .00       0                      .00

              4          0                      .00       0                      .00       0                      .00

              5          0                      .00       0                      .00       0                      .00

              6          4                    22.52       4                    22.52       0                      .00

              7          4                    11.75       4                    11.75       0                      .00

              8          3                   619.30       3                   619.30       0                      .00

              9          0                      .00       0                      .00       0                      .00

             10        130                52,131.66     130                52,131.66       0                      .00

             11          0                      .00       0                      .00       0                      .00

             12         88                   165.53      88                   165.53       0                      .00

             13          0                      .00       0                      .00       0                      .00

Financial Control Totals

The summary version of the report lists for each fiscal period, transaction count and debit amount control record totals, calculated totals, and the difference, if any, between the two. In addition, any error messages associated with a location are printed. The summary version of the report is printed for each location.

Common report fields for financial reports are listed below. Other report fields are listed and described below.

Report Heading	Full Name
PD	Fiscal Period
CONTROL RECORD BALANCE
TRANS	The total number of transactions for each fiscal period contained on the control record for the listed file.
AMOUNT	The total debit amount of all transactions for each period contained on the control record for the listed file.
CALCULATED BALANCE
TRANS	The total number of transactions on the listed file calculated for each period.
AMOUNT	The total debit amount of all transactions on the listed file calculated for each period.
DIFFERENCE
TRANS	The difference between the control record transaction total and the calculated transaction total for each period.
AMOUNT	The difference between the control record debit amount and the calculated debit amount for each period.
YR	Fiscal Year
BASE CURRENCY	Base Currency (Multi-currency environments only.)

Verify and Adjust Controls Transaction Listing - Statistical Control Totals (GL190)

DATE   02/17/92                               ANDERSEN SOFTWARE EUROPE                                                    PAGE     2

TIME   15:33:20                               ANDERSEN SOFTWARE - BERLIN                                                  CO     001

REPORT GL190                                                                                                              LOC    BER

                                           VERIFY AND ADJUST CONTROLS TRANSACTION LISTING

                                                 STATISTICAL VALID TRANSACTION FILE

BASE CURRENCY   DEM   GERMAN MARK

                          CONTROL RECORD BALANCE             CALCULATED BALANCE                   DIFFERENCE

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

         YR  PD       TRANS          QUANTITY          TRANS          QUANTITY          TRANS          QUANTITY

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

         91   1         13                   359.02      13                   359.02       0                      .00

              2          0                      .00       0                      .00       0                      .00

              3          0                      .00       0                      .00       0                      .00

              4          0                      .00       0                      .00       0                      .00

              5          0                      .00       0                      .00       0                      .00

              6          0                      .00       0                      .00       0                      .00

              7          0                      .00       0                      .00       0                      .00

              8          0                      .00       0                      .00       0                      .00

              9          0                      .00       0                      .00       0                      .00

             10          0                      .00       0                      .00       0                      .00

             11          0                      .00       0                      .00       0                      .00

             12          8                      .00       8                      .00       0                      .00

             13          0                      .00       0                      .00       0                      .00

Statistical Control Totals

Common report fields for statistical reports are listed below. Other report fields are listed and described below.

Report Heading		Full Name
PERIOD	Fiscal Period
YR	Fiscal Year
CONTROL RECORD BALANCE
TRANS	The total number of transactions for each fiscal period contained on the control record for the listed file.
QUANTITY	The total quantity amount of all transactions for each period contained on the control record for the listed file.
CALCULATED BALANCE
TRANS	The total number of transactions on the listed file calculated for each period.
QUANTITY	The total quantity amount of all transactions on the listed file calculated for each period.
DIFFERENCE
TRANS	The difference between the control record transaction total and the calculated transaction total for each period.
QUANTITY	The difference between the control record quantity amount and the calculated quantity amount for each period.

Report Sequence

Company, location, account number.

Menu

Verify and Adjust Controls Transaction Listing - Financial Valid Transaction File

Verify and Adjust Controls Transaction Listing - Statistical Cumulative Transaction File (GL190)

Verify and Adjust Controls Transaction Listing - Financial Control Totals (GL190)

Verify and Adjust Controls Transaction Listing - Statistical Control Totals (GL190)