pricing

get price function

formel_bscript object=ue_artikelstamm=pricing=parameter with tab

 

return

Price in <cpreis>

Currency in <cwrg>

blanked agreement in <cargno>

 

Note:

New variant is the BeasServiceLayer function item/GetPrice

 

 

Propertie

value

Default

Mandatory

Description

itemcode

string


x

itemcode

cardcode

string


 

if you work with special price list, then set the supplier

typ

string

E

 

pricing

  xx      price list number

   D        Average Price

   L        Last purchase price

   K        beas calculation price oitm.u_kalk_price

   B      last valuation price

   W        last incoming good price

   N      with out all for second valuation

   E      Last purchase price OITM.LastPurPrc

date

date

today

 

valuation date (price list date)

quantity

decimal

0

 

quantity in ware house unit

you need this if you work for special price list or extented price list

homecurrency

true/false

false

 

if true the return price is allways the home currency

reference date is the propertie date

whscode

string


 

the warehouse. You need this if you get the price from warehouse, example last purchase price and setting "price per warehouse"

uom

string


 

set the purchase unit. if you work with unit group beas return the price in this unit

if you don't set this, beas return the price allways in warehouse unit

 

special price list: beas calculate the warehouse unit, if you don't set the uom-propertie

uomqty

decimal


 

the quantity in purchase unit. You must set this, if you work with uom

agreementnumber

number


 

the number of agreement. if you set this beas return the price of agreement

agreementline

number


 

the number of agreement line

checkagreement

true/false

true

 

true (default)

if agreementnumber = 0 then beas check the agreements and use the last activ agreement

return number in <cargno>

returndiscount

true/false

false

 

false (default)

beas return the price include discount in Variable <preis>

 

true

beas return variable <cpreis> and <cdiscount>

purchaseunit

true/false

false

 

beas return the price in purchase unit

 

Example

 

beasscript-logo-small

object=ue_artikelstamm=pricing=itemcode=A001<tab>typ=E
messagebox=<cpreis,#0.00> <cwrg>