How to check ItemTrackingLines without going into it?

selece28

Hi Nav Masters,

I have a question that i'm not sure about it.
Can we check /see if an item in Sales Order Line already have Item Tracking Lines assigned to it?
I mean without clicking Lines - Item Tracking Lines
Can i just add codes to check on table Reservation Entry?
Please advice

Thanks in advance,

DaveT

Hi selece28,

You could add a flowfield to do the lookup just like the boolean "Bill of Materials" in the item table. This of course will not tell you if the data is valid but just that it exists

Hope this helps

selece28

Hmm... Sorry But i'm using Nav 5 and it seems that i don't have "Bill of Materials" in my Item Table

Any suggestion?

DaveT

Hi

Do you have field 6 on the item table 27?

DaveT

Hi

Its a flowfield with
Exist("BOM Component" WHERE (Parent Item No.=FIELD(No.)))
in the CalcFormula property

Create a field (in a test of course) and set it to a flowfield. then use the assistedit to guide you.

selece28

Hi It seems that Nav 5 don't have field 6.
But i think i got your point.
I'll give it a try.
Thanks