Question

Different Part Nos on Inc Customer Schedule (DELSCH)

N
Rank
Userlevel 2
Badge +6

I want to know if it is possible to have one incoming customer schedule (DELSCH) through EDI that has multiple part numbers that get parsed out into their own incoming customer schedules. I see the XML Schema allows for multiple Article Lines with a Part No field and the Demand Lines also have a Part No field.

 

When I tried to do this however, I get multiple customer schedules for each article line with the demand lines duplicated across all of the schedules.

This topic has been closed for comments

12 replies

GPIE
Rank
Userlevel 5
Badge +11

Hi @NSRJMITCHELL 

I agree with you that this should be possible. Have you tried creating your incoming schedule as a dummy outgoing schedule first in order to check the structure? I can’t find any examples in our sample files of multiple article lines, however.

Can you share a sample file?

N
Rank
Userlevel 2
Badge +6

I’ve attached the file I’m using for testing.

1 Attachment
GPIE
Rank
Userlevel 5
Badge +11

Thanks, nothing obvious wrong with that.

Have you checked IFS Connect > Application Messages? From memory, the DELSCH file gets converted to a RESPONSE file before being processed. We had issues with DELSCH and so also tried bringing in raw RESPONSE files instead and that worked for us (from a testing perspective as we still haven’t turned on that process yet). It might help to identify if the it’s the conversion to RESPONSE that is the issue or the processing of it.

N
Rank
Userlevel 2
Badge +6

I can’t seem to find the response you’re speaking of. 

GPIE
Rank
Userlevel 5
Badge +11

I don’t have any testing data available as the servers have been reset but try going to Application Messages and open an inbound message, then right-click on the message line and then View Message Response.

You should see a file called MESSAGE_RESPONSE.xml that looks something like this...

<?xml version='1.0' encoding='UTF-8'?>
<IN_MESSAGE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:ifsworld-com:schemas:inbound_distribution_transactions_receive_customer_schedule_response">
 <MESSAGE_ID xsi:nil="1"/>
 <RECEIVER xsi:nil="1"/>
 <SENDER xsi:nil="1"/>
 <SENDER_MESSAGE_ID xsi:nil="1"/>
 <RECEIVED_TIME xsi:nil="1"/>
 <VERSION xsi:nil="1"/>
 <CONNECTIVITY_VERSION xsi:nil="1"/>
 <SENDER_ID xsi:nil="1"/>
 <CLASS_ID>DELSCH</CLASS_ID>
 <OBJSTATE xsi:nil="1"/>
 <OBJEVENTS xsi:nil="1"/>
 <STATE xsi:nil="1"/>
 <LINES>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>1.0</MESSAGE_LINE>
   <NAME>HEADER</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02 xsi:nil="1"/>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05 xsi:nil="1"/>
   <C07>Plan</C07>
   <C09 xsi:nil="1"/>
   <C10 xsi:nil="1"/>
   <C11 xsi:nil="1"/>
   <C12 xsi:nil="1"/>
   <C13 xsi:nil="1"/>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C26>L1</C26>
   <C27>98266999</C27>
   <C28>01012200</C28>
   <C30 xsi:nil="1"/>
   <D03>2020-06-01T00:00:00</D03>
   <D04 xsi:nil="1"/>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>2.0</MESSAGE_LINE>
   <NAME>ART</NAME>
   <C00>PARTNO</C00>
   <C01 xsi:nil="1"/>
   <C02 xsi:nil="1"/>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05 xsi:nil="1"/>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08 xsi:nil="1"/>
   <C09 xsi:nil="1"/>
   <C10 xsi:nil="1"/>
   <C11 xsi:nil="1"/>
   <C12 xsi:nil="1"/>
   <C13 xsi:nil="1"/>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16 xsi:nil="1"/>
   <C17 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N01 xsi:nil="1"/>
   <N02 xsi:nil="1"/>
   <D00 xsi:nil="1"/>
   <D01 xsi:nil="1"/>
   <D02 xsi:nil="1"/>
   <D03 xsi:nil="1"/>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>2.0</MESSAGE_LINE>
   <NAME>LIN</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02 xsi:nil="1"/>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05>1</C05>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08 xsi:nil="1"/>
   <C09 xsi:nil="1"/>
   <C10 xsi:nil="1"/>
   <C12 xsi:nil="1"/>
   <C13 xsi:nil="1"/>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16 xsi:nil="1"/>
   <C17 xsi:nil="1"/>
   <C18 xsi:nil="1"/>
   <C19 xsi:nil="1"/>
   <C20 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N02>50000.0</N02>
   <N03 xsi:nil="1"/>
   <N04 xsi:nil="1"/>
   <N05 xsi:nil="1"/>
   <D00>2020-06-01T13:21:44</D00>
   <D01 xsi:nil="1"/>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>3.0</MESSAGE_LINE>
   <NAME>PDN</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02 xsi:nil="1"/>
   <C03>4416</C03>
   <C04 xsi:nil="1"/>
   <N02>145.0</N02>
   <N03 xsi:nil="1"/>
   <D00>2020-04-11T00:00:00</D00>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
 </LINES>
