On Knowledge Quest, it implies that there is a standard way of importing MPS sales forecast from an excel spreadsheet via OLE.

Has anyone experience of doing this, or can someone point me in the right direction to find further info.

Not used it.
The files in question are available in the 'samples' directory of the Baan client installation. The readme file provides some information on the usage of the excel files.

Hopes this helps

DLM

We regularly use the Excel sheet to upload MPS forecast. We actually have the demand load into Sales budget and then copy the budget using Baan session to the demand forecast field. Works quite smoothly.

Thanks to both of you, I have now found the details and it looks to be exactly the solution I was looking for.
However, although I can populate the spreadsheet I cannot get it to connect to Baan. Could you explain what I need to do to connect to the correct company and correct Baan system

Start with the baan.xls spreadsheet as it is much simpler functionality.

Things I have figured out:
-you can't be logged into BAAN on the machine that you run the excel spreadsheet on.
-it will only run the default (the one with the checkmark) baan configuration file.
-if you want it to ask for a password still, that is ok.

This should get you at least to the point of working spreadsheets. However, I have never used the more complexe loading functionality so can't help you there.

Cheers,

-Dennis

hi,
have you ever used exchange schemes in baan?
if so then convert your excel spreadsheet into a .csv(comma separated file)
load through ftp into your unix login path(ur user directory)
and sepcify the path in the exchange scheme .
The MPS data can be loaded into BaaN,using this utility.
we use the exchange schemes regularly for loading MPS/MRP inputs.

This exchange scheme is under Utilities folder of Tools module.

NOTE: The field inputs given in the excel sheet should be exactly as you are defining the fields in the exchange scheme.
Hope this helps.

Any other details regarding exchange scheme do contact.

Rgds,
RL.

We do use an exchange. The Master Schedulers create a .txt file file using Excel with the data formatted with Pipes between filed Scenario|Level|Plan item|period|forecast to be loaded. We FTP that to unix, and has a session written that we run that picks the file up and uploads it to the demand forecast line. The master schedulers love it, we have a 104 weekly periods and they hated loading a change.