Hi Sue,

It is not possible for you to directly post an entry, except using the Accountants' Edition licensed software.  There is a technical document somewhere explaining how to unlink / adjust / relink the G/L account.

First, before you do anything, make sure it's actually out of balance, by clicking Maintenance, then Check Data Integrity.  If that shows 'Data OK', then the accounts are not out of balance with the ledger.

Historical report totals may not always agree to the G/L, but that doesn't mean the G/L is wrong.  The problem may be elsewhere.

No good comes of taking a sledgehammer to something that's already straight. so if the Data Integrity check comes out OK, ask the auditors more questions.  They may be mistaken, or there may be something else wrong.

I've seen where auditors are confused by some Sage 50 reports, as they look only at totals, and are not aware of how Prepayments in A/P / Deposits in A/R work in Sage 50.   Also, it is possible to have incomplete reports - missing inactive customers or vendors, or to failing to select *ALL* when running sub-ledger reports and missing new ones. 

If you really do need to adjust that account look for this technical document:

https://support.na.sage.com/selfservice/viewContent.do?externalId=11727&sliceId=1

Just want to add a little thing; if indeed the data integrity is out on A/R and A/P, and you are planning to unlink it to fix the issue before you unlink A/R and A/P, make sure you are not using foreign currency in either module; If you have outstanding foreign value, unlink will reset all outstanding foreign value to home currency value.  (if you don't use foreign currency then unlink is fine)

Thank you both for your guidance.  So, I do have a data inconsistency

AND I do use Foreign currency.

Jason, If I proceed with unlinking,how do i reset the foreign values?

Hi Sue

You do not have inconsistency between  A/R and A/P, you have it in Total Debit and total Credit (you see the star in between them, in the middle, and A/R and A/P doesn't have it which means is fine)  

For Total Debit and Credit you can try to run dbtuil.exe to re-index the table , make a backup follow article 10403 run database utility, see if that fixes it (if it doesn't you would need to call support to fix total debit and credit issue)

After Dbutil.exe if A/R and A/P are still fine, I would suggest you contact your accountant see why need to do such General journal, because that would create data inconsistency. (you can create invoice which update both General Ledger and Sub Ledger then wont create inconsistency)

I sure hope someone can help me with this one...

I just logged into Sage using the sysadmin password and then logged off and entered it here.  I've tried it about 6 times and I am 100% confident I've entered the correct password.

Is there a super-secret password for this function that is different than the one I use to log into Sage as sysadmin?

Hi Sue Clifford

It is the password for the User Name Sysadmin.  When you normally open Sage are you using the User Namer Sysadmin or another name?

Normally, when I log into Sage I use the username SueC

But if I want to do anything as Admin I log on with the username sysadmin and password that I entered in the screen shot.  

Hi Sue Clifford

Then it should work. Keep in mind a password for Sage is only 7 characters long. This dialog box you are trying to accept the password sticks to the rule. Whereas I have found the normal log in box to Sage does not. Check how long you Sysadmin password is. If it is more than 7 characters, just enter the first 7 characters of it. It is worth a shot.

TLDR:  I got in and ran it

Long Version:  My data is on the server so I had to make a copy to run this process.  I guess copying the .SAI file is not good enough because that's what would not accept my password.  I did a "save as" from within Sage and then it worked.

Thanks for everyone's help!

You are welcome! Great to hear you got it to work!

Hi Sue

If you have use the correct password and use mouse click "OK" option it should give you "Your task complete" message.

if you have password issue. did you check this part of the article?

Note : if you having issue running the utility please verify and make sure sysadmin have third party rights

1. Log into Sage 50 as sysadmin.
2. Click Setup, Set Up Users.
3. If asked for a password, enter sysadmin password.
4. Select the user you log into the third-party product with and click Modify.
5. Select Read-only access or Read/write access to Third-Party Products and click OK.
6. Try utility again.