Blogroll

Get a website with Godaddy


Logo designer Fiverr Frelancer

Thursday, August 21, 2014

inclusive row security in Item Availability based on Company?

Inclusive row security on CO, KCO, KCOO where the company is 00101 is allowed for this specific user in P00950 security workbench.

*ALL CO 00101 00101  Y Y Y Y
*ALL KCO 00101 00101 Y Y Y Y
*ALL KCOO 00101 0101 Y Y Y Y

Found an error saying  "Cannot Convert UOM back to Primary" on ItemA in Item Availability screen P41202 

Resolution : 
Replicate the steps in hitting this error and then capture debug log for this specific user.

From the debug log..
1. Find the word as JDEERR 
ERROR INFO JDEERR - ID= 0, Error= 3349 - b4101220.c, Line= 564  

2. Trace upward and look for sql select statement where it hits the error 

_P41202 SELECT IOLOTN, IOMCU, IOITM, IOLOTP, IOLOTG, IOMMEJ, IODLEJ FROM CRPDTA.F4108 WHERE ( IOITM = 79.000000 AND IOMCU = ' 101LFG' AND IOLOTN = 'C100204140065' ) AND ( IOKCOO = '00101' ) 

3. Open up F4108 (lot master) and look for IOKCOO if it has value 00101 ?  If no, pls add another new row security as 

* ALL KCOO *BLANKS *BLANKS Y Y Y Y 

4.  Re-login to JDE and test again for the item availability search..

Hope that helps....






No comments:

Post a Comment

Amazon store

alidropship plugin

alidropship plugin
alidropship plugin

Total Pageviews

About