on 07-28-2017 7:35 AM
Hello,
We are running BPC 10 NW 731 SP 17 CPM 801 and Excel EPM-Addin (Version 10.0 SP28 Patch 3 Net 4.5).
I want to export periodic transaction data from BPC10.0 NW to flat file. Therefor I use the following Transformationfile and Conversion. I also want to switch the sign of some Accounts. Therefor I use the Formula function in the Conversionfile (2nd Screenshot). This is working fine for the Measure "SIGNEDDATA", but not for all the other (YTD, PERIDIOC, QTD).
Can anyone please suggest how this can be done.
Thank you!
Transformationfile
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=NO
CREDITPOSITIVE=NO
MAXREJECTCOUNT=2
ROUNDAMOUNT=2
SPECIFICMAPPING=YES
*MAPPING
PlanVersion=CATEGORY
Time = TIME
CurrencyCode=CURRENCY
CompanyCode=ENTITY
GLAccount=ACCOUNT
CostCenter=COSTCENTER
Vbund=INTERCO
SIGNEDDATA=SIGNEDDATA
*CONVERSION
GLAccount=EXPORT\ACCOUNT.XLS
CompanyCode=EXPORT\ENTITY.XLS
PlanVersion=EXPORT\CATEGORY.xls
Vbund=EXPORT\INTERCO.XLS
CurrencyCode=EXPORT\CURRENCY.XLS
Conversion File ACCOUNT.XLS
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.