#MSDynGP Purchase Order Entry windows show costs as zero

David Meego - Click for blog homepageOver the last few weeks I have been asked about the same issue a few times by different customers and partners who were unable to work out what was happening.

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.

Or……

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.

David

This article was originally posted on http://www.winthropdc.com/blog.

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.