APPX Software Library

1Transaction Processing

Option 10Consolidated Processing

The following menu appears when you select the Consolidated Processing option from the Transaction Processing menu and allows you to select from four different options.

Consolidated Processing menu

The Accounts Payable Consolidated Processing Menu
Figure 16

Edit Unposted Control Groups

You can use this function to edit the “Print Journal?” and “Post Now?” questions on all control group records of outstanding transactions.

On the following pages, the screen displayed by this function is shown.

The screen shown below presents information about Control Groups.

Unposted Control Groups screen

The Accounts Payable Unposted Control Groups Screen
Figure 17

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press ENTER; the record will be displayed for editing.

Data items for the preceding screen are described below:

Operator ID

Upper case, up to 3 characters Display only Letters and numbers only

The operator ID of the operator who entered the control group is displayed.

Control No

Positive number, up to 4 digits Display only

Supply the control number of the record you want to edit.

File

Upper case, up to 4 characters Display only

The originating file is identified. The valid values and their meanings are:

ADJ
Adjustments
INVC
Invoices
CHCK
Hand/Void/Machine Checks
Description

Alphanumeric, up to 30 characters Display only

The description of this group is displayed.

Print Journal?

Y or N Default Y Required

Enter ‘N’ if you want to delay printing the journal for any reason.

Post Now?

Y or N Default Y Required

Enter ‘N’ if you want to delay posting for any reason.

Journal OK?

Y or N Display only Default N

The system displays ‘Y’ if the journal has been printed and has no errors; otherwise, an ‘N’ is displayed.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • EControl Group Can Only Be Edited by the Original Operator

Press ENTER to save the information on this screen.

Select Next Record to go to the next Control Groups record.

At this screen, the use of the MODE keys - CHG or INQ pertain to those records in the Control Groups file.

This function lists any unposted control groups in the Invoices, Adjustments, and Checks files. The number of transactions will also be included. The following processing steps accomplish this job.

  1. Step 1This disposition type is used for all standard Accounts Payable reports.
  2. Step 2In order to print the Accounts Payable Unposted Transactions - Invoices, this step formats the Invoices Control Groups information. The following data items are shown: Operator ID, Control Number, Description, Line Number, Operator Exclusive?, Print Journal?, Journal OK?, Post Now?, Post Started?, Control Total and Vendor Hash Total.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 09:55                                                                                                       LGG Page:  1
                                                  Unposted Transactions - Invoices


                                                              No     Op   Prnt  Jour  Post  Post
Op/Cntrl      Description                                    Trx     Ex   Jour  OK    Now   Strt   Cntrl Total         Hash Total
=================================================================================================================================

LGG / 0012    Commissions Transfer                             0     N    Y     N     Y     N

LGG / 0013    Commissions Transfer                             0     N    Y     N     Y     N

LGG / 0019    Cash                                             0     N    Y     N     Y     N

LGG / 0021    Net 30                                           1     N    Y     N     Y     N

LGG / 0023    Cash                                             2     N    Y     N     Y     N

MRC / 0025    Test Invoice                                     1     N    Y     N     Y     N

PHB / 0017    test                                             0     N    Y     N     Y     N

SRR / 0009    aug. invoices thru 8/20                          5     N    Y     Y     N     N          8755.06               190

SRR / 0011    RECURRING PAYMENTS                               2     N    Y     Y     Y     N           754.80                90

TMG / 0014    August 1994                                      1     N    Y     N     Y     N
  1. Step 3In order to print the Accounts Payable Unposted Transactions - Checks, this step formats the Disbursements Control Groups information. the following data items are shown: Operator ID, Control Number, Description, Auto Hand Flag, Line Number, Operator Exclusive?, Print Journal?, Journal OK?, Post Now?, Post Started?, Control Total and Vendor Hash Total.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 09:55                                                                                                       LGG Page:  1
                                                   Unposted Transactions - Checks


                                                              No     Op   Prnt  Jour  Post  Post
Op/Cntrl      Description                         Hand/Auto  Trx     Ex   Jour  OK    Now   Strt   Cntrl Total         Hash Total
=================================================================================================================================

SRR / 0009    Aug. checks thru 8/20                   H        3     N    Y     Y     N     N          2481.98               140

SRR / 0011    Aug. void checks                        H        2     N    Y     N     N     N          9323.31-               40

