Skip to Content
0

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

Apr 23 at 09:40 PM

42

avatar image
Former Member

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]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Abdul Mannan Apr 25 at 08:29 AM
0

Hi,

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Apr 23 at 10:24 PM
0

Hi,

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

Regards,

Nagarajan

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Nagarajan,

Still getting an error message.

0
Nagarajan K Apr 24 at 10:58 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded