Profit or Loss for the current year

[Former Member]

Hi experts

I have configured Acc based Calc Business rule to post the income for the current year in the balance sheet

its calculated correctly only when company achieve revenue but when company make loss its calculated wrong

let me explain with example

Total AST = 20000

LEQ +profit of the year  = 20000 now the balance sheet =0

when company make loss

Total AST = 20000

LEQ +profit of the year  =15000

BS doesnt = 0

the reason for this is the Acctype for the GL profit for the year is LEQ when net income is negative (loss) it multiply

- 1 * - 1 which is positive

so is there anyway to tell the system what ever the number coming from the net income consider it with + sign ?

[Former Member]

yes i am using standard acc types but result is only incorrect when company achieves loss

[Former Member]

Hi Elhoussiny,

Defining custom measure would be helpful by considering same signs for INC and LEQ accounts rather than reverse signs which will come with default measures.

Enclosed link would be helpful.

Custom Measure Formulas - SAP BusinessObjects Planning and Consolidation - SAP Library

Regards,

Venkat

[Former Member]

Hi,

could you share a screenshot of the rule and a small report showing the profit and loss account with data and the balance sheet account with data? We use account based calc rules for the same purpose and have never come across this issue.

BR,
Arnold

[Former Member]

Hi Elhoussiny,

You control the sign by changing its acc type for that member.

if you want all income as positive then just * -1.

Andy

[Former Member]

Hi Elhoussiny,

what account types do you use in your setup? If you use the standard, AST for assets, LEQ for liabilities and equity, EXP for expense and INC for income than the standard account based calculation rule should give you the correct amount in the BS whether the entity makes a profit or a loss.

BR,

Arnold