TMG / 0012    this is atest                           A       11     N    Y     N     Y     N
  1. Step 4In order to print the Accounts Payable Unposted Transactions - Adjustments, this step formats the Adjustments Control Groups information. The following data items are shown: Operator ID, Control Number, Description, Line Number, Operator Exclusive?, Print Journal?, Journal OK?, Post Now?, Post Started?, Control Total and Hash Total.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 09:56                                                                                                       LGG Page:  1
                                                Unposted Transactions - Adjustments


                                                              No     Op   Prnt  Jour  Post  Post
Op/Cntrl      Description                                    Trx     Ex   Jour  OK    Now   Strt   Cntrl Total         Hash Total
=================================================================================================================================

SRR / 0002    Aug. adjustments                                 4     N    Y     Y     N     N

This job prints the Invoices, Hand Checks, Checks, and Adjustments journals. The following processing steps accomplish this job.

  1. Step 1This disposition type is used for all transaction file journals.
  2. Step 2This function identifies the application that created the invoice control group.
  3. Step 3In preparation for performing a sort/selection process on the Invoices information, this step provides sequencing of data records by Post Now?, Operator ID, Control Number, Post Year and Post Month, with no option to change the sequence at run time. selection of data records is provided by Operator ID, Control Number, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  4. Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  5. Step 5In order to print the Accounts Payable Invoices Journal, this step formats the Invoices and Invoices Line Items information. The following data items are shown: Trx No, Vendor, Name, Pay Status, Invoice Date, Discount and Invoice Due Date, Description, PO No, Post Month/Year, Transaction Type, Warehouse No, Retention and Liability Account, Invoice No, Apply To, Invoice Amt, Prepayment, Retention, Subtotal, Discount, Freight, Tax, Other, Line No, Offset Account, Item, Warehouse No, Price, Quantity, Prorate?, Amount Prorated to Line Item, Amount, Subsidiary type and Code, Prorata and Line Items Total. As appropriate, group headings appear whenever a change occurs in Control No or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control No. When totals are specified, the following amounts are accumulated: Invoice, Prepaid, Retention, Subtotal, Discount, Freight, Tax, and Other. Grand totals print at the end showing Journal Errors and Warnings.
                                                     APPX Demonstration Company
11/30/94 16:29                                                                                                       SRR Page:  1
                                                 Accounts Payable Invoices Journal


 Trx  Vendor                                  Pay Status    Inv Date Dsc Date Due Date Description                    PO No
Mo/Yr
      Liab Account                                         Trx Type               Wh  Retention Account
      Invoice   Apply To   Invc Amt  Prepayment   Retention    Subtotal    Discount  Disc Basis     Freight       Tax       Other
=================================================================================================================================

Control Group SRR / 0009  aug. invoices thru 8/20

Post Month/Year 08 / 89

0001  00000060 Travel Planners                Normal        08/18/89          09/17/89 Williams to Toronto                  08 89
      2010001001  Accounts Payable, Sales                  AP Invoice
      11985-0   11985-0      681.20         .00         .00      681.20         .00      681.20         .00        .00        .00

Line Account                                         Item Code        Wh      Price   Quantity  Prorate?   Prorata      Amount

0001 4110000001MA  Travel & Entertainment, Sales                            681.000       1.00     Y           .00      681.00
                   Williams to Toronto               GL WILLIAMS
0002 1010001000  Cash, Corporate                                              0.200       1.00     Y           .00         .20
                                                                                                             —————       —————
                                                                          — Line Item Totals —>                .00      681.20
————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————

0002  00000060 Travel Planners                Normal        08/19/89          09/18/89 Peters to Baltimore                  08 89
      2010001001  Accounts Payable, Sales                  AP Invoice
      11994-1   11994-1      870.50         .00         .00      870.50         .00      870.50         .00       .00         .00

Line Account                                         Item Code        Wh      Price   Quantity  Prorate?   Prorata      Amount

0001 4110000001MA  Travel & Entertainment, Sales                            870.500       1.00     Y           .00      870.50
                   Peters to Baltimore               GL PETERS
                                                                                                             —————       —————
                                                                          — Line Item Totals —>                .00      870.50
—————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
  1. Step 6In preparation for performing a sort/selection process on the Disbursements information, this step provides sequencing of data records by Post Now?, Operator ID, Control No, Post Year and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control No, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  2. Step 7According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  3. Step 8In order to print the report requested, this step formats the Disbursements and Disbursements Line Items information. The following data items are shown: Trx No, Vendor, Name, Check Amount, Check No, Check Date, Post Month/Year, Hand Check Status, Cash Account, Description, Check Line No, Apply To Apply Type, PO No, Dr Liability, Discount Amount, Cr Retention, Direct Amount, Account, Subsidiary Type and Code, Retention Account, Liability Total, CR Discount Total, CR Retention Total, Direct Total and Line Items Total. As appropriate, group headings appear whenever a change occurs in Control No or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control No. When totals are specified, the following items are accumulated: Active Check Totals, Liability Total, CR Discount Total, CR Retention Total, Direct Total, Line Items Total, Check Total, Control Total, Current Control, Control Remaining, Vendor Hash Total, Current Hash and Hash Remaining. Grand totals print at the end, showing Journal Errors and Journal Warnings.
                                                     APPX Demonstration Company
