Americas - Pacific Northwest - ID, OR, WA

 View Only

 PO removed the release code

John Durr's profile image
John Durr posted 05-10-2024 02:22 PM

Good Morning,

We ran our capture cost at the end of April and got a review journal entry throwing an error for “Transaction does not balance”.  We located the PO and line that was throwing the off balance and somehow the release had no GL.  We don't know how this constraint was broken since it will normally just revert to 9999s.  The PO has already been invoiced and paid so we cannot change it.  Now our balance is off -$2,114.86.  Does anyone know if there is a way to fix this offset?

Paul Jackson's profile image
Paul Jackson

pretty sure that you can still change the PO Release until it has been “Captured”.

Of course, you would need to “Re-open” the PO, Line, Release and then change the GL Control or GL Account.  Then Close the PO, and re-run Capture.  (of course, cancel the review journal first).

Paul Jackson CFO Aseptico Woodinville WA

John Durr's profile image
John Durr

No go.  We Reopened all Order, Line, and Release and it's still greyed out.

Paul Jackson's profile image
Paul Jackson

did you cancel the review journal?

Paul Jackson CFO Aseptico Woodinville WA

Gary Browning's profile image
Gary Browning

@pjackson , yes we tried that.  (I work at the same company)

The PO was copied from an existing PO, and that PO was attached to a project and job.  When the PO was copied, it brought over the same project number but changed the type to Other instead of Job Material.  I’ve duplicated this scenario and cannot remove the project and open up the GL field to make the entry.

Also, reopening the existing release only enables one field, which I assume is due to it being received and paid.

Gary Browning Tube Forgings of America Inc / The Zidell Companies garyb@tubeforgings.com

...

Just to update, Epicor support provided us a fix.  The record needed was not present in the TranGLC table which the fix added the record.

The GL is now balanced.

Gary Browning Tube Forgings of America Inc / The Zidell Companies garyb@tubeforgings.com