</IN_MESSAGE>

 

N
Rank
Userlevel 2
Badge +6

I found it… It shows the lines being applied to both part nos

 

<?xml version='1.0' encoding='UTF-8'?>
<IN_MESSAGE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:ifsworld-com:schemas:inbound_distribution_transactions_receive_customer_schedule_response">
 <MESSAGE_ID xsi:nil="1"/>
 <RECEIVER>EDI</RECEIVER>
 <SENDER>4311</SENDER>
 <SENDER_MESSAGE_ID xsi:nil="1"/>
 <RECEIVED_TIME xsi:nil="1"/>
 <VERSION xsi:nil="1"/>
 <CONNECTIVITY_VERSION xsi:nil="1"/>
 <SENDER_ID xsi:nil="1"/>
 <CLASS_ID>DELSCH</CLASS_ID>
 <OBJSTATE xsi:nil="1"/>
 <OBJEVENTS xsi:nil="1"/>
 <STATE xsi:nil="1"/>
 <LINES>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>1.0</MESSAGE_LINE>
   <NAME>HEADER</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02 xsi:nil="1"/>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05 xsi:nil="1"/>
   <C07>Call-off</C07>
   <C09 xsi:nil="1"/>
   <C10 xsi:nil="1"/>
   <C11 xsi:nil="1"/>
   <C12 xsi:nil="1"/>
   <C13 xsi:nil="1"/>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C26>4311</C26>
   <C27>23186179:-</C27>
   <C28>100155</C28>
   <C30 xsi:nil="1"/>
   <D03>2021-01-18T00:00:00</D03>
   <D04>2021-01-18T00:00:00</D04>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>2.0</MESSAGE_LINE>
   <NAME>ART</NAME>
   <C00>23186179:-</C00>
   <C01 xsi:nil="1"/>
   <C02 xsi:nil="1"/>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05 xsi:nil="1"/>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08 xsi:nil="1"/>
   <C09 xsi:nil="1"/>
   <C10 xsi:nil="1"/>
   <C11 xsi:nil="1"/>
   <C12 xsi:nil="1"/>
   <C13 xsi:nil="1"/>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16 xsi:nil="1"/>
   <C17 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N01>0.0</N01>
   <N02 xsi:nil="1"/>
   <D00>2020-01-01T00:00:00</D00>
   <D01 xsi:nil="1"/>
   <D02 xsi:nil="1"/>
   <D03 xsi:nil="1"/>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>2.0</MESSAGE_LINE>
   <NAME>LIN</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02>23186179:-</C02>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05>ORD</C05>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08>EA</C08>
   <C09>579</C09>
   <C10 xsi:nil="1"/>
   <C12>579</C12>
   <C13>123456789</C13>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16>Delivery/Calendar Pattern: AS DIRECTED Time Pattern: AS DIRECTED</C16>
   <C17 xsi:nil="1"/>
   <C18 xsi:nil="1"/>
   <C19>True</C19>
   <C20 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N02>5.0</N02>
   <N03 xsi:nil="1"/>
   <N04 xsi:nil="1"/>
   <N05 xsi:nil="1"/>
   <D00>2021-01-18T00:00:00</D00>
   <D01>2021-01-18T00:00:00</D01>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>3.0</MESSAGE_LINE>
   <NAME>LIN</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02>23186183:-</C02>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05>ORD</C05>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08>EA</C08>
   <C09>579</C09>
   <C10 xsi:nil="1"/>
   <C12>579</C12>
   <C13>123456789</C13>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16>Delivery/Calendar Pattern: AS DIRECTED Time Pattern: AS DIRECTED</C16>
   <C17 xsi:nil="1"/>
   <C18 xsi:nil="1"/>
   <C19>True</C19>
   <C20 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N02>5.0</N02>
   <N03 xsi:nil="1"/>
   <N04 xsi:nil="1"/>
   <N05 xsi:nil="1"/>
   <D00>2021-01-18T00:00:00</D00>
   <D01>2021-01-18T00:00:00</D01>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>4.0</MESSAGE_LINE>
   <NAME>PDN</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02>23186179:-</C02>
   <C03>123456</C03>
   <C04 xsi:nil="1"/>
   <N02>1.0</N02>
   <N03 xsi:nil="1"/>
   <D00>2020-01-01T00:00:00</D00>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>3.0</MESSAGE_LINE>
   <NAME>ART</NAME>
   <C00>23186183:-</C00>
   <C01 xsi:nil="1"/>
   <C02 xsi:nil="1"/>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05 xsi:nil="1"/>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08 xsi:nil="1"/>
   <C09 xsi:nil="1"/>
   <C10 xsi:nil="1"/>
   <C11 xsi:nil="1"/>
   <C12 xsi:nil="1"/>
   <C13 xsi:nil="1"/>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16 xsi:nil="1"/>
   <C17 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N01>0.0</N01>
   <N02 xsi:nil="1"/>
   <D00>2020-01-01T00:00:00</D00>
   <D01 xsi:nil="1"/>
   <D02 xsi:nil="1"/>
   <D03 xsi:nil="1"/>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>2.0</MESSAGE_LINE>
   <NAME>LIN</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02>23186179:-</C02>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05>ORD</C05>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08>EA</C08>
   <C09>579</C09>
   <C10 xsi:nil="1"/>
   <C12>579</C12>
   <C13>123456789</C13>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16>Delivery/Calendar Pattern: AS DIRECTED Time Pattern: AS DIRECTED</C16>
   <C17 xsi:nil="1"/>
   <C18 xsi:nil="1"/>
   <C19>True</C19>
   <C20 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N02>5.0</N02>
   <N03 xsi:nil="1"/>
   <N04 xsi:nil="1"/>
   <N05 xsi:nil="1"/>
   <D00>2021-01-18T00:00:00</D00>
   <D01>2021-01-18T00:00:00</D01>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
  <IN_MESSAGE_LINE>
   <MESSAGE_ID xsi:nil="1"/>
   <MESSAGE_LINE>3.0</MESSAGE_LINE>
   <NAME>LIN</NAME>
   <C00 xsi:nil="1"/>
   <C01 xsi:nil="1"/>
   <C02>23186183:-</C02>
   <C03 xsi:nil="1"/>
   <C04 xsi:nil="1"/>
   <C05>ORD</C05>
   <C06 xsi:nil="1"/>
   <C07 xsi:nil="1"/>
   <C08>EA</C08>
   <C09>579</C09>
   <C10 xsi:nil="1"/>
   <C12>579</C12>
   <C13>123456789</C13>
   <C14 xsi:nil="1"/>
   <C15 xsi:nil="1"/>
   <C16>Delivery/Calendar Pattern: AS DIRECTED Time Pattern: AS DIRECTED</C16>
   <C17 xsi:nil="1"/>
   <C18 xsi:nil="1"/>
   <C19>True</C19>
   <C20 xsi:nil="1"/>
   <N00 xsi:nil="1"/>
   <N02>5.0</N02>
   <N03 xsi:nil="1"/>
   <N04 xsi:nil="1"/>
   <N05 xsi:nil="1"/>
   <D00>2021-01-18T00:00:00</D00>
   <D01>2021-01-18T00:00:00</D01>
   <OBJSTATE xsi:nil="1"/>
   <OBJEVENTS xsi:nil="1"/>
   <STATE xsi:nil="1"/>
  </IN_MESSAGE_LINE>
 </LINES>
