D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

How to generate a list of Released products based on product filter code

Jump to Best Answer
  • 1.  How to generate a list of Released products based on product filter code

    Posted Oct 25, 2021 10:34 AM
    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
    ------------------------------


  • 2.  RE: How to generate a list of Released products based on product filter code
    Best Answer

    Posted Oct 26, 2021 02:27 AM
    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
    ------------------------------



  • 3.  RE: How to generate a list of Released products based on product filter code

    Posted Oct 26, 2021 04:05 AM
    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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role