on 10-19-2012 10:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.