Improve FE capability for changing or reassigning project codes to already processed payables.

We recently had to change the project ID for several expense transactions in FE for better tracking and reporting. We thought we could make the "adjustment" in FE like we do in RE with the system taking care of all the related entries. However, we learned that in FE the only way to do this is "void & purge" the original checks, do a "fake reissue" using the same check number, and then go back to mark them as "cleared" (if they were). This is a very cumbersome process to simply reassign a project ID. It should not be this involved when the underlying transaction did not change (invoice processed and paid, checked cleared, etc.). All we wanted was to change the project ID on the transactions.

  • Guest
  • Mar 22 2017
  • Needs review
  • Attach files
  • Guest commented
    June 18, 2019 16:21

    If you have multiple funds setup in FE and make an adjustment in AP on the invoice side, the payment does not reflect the change. The fact that FE is not capable of making both changes, instead what happens is you end up having a discrepancy in your accounts payables if you have multiple funds.

    I am surprise that no one has brought this up as a challenge and the only solution to this would be to make a JE in the general ledger module but when you end up having wrong information in the AP module. There should be an adjustment tab for the payment section as  well. This is Accounting 101 and should be a basic function in FE.

  • Anthony Gillespie commented
    March 22, 2017 20:27

    Marc, you are correct that we can do an adjustment to an invoice.  The problem with this is the adjustment only changes to the new project on the expense and accounts payable.  It does not adjust the check entry that originally hit the accounts payable and bank account.  The correct the check entry, you have to void and purge the check, and then reissue the check.  If the system is able to make all adjustment entries when you do an adjustment in Raiser's Edge, why can't the Financial Edge system make all the necessary entries without having to go through this long process.  In this case there was nothing wrong with the check that was written other than we needed to change the project number it was applied to.  The whole process took us over 4 hrs, with many chances for human error, but if the system could do all the entries it would have taken no more than 10 minutes.

  • Marc Seleman commented
    March 22, 2017 19:07

    You certainly can make an adjustment on an invoice record.  Open the invoice and select in the toolbar Invoice, New adjustment.  Now make the necessary entries on the adjustment tab.

     

    https://kb.blackbaud.com/articles/Article/75079