Sequence for EDI ASN – Epicor ERP Custom Software Solution

  • 20 June 2013
  • cre8
  • 8 comment

Tags: , , , , ,

There are certain scenarios in which certain customers use EDI (Electronic Data Interchange) for ASN (Advanced Shipping Notifications). One of several requirements of this type of interchange is Sequence ID, at both the header and detail level of each shipment (Epicor Software Pack). While these numbers are unrelated to each other, they have the same characteristics:

  • Positive integer
  • Increments by 1 on use

Because the sequence ID is set per Sold to Customer (CustID in Epicor Software), the fields that manage this will be placed on the Customer Maintenance form, and will be governed by standard Epicor Software security.

In order to support these changes to Epicor Software and give the user the ability to keep track of Shipment Sequences, a custom software solution was created:

Two new UD (User Defined fields) were added to the Customer Maintenance form:

  • Shipment Sequence
  • Shipment Detail Sequence

Both fields allow positive integers only and Standard Epicor Software security (as mentioned above) will determine which users have access to updating the fields so by default, they will not be disabled for entry. A value if “0” is used to show a “not used” value, this will not trigger assignment in Shipments. (In order to trigger use in Shipment, the value must be > 0):

Launch Customer Maintenance screen. Form is displayed. Shipment Sequence and Shipment Detail Sequence fields are displayed on the form:


Entering a value and saving it stores the data. When clearing the form and loading the same customer, the information is shown:


On creation of a new Customer Shipment Pack header (New > Pack), the EDI Shipment Sequence field for the referenced Customer Sold to is queried. If the value is > 0, it is incremented by 1, the result is used to populate a UD (User Defined) field in the Pack Header (ShipHead). The field is labeled “EDI Seq”, and is visible but disabled for entry.

                On New > Line, the Shipment Detail Sequence for the Sold to Customer is queried. If the value is > 0, it is incremented by 1, and the result used to populate a UD (User Defined) field at Shipment Detail level (ShipDtl). The field is labeled EDI Detail Sequence and is visible, but disabled for entry:

Form opened. EDI Seq. field is displayed:





8 responses to “Sequence for EDI ASN – Epicor ERP Custom Software Solution”

  1. I know this if off topic but I’m looking into starting my own blog and was wondering what all is needed to get set up? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet smart so I’m not 100% sure. Any tips or advice would be greatly appreciated. Appreciate it

  2. Woah! I’m really digging the template/theme of this blog. It’s simple, yet effective. A lot of times it’s hard to get that “perfect balance” between superb usability and visual appearance. I must say you’ve done a fantastic job with this. Additionally, the blog loads extremely fast for me on Internet explorer. Outstanding Blog!

  3. Wonderful blog! I found it while surfing around on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Cheers

  4. Im not that much of a online reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your site to come back down the road. All the best

  5. Please let me know if you’re looking for a writer for your blog. You have some really good articles and I feel I would be a good asset. If you ever want to take some of the load off, I’d really like to write some material for your blog in exchange for a link back to mine. Please send me an e-mail if interested. Kudos!

  6. Hello! I just wanted to ask if you ever have any issues with hackers? My last blog (wordpress) was hacked and I ended up losing several weeks of hard work due to no data backup. Do you have any methods to stop hackers?

  7. Appreciating the persistence you put into your site and detailed information you present. It’s great to come across a blog every once in a while that isn’t the same unwanted rehashed information. Excellent read! I’ve saved your site and I’m including your RSS feeds to my Google account.

  8. I just added this website to my rss reader, excellent stuff. Can’t get enough!

Leave a Reply

Your email address will not be published.