Shop order material cost: why the fact shows zero while Inventory Transaction History still shows cost

Confirmed (the explanation was accepted by the asker):

1. The difference is expected; the screen and the fact count costs in different ways.
2. When shop order material is unissued, IFS does not change or remove the original issue transaction. It creates a separate reversal transaction (UNISS) for the unissued quantity, and updates QTY_REVERSED on the original issue to record how much of it was later reversed.
3. Inventory Transaction History lists every transaction on its own, so each row shows cost × QUANTITY. A fully reversed issue therefore still shows its full cost, and the reversal appears separately on the UNISS row.
4. The fact reads only ISSUE rows and uses quantity - qty_reversed. This gives the net cost directly without reading the UNISS rows, so the reversal is not counted twice.
5. Where QUANTITY - QTY_REVERSED = 0, the material was issued and then fully unissued, so a net component cost of 0 is correct.
6. To see QTY_REVERSED, check the column chooser for a hidden column on the page; otherwise query INVENTORY_TRANSACTION_HIST2 directly.
7. To verify a case, take the transaction ID, filter the screen on the same shop order and part, and find the matching UNISS row.

If you build your own cost totals from transaction history, either use net quantities on ISSUE rows or include the UNISS rows, but not both.

Prerequisites and limitations Applies to shop order material issues and unissues. The thread is tagged both IFS Applications 10 and IFS Cloud with no specific release, so screen behaviour (for example whether QTY_REVERSED is available in the column chooser) may vary by version.