R47011 Performance Problem

I am having a problem getting the R47011 to run in an acceptable amount of time. We have an external system that our field sales force transmit orders to. I am taking that data and adding the orders to the F47011 and F47012 files. The sample day that I am using has 368 orders and 22,753 total lines. It took 5 1/4 hours to run the R47011 program.

Does anyone have any tips to help me improve performance.

Thanks.

We run 3 threads in our order processing queue. We process 182 orders =
and
1000 lines in about 28 minutes. We run advance pricing - R47011 spawns =
one
R42750 UBE for every order. So we normally have R47011 running with =
about 2
R42750s at the same time.

Gary Mogilner
Xe Update3, SP 18.1, AS/400 720 2-way with 2 gig of memory dedicated to
order processing

Hope this helps

Hi,
I've the same problem with our customer. Report R47011 uses Sales Order Master Business Function with work file. You have to personalize report changing the parameter passed to MBF to use cache.
Furthermore we have disabled all updates on WorkCenter. We have halved processing time of R47011.
Next step is to create more queue and submit parallel version of R47011.
Good luck Gigi

I have changed the parm to use cache instead of the workfile. I will see how much of a difference that makes. Thanks for the tip.

Re: RE: R47011 Performance Problem

I'm sure most of the problem comes from the number of lines I am dealing with. We have basket pricing turned off so R42750 isn't a problem. I'm going to try changing the MBF to use cache instead of the work file. Thanks for the help.