Previous Topic

Next Topic

Book Contents

Book Index

EffectivePriceList - MaxBasic Function

EffectivePriceList(PriceCode: String[, EffectiveDate: Date]): String

Returns the Price Code of the Price List that is effective for a Price Group on a date. For a Price Group, this is the List in the Group with the latest Effective Date on or before the date. Returns an empty string if no List in the Group is effective on the date. If the Price Code is a Price List, it is returned unchanged. An error is raised if the Price Code does not exist.

EffectivePriceList function syntax has these named arguments:

Parameter

Description

Price Code

Required. The Price Code of a Price Group or Price List, for example the Price Code on a Customer.

Effective Date

Optional. The date to find the effective Price List for. Defaults to the System Date.

Use this function in scripts that read Selling Prices for a Customer, Customer Group, Job or document whose Price Code is a Price Group. See Price List.