Reconciliations and OPEN_CO.TBL: What To Do When Items to be Flagged Do Not Appear 

Product: WinTAM Series 6 & Tam Series 7

The TAM Reconciliations program uses a pointer file called OPEN_CO.TBL. The OPEN_CO.TBL tells the Reconciliations program where in the transaction database (TRANSACT.DBF ) to start looking for open items. This helps the program to generate statements more quickly, as the system will not have to check through all of TRANSACT.DBF for open items, but, rather, has a starting point indicating where the last open item for each company was found.

When to Recreate OPEN_CO.TBL

Problems with OPEN_CO.TBL on Version 6.0.3 

If you have just installed version 6.0.3 and have not run a Reconciliation Statement, download the following files from the 6.0.3 downloads area of the Applied Systems web page before following the steps to recreate OPEN_CO.TBL.

The Internet provides instructions on how to download the files and copy them to the correct directory.

Recreate OPEN_CO.TBL 

Follow the steps below to rename and recreate OPEN_CO.TBL.

Note: You must exit all users from the system to pack and reindex TRANSACT.DBF. Larger agencies may want to rename the OPEN_CO.TBL and then pack and reindex as a part of Night Utilities.

V6.3.0 and Above

  1. Access the Reconciliations menu, Agency Bill, List Statements, and List Open Statements. Make sure that there are no open statements. 
  2. Follow the same steps for direct bill (Reconciliations menu, Direct Bill, List Statements, and List Open Statements ). Any open statements must be closed prior to moving to the next step. 
  3. At the desktop, double click My Computer (for TAMCentral agencies, this is labeled with your user name and current server). 
  4. Double click the icon for your TAM network drive. 
  5. Double click the TAM_EXE folder.  
  6. Locate the OPEN_CO.TBL file and click it.
  7. Click File and select Rename from the dropdown menu.
  8. Rename the file OPEN_CO.OLD
  9. Close My Computer.
  10. Double click the Database Maintenance icon from the Applied group in the Programs menu.
  11. Sign in with a user code that has been assigned console operator rights. 
  12. Select Stand Alone Process
  13. Click Next to continue. 
  14. Choose to Pack/Reindex TRANSACT.DBF

V6.2.0 and Earlier Versions

  1. Access the Reconciliations menu, Agency Bill, List Statements, List Open Statements, and List Open Statements and make sure that there are no open statements. 
  2. Follow the same steps for direct bill (Reconciliations menu, Direct Bill, List Statements, List Open Statements, and List Open Statements ). Any open statements must be closed prior to moving to the next step. 
  3. At the desktop, click Start, Run, type Command and click OK. (This brings you to an MS-DOS prompt.)
  4. Go to the network drive that TAM is on, for example, F:, and press [Enter].
  5. Type CD\TAM_EXE and press [Enter] to change to the TAM_EXE directory. 
  6. Type REN OPEN_CO.TBL *.ORG and press [Enter] to rename the OPEN_CO.TBL file. 
  7. Type CD\TAM and press [Enter] to change to the TAM directory. 
  8. Type SET BG=0 and press [Enter]
  9. Type REINDEX 1 TRANSACT and press [Enter]. This packs the TRANSACT.DBF and then creates a new OPEN_CO.TBL file. 
  10. When this is complete, exit from the MS_DOS prompt. 

Return to the Reconciliations menu to try to reconcile the problem items; they should now appear on a statement. If the items still do not appear, view the item through Update Transactions at the customer level, note the Customer Code, Item Number, Accounting Month, Billing Company, Company Paid, and Check fields, and fax the information to Accounting support.

Last Revised: April 06, 2011 04:00 PM

SWE3779