ERPstuff - Oracle EBS Community

Hi,

I am having a typical requirement in FSG i.e. Client wants to give the same account in two rows say example they want to give Bank account in Balance Sheet under Cash & Bank Balances - Assets & Under Overdraft -Liabilities, so that if this account is having positive balance it should show under Assets otherwise it should show under liabilities.

Can any pls suggest if any solution...........

regards,
naga

Hello.

Hello.
For both lines the Activity should be defined as Net.
For debtor column Activity should be defined as Dr and Display Zero must be unchecked. Same for creditor column (Activity = Cr)

Octavio.

Hi Octavio.,

Thanks for ur quick reply. I did the same in rowset calculation, like I created one row (100) for Cash (calculated row of 120) then second row (110) account assignment of all Bank Accounts and then third row (120) in this I made debit balance calculation like
<u>seq Operator Constant Low High </u>
10 Abs 110 110
20 + 110 110
30 / 2

this is how i did and row 110 & 120 display option is disabled. The same repeated for Bank Overdraft range with "-" symbal.

thank u
nagaramesh.
[quote]Hello.

Hello.
For both lines the Activity should be defined as Net.
For debtor column Activity should be defined as Dr and Display Zero must be unchecked. Same for creditor column (Activity = Cr)

Octavio.



<i><div align="right">Originally posted by oteixeira