11/30/94 09:59                                                                                                       LGG Page:  1


                                                        Hand Checks Journal

 Trx Vendor                                   Check Amt  Check No  Chk Date Mo/Yr Status Cash Account
=================================================================================================================================

Control Group SRR / 0011  Aug. void checks

Post Month/Year 08 / 89

0001 00000010 Rainbow Signs, Inc.                168.90- 00000303  08/13/89 08 89 Void  1010001001  Cash, Sales Outlets
Rainbow Signs-cancel payment
Item  Apply To Apl Type     PO No        DR Liab    Discount     CR Retn     Dir Amt   Account

0001  675-SS   Apply To Inv               168.90-       .00                           4090000001WH Repairs and Maintnc, Wholesale
      sign-cancel payment
                                           —————      —————        —————       —————        —————
          — Line Item Totals —>           168.90-       .00          .00         .00       168.90-
—————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————

0002 00000030 Mountain Air Conditioning         9154.31- 00005105  06/01/89 08 89 Void  1010001001  Cash, Sales Outlets
Mountain AC-void lost check
Item  Apply To Apl Type     PO No        DR Liab    Discount     CR Retn     Dir Amt   Account


0001  102      Apply To Inv 97979798     8000.00-        .00                           2010001001  Accounts Payable, Sales
      Mountain Air Conditioning                                                        2030001001  Retention Payable, Sales
0002  109      Apply To Inv               634.68-      19.63-                          2010001001  Accounts Payable, Sales
      Mountain Air Conditioning                                                        2030001001  Retention Payable, Sales
0003  88071000 Apply To Inv               485.00-      15.00-                          2010001001  Accounts Payable, Sales
      Mountain Air Conditioning                                                        2030001001  Retention Payable, Sales
                                           —————      —————        —————       —————        —————
          — Line Item Totals —>          9119.68-     34.63-         .00         .00      9154.31-
—————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————
                                      __________  __________  __________  __________   __________   Active Check Total:    0.
   — Post Mo/Yr 08 89 Totals —>        9288.58-      34.63-        .00         .00      9323.21-        Check Total:    9323.21-
                                      ==========  ==========  ==========  ==========   ==========                      ==========

                                      __________  __________  __________  __________   __________   Active Check Total:    0.
      — Control Group Totals —>        9288.58-      34.63-        .00         .00      9323.21-        Check Total:    9323.21-

                                                                                              Entered    Calculated    Difference
Control Group: SRR / 0011  Aug. void checks                            Control Totals:       9323.31-      9323.21-          .10-
Exclusive?     N                                                       Hash Totals:               40            40
Post Now?      N

Error - The Entered and Calculated Control Totals are Not Equal
Warning - This Control Group Contains Errors and Cannot Be Posted
=================================================================================================================================

=================================================================================================================================
                                         DR Liab    Discount     CR Retn     Dir Amt    Items Tot
                                         _______    ________     _______     _______    _________  Active Check Total:      0.
              — Grand Totals —>          9288.58-     34.63-        .00         .00      9323.21-         Check Total:   9323.21-

Number of Errors in This Journal: 1             Number of Warnings: 1
================================================================================================================================
================================================================================================================================
  1. Step 9In preparation for performing a sort/selection process on the Disbursements information, this step provides sequencing of data records by Post Now?, Operator ID, Control No, Post Year and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control No, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  2. Step 10According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  3. Step 11In order to print the report requested, this step formats the Disbursements and Disbursements Line Items information. The following data items are shown: Trx No, Vendor, Name, check Amount, Check No, Check Date, Post Month/Year, Hand Check Status, Cash Account, Description, Check Line No, Apply To, Apply Type, PO No, Dr. Liability, Discount Amount, Cr Retention, Direct Amount, Account, Subsidiary Type and Code, Retention Account, Liability Total, CR Discount Total, CR Retention Total, Direct Total and Line Items Total. As appropriate, group headings appear whenever a change occurs in Control No or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control No. When totals are specified, the following items are accumulated: Active Check Totals, Liability total, CR Discount Total, CR Retention Total, Direct Total, Line Items Total Check Total, Control Total, Current Control, Control Remaining, Vendor Hash Total, Current Hash and Hash Remaining. Grand totals print at the end, showing Journal Errors and Journal Warnings.
                                                     APPX Demonstration Company
