[Arnold de Vries]

Hi everyone,

I’d need some help in creating one overview (preferably from the Released products) based on product filter code.
Specifically, it’s a value in table WHSFilterCode1_FilterCode[2] I’m interested in, but I can’t seem to find the right table when adding a joint to the advanced filter or sort function.

Does anyone know how I can find this table when adding a joint? Or perhaps an alternative solution?

Thanks in advance!

——————————
Kind regards,

Arnold de Vries
Operational/ERP support at Abacus Medicine B.V.
Alkmaar, Netherlands
——————————

[Ernesto Cortez]

Hi,

I’m not sure but I’d guess you’re using D365. I’m still in AX 2012 but have solved it in the released products form in our version. I’ll describe the join between tables in 2012 below. It shouldn’t be to different right?

The table we’re looking for is “Warehouse item number” and it is joined directly to the Items table.

Hopefully this was of use to you. Good luck.

——————————
Ernesto Cortez
Apotek Produktion & Laboratorier AB
Stockholm, Sweden
——————————
——————————————-

[Arnold de Vries]

Hi Ernesto,

Thank you very much for your reply, it was indeed the same in D365FO as in AX 2012.
Based on the table names I was able to locate the right table and establish the joint.

I’ll make sure to mention D365FO in future posts.

Thanks again for the great help!

——————————
Kind regards,

Arnold de Vries
Operational/ERP support at Abacus Medicine B.V.
Alkmaar, Netherlands
——————————
——————————————-