Home Forums Warehouse Insight External document no

Tagged: 

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • Indrek TikvaIndrek Tikva
      Post count: 4

      Hello,

      What would be the easiest way to insert an External Document No on Inventory put-away document?

      Regards,

      Indrek

      Indrek TikvaIndrek Tikva
        Post count: 4

        Is it necessary to develope extension for this or is it possible to solve it with existing tools?

        Olina ThorsteinsdottirOlina Thorsteinsdottir
          Post count: 27

          This does depend on the version that you have, you can add the External document No. if you have the full version of Warehouse Insights.
          For the Express version out of the box it is not possible to add additional columns.

          On the full version, if you navigate to the Warehouse Insights Applications < The column Tab.
          Add the Event ID and Table No. it the field exists on the table; you can drill down to the field name and add it.

          However, if the field does not exist on the table, instead to drilling don add -1 as the field No.
          Next check the is formula Boolean, then add an Override value, this value is a formula, hence the check for ‘is formula’. You need to know the Table and the field no, a formula can look something like this
          The first number is table No, next is the field no, then you have the where the data is coming from that you are adding to the line.
          37,10,WHERE (Document No.=FILTER(‘[Source No.]’))

          Indrek TikvaIndrek Tikva
            Post count: 4

            Hello

            I have full version.

            Maybe I didn’t express myself accurately. I am looking for a solution where I can enter a new external document number via the hand terminal. Just as it is possible on SALES_OUT_DOC if I make menu MI_EXT_DOC_NUMBER button and i use Event Name SHIPPING::UpdateSalesExtDoc.

            Now I would like to add the external document number in the same way through Application PUT_DOC to External Document No. (7312) field in the Warehouse Activity Header (5766) table. Do I need to develop a new Warehouse Insight Event for this?

            Best regards

            Indrek

             

          Viewing 4 posts - 1 through 4 (of 4 total)
          • You must be logged in to reply to this topic.