RE: MRP100 Upload?

Beth,

I Have done something very similar to what you are asking about.
We use Demand Solutions for our forecasting solution instead of BPCS.

Basically, you want to by-pass the BPCS forecasting system.

1st I remove the old future demand in BPCS by deleting the records in KMR
with an MTYPE = 'F' and in the future so many months looking at the JPD.
2nd I remove all records that are in the past looking at the JPD.
4th I load most of the forecast in weekly records.
5th Some items are in monthly records.

If you would like to see examples, I can send you some.
It is important that your comparisons are done based on the Forecast Period
Master file.
I would think that you would not want to remove frozen periods from your
forecast (demand).

On the upload part, I would upload into a work file. I would use CSV instead
of Excel format.

Sincerely,

Chris Ertz
Software Development Manager
American Metal Products
BPCS 6.0.02 MM Jan Cum 1998 w/ many PTF's
(662)890-8182


Chris Ertz

-----Original Message-----
From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On Behalf
Of Beth Norris
Sent: Monday, July 16, 2001 12:05 PM
To: BPCS-L Mailing list (E-mail)
Subject: MRP100 Upload?

I am interested in uploading the forecast into MRP100 from another format
such as MS Excel.
If anyone has tried something like this and has some advice, I would
appreciate it.

One of my concerns is the possible loss of the DRP orders in the KMR file if
we replace the whole KMR file.  Will they 'Regen' after the next MRP run?

I appreciate your response.

Beth A. Norris
Fawn Engineering
Des Moines, IA
bnorris@wittern.com

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---