11/30/94 09:53                                                                                                       LGG Page:  1


                                                           Checks Journal

 Trx Vendor                                   Check Amt  Check No  Chk Date Mo/Yr Status Cash Account
=================================================================================================================================

Control Group SRR / 0008  Aug. 1st check run

Post Month/Year 08 / 89

0001 00000040 Albert Materials, Inc.         11110.46   00005500   08/16/89  08 89  Check 1010001001  Cash, Sales Outlets

Item  Apply To Apl Type     PO No        DR Liab    Discount     CR Retn     Dir Amt   Account


0001  1006     Apply To Inv              2597.00       53.00       79.50                2010001001  Accounts Payable, Sales
      materials                                                                         2030001001  Retention Payable, Sales
0001  308      Apply To Inv              4128.15       77.53      126.17                2010001001  Accounts Payable, Sales
      stock                                                                             2030001001  Retention Payable, Sales
0001  311      Apply To Inv              2491.70       50.00       76.25                2010001001  Accounts Payable, Sales
      stock                                                                             2030001001  Retention Payable, Sales
0001  96215    Apply To Inv              2058.00        0.00       63.00                2010001001  Accounts Payable, Sales
      materials                                                                         2030001001  Retention Payable, Sales

                                        ________   _________   _________    ________    _________
          — Line Item Totals —>         11274.85      180.53      344.92        0.00     11110.46
_________________________________________________________________________________________________________________________________

0002 00000050 Hardware Services, Inc.         2028.31 00005501  08/16/89 08 89   Check  1010001001  Cash, Sales Outlets

Item  Apply To Apl Type     PO No        DR Liab    Discount     CR Retn     Dir Amt   Account


0001  05981    Apply To Inv               432.81        0.00                           2010001001  Accounts Payable, Sales
      belt repair
0002  98700    Apply To Inv               626.87       62.63                           2010001001  Accounts Payable, Sales
      Drive repair
0003  NEW963-1 Apply To Inv              2200.00       56.00                           2010001001  Accounts Payable, Sales
      new hardware installation
0004  NEW963-9 Apply To Inv              1500.00      150.00                           2010001001  Accounts Payable, Sales
      new hardware installation
                                        ________   _________   _________    ________    _________
          — Line Item Totals —>          1759.68     268.63        0.00         0.00      2028.31
_________________________________________________________________________________________________________________________________

0003 00000070 Insurances Unlimited         254.80   00005502  08/16/89 08 89   Check  1010001001  Cash, Sales Outlets

Item  Apply To Apl Type     PO No        DR Liab    Discount     CR Retn     Dir Amt   Account


0001  89071000  Apply To Inv              254.80        0.00                            2010001001  Accounts Payable, Sales
      Monthly Policy Payment
                                        ________   _________   _________    ________    _________
          — Line Item Totals —>           254.80        0.00        0.00        0.00       254.80
_________________________________________________________________________________________________________________________________
  1. Step 12In preparation for performing a sort/selection process on the Adjustments information, this step provides sequencing of data records by Post Now?, Operator ID, Control Number, Post Year and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  2. Step 13According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  3. Step 14In order to print the Accounts Payable Adjustments Journal, this step formats the Adjustments information. The following data items are shown: Transaction No, Vendor, Name, PO No, Apply To, Adjust Date, Description, Amount, Offset Account, Post Month/Year, Invoice Type, Invoice Type Description, Liability Account, Item Code, Warehouse Number, Subsidiary Type and Subsidiary Code, As appropriate, group headings appear whenever a change occurs in Control Number or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control Number. When totals are specified, the following items are accumulated: Adjustment Total, Control Total, Current Total, Control Total Remaining, Hash Total, Current Hash Total and Hash Total Remaining. Grand totals print at the end, showing Journal Errors and Journal Warnings.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 16:31                                                                                                       SRR Page:  1
                                                Accounts Payable Adjustments Journal


 Trx   Vendor                              PO No                 Apply To  Adj Date  Description                     Adj Amount
              Offset Account                                     Mo/Yr     Invoice Type
              Liability Account                                  Item              Wh    Sub Type/Code
=================================================================================================================================

Control Group SRR / 0002  Aug. adjustments

