EULANDA® ERP System Head Start thru Technology

cn_ArCalcPreise (SQL API)

Back | [ Level back ]

Computes the article source data prices on the basis the supplier prices new. Here the VkNetto, the BruttoFlg and the EkNetto of the supplier to the article  source data table article are transferred.  If in the suppliers item table KrArtikel  no EkNetto located, thus the EkNetto from the VkNetto formed less the supplier discount in the table the KrRG is located.

The procedure calculate in each case a complete supplier is indicated either by the match code or by the account payable ID.

Syntax

cn_ArCalcPreise @KreditorID, @KreditorMatch

Argument

@KreditrorID INT

@KreditorMatch VARCHAR(40)

One of the parameter must be indicated.

Example

EXEC cn_ArCalcPreise NULL, 'BUDERUS'

All articles of the supplier "BUDERUS" are calculated new. 

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