Skip to Content
avatar image
Former Member

BPC 10.0 NW : Validate transaction Flat file data

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 01, 2017 at 07:52 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2017 at 09:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded