Rebuild Client Ledger Detail Technical Information

Last reviewed: 07/12/2011
Article ID: R10480

The information in this article applies to:

SUMMARY

The April 2000 version of Tabs3 Version 9 added the ability to more thoroughly track information for payments, write offs and credits. As a result, two new data files named T3LDGDET.DAT and T3LDGDET.IDX are used to track this information. These data files were not used in versions of Tabs3 Version 9 prior to April 2000. 

The Rebuild Client Ledger Detail program in the April 2000 release of Tabs3 Version 9, 10, 11 & 12 includes an option to rebuild the T3LDGDET.DAT and T3LDGDET.IDX files for individual client matters. This option is called "Apply Detail Only".

Tabs3 Help includes documentation on how to run this program. This article documents some of the more technical information regarding this option that may not be documented in Help.

MORE INFORMATION

Running the Rebuild Client Ledger Detail program with the "Apply Detail Only" option (or Both) is very disk I/O intensive. If running on a network, we recommend running it on the file server if possible and also running it at a time when there is less network traffic. 

If the data files do not balance prior to running this program, they will not balance after running this program.

Note: Users who purchased Tabs3 Version 9 after the April 2000 enhancements do not need to run the Rebuild Client Ledger with the Apply Detail Only option.

Technical Notes regarding "Apply Detail Only" option

When this option is used, the program copies the ledger and payment allocation files to *.BAK files.

T3LEDGER.DAT is copied to T3LEDGER.BAK
T3LEDGER.IDX is copied to T3LDGIDX.BAK
T3PYMALC.DAT is copied to T3PYMALC.BAK
T3PYMALC.IDX is copied to T3PYMIDX.BAK

 

Copying the files may take some time--particularly when the files are larger and the program is being run over a network. This may be deceiving because the program does not show any visual feedback until after the preliminary copying of files has completed.  

As the program runs, it modifies the ledger and payment allocation files.  Upon completion, it deletes the modified ledger and payment allocation files and then renames the *.BAK files back to their original name. Therefore, when this program is run for the first time for users who used Tabs3 before the April 2000 update, no data files are converted--just the two new files are created: T3LDGDET.DAT and T3LDGDET.IDX.

If the Program is Interrupted

If the program does not complete successfully, then the *.BAK files will not be copied back to their original name and the T3LEDGER.* and T3PYMALC.* files that are remaining will be the modified data files. When the Rebuild Client Ledger Detail program is run with the Apply Detail Only option, it looks for the presence of the T3LEDGER.BAK and T3PYMALC.BAK files. If these files are present, the following error message will be displayed:

Error:  The T3LEDGER.BAK or T3PYMALC.BAK files already exist. This program may have been previously run and did not complete. You must 1) restore the Tabs3 data files; and 2) either delete or rename the T3LEDGER.BAK and T3PYMLC.BAK files before you can successfully run this program.

Additional troubleshooting information can be found in KB Article R10480 of our Knowledge Base on the Internet at:

      Support.Tabs3.com

    If the Rebuild Client Ledger Detail program is interrupted, do the following:
  1. You must restore from a backup. 
  2. Run a Data File Integrity Check. Proceed if there are no errors.
  3. Run an Archive File Integrity Check. Proceed if there are no errors.
  4. Call the Technical Support Department at (402) 423-1440.

Log File

Running the Rebuild Client Ledger Detail program with either the Apply Detail Only option or Both option creates a log file named REBLDLDG.LOG.  Information is appended to the log file each time the program is run with one of the above options. The log file contains the date, time, user, and client range used when the program was run as well as a count of ledger detail records created. Keep in mind that multiple ledger detail records can be created for each client.

The log file is not created or modified when the Allocation Detail Only option is selected. 

The following is an example of information in the REBLDLDG.LOG file:

       Rebuild Client Ledger Detail 'Apply Detail' option run at 02:24 PM on 04/17/04
           by user: ALICE for Client: 0.00 thru Client: 999999999.99

       784 Ledger Detail Records Created

Assumptions

There are certain assumptions that the rebuild program makes. The program assumes:  

Limitations of the Program

There are certain known limitations of the program. The following situations will cause problems:


© 1999-2012 Software Technology, Inc.   All rights reserved. Terms of Use
The maker of Tabs3 and PracticeMaster
Tabs3, PracticeMaster, and the “pinwheel” symbol (The "Pinwheel" symbol is a Registered Trademark of Software Technology, Inc.) are registered trademarks of Software Technology, Inc.
e-Mail Suggestions for the Knowledge Base to: kb@Tabs3.com
Technical Support via e-mail is not available.
Knowledge Base:   http://support.Tabs3.com
Web Site:   http://www.Tabs3.com