Best Way To Get Orders From Excel Into JDE (7.3 CUM 8)

[John Nickle]

Hi All

We are looking into the process of exporting orders that are coming in via spreadsheet into JDE. Possible suggestions include an EDI-formatting process to turn the order into an 850 document, someone has mentioned the UFC, though this remains unexplored. I am curious what others have done to overcome this issue. Im sure I have left important information out, let me know what you need. I'm the windows guy but will do my best to come up with it.

Thanks!

John

 

[Nichelle]

I would suggest saving the xls as a csv, upload to your iSeries, map to the Sales Order Z files (F4001Z and F4011Z), then let World take it from there.