Skip to main content
Question

Intrastat report and Serial No Tracked Parts on Customer Orders

  • March 13, 2026
  • 1 reply
  • 4 views
T
Sidekick (Employee)
Forum|alt.badge.img+7

Hi,

I wonder if anyone has met a requirement where outbound (Direction - ) transactions should be tracked based on Serial Number.

My current understanding is that if a part is lot tracked, the CoO is taken from the Lot, else from inventory part.

Meaning that if the same inventory part use Serial tracking, and parts come from different origins we are not able to track the serials origin.

This would of course require CoO on serial, and then to follow-up it on outbound transactions consequently.

1 reply

jbush0419
Do Gooder (Customer)
Forum|alt.badge.img+2
  • jbush0419
  • Do Gooder (Customer)
  • March 13, 2026

​@tipifi  -  you're absolutely correct in your understanding of the current IFS functionality. The system follows this hierarchy for determining Country of Origin (CoO) on outbound transactions:

  1. Lot tracked parts - CoO is taken from the lot batch record
  2. Non-lot tracked parts - CoO is taken from the inventory part master

As I understand it, serial number tracking alone doesn't carry CoO information in the standard IFS functionality. Even if you have serial-tracked parts from different origins, the system will fall back to the inventory part master's CoO since there's no CoO field maintained at the serial level.

This creates exactly the limitation you've identified - you can't differentiate between serial numbers from different countries of origin for Intrastat reporting purposes.

Potential workarounds to consider:

  • Combine lot and serial tracking - If feasible for your business, using both lot batch and serial tracking would allow you to maintain CoO at the lot level while still having serial traceability
  • Custom modification - You could explore adding a custom field for CoO on the Part Serial LU and modify the Intrastat reporting logic, though this would require development effort and might be more effort than it’s worth (unless you have in-house developers) 
  • Alternative part numbering - Create separate part numbers for the same physical part based on country of origin (though this may complicate other processes and you’d lose more than you’d gain IMO)

Based on what I remember, this looks as though it’s a gap in the standard functionality rather than a configuration issue. You might want to consider submitting this as an idea in the IFS Community Ideas section, as improved traceability for serial-tracked parts is something that should be more robust - given IFS’s strengths in this area.

Have you explored whether lot tracking might work alongside serial tracking for your use case, or are there business reasons why lot tracking isn't suitable?

-jason

Terms & ConditionsCookie settingsAccessibility statement