eVision Systems

[eVisionSystems]

Update the CuryID field in APDOC with the correct Currency ID.

CORRECTION STEPS:

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

2. Open Query Analyzer, log onto the server, and choose the Application database.

3. Run the following SQL statement to determine how the CuryID field in the Void Check record is populated in APDOC:

SELECT CuryID, RefNbr, * from APDOC where RefNbr =
'XXXXXX' and DocType = 'VC'

(where 'XXXXXX' is the Refence Number for the Void
Check)

4. Note the CuryID value.

5. Update CuryID with the foreign Currency ID:

UPDATE APDOC SET CuryID = 'xxx' where CuryID =
'YYY' and RefNbr = 'XXXXXX' and DocType = 'VC'

(where 'xxx' is the correct foreign Currency ID and 'YYY' is the
value noted in Step 4)



•Microsoft Business Solutions–Solomon Accounts Payable, when used with:
  Microsoft Great Plains Solomon IV 4.50

The possible solution needs to be further identified by one of our certified solutions consultants, as the problem may extend further than the initial error shown. Please call eVision Systems @ (713)807-9555, or e-mail: Sales@evisionsys.com