Serial-number problems in reports are often blamed on the report design even when the real issue is the relationship between the invoice detail, item movement, batch, or serial tables.
First question: does the data exist?
Before editing the layout, query the relevant tables directly. If the serial does not exist for the document you are testing, no report formula can make it appear.
- Identify the document number and the exact detail record.
- Check the serial table independently before adding joins.
- Watch for one-to-many joins that multiply report rows.
- Compare the SQL result with the report group structure.
Duplicates are usually a clue
If the same item suddenly appears two or three times after adding the serial table, that usually means the join is returning multiple serial rows. At that point, fixing the report frame will only hide the symptom.