A confirmation code will be emailed when setting up your account or resetting your password—check spam if needed.no-reply@dynamicscommunities.com

Forum Replies Created

  • Larry Carrethers

    Member
    November 11, 2024 at 7:56 pm in reply to: Credit limit alerts
    Up
    0
    Down
    ::

    This is what I used in case anyone else runs into this issue

    RM00101_T1.CRLMTTYP = 2 AND ( RM00103_T2.CUSTBLNC >=

    ( RM00101_T1.CRLMTAMT * 0.8 ) ) AND RM00103_T2.CUSTBLNC <=

    (RM00101_T1.CRLMTAMT * 1 ) AND RM00101_T1.CRLMTAMT > 0

  • Larry Carrethers

    Member
    November 11, 2024 at 7:43 pm in reply to: Credit limit alerts
    Up
    0
    Down
    ::

    Yes, the business Alert functionality will work. I believe I have it now.

  • Larry Carrethers

    Member
    November 11, 2024 at 7:33 pm in reply to: Credit limit alerts
    Up
    0
    Down
    ::

    They only want an email with the results

  • Larry Carrethers

    Member
    November 11, 2024 at 10:09 am in reply to: Credit limit alerts
    Up
    0
    Down
    ::

    The example looks like it is giving me all customers with credit balances over there credit limit.

    ex.

    Customer Credit limit Credit limit balance

    A 50000.00 81348.38

    so what i’m looking for is if he credit limit balance is was 40000 so near the credit limit balance but not over

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!