1

Sales Order Entry Import & Allocation Workflows (Automation Process) – Epicor ERP Custom Software Solution

  • 7 August 2013
  • cre8
  • 1 comment

Tags: , , , , , , , ,

A common requirement by Customers is to be able to automate SO (Sales Order) processes; for this reason, Standard Epicor Software includes an Epicor Service Connect WF (Workflow) that gives the user the ability to import Sales Orders from an XML file into E9. For this custom software solution certain steps were taken to best optimize the SO automation process. This solution is divided into three sub-processes:

  • SO Import process: Epicor’s standard Service Connect Workflow will be modified and adapted to best suit the customer’s needs.
  • SO Allocation: A new Epicoe Service Connect Workflow was created to handle the allocation process. This SO Allocation WF is executed from two different places:
    • SO Import process
    • A Daily BAQ export process which is executed based on a schedule defined by the user.
    • Company screen customization: The allocation rule defined by the user is maintained in the Company Maintenance application, the number of days that are to be validated is saved in a UD (User Defined) field

For the first step, the tasks required by the customer to be executed by the Workflow are as follow:

  1. Create Order Header / Lines
  2. Set Order as “Ready to Process”
  3. Check for Credit Limits and send an e-mail notification, set Task for Approval
  4. Send an acknowledgement e-mail to the dealer
  5. Allocate/Reserve Inventory

If an order is not immediately allocated at the moment of being imported, or if an existing order needs to be allocated, the SO Allocation Workflow can be executed:

XML file to import through SC.

Sales_Allocation_001

Sales Order created has Order Totals.

Sales_Allocation_002

Line 1 – Quantity and Price List assigned is correct.

Sales_Allocation_003

Line 2 – Quantity and Price List assigned is correct.

Sales_Allocation_004

Line 3 – Quantity and Price List assigned is correct.

Sales_Allocation_005

Line 4 – Quantity and Price List assigned is correct.

Sales_Allocation_006

Line 5 – Customer Part is populated, Quantity is correct.

No price list is assigned, which is correct.

Sales_Allocation_007

Sales_Allocation_008

Sales Order is allocated correctly.

Sales_Allocation_009

Sales_Allocation_010

The Company Configuration Screen has also been modified to include a UD field (Allocation days) which limits the amount of days to review in order to decide whether or not the order should be allocated and compare such order to the current ship date:
Sales_Allocation_011

One response to “Sales Order Entry Import & Allocation Workflows (Automation Process) – Epicor ERP Custom Software Solution”

  1. Joey Chen says:

    Hello,

    I am new to Epicor and Service connect. I have a very similar task to import sales order from XML into E9. But I could not find any Epicor’s standard Service Connect Workflow. Could you please share your workflow?

    Thank you in advance!

    Regards,

    Joey

Leave a Reply

Your email address will not be published.