Filtering the Item-Cross Reference field

tepa · 2010-02-18

Halo everyone

I am facing the case below (Navision 5 SP1):

I passed in T_5717 some records regarding the "Cross-Reference No." field

In sales order form I am using a barcode scan but the value which returns is different than the value i passed in T_5717

The difference is located by the end of the value (T_5717 "Cross-Reference No." = PPBS2815-145
T_37 "Cross-Reference No." = PPBS2815-145/2)

Any Ideas how can i setfilter / setrange the result starting T_37 to T_5717 ?

Thank you in advance

kine · 2010-02-18

I am lost in your description...

you meant, that in Cross reference table you have barcode with value "PPBS2815-145" but in sles line you scan value "PPBS2815-145/2" and you want to find the value "PPBS2815-145" in cross reference table?

Why you have these different values there? Why you scan something different than you have in the cross reference table? That's what you need to answer yourself.

tepa · 2010-02-24

Thanks for your reply

The case is that the cust have every 3months new catalogue of parts which have new barcodes.
Same items different barcodes (xxxxxxxv2,xxxxxxxxr44, etc)

Because of 1 do not want to pass new catalogue every time i have new list (7000,00-9000,00 "Cross-Reference No." in T_5717)
i impl this solution in order to avoid dataports

The problem is exactly that you described

Any advice accepted

Thanks in advance

kine · 2010-02-24

Then just change the trigger, where the cross refference is processed, and before passing the value, remove the /2 part from the scanned code. Have you some problem with this?

tepa · 2010-02-24

you mean OnValidate trigger?

kine · 2010-02-25

Yes, if you want to make it table-wide.

tepa · 2010-02-25

Thank you for your advice

Be well!

Filtering the Item-Cross Reference field

Comments

Categories