Generating Distribution Ledgers
After you have defined the distribution ledgers using the Distribution Ledger Types program (P09J25), you run the Generate Distribution Ledgers program (R09J500) to add the distributed transactions to the distribution ledgers. The R09J500 program selects the distribution records from the F09J12 table that are associated with a specified source ledger type and processes only those records that fulfil the following conditions:
Transaction Status = Process Complete
Distribution Ledger Type = Blank (the transaction has not been added to the distribution ledger)
The program creates account balances records, placing the managing partner's share in the managing ledger and the totals of the non-managing partners' share in the non-managing ledger. You can choose to only populate the managing or non-managing distribution ledgers when you define distribution ledgers in the Distribution Ledger Types program (P09J25).
You can set up a processing option to generate journal entries. The system creates the journal entries using the original account where the transaction occurred.
The document type used for the journal entries is JG (Joint Venture Distribution Ledgers Journal Entries). A distribution journal entry batch is created for each distribution ledger that is processed. You do not need to run the GL Post program (R09801) for these distributed transactions as the R09J500 program creates the journal entries with the status as Posted. The journal entries contain a reference to the original transactions that were distributed, and this information is stored in the original document fields: Original Document, Original Document Type, Document Company, and Line Number.
After the R09J500 program completes processing, it generates a report. If there are records that the program is not able to process, the errors are reported to the work center and the R09J500 report contains the message Review Errors Written to Work Center. The system updates the Distribution Ledger Type field in the F09J12 table for each record processed to indicate that the transaction has been added to the distribution ledger.
Example:
Consider this setup and review how the system processes the records:
The Distribution Ledger Types program (P09J25) has a distribution ledger record with these values: Source Ledger = AA, Managing Ledger Type = 1A, and Non-Managing Ledger Type = 2A.
The processing options for the R09J500 program have been set up to generate both managing and non-managing ledgers, and to create journal entries in the F0911 table and the account balances records in the F0902 table.
In the F09J12 table, you have three distribution records distributed in this manner: 25% to the managing business unit = 30 USD, 25% each to two outside partners = 60 USD (30 USD to each partner), and 25% to an insider business unit = 30 USD. The total distributed amount = 120 USD.
When you run the R09J500 program, the system creates entries to the distribution ledgers 1A and 2A. The 1A ledger has the distributed amount for the managing business unit = 30 USD. The 2A ledger has the totals of the distributed amounts for the two outside partners + the distributed amount for the insider business unit, which is 60+30=90 USD.
The system creates summarized journal entries (summarized by line number) using the original account where the transaction occurred. The system also creates account balances record for the account with 90 USD in the 1A ledger and 30 USD in the 2A ledger. The AA ledger has 120 USD.