IFS Community Post (English) Subject: Best Practice for Receiving Steel Coils: Handling Supplier Excel (Heat/Lot/Coil No) before Arrival in IFS10 - Standard vs Customization?

Body: Hi IFS Community,

I work in the Steel Industry (Coil Service Center / Decoiling) using IFS Applications 10. We have a specific scenario regarding purchasing and receiving raw material (Steel Coils) and I am wondering if there is a standard solution for this or if it requires customization.

The Scenario:

1. Purchasing: We create a Purchase Order for a total weight (e.g., 100 Tons of 5x1000mm Steel Coil) as a single line item.

2. Supplier Notification: Before delivery, the supplier sends us a detailed packing list via Excel. This file contains specific details for each individual coil that makes up the 100 tons:

   • Coil No / ID

   • Heat No / Cast No

   • Lot/Batch No

   • Specific Weight (e.g., Coil 1: 20 tons, Coil 2: 18 tons...)

   • Valid From / Expiry Dates (critical for storage costs)

3. The Problem: Currently, our Purchasing team has this Excel file, but the Warehouse team does not see this detail in IFS. When the truck arrives, the Warehouse team has to physically climb onto the truck and check each coil's tag manually to verify details against the general PO line. This causes significant time loss and safety risks.

The Requirement: We want the Purchasing team to upload/enter this detailed Supplier Excel into IFS before the truck arrives. The goal is for the Warehouse team to see a "pre-receipt" list with all specific Coil IDs, Heat Nos, and Weights pre-populated. So when the truck arrives, they just verify and execute the receipt against these specific lines.

My Questions:

1. Is the "Incoming Dispatch Advice" functionality the correct standard tool for this in IFS10?

2. Is there a standard functionality to upload this Supplier Excel (mapping Heat No to Lot/Batch, Coil No to Serial/Handling Unit) into the Dispatch Advice, or do we need a custom Excel Migration Job / External Interface?

3. How do other companies in the Steel Industry handle this "Breakdown of PO Line into Specific Coils" before receipt?

Any advice or best practices would be greatly appreciated.

Tags: #SupplyChain #Procurement #WarehouseManagement #SteelIndustry #IncomingDispatchAdvice #IFSApps10 #LotBatchTracking