Tekoa SoftwareTEKOA

 software  

 Tekoa Software Home Page

 Home

|

 Tekoa Software News

 News

|

Tekoa Software Support

 Support

|

 Tekoa Software Login

 Sign In

Tekoa Software Home 

Tekoa Software Development and Dedicated Server Hosting. 

 
Customer Service 

Contact Customer Service if you need more help. 

 
Sage MAS 90 200 Application Host 

Secure Application Hosting for Sage MAS 90 200 for todays enterprise. Get more from the software you already own. 

 
 
Sage MAS 200 Cloud Computing

Web Services, Tekoa MAS Web Browser, Customer Portal, Essential Technical Support...

All part of Tekoa's Cloud Computing Solution for MAS90 and MAS200.  Technology for today's web enabled enterprise.
MAS 90 200 Support
MAS 90 200 Paperless Office Email that Works!
 More Information...

Tekoa Software Knowledgebase Tekoa Software Knowledgebase 

Find answers to your technical support questions using our knowledgebase.

Using the seach below, enter keywords related to your technical support question. We will search our support database and find support articles related to your inquiry.

 
 
Title

Displaying Data File Records with the DFDM Utility 
ID 0000000035 
Subtitle Data File Display & Maintenance (DFDM) Utility 
Description This procedure will help you display records only. See other articles for other processes. 
Text The DFDM Utility is a multi-purpose file analysis and maintenance tool used to access and examine the contents of MAS 90/200 data files. This utility can be used to view, modify or remove data records.

IMPORTANT: The DFDM Utility contains options capable of modifying MAS 90/200 data files. There is no audit trail available for records modified through this utility, so BACK UP all files to be modified before executing and changes or deletions of records!

To access the Data File Display & Maintenance (DFDM) Utility, select it from the "Repair" menu. 
 
Resolution TO DISPLAY RECORD INFORMATION:
When using the DFDM to display file information, several pieces of useful information wil lbe displayed. Corresponding fields for file name, key size, record size, number of records and record type will be shown. At the top of the record information area, the 'Key' line will show the key of the currently-displayed record.

The vertical column of numbers on the left side is the 'Variable Index'. Each number in this index corresponds to a specific data field within the record. Data fields exceeding 74 characters will wrap on to additional lines. The index numbers corresponding to these are followed by a colon (:).

The numbered grid across the top of the display allows you to measure the number of bytes contained within the data field - each character represents one byte.

Several options are available when viewing records:
1. Click the right-arrow navigation button to see records one at a time from the beginning of the file to the end. Click the left-arrow button to back through the data records from the last record to the first.

2. To display information for records starting with a specific key value, enter an alphanumeric key value in the 'Key' field, then press 'Enter'. NOTE: This field is case-sensitive!

3. Click the 'Key Scan' buttion to see a list of the records. Use the 'Search' button to enter a specific starting key.

4. Click on the 'Edit' button to modify the content of the record. For more explicit instructions on this, see our article on "How to Modify Records Using the DFDM".

5. Click the 'Delete' button to remove the selected record from the file. For more specifics on how to accomplsih this, see our article on "How To Delete Data Records Using the DFDM". Note that the 'Delete' button is disabled when viewing an Index type data file.

6. Click on the 'Printer' button to open the Print window. In the 'Print Option' list, select 'Print Records' or 'Print Keys'.

7. Clear the 'All' check box to define the range of records or keys to print.

DISPLAYING A DATA FILE:
1. Click on the 'Folder' button to select a file or enter the name of the file in the "Field Name" field.
a. The first 2 characters represent the application code, the last 3 characters represnt the company code. (e.g., "GLABC" represents General Ledger GL0 file for company ABC.)
b. When the file name is entered or selected, the data file contents will be displayed.

2. Click the arrow buttons to navigate through the records in the selected or named file.

3. In the "Key" field, enter a key and press 'Enter' to view the first record for that key.

4. Click on the 'Key Scan' button to display only the key information for the selected or named file. NOTE: The 'Key Scan' button does not display indexed files.


