Beginning Balances and Other Setup Issues
Correcting Beginning Balances
There are two ways to correct beginning balances. If the correction just involves editing amounts, click Auditor, then go to View Journal, select the Beginning Balances (usually right at the top, always dated 12/1/1994), and make your corrections.
If you need to add additional lines to the Beginning Balance transaction, it is often easier to delete the beginning balances, then add new ones. There will be one beginning balance transaction per bank account. Select one at a time in View Journal and type Delete on your keyboard. Go to Tables / GeneralInfo, and change the NextStep column to "3". Close back out to the front end (you will get an error message and Auditor will shut down; just restart it), click the NextStep "Enter Beginning Balances", and enter the new Beginning Balance transaction. Click Auditor again, and use the NextStep selector to go back to the step you were on.
However, when the list of beginning balances is long and you only need to add one or two lines, it may be easier to add account lines to a beginning balance transaction in the back end. First, go to Auditor / View Journal, find the Beginning Balances, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the Beginning Balances. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount. Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do. If your beginning balances don't add up, you will get a notification that the database is out of balance when you re-enter the front end.
Note: If you change the beginning balance of a bank account, you must also go to Tables / BankRecs and correct the beginning balance there.
Finding Beginning Balance Transactions
Generally, the Beginning Balance transactions are right at or very near the top in View Journal. But if you have trouble finding them, go to Tables / Journal, and sort by JournalTypeID. The Beginning Balance transactions will have JournalTypeID = 0. Note the JournalID, and use it to find the transactions in View Journal.
Entering the EntityID
For Jewel tech support and others who have the "universal" (non-conference-specific) version of Auditor, the EntityID controls which server a database automatically uploads to, so having it entered correctly can help avoid uploading it to the wrong server accidentally.
If a church's EntityID is not entered in the database, there are two ways to enter it:
- If you have Auditor for a specific conference, go to Maintenance / Properties / Church Info tab, and select the church from the list. Click OK to save.
- If you have the "universal" version of Auditor, then look up the church's EntityID on eAdventist. Be very, very sure you get the right church! Then click Auditor, and go to Tables / GeneralInfo. Carefully enter the EntityID in the proper column, and click OK. Auditor will throw an error and close, but just re-open it and continue working.
Jewel Password Issues
If a treasurer has set a password for Jewel, it can be viewed by clicking Auditor, then Tables / GeneralInfo, under the Window column.