I’m new at this so please forgive my ignorance. Using Monarch Pro v. 5.02, I’m trying to get a simple list of available inventory. I’ve found a way to get a list of stock availability whether positive or negative, but I can’t get Monarch to filter out the negative stock AFTER the summary has summed. I guess that would be the easy question/answer:
Is there a way to filter the summary table after it has summed up the fields?
Perhaps the harder question/answer would be:
Is there another way I can pull the needed information from the report, so that I can get the final information I need?
Here is the report. crossing my fingers hoping the spacing comes out right Let me know if it doesn't and I'll send a copy directly.
DESCRIPTION/ SCHEDULE DEMAND CUMULATIVE ATP REQ. ORD ORDER NUMBER
PART NUMBER ON HAND QTY QUANTITY QUANTITY AVAILABILTY DATE DATE STA ORDER-SUF-LINE CUSTOMER NAME
N501375 3 541 10JUL03 H4 135306-002-003 GE SUPPLY LOGISTICS
N506095 F52N7582 0820
N506110 F12N7699 0820
3,000 2,223- 01SEP03 H1Y 132657-002-002 I.L.S. - COLUMBIA
6,204 3,981 S 05MAY03 ORDER: 119545 LOT:
N506120 59N7856 0820
23,000 10,549 06AUG03 OA 133896-001-001 EMD/GMC WHSE 529
N506150 F51ND7528 0820
100 8,369 S 05MAY03 ORDER: 119545 LOT
N501735 80HS080 0428
10,259 -10,259 S 23JUN03 ORDER: 119432 LOT:
10,559 300 01SEP03 H1Y 132657-002-002 I.L.S. - COLUMBIA[/font][/quote]After the same header info on every page, it lists a part number for each part we have stock on and orders and production in process if any. The number immediately below the part number (first indention) is the amount of that part currently in stock. The lines with “ORDER” in them are projected production runs of the part (projected quantities at the second indention.) The other lines are customer orders (order quantities at the third indention.) The middle column is a running tally of available parts.
I need a list of
A. all our part numbers that have stock available after orders due within 12 weeks have been subtracted from current available stock, not taking into consideration any production runs (We don’t know for sure when or how many will be completed) and
B. that new amount of actual available stock.
I’ve tried multiple line fields but between the production run lines and header getting in the way I can’t get it to work. This is the closest I’ve been able to come:
I filter out the ones more than 84 days (12 weeks) away, keeping the “Nulls.”
This column doesn’t make sense until the summary table.
Monarch nicely lists each part number once with the total positive or negative available stock. Now I want to filter out the negative fields. But when I apply a filter to the summary it takes out the negatives and THEN sums. I want it to sum and THEN take out the negatives.
So is there a way to do that? Or is there a better/different way to take the information out of the report that will leave me in a better position to get the final answer I’m looking for?
Thanks for any help!
[size="1"][ July 16, 2003, 10:52 AM: Message edited by: GreerStopNut ][/size]