Switching of account based on source value

[Former Member]

Hi,

I am trying to load data to SAP BPC using a CSV file and want to map a source account to BPC account based on the source value.

For example :

If amount of Account1 in csv file is +ve it should be mapped to AccountA in BPC

If amount of Account1 in csv file is -ve it should be mapped to AccountB in BPC.

Can anyone help to achieve this?

Thanks in advance.

Regards,

Krishnan

[former_member186338]

Just read my answer here: https://answers.sap.com/questions/240890/bpc-101-loading-transaction-data-into-different-ac.html

Another option is to process text file using VBA.