|1. ||Click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer . |
|2. ||In the database list, select the company database where you receive the error message. |
|3. ||Type the following statements in the Query window. |
select CURNCYID, CURRNIDX,* from PA30500
select CURRNIDX,* from PA30501
|4. ||Click Execute . |
|5. ||If the fields are blank for the transactions that you are trying to post, type the following statements to update the fields with the correct, functional Currency ID and Currency Index values. |
update PA30500 set CURNCYID = 'Z-US$'
update PA30500 set CURRNIDX = '1007'
update PA30501 set CURRNIDX = '1007' Note Replace the Z-US$ placeholder with the value in the FUNLCURR field in the MC40000 table. Replace the 1007 placeholder with the value in the FUNCRIDX field in the MC40000 table. To find these values, run the following statement against the company database.
select * from MC40000
|6. ||Click Execute . |