Condition |
Error Message Containing the statement:
DBFNTX/1021 Data width error
or
Field overflow
The most frequent cause of this error is entering a number that is too large for the program to handle. Usually in the Receipts or Disbursements section of Stockroom Inventory Manager. CAUSE - This is caused by data entry errors. Leaving out a decimal point, for example, will turn 1000.00 into 100,000. With older versions of the program (prior to 4.x) this error can also occur if the result of certain extended price calculations (QTY * PRICE) exceed the defined field sizes.
Action |
In Stockroom Inventory:
This problem most often occurs when entering receipts, disbursements or adjustments.
If the problem occurs during the entry of receipts, print out the List of Received Items (before posting) report. Find the problem item and correct it in the Enter / Edit Received items option. In versions prior to 4.0, print out the Inventory Disbursement List.
If the problem occurs during the entry of disbursements (in version 4.0), print out the Packing List with Prices. If the problem occurs during the entry of disbursements (in version 4.1), print out the Inventory Disbursement List - ID Order, Amount.
Find the problem item and correct it in the Enter Item Disbursements option.
If the problem occurs during the entry of adjustments, print out the Discrepancy Report. Find the problem item and correct it in the Enter Item Adjustments option.
Action |
Install Stockroom Inventory Manager to a temporary directory (throughDisk #1 only). Copy the empty TRANS.DBF in that temporary directory to the \INV directory (or directory where Stockroom Inventory Manager is installed). This will remove the bad entry. Now delete all files in the TEMPORARY directory.
Action |
DIY - If you have dBase (or dBXL or FoxPro, etc). you can edit TRANS.DBF and remove the bad entry.
E-MAIL - If you have internet access, call CMS and ask for a blank copy of the TRANS.DBF file.
MAIL - A copy of TRANS.DBF can also be mailed.
BACKUP - Keep a backup copy of the file TRANS.DBF in another directory or rename a copy TRANSBAK.DBF.
In Purchase Order Tracker:
Usually this problem occurs when entering purchase order line items.
Locate the requisition or purchase order where the error occurred. Press <F7> to edit line items. Page Down to the line item that is in error. While in the "Our ID" field press <F3> and enter the correct conversion quantities and prices for the item. Print out the requisition or purchase order, check the quantities and prices. If the values are incorrect repeat the process.
In products other than Stockroom Inventory Manager , Purchase Order or Supply Manager:
There is most likely a problem with data entry. Please follow these steps:
1) Restart the program. Enter the part of the program that fails. Just prior to the step or operation that causes the program to fail, press <Shift><Print Scrn>. Your screen will then go to the printer.
2) Cursor to the spot or perform the operation that causes the program to fail and after the program fails, press <Shift><Print Scrn> with the error message on the screen.
3) Fax this output to CMS. (801) 363-3653
Go to CMS Support Page Go to the CMS Home Page Return to CONTENTS Page