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

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

    Posted by DSC Communities on October 25, 2021 at 10:34 am
    • Arnold de Vries

      Member

      October 25, 2021 at 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
      ——————————

    • Ernesto Cortez

      Member

      October 26, 2021 at 2: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
      ——————————
      ——————————————-

    • Arnold de Vries

      Member

      October 26, 2021 at 4: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
      ——————————
      ——————————————-

    DSC Communities replied 4 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘How to generate a list of Released products based on product filter code’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!