Sage 100

 View Only
  • 1.  This field can only be set for deposits/adjustmen

    Posted 11-26-2013 11:53
    This field can only be set for deposits/adjustments"" message occurs when trying to check on the Cleared checkbox in Bank Reconciliation for a check. I have never seen this message before and cannot figure out what is controlling that. The client only has this problem clearing checks in one company; in their other company they can clear checks just fine.


  • 2.  RE: This field can only be set for deposits/adjustmen

    Posted 11-26-2013 12:53
    What version? Are the interfaces between AR/AP active with BR? if so, try turning them off, saving, then turning them back on.


  • 3.  RE: This field can only be set for deposits/adjustmen

    Posted 11-26-2013 14:43
    Were any of these transactions originally imported instead of being put there by the module involved (PR or AP)?


  • 4.  RE: This field can only be set for deposits/adjustmen

    Posted 02-04-2014 14:17
    OK I FINALLY figured this out! It seems that several Check records in the BR_Transaction file had Field 4 Transaction Date assigned. Because this field was not blank, while in the Reconcile Bank task when you tried to clear it you got that ""This field can only be set for deposits/adjustments"" message. Apparently checks can't have a transaction date. Not every check had a transaction date ... it was a random few .. but once I cleared that field those checks could then be cleared. Don't know how or why some records had a transaction date, but they were converted records from before the upgrade. Hopefully no new Check transactions update to that field.