940 file line sequencing

  • 1
  • Problem
  • Updated 4 years ago
  • Solved
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Old

We are getting errors coming back from our 3PL that our 940’s have incorrect line sequencing.

I have checked our test files and indeed on some orders like the one I am pasting below the sequence for the 3 lines is 2,2,3 (missing 1).

I checked the file in Dynamics GP and the sequencing is correct, therefore I believe this is a Process Logic issue. SPS has confirmed the PO had the correct items and sequence. Customer PO # is 4JFTSVVK.

Note sequence in the 3 lines below. (I have blanked out pricing.)

NRI-USA,RO-10418,LI,2,,10053-00152-OS,828432018222,,,,,,,,,,,,ANCHOR PAD 600D POLY REAL TREE,,12.00,EA,,,,,,,,,,,,,,,xxxx,
NRI-USA,RO-10418,LI,2,,10057-00052-OS,828432008599,,,,,,,,,,,,POPQUIZ PAD 600D POLY BEESWAX,,1.00,EA,,,,,,,,,,,,,,,xxxx,
NRI-USA,RO-10418,LI,3,,10055-00043-OS,828432010622,,,,,,,,,,,,HRTGE PAD 600D POLY OLIVE DRAB,,1.00,EA,,,,,,,,,,,,,,,xxxx,
Photo of Tanya Hill

Tanya Hill

  • 70 Points

Posted 4 years ago

  • 1
Photo of FAQ

FAQ, SPS FAQ

  • 9,340 Points 5k badge 2x thumb

After looking at the incoming 850 (purchase order data) and the outgoing 940 (warehouse send) information the line items did not seem to add up correctly.  The 850 had 4 line items on it and the 940 only had 3 lines on it.  It would seem that the SOP transaction was edited after importing and lines were deleted and possibly added to the order.  When an 850 line item is deleted the EDI information associated with that line item is also deleted.  The means the data the trading partner sent in is lost.  In this case the trading partner had sent in Line Item Sequence Numbers (which is optional from the trading partner) so when the line items were edited that information was lost. 

The key to keeping the EDI information in tact for all documents is to not edit the orders after they are imported with the exception of address information and quantities. 

This conversation is no longer open for comments or replies.