on 04-30-2013 10:08 PM
What is the best method to reclassify cash account based on whether it has negative or positive balance?
I tried to use business rule but did not see option to use -ve/+ve condition.
I am working on EPM 10 (MS)
At present there is no standard reclassification functionality in BPC - script logic/stored procedure is your best option
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi David,
how do you get the data into BPC? If you load it using a conversion file you could have the sign check in the conversion file.
Regards,
Arnold
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi David,
I believe you want to have a conditional reclassification depending on the sign of the source account. However, this can be done through business rules.
As Linda said, you need to do it with script logic.
You can use WHEN statement and copy the data from the source to the appropriate destination depending on your conditions.
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.