This support note applies to:
- AE Accounts (AU)
In MYOB Accountants Enterprise Accounts (AE Accounts) you may experience the error "Cannot create an accounts ledger error please check the accounting master A1C is accessible" w hen creating an Accounting matter or opening an Accounts ledger.
This error may appear due to one of the following:
- the Master file (A1C) is corrupt or missing, or
- there is not enough space in the central database directory (CDS.dir).
If the error occurs due to the Master file being corrupt or missing, you will need to restore from back up as required.
If the error occurs due to the system reading that there is not enough space in the database, contact MYOB Support to increase the space in the Volume table of the cds.dir file.
Press and hold the Windows key + R on your keyboard. The Run window appears.
In the Open field, type s:\Data\MYOB in the Open field and click OK.
where: s:\Data\MYOB is the location for you data directory. A list of files within this directory appears. The first 7 files listed are the accounting master files and any corrupted accounting master files will show a .r extension.
Highlight the affected file eg, 000000.a1c.r and, from the File menu, select Rename. The 000000.a1c.r becomes editable.
Remove the .r extension and click OK. The file is renamed to 000000.a1c
Repeat steps 3 and 4 for the rest of the files showing an .r extension. The files are renamed removing the .r extension.
Listed below are what the accounting master files look like in the data directory if they have been corrupted.
The following files are the accounting master files which reside in the data directory:
If any of the files listed are missing you need to restore these from a backup.
If the accounting master files are missing you need to restore the relevant file from a datasafe backup.
Follow the menu path:
Start > All Programs > MYOB Accountants Enterprise > Datasafe.
The Datasafe Utilities screen appears.
Highlight the online backup dated before the error occurred from the Current Online Backup screen. The relevant backup highlights.
Press ALT and double click the highlighted backup. The list of files appears in the backup folder.
Highlight the Accounting master files you wish to restore and, from the Edit menu select Copy. The accounting master files are ready to be restored to the data directory.
Press and hold the Windows button and press R on your keyboard. The Run screen appears.
Type s:\Data\MYOB in the Open field and click OK, where
s:\Data\MYOB is the location for you data directory.
The list of files within this directory appears showing an .r extension.
From the Edit menu select Paste. The files will be restored to the data folder.
There maybe some instances where the volume table in the file cds.dir is full, in order to rectify this the volume table needs to be increased. To confirm if this is the issue, backup the accounts ledger in client file maintenance.
Backup an Accounts ledger in client file maintenance
In Contacts highlight the client and from the Tools menu, select Client File Maintenance. The Client File Maintenance screen appears.
At the FILE GROUP field Type ACT then press Enter. The act home and backup copies are listed.
At the SELECTION field type BACK- and the backup number and press Enter twice. A warning message no free space appears and you are unable to backup the ledger.
If you receive the above message or you are only able to back up to a floppy drive, contact MYOB support and request to have the volume table increased.
MYOB INTERNAL STAFF ONLY
To increase the space in the volume table of cds.dir:
- Open Datasafe and under other Other Utilities, choose options indicated in the image below, then click Run Now...
- From within the Windows Command Prompt, type s volume > C:\TEMP\volume.txt, then press the ENTER key. This will output the contents of the volume table to a .txt file in the C:\TEMP folder.
- Navigate to the C:\TEMP folder and open the volume.txt file in Notepad. The file contents will appear similar to the following:
- Increase the numbers highlighted above by 1000000 (i.e. 1 million). For example:
- Save your changes to the .txt file and close
- In the command prompt window, type d volume then press ENTER. The cursor moves to the next line.
- Type u volume < C:\TEMP\volume.txt then press ENTER. The cursor moves to the next line.
- Type s volume and confirm the change to the volume.txt file has been imported into the volume table.
- Type q to close the dbed command.