• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Modification takes too much time in P3111

USEJ

Member
Hi List,

It is time consuming to make some modifications on a line item in P3111. Some
of our part list have around 250 items in it. When I am in Enter/Change Order
(P48013) I select a work order and I press on Part List in the row exit, I can
see all the part list. The problem here is that I want to modify the Requested
quantity for the line item that includes the item number "102236" but there is
no QBE in P3111 so I have to look at each line to find the line with item number
"102236". This process is take too much time. Does anybody have the same
problem and how do you fix it?

Thanks!

We are on B7332.

Sebastien Ouellet
Manufacturing System Project Manager
 

vbojan

Well Known Member
Hi Sebastien,

Open P3111 for design, select W3111A (Work Order Part List) form, double-click on grid and uncheck "Hide Query by Example".

Hope this helps.

Regards,
Bojan.

Bojan Vukicevic,
Sr. programmer analyst
Serrot International Inc.
 

Michelle D.

Active Member
Bojan,

Is this really the best thing to do? Isn't there a reason why the QBE was
hidden? Would making this change have any impact on doing inventory issues
(P31113)?

Michelle Dulay
ERP Coordinator
BFGoodrich Aerospace
Chandler Evans Control Systems
email: mdulay@chandlerevans.bfg.com

OneWorld B7322 with the MFG Mini-Cum, coexistent with World A7.3
AS400 V4R3 Enterprise Server
Windows NT SQL V6.5 Deployment Server
SynQuest V5.07.02
Oracle
NT Logic - between AS400 (OneWorld) and HP9000 (SynQuest)




OneWorld B7322, MFG Mini-Cum, coexistent World A7.3
AS400 V4R3 ES
WinNT SQL6.5 DS
 

vbojan

Well Known Member
Re: RE: Modification takes too much time in P3111

According to documentation (“JDEdwards OneWorld Developers Guide” pg. 241) disable QBE can speed up performance. That is default for Headerless Detail form. Theoretically it is possible that some code in some application is affecting all records selected by header filter, not only subset made by QBE, but I never had problem with enabling QBE. Shouldn’t be problem for W3111A but I can’t try it on my system. If you try please let me know result, I am curious also.

Regards,
Bojan.
 

Michelle D.

Active Member
Bojan,

Is this really the best thing to do? Isn't there a reason why the QBE was
hidden? Would making this change have any impact on doing inventory issues
(P31113)?

Michelle Dulay
ERP Coordinator
BFGoodrich Aerospace
Chandler Evans Control Systems
email: mdulay@chandlerevans.bfg.com

OneWorld B7322 with the MFG Mini-Cum, coexistent with World A7.3
AS400 V4R3 Enterprise Server
Windows NT SQL V6.5 Deployment Server
SynQuest V5.07.02
Oracle
NT Logic - between AS400 (OneWorld) and HP9000 (SynQuest)




OneWorld B7322, MFG Mini-Cum, coexistent World A7.3
AS400 V4R3 ES
WinNT SQL6.5 DS
 
Top