Our largest customer supplies us with sales orders via a spreadsheet, this sheet contains 100+ columns that have to be pre-processed to define the exact requirements.
We have code (via a customisation) that processes this file and creates a DMT for processing via SalesOrderCombined. As part of the migration upgrade I would like to re-write the code to directly create sales orders within the Epicor environment from a Function.
It would be helpful if anyone had code to share that achieves simply creating a sales order for a specified customer.
The Epicor EDI module is the vehicle that one of my other customers use to deal with 100s/1000s of lines being automatically generated via a import from supplied file. Although when many thousands they can get a little clunky to work with.
Are you trying to avoid additional licensing or just use standard tools to achieve the same result?
Thanks for the response. The frequency of an inbound order file is once per two weeks, and the total volume of orders is around 200. We are looking to avoid additional licensing, plus we have to cast eyes over the orders as the customer does not stick to pre-defined conventions. It is not possible to resolve this issue.
We do this a lot. We generate all the orders off of quotes. It’s makes it easier for us with configured parts. You don’t have to pass nearly as much data to get the order.