Skip to Content
0

BPC 10.0 NW : Validate transaction Flat file data

Feb 01, 2017 at 07:48 AM

92

avatar image
Former Member

Hello Experts

We have a requirement to validate Trial Balance (Debit = Credit) before loading the transaction data into BPC from Flat file. We are looking for different options for the same.

Any help on this would be highly appreciated.

Regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Feb 01, 2017 at 07:52 AM
1

You have 2 options:

1. Use routine badi in transformation file to perform validation.

2. Use vba to check source file.

But to my mind it's better to validate after load.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 11, 2017 at 09:34 AM
0

With the Help of Validations we can do.

Create a Validations Trial Balance (Debit = Credit)

Upload your Flat file in the Validations

Run the Validations.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but the question author clearly mentioned:

"before loading the transaction data into BPC from Flat file"

0