Trail Balance Issue

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
anjan123
Posts: 151
Joined: Tue Jun 26, 2007 1:06 am
Location: India

Trail Balance Issue

Post by anjan123 »

Hi Folks,

we have following issue.

we ran Trail Balance detail report being in GL Supervisor responsbility, it is showing -1100 balance.

The same report with same parameters we ran being in GL SUPER USER responsbility. it is showing balance is "0"


copied the both Report details in Excel and identified the missing line.

But , why it happen like that. and how we can resolve this issue in Super Visor responsibility.


Regards
Anjan
admin
Posts: 2063
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl check the security settings in GL may be account(s) are excluded for this responsibility. thanks
anjan123
Posts: 151
Joined: Tue Jun 26, 2007 1:06 am
Location: India

Post by anjan123 »

Dear Admin,


Can you tell me how can restrict a combination balance through security rule.


Note:- we have 3 segements example Company Account Dept

Company : c1 ,
Account: A1,A2,A3 ----- A10.
Dept: D1,D2,D3,D4


1)C1.A1.D1=10000
2)C1.A1.D2=-1100
3)C1.A1.D3=1000000

now we have shown both the reports 1 & 3 combination balance, where as 2 combination is showing in one report. and i reviewed the security rule "D2" is not restricted for that responsbility.

How we can check the security rule other than this.


Regards
Anjan
tgs100
Posts: 624
Joined: Tue Jun 13, 2006 3:42 am
Location: USA
Contact:

Post by tgs100 »

Generally this kind of problem arises due to security rules. Try querying through backend to check the security rules for the responsibility.

Cheers,
Saravanan
Murthyoracle
Posts: 147
Joined: Thu Sep 06, 2007 9:13 am
Location: India

Post by Murthyoracle »

Pls check whether the particular transaction have been transferred to GL or not.

Murthy
Post Reply

Who is online

Users browsing this forum: No registered users and 15 guests