Understanding the Post Process

After you successfully run the Billing Edit/Register program (R15300) and approve batches (if necessary), you must post the batches to create transactions in the appropriate tables. The system provides two versions of the G/L Transaction Generation program (R15199); one to generate invoices, Post Invoices, and one to generate vouchers, Post Vouchers. The only difference between the two versions is the setting of the Batch Type processing option. You must run the appropriate version for the billing documents in the batch; you cannot generate and process invoices and vouchers in the same batch.

Regardless of whether you post invoices or vouchers, the system:

• Selects records from the Lease Billing Master table (F1511B).

• Creates a new record in the F0011 table and assigns it one of these batch types:

  • For invoices, the system assigns the batch type 2B.

  • For vouchers, the system assigns the batch type / (forward slash).

    For audit purposes, the system uses the same batch number that was assigned to the original batch.

• Creates records in the F03B11 table and the F0911 table if you post invoices, and assigns the records one of these document types (based on the program that originated the billing record):

  • RD: Recurring billing

  • RH: Expense participation

  • RJ: Sales overage

  • RL: Escalations

  • RN: Manual billing

  • RT: Fees and interest

  (Release 9.2 Update) If records are created in the F03B11 and F0911 tables, the program creates records in the F03B116, F03B117, and F03B11T tables if you are posting invoices that are included in revenue recognition processing.

• Creates records in the Accounts Payable Ledger table (F0411) and the Account Ledger table (F0911) if you post vouchers, and assigns the records one of these document types (based on the program that originated the billing record):

  • PF: Recurring billing

  • PJ: Sales overage

  • PQ: Manual billing, expense participation, escalations

  Note: The system creates vouchers with a Supplier Invoice Number (VINV) as a combination of doc type, doc number (for the voucher) and company.

• Creates records in the F0911 table if you post accrual entries from recurring billings, and assigns the records a document type of AC.

  During the post process, the system also updates the Subledger and Subledger Type fields. This table describes the value that the system uses to update the Subledger and Subledger Type fields, depending on the setting of the Update Subledger In Account Ledger processing option:

  Processing Option Setting	Subledger	Subledger Type
  1 (tenant)	Address Book Number	A
  2 (lease)	Lease Number	L
  3 (unit/asset) (Release 9.2 Update)	Unit Number for a property asset or Asset Number for a non property asset.	U for property assets. E for non-property assets.
  4 (building) (Release 9.2 Update)	Building Number	C for buildings.

• Updates the posted code to D on the records in the F1511B table.

• Changes the billing status from G to X for the appropriate period in the F15011B table for these generation types:

  • 1: Recurring billing

  • 2: Expense participation

  • 3: Sales overage

  • 4: Escalation

  • 6: Estimated expense participation

• Automatically submits the General Ledger Post Report (R09801), which:

  • Creates automatic entries with the document type AE in the F0911 table.

  • Updates the Account Balance table (F0902).

  • For invoices, updates the posted code on records in the F03B11 table to D.

  • For vouchers, updates the posted code on records in the F0411 table to D.

  • Updates the posted code on records in the F0911 table to P.

  • Updates the batch status to GL Approved.