Question #2.  Yesterday I posted the CRA Payment that was for PP# Ending May 31st.  The payment was made June 6th, 2023.  After doing that my data integrity was off.  In checking the payment journal entry, it did all the steps except Debiting the AP Liability and Crediting the Bank Account.  Anybody have this issue and what would cause it?  Yesterday morning I did create a new physcial year as our year end is May 31, 2023. I have never run across this problem before. So do I just do a journal entry to fix that part so my data will be balanced?

I can't help you with your first question because I don't use the report.  However, I have some questions about your second one.

1) Is the Data Integrity discrepancy in the Debits and Credits at the top?

2) When you run the Comparative Balance sheet comparing Jun 1/23 vs May 31/23, does the total of the May 31/23 Retained Earnings plus the Current Earnings equal the Retained Earnings on Jun 1/23?

3) When you triggered the year end, did you use the Maintenance Menu, Start New Year or one of the other three methods?

Morning Richard, The Data Integrity is showing Debit of 38,213.52 (which is the amount of the CRA Payment) and the Credit is showing Zero for the Unpaid Invoice/Deposit.  The comparative balances between 2023 & 2024 = $1,716,414.51 and match.  The method I used I believe was when I started Sage up I put in the date of June 1, 2023.  Possibly may have been from Maintenance, Can't remember. 

Richard the above attachment shows what it didn't do when I posted the payment.

I asked the three questions because years ago there was a bug in the system that caused the Retained Earnings in the new year not to update with the balance of the previous year Current Earnings if you triggered the year end transition from the file opening Change Session Date dialog.  This caused the Debits <> Credits in the Data Integrity Check dialog.  I don't know if this happened for you, you only mentioned two lines that don't exist in my Data Integrity Check.  it sounds like your Trial balance will balance so this is likely not the issue.

It does sound like for some reason there is a discrepancy between the left and right side of your Data Integrity Check on at least one line.  I would go back and restore the backup you took before you transitioned to the new year (don't overwrite your current file, be careful to restore it to another location and name).  Then check the Data Integrity.

If it looks ok, transition that file to the new year using Maintenance Start New Year and see if your integrity stays ok.  Then post the same entry again and see if it causes a problem.  If it all works ok this time, then you need to decide if you should try to get your current file fixed or just re-enter from what you have done since moving to the new year.  I don't know how many entries that might be.

I don't have enough information to determine if just unlinking the linked area of the program that has been affected and posting an entry will correct the problem, you will have to look into that more at your end.  It might not solve the problem as there could be an imbalance in the file internally that needs to be corrected.  Sage Tech support may be able to do that over the phone with their internal rebuild option.  I don't know if it's the same one as in the dbuil utility.

Thanks for the Info Richard. The only data integrity that was not correct was the Accounts Payable.  All the rest were good.  About a year ago I had a small discrepancy for no apparent reason and I did do a GL entry and that fixed the problem after I had unlinked. I think I will try the simple possible solution first (can always reverse it) by doing an entry first.  I have several AR invoices I did yesterday before I noticed the integrity was out. If that doesn't work I will try the Recover from last backup.