Cash Management > Bank Task > Responsible Party Config


  • Responsible Party Matching (Section 1)
  • Bank Deposit GL Location (Section 2)
    • Section 2 will be children record of Section 1


  • Fields
    • Responsible Party Matching (Section 1)
      • intResponsiblePartyMatchingId (hidden)
      • Type - Text Fields to Summary the Type of Transaction
        • Required to be Unique
      • Description Contains - Text Field - purpose is to used for matching line in import file in combination with Account Number and Reference.
        • Allow for Multiple values to be Includes one of and values separated by Or
        • Can Be Blank = mean match to any value
      • Account Number Contains - Text Field - purpose is to used for matching line in import file in combination with Description and Reference.
        • Allow for Multiple values to be Includes one of and values separated by Or
        • Can Be Blank = mean match to any value
      • Reference Contains - Text Field - purpose is to used for matching line in import file in combination with Account Number and Description.
        • Allow for Multiple values to be Includes one of and values separated by Or
        • Can Be Blank = mean match to any value
      • Action - Drop Down with Fixed Values of: Bank Deposit, Bank Transfer, Clear Checks, Notify Only, Ignore
        • During import these Action will control what type of transaction will be created.
        • Required Field
      • GL Location Search Column - Drop Down with fixed values of: Description and Reference
        • Required when Action = Bank Deposit
        • Not Allowed entry for Action <> Bank Deposit
      • Primary Bank - Drop Down to select Cash Management Bank Account
        • Required when Action is one of Bank Deposit, Bank Transfer, Clear Checks, Notify Only
        • Not allowed entry for Action = Ignore
      • Offset Bank - Drop Down to select Cash Management Bank Account
        • Required when Action = Bank Transfer
        • Not allowed entry for any other Action
      • GL Primary - Drop Down to select General Ledger Primary Segment
        • Required when Action = Bank Deposit
        • Not Allowed entry for Action <> Bank Deposit


    • Bank Deposit GL Location (Section 2)
      • Only Allow Data Entry when Action = Bank Deposit
      • intBankDepositGLLocationId (hidden)
      • intResponsiblePartyMatchingId (hidden)
      • Contains Value - Text Field
      • GL Location - Drop Down to select General Ledger Location Segment




Sample Config.

Keys:

  • Action: Create Bank Deposit
  • Description Contains = "Cust ID: 11000004501"
  • Account Number Contains = "4618292189"

SampleBankTaskFile.csv





Keys:

  • Action: Create Bank Transfer
  • Description Contains = "FUNDS TRANSFER FROM ACCT 4618292189" Or "FUNDS TRANSFER TO ACCT 4618292189"
  • Account Number Contains = "4618309905"






Keys:

  • Action: Clear Check
  • Description Contains = "CHECK"
  • Account Number Contains = "4239715153"






Keys:

  • Action: Notify Only
  • Description Contains = "DEPOSIT 18 033945894"
  • Account Number Contains = "4622580554"







Keys:

  • Action: Ignore
  • Description Contains = "DEPOSIT 18 033945894"
  • Account Number Contains = "4622580554"







Keys:

  • Action: Clear Check
  • Description Contains = "CHECK"
  • Primary Bank = <Bank Accounts>

Sample Multiple Bank File.csv





Keys:

  • Action: Clear Bank Deposit and Clear Bank Withdtawal
  • Description Contains = <Trasaction Description>
  • Primary Bank = <Account Designator>

Sample Multiple Bank BDEP BWD - Cleared.csv


  • No labels