FSG Account value

[nagaramesh]

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

[oteixeira]

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.

[nagaramesh]

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