LOCAL REFERENCE FIELD FOR REPORTING

I CREATED A LOCAL REFERENCE TO DISTINGUISH BETWEEN ACCOUNTS THAT HAVE THE SAME CATEGORY CODE. THE REFERENCE CODE IS TO ACCEPT THE UNIQUE SERIAL NUMBER AND REFERENCE IT LATER IN A LINE ON A REPORT.

UNFORTUNATELY, EVERYTHING HAS APPEARED EXCEPT THE VALUES FOR THIS LOCAL FIELD. ASSIST IF YOU CAN

Can you please give some more details or screen shots of what you have done.

The issue has been resolved but thanks anyway.

What I was doing was that, I had a set of internal accounts with the same category code and the institution wanted to report them on separate lines
eg. USD104100005
USD104100006 etc

So I created a local reference field for accounts where I can differentiate between all accounts with the same category with the unique serial so for the first one, the serial would be 5 and so on.

The first issue was when I was updating the CONSOLIDATE.COND TABLE with ID ASSET&LIAB, the system threw an error and could not update it. I spoke with Temenos and they said I need an update... from RE_config_R08 go RE_Config_R10. which I did.

After the update, I was able to add my local field to the CONSOLIDATE.COND.

The second issue then happened, where the Lines were all reporting zero... even after running COB.
So I checked the contents of the of those lines and they all did not have consol keys. So I tried one more thing. I performed a transaction on these internal accounts and Then they started reporting. So even though the issue has been resolved, I wish I knew why it was not pick the figures for just those particular lines until there was a transaction hitting it.

Note: that the lines that were not reporting were the lines that a relation to the local reference field I created.

After doing a change in CONSOLiDATE.COND for ASSET&LIAB have to tried to rebuild the keys by running RE.REGEN.REQUEST?

yeah I did all.

Hi Saddom,

I wouldn't recommend to bring local.reference field into consol key for accounts as in this case you're going to "kill" the hole idea of having consolidate data in CAL .

As soon as we have now full control over detailed balance sheet in T24 I would recommend to use enquiry/jBasic tools in order to reach your goal.

Only IMHO, nothing more .... :)