Managing Payment Profiles and Accounting Profiles

This chapter provides an overview of payment and accounting profiles and discusses how to:

• Manage payment profile records.

• Manage accounting profile records.

• Generate the accounting profile journal entries.

Understanding Payment and Accounting Profiles

The system generates payment profile records automatically depending on the billing process that you run. This table specifies which profile records the system creates when you run the corresponding program:

Except for manual billing, which updates the Lease Billings Master table (F1511B) when you enter the billing record, the system uses the payment profile records to generate Lease Master Billing records (F1511B) when you run the Global Generation program.

The system uses the accounting profile to generate accrual entries, so that reporting can be done on a fixed amount instead of an amount that fluctuates based on the number of days in the billing period. You must run the Accounting Profile Journal Creation program to generate these journal entries.

The system stores payment profile records in the Payment Profile table (F74U0205). The system stores accounting profile records in the Accounting Billing Profile table (F74U0212).

Managing Payment Profile Records

This section provides an overview of payment profile records and lists the forms used to manage payment profile records.

Understanding Payment Profile Records

You use the Payment Profile Inquiry program (P74U0205) to review payment profile records. You can access this program from several menus, as well as from the recurring billing information program. The Payment Profile Inquiry program displays payment profile information on three forms:

• Work With Payment Profile

  This form displays each payment profile record from the Payment Profile table (F74U0205). You access this form only when you select Payment Profile Inquiry from a menu.

• Payment Profile Information

  This form displays details about the payment profile record, such as:

  • The billing dates that the system used to generate the record.

  • The status of the record.

  • For fee and interest records, the lease adjustment percent, the amount on which the fee is based, and the rate used to process the fee.

  • The posted code.

  • The invoice date, due date, and general ledger date.

• Work With Payment Profile Status History

  This form displays audit information, such as when the status of the record was changed, the reason for the change, and the user ID of the person who changed it. The system displays records from the Payment Profile Status History table (F74U207A).

Changing Payment Profile Statuses

Each payment profile record has a status that maintains an audit trail of the changes that were made to the record. The system assigns default status codes based on the values set up in the Default Payment Profile Status program. The system stores records for status changes as history in the Payment Profile Status History table (F74U207A).

You can change the status of the payment profile record individually or by selecting a record and selecting the corresponding Row menu, or you can update payment profile records globally by running the Payment Profile Status Change program.

Clearing and Regenerating Payment Profile Records

If you need to make changes to recurring billing records, you need to clear the payment profile and accounting profile records that the system generated initially, change the recurring billing line, and regenerate the payment and accounting profile records. You must perform these tasks from the recurring billing application.

To clear payment profile records, all of the records associated with the recurring billing line must be set to an open (blank) status. You cannot manually update the status of a payment profile record to blank; you must run the Payment Profile Status Change program (R74U0221).

When you clear the payment profile records associated with a recurring billing line, the system changes the color of the line to yellow to indicate that payment profile records are missing. The system regenerates new payment profile records automatically when you change the recurring billing record. If you do not need to change the recurring billing record because you cleared the records erroneously, you can click OK on the Enhanced Recurring Billing form to regenerate the records for the same amount.

Extending the Payment Profile

The system generates payment profile records based on the number of years that you specify in the additional lease master information, not the recurring billing dates. If you did not enter a number of years that is equal to the term of the lease, you might need to create additional payment profile records for recurring billing lines at some point during the term of the lease. To do so, you must select Ext. Payment Profile (extend payment profile) from the Row menu on the Enhanced Recurring Billing form. The system generates the additional payment profile records automatically based on the Number of Years to Create value, which is set up in Lease Master Additional Information. For example, if the number of years to create is set to 1, then the payment profile will be extended for only one additional year. To extend it for more than one year, change the value of the Number of Years to Create in Lease Master Additional Details.

Forms Used to Manage Payment Profile Records

Managing Accounting Profile Records

This section provides an overview of accounting profile records and lists the forms used to manage accounting profile records.

Understanding Accounting Profile Records

You can review accounting profile records only from the Recurring Billing Information program by selecting the Row menu that corresponds to the Accounting Journal Method field that you specified in the Additional Company Constants program. The system enables the Row menu, Wkly Account (weekly accounting) field, which you use to review weekly accounting profile records only when you select the Weekly Accounting Used check box on the Maintain Constants form. You access this form from the Additional Company Constants program.

The system provides these forms for the review of accounting profile information:

• Accounting Profile Information or Weekly Accounting Profile Information.

  Use this program to review the accounting profile records for the recurring billing line that you selected. The system displays the amount, the status, and the audit information that corresponds to the journal entry when you run the Accounting Profile Journal Creation program. The system displays information from the Accounting Billing Profile table (F74U0212).

• Periodic Accounting Profile History or Weekly Accounting Profile History.

  Use this program to review the audit trail of changes that were made to accounting profile statuses, such as when the status of the record was changed, the reason for the change, and the user ID of the person who changed it. The system displays records from either the Periodic Accounting Profile Status History table (F74U207B) or the Weekly Accounting Profile Status History table (F74U207C).

