You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Issue with User Defined Query to find commission value from previous earnings transactions

    in Incentive Compensation 4 comments

    Summary:

    I am trying to find the COMMISSION_VALUE from previous earnings table if there's a match on a transaction id. But for some reason it always retrun Calculation Error. Here are some key fields
    Record that needs commission_value is from the CN_TP_TRANSACTIONS_ALL table.

    The transaction ID is stored in the ORDER_NUMBER column.

    Record that I am using to find the commission_value is the CN_TP_EARNINGS_ALL table,

    The transaction ID is stored in the SOURCE_TRX_NUMBER column


    Content (please ensure you mask any confidential information):

    I followed the instructions here so that:

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!