Unable to post payments journal with fund out of balance error

Description of Issue
  • Fund out of balance
  • Error posting Payments Journal
  • System log error : Invalid number of dtdf accounts detected for XXX and XXX, count:          0
Context
  • Accounts Receivable
  • General Ledger
  • Payments Journal
  • Due To/Due From Setup
  • General Ledger Settings
Cause

Posting of AR batch is attempting to cross funds but there is currently not a relationship setup between the funds

Resolution

A.)Identify if there should be a Due To/Due From Setup record created

  • If site does not use a treasury fund (TREAS) there should be a DTDF record for Fund A to Fund B.
  • If site uses pooled cash there should be a DTDF record for Fund A to Fund TREAS and Fund B to Fund TREAS. 
  1. Review batch report that displays funds involved
  2. Financials > General Ledger Menu > Setup/Charts of Accounts > Due To/Due From Setup
  3. Click Search
  4. Click Accept 
  5. Click Browse
  6. Review the setup to see if there is a missing relationship of funds
  7. If missing fund relationship, continue with adding new DTDF record

http://help.munis.com/2019.1/GL/Content/Programs/gldtdfmt01.htm

B.) If supposed to be setup with pooled cash for DTDF 

  1. Financials > General Ledger Menu > Setup/Charts of Accounts > General Ledger Settings
  2. Click Update
  3. Enter your treasury fund number in Pooled Cash/treasury fund field
  4. Click Accept

C.) If the wrong cash account was assigned to the payment, the cash account can be updated in Payments Journal

  1. General Revenues > Payments journal
  2. Search for the batch
  3. Click the Cash Accounts tab
  4. Click Update
  5. Type in the new cash account in the New Cash Org, Obj, and Proj fields
  6. Click Accept
Additional Information