on 02-01-2017 7:48 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
Sorry, but the question author clearly mentioned:
"before loading the transaction data into BPC from Flat file"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.