PriceListProduct

IMPORTANT  The SOAP API entered a limited enhancement phase in Q4 2020. Access to version 1.6 will be deactivated.

This entity is only used in Multi-currency databases. It describes whether a Product on the Price List uses the internal currency or an external currency, and if it is external, lets you set the price in that currency.

Entity details

You can also retrieve this information with the Web Services API call The getEntityInfo() SOAP API call.

Entity Name: PriceListProduct
Can Create:  
Can Update:
Can Query:
Can Delete:  
Can Have UDFs:  

Conditions and requirements

General

  • If you don't have Multi-currency enabled and you try to write to the entity, you will receive an error.

Special field attributes

Field Conditions and Requirements
UnitPrice If UsesInternalCurrencyPrice equals true, then UnitPrice will return UnitPrice divided by the current Currency exchange rate; that is, the Unit Price of the MaterialCode entity with id equal to PriceListMaterialCode.AllocationCodeID, divided by the current exchange rate of the Currency with id equal to PriceListMaterialCode.CurrencyID.

UsesInternalCurrencyPrice

 

  • If the UsesInternalCurrencyPrice field is set to true, any supplied value for the UnitPrice field (or its equivalent) will be ignored by the system.
  • If the UsesInternalCurrencyPrice field is set to true, any existing value for the UnitPrice field will be cleared.
  • If the UsesInternalCurrencyPrice field is set to false, the UnitPrice field will be required, even though it is not required otherwise.

Field definitions

Field Name Label Datatype Read Only Is Required Reference Name Picklist
CurrencyID Currency ID integer Currency  
id Product ID long    
ProductID Product ID integer Product  
UnitPrice Unit Price decimal  
Only when UsesInternal
CurrencyPrice =
false
   
UsesInternalCurrencyPrice Uses Internal Currency Price boolean