Updating the Joint Venture Account Type for Multiple Accounts (Release 9.2 Update)

In case you change any of the joint venture AAI ranges to include or remove accounts, you can run the Update Joint Venture Account Type program (R09J411) to mass update the joint venture account type for the distributable accounts included in the AAI range.

This program determines which AAI range each distributable account comes under and updates the joint venture account type as Revenue, Capital Cost, or Expense in the Joint Venture Distributable Accounts table (F09J01). The program also updates the joint venture account type for associated distribution records in the Joint Venture Account Ledger table (F09J11) that are not at the transaction status of Process Complete.

Note: If an account is removed from an AAI range and the account is already set as distributable in the F0901 table, the R09J411 program updates the joint venture account type as Distribution Only.