EULANDA® ERP System Head Start thru Technology

cn_WeJobCre (SQL API)

Back | Level back

Produces a new incoming goods job. Over the returned job ID then the different article quantities can be assigned to the job. Over a locking call of cn_wejobexec the actual stock item is then accomplished.

Syntax

cn_WeJobCre
  @GegenLO int,
  @StockGr int,
  @Info varchar(100),
  @JobID int = NULL OUT,
  @Date datetime = NULL

Argument

[ @gegenlo ] = StockLocation-ID

With installed purchase module this is the stock location of the supplier. Otherwise the total account incoming goods is indicated here (8000).

Example

DECLARE @jobid int, @exec int

EXEC @exec = cn_wejobcre @gegenlo = 8000, @Stockgr = 1, 
  @info = 'Actebis Supply Nr. 5454', @jobid = @jobid OUT

EXEC @exec = cn_wejobitemadd @jobid = @jobid, 
  @ar_id = 5, @quantity = 10, @lo_id = 1000

EXEC @exec = cn_wejobitemadd @jobid = @jobid, 
  @ar_id = 8, @quantity = 6, @lo_id = 1000

EXEC @exec = cn_wejobexec @jobid = @jobid

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.