Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you try to print a historical Sales Order Processing invoice in Microsoft Dynamics GP: "You must be viewing by Functional or Originating currency to print a document

Error message when you try to print a historical Sales Order Processing invoice in Microsoft Dynamics GP: "You must be viewing by Functional or Originating currency to print a document

IMPORTANT

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

↑ Back to the top

SYMPTOMS

When you try to print a historical Sales Order Processing invoice in Microsoft Dynamics GP or in Microsoft Business Solutions – Great Plains, you receive the following error message:

You must be viewing by Functional or Originating currency to print a document.

This problem occurs if you do not have Multicurrency registered.

↑ Back to the top

CAUSE

This problem occurs because the VIEWTYPE values that are set for the Sales Document Inquiry window or the RM Transaction Inquiry window are incorrect. This information is stored in the Multicurrency User Preference table (MC40500).

↑ Back to the top

RESOLUTION

To resolve this problem, update table MC40500. To do this, follow these steps:
1. Follow the appropriate step: • If you are using Microsoft SQL Server 7.0 or Microsoft SQL Server 2000, run the statement in SQL Query Analyzer. To open SQL Query Analyzer, click Start , point to Programs , point to Microsoft SQL Server , and then click Query Analyzer .
• If you are using Microsoft SQL Server Desktop Engine, run the statement in the Support Administrator Console. To open the Support Administrator Console, click Start , point to Programs , point to Microsoft Support Administrator Console , and then click Support Administrator Console .

Note The Support Administrator Console requires a separate installation. If you do not have the program installed, you can install it by using the Microsoft Dynamics GP installation CD.
• If you are using Microsoft SQL Server 2005, run the statement in SQL Server Management Studio. To open SQL Server Management Studio, click Start , point to Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio . To run a script, click New Query .


     
2. Make sure that all users exit Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains.
3. Run the following query against your company database, and then note the value in the DEX_ROW_ID column. 
SELECT DEX_ROW_ID, * FROM MC40500 WHERE TRXSOURC IN (SOP_Document_Inquiry, RM_Transaction_Inquiry)
4. Run the following UPDATE script. 
UPDATE MC40500 SET VIEWTYPE = 3 WHERE DEX_ROW_ID = <X>
Note Replace <X> with the value in the DEX_ROW_ID column that you noted in step 3.
5. Repeat this UPDATE script for all the records that you want to update.

↑ Back to the top

Keywords: kb, kbnosurvey, kbtshoot, kbprb, kbMBSMigrate, kbMBSPartner, BemisKB854925, kbExpertiseInter

↑ Back to the top

Article Info
Article ID : 854925
Revision : 1
Created on : 3/9/2017
Published on : 3/9/2017
Exists online : False
Views : 82