Skip to main content
Question

How is the Part Lot Batch (LotBatchMaster) table populated

  • June 15, 2026
  • 1 reply
  • 26 views

Forum|alt.badge.img

With use IFS 25R2. We are struggling to understand how and when the LotBatchMaster table gets populated, and we are facing situations where we expect records to exist but find nothing.

 

Situation 1 — Customer Order delivery : We manually reserved specific lot numbers against a customer order line, and the delivery was completed successfully. We can see the inventory transactions in the transaction history. However, when we open the Part Lot Batch page and filter by article or by lotNo., no record appears for these lots. We would expect to see entries with Order Type = Customer Order.

Situation 2 — Return Material Authorization : We processed a customer return (RMA). During the receipt of the returned goods, we specified the lot numbers of the items being returned (in order to have the same lot No of the Costumer Order line). The receipt was completed successfully. Again, when we open Part Lot Batch, no record appears for these returned lots. We would expect entries with Order Type = Return Material Authorization. 

But when we enter other value (ex. LOT001) when performing the part receipt, we can find the record in the Part Lot Batch with Order Type = Return Material Authorization. 

(These situations are only examples)

My question : What exactly triggers the creation of a record in LotBatchMaster? Is there a configuration we are missing, or would this require a custom development to explicitly create/update LotBatchMaster records based on the lot number at each relevant transaction event (delivery, return receipt, manual receipt)? Any guidance or documentation pointer would be very helpful.

 

*We will have a custom development that relies on the Part Lot Batch (LotBatchMaster) page. Our logic is built around lot numbers, and quality status directly on each lot record. The lot number is the key identifier for our entire development.

1 reply

Forum|alt.badge.img+12
  • Hero (Partner)
  • June 15, 2026

Hi,
A Part Lot/Batch record is created when IFS recognises the existence of a lot or batch. This can happen, for example, in the following scenarios:

  • When you receive a lot from a supplier through a purchase order
  • When receiving from production
  • Via direct receipt into inventory
  • From a customer return through an RMA
  • Through a positive inventory counting difference

You can try this by performing any of the above actions and then checking the Part Lot/Batch records for the relevant lot number.

 

Regarding your question and the expectation that a record should be created when delivering a customer order:
To manually reserve a lot in your Scenario 1 and deliver the customer order using that lot, the lot must already exist in your inventory. In other words, a corresponding Part Lot/Batch record must already be available in the system.

Did you import the lot/batch records into your system during an upgrade or via migration from another ERP system? 

Were they not created using the processes I have listed above?

When you check the inventory transaction history for the lot/batch delivered on the customer order, what is the transaction code for the earliest (oldest) transaction associated with that lot/batch number?

(I am a bit unclear on Scenario 2, so I will not comment on it here 🙂)

 

Thanks

Asanka