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.Â
- Review batch report that displays funds involved
- Financials > General Ledger Menu > Setup/Charts of Accounts > Due To/Due From Setup
- Click Search
- Click AcceptÂ
- Click Browse
- Review the setup to see if there is a missing relationship of funds
- 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Â
- Financials > General Ledger Menu > Setup/Charts of Accounts > General Ledger Settings
- Click Update
- Enter your treasury fund number in Pooled Cash/treasury fund field
- Click Accept
C.) If the wrong cash account was assigned to the payment, the cash account can be updated in Payments Journal
- General Revenues > Payments journal
- Search for the batch
- Click the Cash Accounts tab
- Click Update
- Type in the new cash account in the New Cash Org, Obj, and Proj fields
- Click Accept
Additional Information