What determines red or black actual amounts in account inquiry for balance sheet accounts?
User wants to know why one year is black and one year is red
Account Inquiry
Account Master
Balance Type
The set up in Account Master determines how the actual amounts will appear on balance sheet accounts in Account inquiry.
MUNIS > Financials > General Ledger Menu > Set Up Chart of Accounts > Account Master
The Balance Type determines how the amounts will display in account inquiry actual memo balance.
Balance Type                  Assets                                  Liability + Equity                              Fund Balance
Normal Balance                               Debit                   Credit                        Credit  Â
Debit Balance                  Black                                     Red                          Red      Â
Credit Balance                 Red                                       Black                         Black
Black means the total matches the Normal Balance for the Balance type (Asset, Liability + Equity, or Fund Balance)
Red means the total does not match the Normal Balance for Balance type (Asset, Liability + Equity, or Fund Balance)
NOTE
This functionality is built into the program. There is a field in Account Master for the Normal Balance, MUNIS DOES NOT change the functionality dependent on what this field says. That field is information only (it is used for a few reports so it should be set up correctly according to the information above however it does not determine how the Red or Black will display in Account Inquiry.
Once the accounts themselves are set up, the sum of the posted journals that displays in the Actual memo field determines if the value will show as Red or Black. Follow the table above.