on 06-23-2015 4:38 AM
Hi Experts,
Is there any way to auto change the warehouse based on the selected numbering series?
Thank you.
Best regards,
Low
hi unni I need a help ..can u follow me .so tat I can ask my doubts
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.