Skip to Content

Conversion File formula Value*-1 BPC 7.5 NW

Dear Freinds,

My requirement is to change the sign of data while loading the data into BPC using BPC tranformation and conversion file.

I tryied with Convertion formuls

EXTERNAL INTERNAL FORMULA

0080100006 IC_80100006 VALUE*-100

my transformation file

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=NO

CREDITPOSITIVE=NO

MAXREJECTCOUNT=-1

ROUNDAMOUNT=

SELECTION=0GL_ACCOUNT,0080100006;

other things are normally working , Kindly sugesst were I gone wrong .

Thanks !

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 04, 2011 at 01:51 PM

    Hi vishwanathg7,

    If you Want to change the sign of the data all you have to do is put the credito positive in yes, like this

    *OPTIONS

    FORMAT = DELIMITED

    HEADER = YES

    DELIMITER = ,

    AMOUNTDECIMALPOINT = .

    SKIP = 0

    SKIPIF =

    VALIDATERECORDS=NO

    CREDITPOSITIVE=YES

    MAXREJECTCOUNT=-1

    ROUNDAMOUNT=

    SELECTION=0GL_ACCOUNT,0080100006;

    HOPE THIS HELPS,

    Edited by: Guillermo Ferro on Apr 4, 2011 3:51 PM

    Add comment
    10|10000 characters needed characters exceeded