Re: Pegging planned items back up to discrete customer orders.

Marc:

The function you are asking for is integral to Systems Plus' OTTO software and 
just one of its many capabilities.

Using its bi-directional pegging support, OTTO pegs purchased items or any 
intermediate level, fabricated item to customer orders.  The infomation is 
available via a variety of inquiries and reports.

For example, here is an inquiry for part 081E14410

                       Item Inquiry - Customer Orders                19:54:27  
                                                                               
Item: 081E14410                     On Hand:          .10  Date Limit: 12/31/99
Desc: SHT GALV 14GA 48X120                                                     
  <-------------------- Demand -------------------> <-------- Supply ------->  
                                        Reqd   Reqd   Total                     
   DD    Rel   
   Order #  Ln#      Item#      Date   Qty     Qty    Order #  Tp  Qty   Date  
  0072440     1 063331102        8/06      1       1 040806001 NO         8/04 
  658976      3 070713204        8/17      2       3 040817001 NO         8/13 
  657018      4 096183406        8/19      2       5 040819001 NO         8/12 
  659383      1 070713606        8/20      1       6 040820001 NO      1  8/18 
  657718      1 096183202        8/25      5      11 040825001 NO      2  8/23 
  657718      3 096183204        8/25      1      12 040825001 NO      1  8/23 
  657112     15 070713202        8/27      1      13 040827001 NO         8/25 
  659281      1 063330406        9/03      1      14 040903001 NO      1  9/01 
  648046      1 096183406        9/10      4      18 040910001 NO      6  9/03 

The part is a sheet of galvanized steel found 4 levels down in the BOM.  There 
is 1/10th of a pound on hand and it is required on 9 different customer order 
(Order #) line items (Ln#).  The total poundage required is 18 pounds (Total 
Qty).

And for the record the majority of sites using OTTO are BPCS sites.

For more information visit www.ottorpm.com or contact me off line.

Roy Luce
Systems Plus.
-----Original Message-----
From: Marc Graff <mgraff@xxxxxxxxxxxxx>
Sent: Aug 3, 2004 4:15 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: Pegging planned items back up to discrete customer orders.

I would like to know if anyone has solved the issue of planned item
pegging back to the customer order.  I know the data exists in BPCS, I
just haven't found anyone who knows how to extract it.  I had a
consultant in who said if we could flatten the bill of materials for a
planned item we should be able to drill from the child item up through
the bom to the end item, and to the customer order number.
Unfortunately he was not able to do this.  (We use Production version
405 CD.)

 

This is an example of what I am hoping to solve:

 

Currently, in our version of BPCS, all planned items (items that have a
demand in the system and have a planned order but have no open shop
orders yet), are consolidated based on the requested ship date.  

 

For example:



Customer:

Item 

Qty

Due

 

 


1

A

60

15-Apr

 

 


2

A

90

15-Apr

 

 


3

A

120

15-Apr

 

 


4

A

30

15-Apr

 

 


 

 

 

 

 

 


 

 

 

 

 

 


One 'planned' order for Item A for 300 pieces is created in BPCS.

 

 

 

 

 

 

Is there are way to not have BPCS do this automatic consolidation?  In
MRP systems I have used, automatic consolidation was a server flag that
was set to Yes or No, with a consolidation interval and horizon.  I
would think that BPCS would at least have the option to turn automatic
consolidation on or off.

 

Any help would be appreciated..

 

Regards,

 

Marc Graff

Production Control Manager

States Industries, Inc.

(541) 688-7871 ext. 283

 

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.