Skip to Content
author's profile photo Former Member
Former Member

SBO: Formatted Search won't work with just one line

Posted on Apr 19, 2004 at 03:22 AM 18 Views

Hi

I have the following Formatted Search which I would like to load and have available behind a UDF on the Inventory Master File. I have done this and it works well but ONLY if there are multiple PO Order Lines per Inventory Item and we want to show the same info even if there is only one PO Order LIne. Can anyone help me please.

SELECT T0.DocNum,T1.LineNum,T1.ItemCode, T1.Dscription, T1.Quantity, T1.ShipDate AS "ETA Date", T1.OpenQty, T1.WhsCode, T1.DocDate, T0.DocStatus FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocStatus = 'O' AND T0.DocType = 'I' AND T1.ItemCode = $[$5.1.0] FOR BROWSE

SAP Business One Extensibility
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2004 at 12:52 PM

    Hello Marilyn,

    I guess the solution for your problem is quite simple:

    when you receive more than one result from a formatted search, you get a seperate window with a list of all results matching your query. When there's only one match, it will be taken immediately to the field. In your case you won't see the whole list, but only the entry of the first column will be taken to your UDF.

    Did you define it in the correct way? I tested your query and on my machine it works fine also with single entries... By the way: how do you store a result list in a UDF...!? You surely are only able to select ONE...

    If you just want to be able to see the list without storing the info, just select the query from the menu, when you're in the items managment. No need for a formatted search then.

    Regrads,

    Dierk

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Apr 22, 2004 at 08:25 AM

      Hello Marilyn,

      I suppose you should go to your customer and play the song "You can't allways get what you want"... 😉

      Serious: IMHO there's no possibility to do this via formatted search - may you try to assign a formatted search to a user defined table. It's possible, but I never did this, so I don't know, if the whole table will be filled, or also just one field (I guesss only one field... - please keep me updated, if you try this out).

      The best (technical) solution for this would be the creation of a seperate window attached to the items management via SDK - if your customer thinks, that it's worth this effort and is willing to pay for it!?

      From the practical point of view, I would say, that maybe your customer had this functionality in his old system and is used to it, without thinking about, how important this is, or just likes to have it, or the responsible person on the customers side wants to distinguish her- / himself with some 'urgent' requests or.... But does your customer REALLY need this functionality? Where's the advantage over opening the query via the menu? One mouseclick... hmmmm... If this Info was stored in the standard setup of SBO on a sepearate tab, you would have to click also.

      Maybe the standard purchase analysis (left bar graph icon) in the items managment is sufficient in real life anyway...!?

      I personally wouldn't put too much effort into such a request.

      Regards,

      Dierk