Balance Forward - ARUTBF

To conserve disc space and improve processing efficiency, it is useful to create balance forward entries for transactions in the AR database. Balance forward transactions may be applied to a selected subset of the AR database. This operation summarizes by Division and applies the activity to the associated division account as defined on the AR Code Definitions (ARUPCD), Division tab. It is highly recommended that a full back up of the AR database be made prior to this operation.

The utility reads through every transaction for each Account ID selected by the selection criteria. One "Net Balance Forward" entry for all prior Accounts Receivable transactions and one entry for all prior Cash Receipts transactions are formed. The former is titled "Net Charges Forward"; the latter is titled "Net Payments Forward." Balance Forward transactions are created with the same date. A report is printed of all purged and created transactions.

AR Selection Criteria:
01 - Command Selection
02 - Account Information
03 - Responsible ID Information
04 - Category (By Term) Info
05 - Transaction Detail
06 - Special Information
07 – AR Reference Details
10 - IRIS Information
SF - Select File
Term Codes for the new transactions: Enter the Term Code for the new transactions. As a result of running the balance forward, new transactions will be created. Enter the Term Code to be applied to these transactions. Term codes are defined on the AR Code Definitions (ARUPCD), Term tab.
Start Date: Enter the starting date from which transactions will be taken to create the balance forward. Start and End dates use the transaction Reference Date.
Ending Date: Enter the ending date from which transactions will be taken to create the balance forward.
Date for new Balance Forward transaction: Enter the date you would like put on the new balance forward transactions. WARNING: Care must be taken not to have transactions with dates between the ending and new balance forward dates. This could cause reports to give faulty information or the balance forward transaction not to have the balance you expect.
Would you like single transactions collapsed also?: If "Y" is selected, account IDs that have a single transaction pass selection criteria will be processed the same as if multiple transactions passed. Entering "N" will cause the selected account IDs that have only one transaction pass selection criteria to be skipped.
Print report only?: Respond "Y" to print a report of the changes that will occur; no actual changes will be made to the Accounts Receivable database. Respond "N" to effect changes.
Items by which to summarize transactions for Balance Forwards Enter items by which to summarize transactions for Balance Forwards:
01 – Org Key
02 - Object
03 - Project
04 - Account
05 - Transaction Term
06 - Primary Reference
07 - Transaction Type
08 - Miscellaneous Code
09 - Finance Code
10 - Statement Date
11 – AR Division
The user is able to choose the method of summarization from this menu of transaction related items. If the user selects to summarize by "Primary Reference," an additional question will allow selection of method of summarization.
Generate Balance Forward Transactions if Net = 0?: Respond "Y" if balance forward entries should always be generated. Respond "N" if NO balance forward transactions should be generated when the net is equal to zero.