Had to request an enhancement SAR for XE but was turned down refer below notes
-----------------------------------------------
Involved Programs - P09121 – Indexed Computations
Where we give the system how to allocate
R093921 – Indexed Computation & Print Report
Where it calculates the allocations & update the files including F0911
Functionality Required - Need a change to the existing functionality of R093921.
What we need for Cost Allocations considering the
Balance Method is given below as an example.
It should be similar in Transactions Method considering the entries in F0911 table.
EXAMPLE
If we want to transfer all transactions
From account 12310 with subledger A of 00001110
To account 12310.1110 with subledger A of 00001110,
AND all transactions
From account 12310 with subledger A of 00002010
To account 12310.2010 with subledger A of 00002010.
The current functionality of JDE will print the allocation report with the following computations, which is correct:
Db. Account 12310.1110 Subledger 00001110
Cr. Account 12310 Subledger 00001110
Db. Account 12310.2010 Subledger 00002010
Cr. Account 12310 Subledger 00002010
HOWEVER, it will post the following journal entries to F0911 File
Db. 12310.1110 Subledger A 00001110
Db. 12310.2010 Subledger A 00002010
Cr. 12310 (net of all transactions and without a subledger value).
The problem with this functionality is if you have additional entries that are made after the allocation is run, you can not re-run the allocation, or it doubles up on the allocation and moves the original transactions as well as the new transactions. If the subledger values were properly populated on the from account (12310) theoretically JDE should be smart enough to know that these transactions were already allocation and do not need to be reallocated.
• In the 'Indexed Computations Compute & print R093021', the report PRINTS all the details with FROM & TO accounts for the allocation.
In this example,Two FROM Accounts & two TO accounts - we are concerned about altogether 4 records with a subledger value populated on them.
• But When the posting is done , it only shows one contra A/C (replacing all the 'FROM A/Cs) with all the TO A/Cs.
Only the two "TO" account transactions have a subledger value populated on them, the "FROM" account does not. We need two FROM A/Cs with subledgers instead of having one CONTRA A/C.
• We understand this is because the F0911 File is not updated with the detail FROM A/C information (object, subsidiary, subledger) through the Index Computation program. Instead it has One consolidated record as a Contra Account.
• We would like the double entries of the Computations program to be, all the 'FROM
ACCOUNTS' to all the 'TO ACCOUNTS' considering the method.
Two FROM Accounts & two TO accounts - Altogether 4 entries. With subledger values populated on all 4 transactions
• JDE might require a Contra A/C, however it is not useful to meet our needs for allocations.
