Instead of set variables (see Pricing Formulas) you can perform pricing also by creating a stored procedure.

Enter the following in the Formula field:

exec <name of procedure>

e.g.

The procedure needs to contain the following parameters:

create procedure _MojIzracunCene
@cTip char(2) 'I' regular sales
'P' regular purchase

@cCenRazred char(1) <- SUBJEKT.CENRAZRED subject's pricing level
@cKupec char(30) <- SUBJEKT.NAZIV subject for which you are trying to perform pricing (you can put it inside '')

@cSkladisce char(30)<- SUBJEKT.NAZIV warehouse for which separate pricing is set(you can put it inside '')
@cIdent char(16) <- MS.IDENT item for which you are trying to perform pricing
@cgValuta char(3) the currency used in pricing
@dgDatum datetime date and time (it is used when looking up contract prices)
@nKolicina decimal(19, 6) quantity
@cKolicina char(1) 'T' = used only if variable for quantity is included in formula
'F' = used always
as

--Returns RecordSet with price and discount

set nocount on

declare
@nVrniCena Float,
@nVrniRabat Float

set @nVrniCena = 0
set @nVrniRabat = 0

select @nVrniCena = MpCena * 2
from MS
where Ident = @cIdent

select @nVrniCena, @nVrniRabat