Hi
We have a very unique situation where in until a particular day all the transactions were correct. On a particular day to create a new entity on the existing DB, the consultant had exported the setups from Test DB and restored in Production DB. This had created a mess in the Setups like Main Account and Dimensions table.
For same account For e.g.: 2215090 there are 2 records in Main account table with Different Rec ID's and in dimensionattributevaluecombination table, it had created more records.... This was not visible in front end but when the journals are posted after that particular date, it had taken the RECIds of the wrong combination. Until certain date the recids are same but after the particular date, system had taken wrong ids because of which it is displaying two lines in trial balance.
When we looked at the backend on the dimension table we could see many rows for the same account and we are not clear which one pertains before particular date and which one pertains after that
How do we combine the transactions happened so that in TB it appears in Single line?
Even in Summary TB, the transaction are not included in line total but included in grand total. But when we take the detailed TB all transactions are visible
Please see the below image... The amount of 460.61 was not included in the line total on Summary TB but was iincluded in Grand Total. This transaction was posted after duplication of Dimension sets and we could see that iit was due to that....Now how to merge these two transactions so that it appears as single total.