Post Month/Year 08 / 89

 0001  00000020  Pool and Associates                             9852-6    08/20/89  correct invoice amount              300.00
              4100000001WH  Promotion/Advertising, Wholesl       08 89     1 Invoice
              2010001001  Accounts Payable, Sales                                   0

 0002  00000040  Albert Materials, Inc.                          8090      08/20/89  Write off retention                 222.31-
              2030001001  Retention Payable, Sales               08 89     2 Retention Invoice
              2010001001  Accounts Payable, Sales                                   0

 0003  00000060  Travel Planners                                 11596-1   08/20/89  correct vendor                      985.60-
              2010001001  Accounts Payable, Sales                08 89     1 Invoice
              2010001001  Accounts Payable, Sales                                   0

 0004  00000080  Sam Jones                                       11596-1   08/20/89  correct vendor                      985.60
              2010001001  Accounts Payable, Sales                08 89     1 Invoice
              2010001001  Accounts Payable, Sales                                   0
                                                                            — Post Month/Year 08 89 Total —>              77.69
                                                                                                                         ——————
                                                                                                                   ============

                                                                                                                         ——————
                                                                                    — Control Group Total —>              77.69

                                                                                              Entered    Calculated    Difference
Control Group: SRR / 0002  Aug. adjustments                             Control Totals:                       77.69
Exclusive?     N                                                        Hash Totals:                            200
Post Now?      N

=================================================================================================================================

                                                                                                                     Adj Amount
                                                                                                                          —————
                                                                                            — Grand Total —>              77.69
Number of Errors in This Journal: 0             Number of Warnings: 0
=================================================================================================================================
=================================================================================================================================
  1. Step 15In order to print the Accounts Payable Journal Summary, this step formats the summarized Distributions information. The following data items are shown: Post Year, Post Month, GL Account, Description, Journal Code, Operator ID, Transaction Date, Debits and Credits.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 10:00                                                                                                       LGG Page:  1
                                                  Accounts Payable Journal Summary



Yr Mo  Account       Account Name                    Jrnl  ID   Trx Date        Debits        Credits
=================================================================================================================================
89 08  1010001001  Cash, Sales Outlets               APCD  SRR  08/13/89       9323.21
89 08  2010001001  Accounts Payable, Sales           APCD  SRR  08/13/89                      9119.68-
89 08  4070000000WH  Discounts Lost, Wholesale       APCD  SRR  08/13/89                        34.63-
89 08  4090000001WH  Repairs and Maintnc, Wholesale  APCD  SRR  08/13/89                       168.90-
                                                                                ——————         ——————
                                                  — Grand Totals —>            9323.21        9323.21-
                                                                          =============  =============

Post All Transactions

