We are rolling out EDI using IFS and have come across and issue with custom fields. Standard .XML tags apparently do not handle $ sign. All of IFS’s standard custom field attribute configuration uses $ in the field name, i.e. ( CF$_SP_ATTENTION, CF$_SP_SHPPING_ACCT). Below you can see the two fields created on the incoming customer order screen:
The .xml file sent from our EDI integrator is showing below:
<?xml version="1.0" encoding="UTF-8"?>
-<ORDERS xmlns="urn:ifsworld-com:schemas:inbound_distribution_transactions_create_customer_order_request">
<CURRENCY_CODE>USD</CURRENCY_CODE>
<CUSTOMER_COMPANY_COUNTRY>USA</CUSTOMER_COMPANY_COUNTRY>
<CUSTOMER_COMPANY_NAME>Webstaurant Store</CUSTOMER_COMPANY_NAME>
<CUSTOMER_POSTAL_ADDRESS>2205 OLD PHILADELPHIA PIKE,,,,USA</CUSTOMER_POSTAL_ADDRESS>
<EAN_LOCATION_DOCUMENT_ADDRESS>23-1855710</EAN_LOCATION_DOCUMENT_ADDRESS>
<EAN_SUPPLIER_DOCUMENT_ADDRESS>39-0792349</EAN_SUPPLIER_DOCUMENT_ADDRESS>
<CF_SP_ATTENTION>levi kravetz 3478669114</CF_SP_ATTENTION>
<CF_SP_SHIPPING_ACCT>339973245</CF_SP_SHIPPING_ACCT>
<HEADER_NOTE>Residential 339973245</HEADER_NOTE>
<LABEL_NOTE>Residential 339973245</LABEL_NOTE>
<ORDER_DATE>2020-07-10T00:00:00</ORDER_DATE>
<ORDER_NO>1775721test</ORDER_NO>
<OUR_CUSTOMER_NO>144840</OUR_CUSTOMER_NO>
<SHIP_VIA_DESCRIPTION>Next Day Air FedEx TRS 133296492</SHIP_VIA_DESCRIPTION>
<RECEIVER_COMMUNICATION_ID>CONNECT</RECEIVER_COMMUNICATION_ID>
<VENDOR_NO>39-0792349</VENDOR_NO>
<WANTED_DELIVERY_DATE>2020-07-10T00:00:00</WANTED_DELIVERY_DATE>
<SENDER_COMMUNICATION_ID>CONNECT</SENDER_COMMUNICATION_ID>
<SHIP_VIA_CODE>202</SHIP_VIA_CODE>
<ALLOW_BACKORDERS_DB>1. No Partial Deliveries Allowed</ALLOW_BACKORDERS_DB>
<MESSAGE_TYPE>ORDERS</MESSAGE_TYPE>
When they created the .xml, they said they cannot insert the $ in the xml as it will not allow it. When trying to load the file without the $, IFS gives this error:
So basically is there any way to handle incoming EDI .XML files using standard IFS custom field attributes?
Thanks,
Mark