So, I thought I would write an article that explains the problem and the solution and hopefully, it will show up when someone does a search when they have this issue.
The problem is that a specific user reports that the Purchase Order Entry or Purchase Order Inquiry Zoom window is not showing Unit Cost and Extended Cost values, instead it just shows zeros.
Because this issue seems to only affect specific users, it is common to think that this problem is security related, but that is not the case.
The actual cause is the currency view.
The currency view which can be changed using the View Button on the window’s toolbar is stored on a per user basis and so will be remembered between sessions.
If the Reporting Currency view has been selected, but the Reporting Rate rate has not been configured, the value will show as zero.
Changing the Currency view back to Originating or Functional view fixes the issue, but the change must be made while logged on as that user.
You could use the following SQL query view and/or update the View Type setting stored in the MC_User_Preferences (MC40500) table.
select * from MC40500 where USERID = 'XXX' --update MC40500 set VIEWTYPE = 2 where VIEWTYPE <> 2 and USERID = 'XXX'
where the View Type can have the following values:
- CURRENCYVIEW_FUNCTIONAL = 1
- CURRENCYVIEW_ORIGINATING = 2
- CURRENCYVIEW_REPORTING = 3
Note: This issue could occur on any window that has the Currency View functionality and not just Purchase Order Processing windows.
Hope this is useful.
This article was originally posted on http://www.winthropdc.com/blog.