Castorama EDI

Requirements For Dematerialization Process At Castorama (Kingfisher)

Two ways are proposed to ensure the dematerialization:

  1. The EDI solution (EDIFACT standard).
  2. A Web EDI portal developed by Castorama.

Those solutions cover the following transactions:

  • Purchase order
  • Despatch advice

Invoice Fax and mailing can’t be used anymore to manage those transactions.

EDI Master Data

  • Supplier code – 6 digits
  • Castorama’s item code – 9 digits
  • The EAN code (EAN 13 and 14) is mandatory for all items.

The unit measure must be the same between the purchase order, the dispatch advice and the invoice. Despatch advice and invoices not respecting that rule are systematically rejected.

Purchase Order

As previously mentioned, all purchases orders must be retrieved by the supplier either via EDI or from the Portal. Orders will NOT be faxed and mailed anymore. Purchase orders are mandatory to enable the delivery goods. Any good receipt with no corresponding purchase order is automatically rejected. The original purchase order number must be recorded in the EDI dispatch advice and printed on the delivery slip with exactly the same format including the leading zero if there is any.

Dispatch Advise

As previously mentioned, all dispatch advices must be sent by the supplier either via EDI or from the Portal before the physical delivery.

  • Back orders are not allowed – One purchase order must have one dispatch advice and only one
  • Order receipt in several times – 1 order can be delivered in several and a BL must correspond to a truck.
  • Additional item lines are not allowed – It is not possible to add item lines that are not in the purchase order.
  • Lead time – All orders not delivered 15 days after of the delivery date defined in the purchase order are automatically closed.
  • EAN code – Must be the same as the one recorded in the purchase order.
  • Delivered quantity cannot be equal to zero – Item lines with no quantity should not be sent. Otherwise, the complete dispatch advice will be rejected.
  • When to send the dispatch advice? – The dispatch advice must be sent the previous day of the delivery but no more than 30 days before (DTM-17 and DTM-137).
  • Unit of measure – The unit of measure must be the same as the one recorded in the purchase order.
  • Delivery note number – The delivery note number can have special character such as / or – .
  • Order number line in DESADV and INVOIC – The order line number must be the same in DESADV and INVOIC like sent in the order (segment RFF+LI).

Delivery Note

The following fields are mandatory on the Delivery Note, the paper version, used by the carrier:

  • The purchase order number
  • EAN code
  • Delivered quantity
  • Title « N° de Bon de livraison » or « Réf BL »
  • The delivery note number must be human readable
  • Barcode for the delivery note number
  • The delivery note number must be free of special characters such as – /
  • The delivery note number must be exactly the same as the one recorded in the DESADV sent via EDI or from the portal.

Invoice

As previously mentioned, invoices must be sent by EDI or from the portal.

  • One invoice per dispatch advice. There must be one invoice per despatch advice and only one.
  • The delivery note number recorded in the invoice must be the same as the one recorded in the despatch advice. Delivery note number : special characters such as – / are not allowed.
  • Additional item lines are not allowed.
  • Item EAN code. Must be same as the one recorded in the purchase order and dispatch advice.
  • Unit of measure. Must be the same as the one in the purchase order and dispatch advice

To learn more about EDI and become a certified EDI Professional, please visit our course schedule page.

Leave a Reply

Your email address will not be published.

Post Navigation