Toll Free: (800) 996-9777 Local/Intl: (858) 732-3001 Help Desk Submit a Ticket Chat Request Free Trial

Bank Account Adjustments Missing

Q. When in MaxxTraxx, the default bank adjustments, Bank Charge, Credit Card Charges, Returned Check and Interest Earned, are all missing. The main problem tends to show up first time they have an NSF check. You can't manually that one, so that request the customer's name when you choose it. And chances are, they've already put in other adjustments, so the required IDs are already used.

Answer:

To fix it requires a little surgery.  First determine if they have added any "necessary (to them)" adjustments to the table.  If so, note them and the accounts and amounts, because you'll need to re-add them to the table once you're done with the defaults.
 
You'll do this thru SQL Express. Start by opening the Account Adjustments, and delete all records.
 
Run this script to clear the IDs:  
 
Dbcc checkident (AccountAdjustments, reseed, 0)
 
Now you can re-add the default adjustments back into the table.  They must be done in order, so that the IDs are correct. Set them up exactly as follows:
 
ID    GlaID    AdjustmentType    Description                Amount    IsSystem    IsActive   All Other Fields
1    118        1                             BankCharge                0.00            True            True        0
2    115        1                             Credit Card Charge      0.00            True            True        0
3     0           1                            Returned Check           0.00            True            True        0
4    89          2                            Interest Earned            0.00            True            True        0
 
Once this is done, you can go back into MaxxTraxx and add the other adjustments that were there previously.
 

Written By: Rex Panton