</IN_MESSAGE>

 

GPIE
Rank
Userlevel 5
Badge +11

So it’s the conversion to the intermediate file that is causing the issue. Are you providing all mandatory lines in the Delsch file? And what version/update are you on? It might be a bug fixed in a later update so you will either have to update, or wait for IFS to fix.
The only other option is to import your own intermediate file and bypass the Delsch format, but that depends on what is generating your inbound file. 

N
Rank
Userlevel 2
Badge +6

I’m on version 10 update 8. I’m looking at the Receiver Customer Schedule API and it looks like it doesn’t even look at the part # on the line segment at all. I am going to put in a ticket to see if this is intended behavior. Thank you for all your help!

GPIE
Rank
Userlevel 5
Badge +11

No problem. IFS were very helpful to us when we had similar issues. Please let us know how you get on. 

N
Rank
Userlevel 2
Badge +6

IFS Pretty much only told me that I need additional training, and that I may be using the incorrect schema and directed me to the schema I am using.

GPIE
Rank
Userlevel 5
Badge +11

OK, that’s a shame.

In the sample, you have <MESSAGE_ID>23186179:-</MESSAGE_ID> and then later on <PART_NO>23186183:-</PART_NO> so could the “:-” be causing an issue?

In this view, what does the Error Text show?

 

N
Rank
Userlevel 2
Badge +6

I see it in the Connectivity Inbox Messages as Accepted, I don’t see it in the Application Messages at all

Terms & ConditionsCookie settings