I'm trying to create a query to copy information from an invoice to a user field.
We have 2 locations, each one uses its own series for most documents. A new add-on we'll use requires a user field series, which I basically want to make the same as the document's series; since I couldn't find a simple way to assign that field to specific users (like the invoice series), I'm trying to create a query that copies the document's series to the user field series.
The last query I tried was:
select b.name
from dbo.user_series d
inner join oinv o
on b.name = (select seriesname from nnm1 where series = o.series)
I'm not sure if its possible to do something like
MAKE b.series
from dbo.user_series b
inner join oinv o
where b.series = o.series
Thanks in advance
Hugo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.