cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 10 NW , Expense Type of Account

Former Member
0 Kudos

Hi All,

Sorry, i'm new in BPC. When my users doing input data in Expense Type of Account, they input plus data ( etc : 1000 ). But when i load the data in report, the result is minus ( - 1000 ).

Can i present the report for expense account in 1000 too ?

Thanks,

Suprapto

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Hi Suprato,

There is something wrong with your description:

When the user enter positive value to:

EXP,AST types - then in the system SIGNEDDATA will be positive and in Excel report the value will be also positive.

INC,LEQ types - then in the system SIGNEDDATA will be negative but in Excel report the value will be positive.

Is there any DEFAULT.LGF?

B.R. Vadim

Former Member
0 Kudos

Dear All,

Thanks for all of your replay.

After i checked in my data. Below is the data that i captured in screenshot.

First Picture :

Account 5910000100 - WIP PS Bangunan dalam penyelesaian : Account Type : EXP

2nd Picture :

user input in input template plus number.

3rd Picture :

The report that show, 5910000100 - WIP PS Bangunan dalam penyelesaian , is still plus. But when it will go summarize in SMLACCOUNT it will get minus number.

In my account, the hierarchy is :

1st : SMLACCOUNT  - INC

2nd : 1XXXX :AST

3rd : 12XXXX : AST

2nd : 5XXXX : EXP

3rd : 5910000100 : EXP

Is it because i'm create SMLACCOUNT as parent for the whole account ?

If that is the problem then, can i create a dimension member to be a parent for the whole account of EXP, INC, AST and LEQ ?

Thanks,

Suprapto

former_member186338
Active Contributor
0 Kudos

Then, what you see on the screen is a correct system behavior: INC in this case will be negative.

Imagine you have parent account EBIT with the type INC and 2 childs of this account: NETSALES - type INC and EXPENSES - type EXP.

NETSALES: 100 (SIGNEDDATA: -100)

EXPENSES: 60 (SIGNEDDATA: 60)

EBIT: 40 (SIGNEDDATA: -40)

and

NETSALES: 10 (SIGNEDDATA: -10)

EXPENSES: 60 (SIGNEDDATA: 60)

EBIT: -50 (SIGNEDDATA: 50)

B.R. Vadim

Former Member
0 Kudos

Hi Vadim,

So is it correct if i'm created the parent of whole account ( INC, EXP, LEQ, and AST ) with type INC ? or is it there is principal in BPC common to use for parenth for the whole account parent?

Thanks,

Suprapto

Former Member
0 Kudos

Hi Suprapto,

There is no thumb rule to define the acctype of the parent. It depends on the nature of the account. For example, if we talk about EBITDA, then it would INC; since this account indicates the earning of the company.

Hope you got the idea.

anil_agrawal
Active Participant
0 Kudos

Hi Suprato,

Normally, we want to see all the value positive in Report. Negative values treated as exception or something wrong in figure.

So based upon your final figure expectation regarding the top node, you can assign the acctype.

Regards,

Anil

former_member186338
Active Contributor
0 Kudos

Normally you want to see positive Net Income (INC) in the report when Net Sales (INC) value is greater then Total Expences (EXP). If you have Total Expences greater then Net Sales the you have negative Net Income (actually - Loss).

For the reporting purposes it's good that BPC can show expenses and sales as positive numbers, but for the internal storage (SIGNEDDATA) the values are stored based on accounting principles: INC is negative. So when you have a node with EXP and INC children in most cases the node should be INC according to P&L structure (EBIT, EBITDA,NI...).

B.R. Vadim

Former Member
0 Kudos

Dear All,

Thanks for the advise.

Suprapto

Answers (2)

Answers (2)

former_member215589
Active Participant
0 Kudos

Hi Suprapto,

There is a property in Account type dimension called 'ACCTYPE' which can have INC, EXP, LEQ or AST.

The change in sign in completly depended on the way you set this property for any member id in Account dimension.

helpful link:

http://scn.sap.com/docs/DOC-26973

Hope this helps.

Regards,

Priyanka Singh

Former Member
0 Kudos

Hi Suprapto,

Ideally, any account whose ACCTYPE property is EXP will be displayed with the same sign. This means if the data in your database is 100, it should be displayed as 100. If its displayed as -100, then the ACCTYPE is not proper. Please verify the same.

Hope this helps.