EULANDA® ERP System Head Start thru Technology

cn_creanp (SQL API)

Back | Level back

Puts on an article to an existing offer. The article must be likewise present. The article can be indicated over the article number and alternatively over the ID of the article. The offer is generally indicated over the ID of the offer header set. To each position which can be put on a quantity can be indicated. All fields of the position are filled from the read article.

The procedure supplies the return value 0 during error free execution. All deviating values are errors.

If the offer should be seized another currency like the read articles, then the article currencies are converted automatically with the import into the other currency.

Syntax

cn_creanp @an_id = www, @ar_id = xxx, @ar_number = 'yyy', @anp_quantity= zzz

Argument

@an_id = www

www is the ID of an existing head data set to an offer.

@ar_id = xxx

xxx indicates the ID to existing articles. The data of the article are copied to course-read and into the position. The position reference dbo.OfferPos.ArticleID contains of the position after the creation in XXX indicated. Alternatively to the ID also the article number can be indicated as parameters more @ar_number.

@ar_number = 'yyy'

yyy indicates the article number to existing article. The data of the article are copied to course-read and into the position. The position reference dbo.OfferPos.ArticleID contains the ID of the read article of the position after the creation. Alternatively to the article number also the ID of the article can be directly indicated. In this case the parameter must be used @ar_id.

@anp_quantity = zzz

zzz  indicates the quantity. 

Example

declare @e int
exec @e = cn_creAnp @an_id=136, @ar_Number='Adobe indesign', @anp_quantity=2
Select @e [Exec]

In this example to the existing offer with the ID 136 a position with the article "Adobe Indesign“ and the quantity of 2 is added.

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