TO DISPLAY KEY INFORMATION:
1. Click on the right-arrow button to display the key information from the first record in the file.

2. If you want to see key information for other records, click the 'Key Scan' button, then the 'Search' button. Enter the alphanumeric key information in 'Enter Starting Key' field. NOTE: This field is case-sensitive.

3. Click 'OK' to display records with the value in the 'Key Scan' window. The key information is displayed for each record in the file.

4. You can scan through the file using the 'Page Down' key.

5. To display records starting with a different key value, click on the 'Search' button again.

6. Double-click any record in the Key Scan list to view its content.

7. Click on the 'Printer' button to print the Data File Listing. 
Related Link 1 http://www.tekoasoftware.com/support 
Related Link 2  
 Sage MAS Knowledgebase Search
Clear

Sage MAS 90 MAS 200 Knowledgebase Articles 
Kb Title Kb ID Category Type
Barcode Printing Crystal Reports Sage MAS 90 200 

0000000003 

 Sage MAS 90 200 Technical Support  Technical Support 
Downloading, Installing and Updating Tax Tables 

0000000031 

 Sage MAS 90 200 Technical Support  How To Instructions 
What if I forget my password? 

0000000002 

 Frequently Asked Questions  General Information 
Printer using ports not COM, LPT or USB 

0000000059 

 Sage MAS 90 200 Technical Support  Technical Support 
PVXWIN32.EXE - DLL Initialization Failed 

0000000013 

 Sage MAS 90 200 Technical Support  Technical Support 
MAS 90 200 Q1 2009 Tax Table Update 

0000000039 

 Frequently Asked Questions  How To Instructions 
How To Use Item Alias Codes in MAS 90 200 

0000000010 

 Sage MAS 90 200 Technical Support  How To Instructions 
MAS 90 200 Paperless Office Email Errors 

0000000044 

 Sage MAS 90 200 Technical Support  Technical Support 
Can I Export MAS 90 200 Reports to Excel or Word? 

0000000011 

 Frequently Asked Questions  How To Instructions 
Reversing a Credit Card Payment in MAS 90 or 200 

0000000026 

 Sage MAS 90 200 Technical Support  Technical Support 
Rebuilding key files in MAS 90 and MAS 200 

0000000032 

 Sage MAS 90 200 Technical Support  Technical Support 
Invoice Already Being Paid of Balance Exceeded 

0000000034 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 11 POWUZA 3330 when Rebuilding Sort Files 

0000000006 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 11 POSUZA 3330 

0000000020 

 Sage MAS 90 200 Technical Support  Technical Support 
Crystal Reports Export To Text Do Not Prompt 

0000000025 

 Sage MAS 90 200 Technical Support  How To Instructions 
Moving MAS 90 or MAS 200 to a new location 

0000000022 

 Sage MAS 90 200 Technical Support  Technical Support 
Runtime DLL Files for Special Formulas 

0000000023 

 Sage MAS 90 200 Technical Support  General Information 
How to register .DLL and .OCX files 

0000000057 

 Sage MAS 90 200 Technical Support  How To Instructions 
Creating a one-sided journal entry 

0000000028 

 Sage MAS 90 200 Technical Support  Technical Support 
Installing Workstation Setup for MAS 90 & 200 

0000000027 

 Sage MAS 90 200 Technical Support  Technical Support 
TCP/IP Connection Failure in MAS 200 

0000000014 

 Network Support  Technical Support 
MAS 90 MAS 200 2009 Payroll 941 Program Update 

0000000045 

 Sage MAS 90 200 Technical Support  Technical Support 
Setting Default Printers in MAS 90 & 200 

0000000040 

 Sage MAS 90 200 Technical Support  Technical Support 
Setting a Default Device Configurator Printer 

0000000046 

 Sage MAS 90 200 Technical Support  How To Instructions 
Microsoft IIS Loses MAS 90 200 ODBC Connection. 

0000000041 

 Sage MAS 90 200 Technical Support  Technical Support 
