The REST API is failing to retrieve the lot details for a work order
Summary:
Hi Team,
We use this API to obtain the lot number: https://{pod}:443/fscmRestApi/resources/11.13.18.05/workOrders/{WO ID}/child/WorkOrderLotNumber. However, this is unfortunately not supported for lot numbers assigned during work order completion and works only for preassigned lot numbers. As an alternative, we are using another API to get the details: https://{pod}:443/fscmRestApi/resources/11.13.18.05/inventoryCompletedTransactions/{TransactionId}/child/lots. The transaction ID can be obtained using the following query: select * from INV_MATERIAL_TXNS where TRANSACTION_SOURCE_NAME = {'WO number'}. However, this query returns many transaction IDs. Could you please assist us with this?
Content (please ensure you mask any confidential information):