cancel
Showing results for 
Search instead for 
Did you mean: 

Auto Change Warehouse Based on Numbering Series

Former Member
0 Kudos

Hi Experts,

Is there any way to auto change the warehouse based on the selected numbering series?

Thank you.

Best regards,

Low

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

hi unni I need a help ..can u follow me .so tat I can ask my doubts

Former Member
0 Kudos

Ya its possible Low....

Pls find the below fms query ..

This fms query is made according to branch wise

if ( $[OQUT.Series] = '620')  

(SELECT 'BLR-SAL' )

else if ($[OQUT.Series] = '621')

(SELECT 'CHN-SAL' )

Else if  ($[OQUT.Series] = '622')

(SELECT 'PUN-SAL')

Else if  ($[OQUT.Series] = '623')

(SELECT 'MUM-SAL')

Regards,

K.Ramasamy

ramasamy.july12@gmail.com

former_member212181
Active Contributor
0 Kudos

Hi Low,

You can create a query and assign formatted search in warehouse code to get this done.

please explain how document numbering series is related with warehouse codes?

     a) series name

     b) Prefix/suffix/remarks in numbering series

Thanks

Unnikrishnan

Former Member
0 Kudos

Hi Unnikrishnan,

a) series name - We use branch location as series name.

b) Prefix/suffix/remarks in numbering series - We don't have any of them, just 8 digits. First digit will determine what type of document, second digit will determine which branch.

Thank you.

Best regards,

Low

former_member212181
Active Contributor
0 Kudos

Hi Low,

Please try below query and give your feedback

----

Declare  @WhsCode varchar (20), @Series Varchar (8)

Select @WhsCode = $[$38.24.0]

Select @Series = Select Substring(SeriesName,2,1) from NNM1 where Series = $[$88.0.0]

Select

  Case @Series

  When '0' then '0WHSCODE'

  When '1' then '1WHSCODE'

  When '2' then '2WHSCODE'

  When '3' then '3WHSCODE'

  When '4' then '4WHSCODE'

  When '5' then '5WHSCODE'

  When '6' then '6WHSCODE'

  else @WhsCode

  end [WhsCode]

-----------

--Notes

--1)Please give your second digit of document numbering series name in when condition

-- 2) Please give your warehouse code in then condition equavalent to when series name

Thanks

Unnikrishnan

Former Member
0 Kudos

Hi Low,

You can use FMS using case when condition.

You can  start using below FMS; this is for Sales invoice.

SELECT case when $[OINV.Series]='131' then 'WHSE1'

when $[OINV.Series]='4' then 'WHSE2' else 'DEFAULT' end

Refresh regularly - when exiting field - Item No.

Regards,
Lean