This job post invoices, checks, and adjustments. The following processing steps accomplish this job.

  1. Step 1This disposition type is used for all posting functions.
  2. Step 2This function identifies the application that created the invoice control group.
  3. Step 3In preparation for performing a sort/selection process on the Invoices Control groups information, this step provides sequencing of data records by key, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Journal OK? and Post Now?, with the option to enter user-specified comparisons at run time.
  4. Step 4This step prevents CANCEL from canceling the current job.
  5. Step 5Accounting to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  6. Step 6This step process the information for Invoices Control Groups, Invoices and Invoices Line Items. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Invoices Control Groups, Invoices, Invoices Line Items and Transaction Control files will occur. Generalized routines are performed to do Prorata Set Up in Account Payable, do Month to Date Postings in Accounts Payable, Post GL Transactions in General Ledger, Convert Calendar To Fiscal in General Ledger, Compute Prorata Line Amount in Accounts Payable and Calculate Estimated Freight in Accounts Payable.
  7. Step 7This step processes the information for Invoices Control Groups, Invoices and Invoices Line Items. Under certain conditions, records in the Transaction Control and Miscellaneous Vendor Name/Address files will be added. Updates to certain fields in the Parameters, Invoices Control Groups, Miscellaneous Vendor Name/Address and Transaction Control files will occur. Generalized routines are performed to do Prorata Set Up in Accounts Payable, Post AP Transactions in Accounts Payable, Compute Prorata Line Amount in Accounts Payable, Calculate Estimated Freight in Account Payable, Post Inventory Costs in Inventory Control, do Month to Date Postings in accounts Payable, Post GL Transactions in General Ledger and Convert Calendar To Fiscal in General Ledger. Records in the Invoices Line Items, Invoices and Invoices Control Groups files will then be deleted.
  8. Step 8In preparation for performing a sort/selection process on the Disbursements Control Groups information, this step provides sequencing of Data records by key, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Journal OK? and Post Now?, with the option to enter user-specified comparisons at run time.
  9. Step 9This step prevents CANCEL from canceling the current job.
  10. Step 10According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  11. Step 11This step processes the information for disbursements Control Groups, Disbursements and Disbursements Line Items. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Disbursements Control Groups, Disbursements, Disbursements Line Items and Transaction Control files will occur. Generalized routines are performed to do Month to Date Postings in Accounts Payable, Post GL Transactions in General Ledger and Convert Calendar To Fiscal in General Ledger.
  12. Step 12This step processes the information for Disbursements Control Groups, Disbursements and Disbursements Line Items. Under certain conditions, records in the Transaction Control and Outstanding Checks files will be added. Updates to certain fields in the Parameters, Disbursements Control groups, Vendors and Transaction Control files will occur. Generalized routines are performed to Post AP Transactions in Accounts Payable. Records in the Disbursements line Items, Disbursements and Disbursements Control Groups files will then be deleted.
  13. Step 13In preparation for performing a sort/selection process on the Adjustments Control Groups information, this step provides sequencing of data records by key, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Journal OK? and Post Now?, with the option to enter user-specified comparisons at run time.
  14. Step 14This step prevents Cancel from canceling the current job.
  15. Step 15According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  16. Step 16This step processes the information for Adjustments Control Groups and Adjustments. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Adjustments Control Groups, Transaction Control and Adjustments files will occur. Generalized routines are performed to do Month to Date Postings in Accounts Payable, Post GL Transactions in General Ledger and Convert Calendar To Fiscal in General Ledger.
  17. Step 17This step processes the information for Adjustments Control Groups and Adjustments. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Parameters, Adjustments Control Groups and Transaction Control files will occur. Generalized routines are performed to Post AP Transactions in Accounts Payable and Post Inventory Costs in Inventory Control. Records in the Adjustments and Adjustments Control Groups files will then be deleted.
  18. Step 18This function displays a warning to the operator if any errors were encountered during posting or processing.

Print/Post All Transactions

This job prints the Invoices, Adjustments, and Checks journals and then posts the transactions. The following processing steps accomplish this job.

  1. Step 1This disposition type is used for all transaction file journals.
  2. Step 2This function identifies the application that created the invoice control group.
  3. Step 3In preparation for performing a sort/selection process on the Invoices information, this step provides sequencing of data records by Post Now?, Operator ID, Control Number, Post Year and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  4. Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  5. Step 5In order to print the Accounts Payable Invoices Journal, this step formats the Invoices and Invoices Line Items information. The following data items are shown: Trx No, Vendor, Name, Pay Status, Invoice Date Discount and Invoice Due Date, Description, PO No, Post Month/Year, Transaction Type, Warehouse No, Retention and Liability Account, Invoice, No, Apply To, Invoice Amt, Prepayment Retention, Subtotal, Discount, Freight, Tax Other, Line No, Offset Account, Item, Warehouse No, Price, Quantity, Prorate?, Amount Prorated to Line Item, Amount, Subsidiary Type and Code, Prorata and Line Items Total. As appropriate, group headings appear whenever a change occurs in Post Month or Control No. When totals are specified, the following amounts are accumulated: Invoice, Prepaid, Retention, Subtotal, Discount, Freight, Tax, and Other. Grand totals print at the end Showing Journal Errors and Warnings.
  6. Step 6In preparation for performing a sort/selection process on the Disbursements information, this step provides sequencing of data records by Post Now?, Operator ID, Control No, Post Year and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control No, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  7. Step 7According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  8. Step 8In order to print the report requested, this step formats the Disbursements and Disbursements line Items information. The following data items are shown: Trx No, Vendor, Name, Check Amount, Check No, Check Date, Post Month/Year, Hand Check Status, Cash Account, Description, Check Line No, Apply To, Apply Type, PO No, Dr Liability, Discount Amount, Cr Retention, Direct Amount, Account, Subsidiary Type and Code, Retention Account, Liability Total, CR Discount Total, CR Retention Total, Direct Total and Line Items Total. As appropriate, group headings appear whenever a change occurs in Control No or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control No. When totals are specified, the following items are accumulated: Active Check Totals, Liability Total, CR Discount Total, CR Retention Total, Direct Total, Line Items Total, Check Total, Control Total, Current Control, Control Remaining, Vendor Hash Total, Current Hash and Hash Remaining. Grand totals print at the end, showing Journal Errors and Journal Warnings.
  9. Step 9In preparation for performing a sort/selection process on the Disbursements information, this step provides sequencing of data records by Post Now?, Operator ID, Control No, Post Year and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control No, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  10. Step 10According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  11. Step 11In order to print the report requested, this step formats the Disbursements and Disbursements Line Items information. The following data items are shown: Trx No, Vendor, Name, Check Amount, Check No, Check Date, Post Month/Year, Hand Check Status, Cash Account, Description, Check Line No, Apply To, Apply type, PO No, Dr. Liability, Discount Amount, Cr Retention, Direct Amount, Account, Subsidiary Type and Code, Retention Account, Liability appropriate, group headings appear whenever a change occurs in Control No or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control No. When totals are specified, the following items are accumulated: Active Check Totals, Liability Total, CR Discount Total, CR Retention Total, Direct Total, Line Items Total, Check Total, Control Total, Current Control, Control Remaining, Vendor Hash Total, Current Hash and Hash Remaining. Grand totals print a the end, showing Journal Errors and Journal Warnings.
  12. Step 12In preparation for performing a sort/selection process on the Adjustments information, this step provides sequencing of data records by Post Now?, Operator ID, Control Number, Post Year and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Print Journal? and Journal OK?, with the option to enter user-specified comparisons at run time.
  13. Step 13According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  14. Step 14In order to print the Accounts Payable Adjustments Journal, this step formats the Adjustments information. The following data items are shown: Transaction No, Vendor, Name, PO No, Apply To, Adjust Date, Description, Amount, Offset Account, Post Month/Year, Invoice Type, Invoice Type Description, Liability Account, Item Code, Warehouse Number, Subsidiary Type and Subsidiary Code. As appropriate, group headings appear whenever a change occurs in Control Number or Post Month. If requested, totals appear whenever a change occurs in Post Month or Control Number. When totals are specified, the following items are accumulated: Adjustment Total, Control total, Current Total, Control total Remaining, Hash Total, Current Hash Total and Hash Total Remaining. Grand totals print at the end, showing Journal Errors and Journal Warnings.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 10:58                                                                                                       LGG Page:  1
                                                Accounts Payable Adjustments Journal


 Trx   Vendor                              PO No                 Apply To  Adj Date  Description                     Adj Amount
              Offset Account                                     Mo/Yr     Invoice Type
              Liability Account                                  Item              Wh    Sub Type/Code