How to Back Up and Restore Data Files 

0000000030 

 Sage MAS 90 200 Technical Support  Technical Support 
"A goods receipt is currently referencing this PO" 

0000000055 

 Sage MAS 90 200 Technical Support  Technical Support 
A goods receipt is currently referencing this PO 

0000000015 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 88 SY_ReportEngine.pvc 1127  

0000000051 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 88 SY_ReportEngine.pvc 1535 when printing 

0000000052 

 Sage MAS 90 200 Technical Support  Technical Support 
Add the ability to edit/revise menus in MAS90/200 

0000000019 

 Sage MAS 90 200 Technical Support  General Information 
Installing Service Packs, Updates or Program fixes 

0000000029 

 Sage MAS 90 200 Technical Support  Technical Support 
Displaying Data File Records with the DFDM Utility 

0000000035 

 Sage MAS 90 200 Technical Support  Technical Support 
Modifying Records using the DFDM Utility 

0000000036 

 Sage MAS 90 200 Technical Support  Technical Support 
Deleting Records Using the DFDM Utility 

0000000037 

 Sage MAS 90 200 Technical Support  Technical Support 
Sage MAS 90 200 Payroll Tips on W-2 Are Incorrect 

0000000005 

 Sage MAS 90 200 Technical Support  Technical Support 
Error: "(CheckOFSIConnection) 8900: 

0000000042 

 Sage MAS 90 200 Technical Support  Technical Support 
Finance Charges Not Calculated  

0000000024 

 Sage MAS 90 200 Technical Support  Technical Support 
Reports Default to Wrong Printer in Crystal Report 

0000000047 

 Sage MAS 90 200 Technical Support  Technical Support 
The object SO_SalesOrder_UI does not exist 

0000000017 

 Sage MAS 90 200 Technical Support  Technical Support 
Install or Uninstall PDF Converter 

0000000058 

 Sage MAS 90 200 Technical Support  How To Instructions 
Object ProvideX.Script was invalid 

0000000021 

 Sage MAS 90 200 Technical Support  Technical Support 
Connection failure to host 

0000000012 

 Network Support  Technical Support 
Financial Reports Defaulting to Incorrect Printer 

0000000048 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 13 SO_PurgeSalesHistory.pvc Line 140 

0000000004 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 65 CI_Audit Tracking.pvc 132 

0000000016 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 71 SO_SALESORDER_UI.PVC 515 

0000000018 

 Sage MAS 90 200 Technical Support  Technical Support 
"Data is not selected for report printing" in RMA  

0000000049 

 Sage MAS 90 200 Technical Support  Technical Support 
Default RMA date is retained in RMA Entry  

0000000053 

 Sage MAS 90 200 Technical Support  Technical Support 
Credit Memos Posting to Incorrect Warehouse 

0000000038 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 88 Sy_ReportEngine.pvc 702 when printing  

0000000050 

 Sage MAS 90 200 Technical Support  Technical Support 
Error 12 SY_PDF Converter.pvc 369 

0000000056 

 Sage MAS 90 200 Technical Support  Technical Support 
Residential address check box is cleared on SO's 

0000000054 

 Sage MAS 90 200 Technical Support  Technical Support 
Cannot connect to database for pages w/ MAS data 

0000000007 

 Tekoa ERP Software Support  Technical Support 
FireBox VPN instability from remote office to Host 

0000000008 

 Network Support  Technical Support 
Grids with multiple tables pass blank variables. 

0000000009 

 Tekoa ERP Software Support  Technical Support 
FRX: Run-Time Error -2147220503 

0000000043 

 All Categories  Technical Support 
 

 Tekoa Software, Inc.  All Rights Reserved. General: 509-340-3580       Support: 509-340-3733     Contact Us

www.TekoaSoftware.com 
 software for today's web enabled enterprise  Web Software Development  |  Web Design  |  eBusiness Solutions  | Web Enterprise  |  Business Management Software

  Tekoa Software Blog