Review Journal with a Transaction does not balance

Kinetic ERP
1

Hello,

We have a problem.

We have a review journal with a negative balance.

We tried cancelling and reposting but it isn’t fixing the issue.

image
image748×340 7.01 KB

We invoiced it on the 10th… but it has a yellow “Hold Invoice” that actually isn’t checked off.

image

image

2

Sounds like there might be a missing GL Control Code. I would dig into whatever GL Control Codes are involved to see if there is not a GL account.

Rejecting and submitting will not fix the issue. You need to track down what the error is and address it. You could also use the PE Log to try and figure out what is wrong.

3

It looks like the review journal transaction is coming from the Capture COS/WIP process, not from Invoice Entry. That AR Invoice you show looks like it posted correctly - I would expect to see “Review Journal” as a status if it were the transaction that were stuck.

I suggest cancelling the review journal and then running the Inventory/WIP reconciliation report for 11/8 (the apply date) to see if the GL summary balances. You most likely have a missing GL Control code.

4

Thank you both.

How do I access PE logs?

5

I would do what @tsmith suggested first. The PE Log should be the very last thing that you try.

6

I don’t know if this will help, but last time this happened to us, the GL context was correct, but we were still missing an offsetting debit. Support told me this: “it needs to be confirmed once the PO line and release have been created. If the Part was known, the expense when purchasing as Unknown would default to the Part’s Part Class OR if this a misc. receipt the default account would be pulled from the Suppliers associated GL Control.”

Here was the resolution I documented for our case:

  1. Locate the PUR-UKN transactions missing the debit side of the entry and utilize the pack slip information in the column labeled “reference” to find the purchase order.
  2. Using the Vendor and Pack slip Number from the report go into Receipt Tracker to obtain the PO number for PUR-UKN transactions.
  3. Next go to Purchase Order Entry and enter the PO
  4. Now go to the Releases tab
  5. Click Actions > Reopen Release
  6. Save this change
  7. Now go to the Summary tab and uncheck the Approved check box
  8. Save this change
  9. Select the Line and Release in the tree view and click Actions > Get Default GL Account. Once it is populated you may change it to any valid account.
  10. Save and close the PO again.
  11. Run the inventory WIP Reconciliation report to confirm it is now in balance.