Skip to Content
avatar image
Former Member

How to set approval query for Inventory Transfer in SAP Business One

Hi,

I'm trying to set a query in the Query manager to require approval when inventory is moved from warehouse 'WHS-PRO1' to warehouse 'CRM-001' in SAP Business One version 9.3.

I've tried using all the answers I got from the other forums. Non work for me.

SELECT distinct 'true' FROM OWTR T0 INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry WHERE $[$18.0.0] = 'WIP-PRO1' and $[$23.5.0] = 'CRM-001'

I also tried replacing $[$23.5.0] with $[OWTR.Filler]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 25 at 08:29 AM

    Hi,

    Set your query on header level warehouse codes because approval does not work on row level queries its standard system behavior

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 10:24 PM

    Hi,

    To check your approval query, open inventory transfer document first and then run query.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 24 at 10:58 PM

    Hi,

    Follow below steps,

    1. Open new inventory transfer document

    2. select items to transfer

    3. Before adding the document, run your approval query from Tools->Query

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded