Std Cost Simulation - Obsolete & Use-Up MANUFACTURED Items

[Frosty the Coder]

The site has been using STOCKING TYPE (STKT)
to obsolete/use-up both purchased & manufactured items.

W/in the Cost Roll Up Stream (J30820, 825...),
STKT is checked against UDC 41/I,
where it picks up either a "P" or an "M" for costing.

Both OBS and USE-UP are set to a "P".
This causes the OBS MFGd items to not cost properly.

Changing the UDC for these to "M" gets them working,
but messes up the OBS Purchased Items.

Changing the OBS MFGd items back to an "S" SEEMS TO WORK,
but people want these items to be "Obsolete".

Any suggestions other than changing the code that handles this?

Please AND Thanks
Gene

 

[Jeff_MontAssoc]

Take the last good standard cost and input that into Cost Method 08 (or whatever method you roll into 07 for purchased items). Then roll those items.

 

[Frosty the Coder]

Thanks, that would correct the costs shown for obsoletes, making them "ignorable".
Clearly NOT the path they'd want to take.

They asked that I "simply exclude the obsoletes" from the rpt.

I TRIED doing this w/P30820 data selection.

I'm finding that everything but QRYSLT(*ALL) gets odd results.

As a matter of fact, when I change it to an
"IF GLPT *LE IN30 OR GLPT *GT IN30" I end up w/more pages of output.

I guessing that J30820 is reusing the data selection and not doing it well.

BOTTOM LINE - Does anything but *ALL work for P30820 data selection?

Please AND Thanks
Gene

PS - when I try to compile & debug this, I start getting "parameters not passed....."
Grrr

 

[curryj]

I don't know this part of the software very well, but I'm currently looking at several versions of P30820 that our cost accountant uses regularly, and they've all got data selection based on some combination of Stocking Type, G/L Category, Item Number Short and Business Unit.

He thinks they work fine.

 

[curryj]

I had another thought. I wondered if you were aware that if you include an OR in your data selection, you have to repeat all selection criteria above the OR, including them below the OR, only changing the one you actually want to be different.

If you had something like

Business Unit EQ ' 10' AND

GL Category LE 'IN30' OR

GL Category GT 'IN30'

you'd definitely get more output because you'd get everything in all business units with the GL Category greater than IN30.

You probably knew that, but it does throw some people.

 

[Frosty the Coder]

Jon, my "OR" matches my "IF" w/the exclusion of GLPT.

Thanks for the thought though.
I wouldn't have been the first silly mistake I've ever made.

Gene

 

[Frosty the Coder]

Jon/Jeff - the "odd" results ended up being what the data should be showing.

Data Selection worked FINE.

Thanks for your assistance.

Gene