=================================================================================================================================

Control Group SRR / 0002  Aug. adjustments

Post Month/Year 08 / 89

 0001  00000020  Pool and Associates                             9852-6    08/20/89  correct invoice amount              300.00
              4100000001WH  Promotion/Advertising, Wholesl       08 89     1 Invoice
              2010001001  Accounts Payable, Sales                                   0

 0002  00000040  Albert Materials, Inc.                          8090      08/20/89  Write off retention                 222.31-
              2030001001  Retention Payable, Sales               08 89     2 Retention Invoice
              2010001001  Accounts Payable, Sales                                   0

 0003  00000060  Travel Planners                                 11596-1   08/20/89  correct vendor                      985.60-
              2010001001  Accounts Payable, Sales                08 89     1 Invoice
              2010001001  Accounts Payable, Sales                                   0

 0004  00000080  Sam Jones                                       11596-1   08/20/89  correct vendor                      985.60
              2010001001  Accounts Payable, Sales                08 89     1 Invoice
              2010001001  Accounts Payable, Sales                                   0
                                                                            — Post Month/Year 08 89 Total —>              77.69
                                                                                                                         ——————
                                                                                                                   ============

                                                                                                                         ——————
                                                                                    — Control Group Total —>              77.69

                                                                                              Entered    Calculated    Difference
Control Group: SRR / 0002  Aug. adjustments                             Control Totals:                       77.69
Exclusive?     N                                                        Hash Totals:                            200
Post Now?      N

=================================================================================================================================

                                                                                                                     Adj Amount
                                                                                                                          —————
                                                                                            — Grand Total —>              77.69
Number of Errors in This Journal: 0             Number of Warnings: 0
=================================================================================================================================
=================================================================================================================================
  1. Step 15In order to print the Accounts Payable Journal Summary, this step formats the Summarized Distributions information. The following data items are shown: Post Year, Post Month, GL Account, Description, Journal Code, Operator ID, Transaction Date, Debits and Credits.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 10:59                                                                                                       LGG Page:  1
                                                  Accounts Payable Journal Summary


