Share
Report
69I have a user who posted a recurring JE with 5 transactions in March. The General Posting Journal (GL) shows only 1 of the 5 transactions, but the full amount of the batch for all 5 transactions. The journal entries have rolled forward to the next month, April. The user uses the same JE numbers and batch id each month. Is this best practice? The user tried to attach a doc to one of the transactions, it replicated to the past months since it is the same JE #. He tried to delete it. The 4 transactions that are not showing on the report appear to have a doc attach, not sure this is relevant. As he stated he had some issues in the prior months. His statement regarding that is here: “One item to note that I completely forgot about until I saw your detail is I had a minor issue with this journal entry when I was booking February. I changed some of the values of rents in February, but I forgot to change the credit going to accrued liabilities so when I tried to post, it went to batch recovery (because the journal entry did not balance). The other 4 journal entries posted, but only the rents did not post in February. I ended up doing a manual journal entry to make up for it. For March only the rents posted, but the other 4 did not. I feel like there is a strong correlation there.”
I created the ‘View Posted GL Trx’ from Victoria Yudin’s site (TY Victoria). The missing transactions from March do not show up in this view, nor the GL20000 table.
They are not in the GL10000 or GL 10001 tables. Where else can I look? Where might they be? What do we need to do to straighten this mess out? Any help is much appreciated!
All responses (
Answers (