Changing Accounting Profile Statuses

Each accounting profile record has a status that maintains an audit trail of the changes that were made to the record. The system assigns default status codes based on the values set up in the Default Payment Profile Status program. The system stores records for status changes as history in either the Periodic Accounting Status Profile History table (F74U207B) or the Weekly Accounting Status Profile History table (F74U207C).

You can change the status of the accounting profile record individually or by selecting a record and selecting the corresponding Row menu. Alternatively, you can update accounting profile records globally by running either the Periodic Accounting Profile Status Change program or the Weekly Accounting Profile Status Change program.

Clearing and Regenerating Accounting Profile Records

If you need to make changes to recurring billing records, you need to clear the payment profile and accounting profile records that the system generated initially, change the recurring billing line, and regenerate the payment and accounting profile records. You must perform these tasks from the recurring billing application.

To clear accounting profile records, all of the records associated with the recurring billing line must be set to an open (blank) status, and you cannot have generated journal entries for the records. You cannot manually update the status of an accounting profile record to blank; you must update them globally by running either the Periodic Accounting Profile Status Change program (R74U0222) or the Weekly Accounting Profile Status Change program.

If you clear accounting records for the wrong recurring billing line, you can regenerate them by clicking OK on the Enhanced Recurring Billing form. The system automatically regenerates the accounting profile records.

Extending the Accounting Profile

The system generates accounting profile records based on the number of years that you specify in the additional lease master information, not the recurring billing dates. If you did not enter a number of years that is equal to the term of the lease, you might need to create additional accounting profile records for recurring billing lines at some time during the term of the lease. To do so, you must select Ext. Accounting Profile from the Row menu on the Enhanced Recurring Billing form. The system generates the additional accounting profile records automatically based on the Number of Years to Create field, which is set up in the Lease Master Additional Information . For example, if the number of years to create is set to 1, then the accounting profile will be extended for only one additional year. To extend it for more than one year, change the value of the Number of Years to Create field in the Lease Master Additional Details form.

Forms Used to Manage Accounting Profile Records

Note. To access Enhanced Real Estate Management objects and screens, set the Localization code for the U.K. to 74U.

Generating the Accounting Profile Journal Entries

This section provides an overview of the Accounting Profile Journal Creation Program (R74U0212) and discusses how to:

• Run the Accounting Profile Journal Creation (R74U0212).

• Set processing options for Accounting Profile Journal Creation (R74U0212).

Understanding the Accounting Profile Journal Creation Program

You run the Accounting Profile Journal Creation program (R74U0212) to generate journal entries in the Account Ledger table for fixed billing amounts. Because you can generate billing amounts for any day of the period, the amount that you generate from the payment profile records could be different for each period. The system generates payment profile records based on the billing date that you enter in the billing pattern that you assign. The system generates accounting profile records based on the value of the Accounting Journal Method field that you enter in the Additional Company Constants program. For example, if you enter P, the system generates accounting profile records monthly, from the first of the month through the end of the month. In effect, the system produces a straight-line amount for each month. Some companies and countries require that reporting be done on straight-line billing amounts, rather than the actual, fluctuating billing amounts.

The system generates accounting profile records only for billing types that generate recurring billing records, such as recurring billing and estimated expense participation.

You can run the R74U0212 program in either proof or final mode:

• In proof mode, the system generates a report of the records that it selects to process.

• In final mode, the system generates a report of the records that it processes and generates the journal entry in the Account Ledger table.

  The system also updates the accounting profile records with audit information, such as the batch number, document number, document type, and general ledger date. The system updates the status to G (generated).

You can generate accounting profile journal entries for each period or whenever you want. The system enables you to generate catch-up billings for any periods that you do not process.

Update the Accounting Profile Records

A processing option enables you to choose whether to update the accounting profile records regardless of errors. The system generates the journal entries regardless of how you set this processing option. For example, if you set up an automatic accounting instruction (AAI) with an invalid account, the system generates the journal entries without an account number.

If you choose to update the accounting profile records, you must correct the existing journal entry and post it. Otherwise, the information that is updated on the accounting profile records will not match the actual journal entry (for example, if you delete the journal entry and reenter it).

If, however, you do not update the accounting profile records, you might lose the audit trail completely. The system enables you to update the status of the accounting profile record, but it does not enable you to enter the audit information to locate the journal entry. Therefore, because the system still generates the journal entry, even if you delete it, you cannot rerun the program to regenerate it or to update the audit information on the accounting profile record. You can update the status to G (generated), however, and attach a memo with the correct journal entry audit information. You cannot clear the accounting profile records once journal entries are generated.

Running the Accounting Profile Journal Creation Program (R74U0212)

Select Accounting Profile (G74U1530), Accounting Profile Journal Creation.

Select Create Journals from the Report menu on the Accounting Profile Information form, which you access by selecting the corresponding Row menu from the Enhanced Recurring Billing form.

Setting Processing Options for Accounting Profile Journal Creation (R74U0212)

Processing options enable you to specify the default processing for programs and reports.

Process

Print

Catch Up

AAI