F30026 Cost Load in Excel

[MGrejtak]

Does anyone know if there is an upload feature with World to load F30026
Cost Components from an Excel file?

Michael Grejtak, CPIM
JDEdwards Manufacturing Systems Analyst A7.3.11
Planning/Inventory/Shop Floor Control
VOICE (419)424-8253
FAX (419)424-8356
www.hancor.com

 

[miaconis55]

I have created a process for one of my clients that accomplishes this task
via MS Access. It takes the values from an Excel spreadsheet and transfers
them to an Access data base. From there an AS/400 file is loaded and a
program is run to update the elemental costs in JDE World. Dreamwriter
options are available to select the cost method loaded. If you would like
to discuss this further, feel free to e-mail me and I can check with the
client to verify that they are willing to share it.

Mike Iaconis
Soar Technology Solutions
[email protected]

World A7.3 cum 8

 

[MGrejtak]

So you're saying that the Dreamwriter is a customRPG program? Is it =
possible
to load the data into SQL Server instead?

 

[miaconis55]

You are correct. It is a custom RPG program. The whole process was
developed because the accountants develop there new costs using an excel
spreadsheet and asked for a way to transfer them to JD Edwards.