Yr Mo  Account       Account Name                    Jrnl  ID   Trx Date        Debits        Credits
=================================================================================================================================
89 08  2010001001  Accounts Payable, Sales           APAJ  SRR  08/20/89                        77.69-
89 08  2030001001  Retention Payable, Sales          APAJ  SRR  08/20/89                       222.31-
89 08  4100000001WH  Promotion/Advertising, Wholesl  APAJ  SRR  08/20/89        300.00
                                                                                ——————         ——————
                                                  — Grand Totals —>             300.00         300.00-
                                                                          =============  =============
  1. Step 16This function identifies the application that created the invoice control group.
  2. Step 17In preparation for performing a sort/selection process on the Invoices Control Groups information, this step provides sequencing of data records by key, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Journal OK? and Post Now?, with the option to enter user-specified comparisons at run time.
  3. Step 18This step prevents CANCEL from canceling the current job.
  4. Step 19According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  5. Step 20This step processes the information for Invoices Control Groups, Invoices and Invoices Line Items. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Invoices Control Groups, Invoices, Invoices Line Items and Transaction Control files will occur. Generalized routines are performed to do Prorata Set Up in Accounts Payable, do Month to Date Postings in Accounts Payable, Post GL Transactions in General Ledger, Convert Calendar To Fiscal in General Ledger, Compute Prorata Line Amount in Accounts Payable and Calculate Estimated Freight in Accounts Payable.
  6. Step 21This step processes the information for Invoices Control Groups, Invoices and Invoices Line Items. Under certain conditions, records in the Transaction Control and Miscellaneous Vendor Name/Address files will be added. Updates to certain fields in the parameters, Invoices Control Groups, Miscellaneous Vendor Name/Address and Transaction Control files will occur. Generalized routines are performed to do Prorata Set Up in Accounts Payable, Post AP Transactions in Accounts Payable, Compute Prorata Line Amount in Accounts Payable, Calculate Estimated Freight in Accounts Payable, Post Inventory Costs in Inventory Control, do Month to Date Postings in Accounts Payable, Post GL Transactions in General Ledger and Convert Calendar To Fiscal In General Ledger. Records in the Invoices Line Items, Invoices and Invoices Control Groups files will then be deleted.
  7. Step 22In preparation for performing a sort/selection process on the Disbursements Control Groups information, this step provides sequencing of data records by key, with no option to change the sequence at run time. Selection of data records is provided by Operator ID, Control Number, Journal OK? and Post Now?, with the option to enter user-specified comparisons at run time.
  8. Step 23This step prevents CANCEL from canceling the current job.
  9. Step 24According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  10. Step 25This step processes the information for Disbursements Control Groups, Disbursements and Disbursements Line Items. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Disbursements Control Groups, Disbursements, Disbursements Line Items and Transaction Control files will occur. Generalized routines are performed to do Month to Date Postings in Accounts Payable, Post GL Transactions in General Ledger and Convert Calendar To Fiscal in General Ledger.
  11. Step 26This step processes the information for Disbursements Control Groups, Disbursements and Disbursements Line Items. Under certain conditions, records in the Transaction Control and Outstanding Checks files will be added. Updates to certain fields in the Parameters, Disbursements Control Groups, Vendors and Transaction Control files will occur. Generalized routines are performed to Post AP Transactions in Accounts Payable. Records in The Disbursements Line Items, Disbursements and Disbursements Control Groups files will then be deleted.
  12. Step 27In preparation for performing a sort/selection process on the Adjustments Control Groups information, this step provides sequencing of data records by key, with no option to change the sequence at run time.

Selection of data records is provided by Operator ID, Control Number, Journal OK?, and Post Now?, with the option to enter user-specified comparisons at run time.

  1. Step 28This step prevents CANCEL from canceling the current job.
  2. Step 29According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  3. Step 30This step processes the information for Adjustments Control Groups and Adjustments. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Adjustments Control Groups, Transaction Control and Adjustments files will occur. Generalized routines are performed to do Month to Date Postings in Accounts Payable, Post GL Transaction sin General Ledger and Convert Calendar To Fiscal in General Ledger.
  4. Step 31This step processes the information for Adjustments Control Groups and Adjustments. Under certain conditions, records in the Transaction Control file will be added. Updates to certain fields in the Parameters, Adjustments Control Groups and Transaction Control files will occur. Generalized routines are performed to Post AP Transactions in Accounts Payable and Post Inventory Costs in Inventory Control. Records in the Adjustments and Adjustments Control Groups files will then be deleted.
  5. Step 32This function displays a warning to the operator if any errors were encountered during posting or processing.