logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
phaag  
#1 Posted : Wednesday, June 13, 2018 12:02:28 PM(UTC)
phaag

Rank: Administration

Groups: Administrators, Registered
Joined: 1/2/2018(UTC)
Posts: 9
United States

Recently, a customer complained that they were seeing $0 in the Original Amount column of the Payables Transaction Inquiry - Vendor screen. After looking into it a bit, I determined that the issue was that the View Type (VIEWTYPE) in the multicurrency user preferences tables (MC40500) had been set to "Apply" (4) instead of "Reporting" (3). This, despite the fact that they don't have multicurrency even registered.

Ultimately, the fix was to run the following SQL statement against the company database:

Code:
update MC40500 set VIEWTYPE=3 where USERID='myuser' and TRXSOURC='PM_Transaction_Inquiry'
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.