Sys Msg 118 'Overflow in floating point' in Cash Manager


TechKnowledge Content


Potential Causes


1. The error occurs when entering one transaction in Cash Account Transactions (20.010.00). Records exist in CATRAN and/or CASHSUMD with a blank CuryID value. See resolution 17989.


2. The error occurs when attempting to insert a new line in Bank Reconciliation (20.210.00). Records exist in the CATRAN, CASHSUMD, APDOC, and/or ARDOC tables with a blank CpnyID value. See resolution 25330.


3. The error occurswhen attempting to close Cash Manager Module in General Ledger Closing (01.560.00). See resolution 1.


Resolutions


Resolution 1 - Run the CAIntegrity Check (20.990.00).


1. Make a BACKUP of the database which can be restored in case an undesired data loss occurs.


2. Access CA Integrity Check (20.990.00).


3. Specify the Date Ranges in Start Date and Ending Date fieldsforthe Period that you are unable to close.


4.Click Begin Processing.


Resolution 17989 - Verify that the CuryID fields are populated in the CATRAN and CASHSUMD tables using Query Analyzer.


1. Make a BACKUP of the database which can be restored in case an undesired data loss occurs.


2. Open General Ledger Setup (01.950.00) - Currency Info and make note of the Currency ID.


3. Using Query Analyzer, access the appropriate System database and execute the following statement to verify that the BaseCuryID field is populated in the COMPANY table:


SELECT * from COMPANY where CpnyID = 'YYYY'

(where YYYY = the appropriate Company ID)


4. If the BaseCuryID is not populated, execute the following statement to make it match the Currency ID noted in Step 2:


UPDATE COMPANY SET BaseCuryID = 'XXX' where BaseCuryID = '' and CpnyID = 'YYYY'

(where XXX = the Currency ID value noted in Step 2, '' = 2 single quotes and YYYY = the appropriate Company ID)


5. Accessthe appropriate Application databaseand executethe following statements to verify that the CuryID fields are populated in the CATRAN and CASHSUMD tables:


SELECT * from CATRAN where CpnyID = 'YYYY' and Module = 'ZZ' and BatNbr = 'BBBBBB'

SELECT * from CASHSUMD where CpnyID = 'YYYY'

(where YYYY = the appropriate Company ID, ZZ = the module where the transaction originated andBBBBBB = the appropriate Batch Number)


6.If theCuryID fields are not populated, execute the following statements to update them:


UPDATE CATRAN SET CuryID = 'XXX' where CuryID = '' and CpnyID = 'YYYY'

UPDATE CASHSUMD SET CuryID = 'XXX' where CuryID = '' and CpnyID = 'YYYY'

(where XXX = the Currency ID value noted in Step 2, '' = 2 single quotes and YYYY = the appropriate Company ID)


Resolution 25330 - Populate the CpnyID field using Query Analyzer.


1. Make a BACKUP of the database which can be restored in case an undesired data loss occurs.


2. Using Query Analyzer, access the appropriate Application database and executethe following statement to look for records that are missing a CpnyID value:


SELECT * from CATRAN where CpnyID = ''

(where '' = 2 single quotes and CATRAN = the appropriate table name)


3.If results display,execute the following statement to update the CpnyID to the correct value:


UPDATE CATRAN SET CpnyID = 'YYYY' where CpnyID = ''

(where YYYY = the correct Company ID and '' = 2 single quotes)


Note -CATRAN is provided as an example. Other table names can be used as appropriate. Also, additional criteria may need to be specified in the where clause of the UPDATE statement to ensure that records are updated correctly.




This article was TechKnowledge Document ID:126895