Price Sheet Strategies
Most manufactures issue two kinds of prices sheets, full prices sheets usually once a year (or at some other regular interval) and supplemental price sheets for new numbers added between regular full price sheets.
There are three approaches to prices sheets that work well in PIESCentral and don’t require changing the setup for documents each time you publish.
⚠️ Note: A PIES Price Sheet consists of a Price Sheet Name, Price Sheet Number, Currency, PriceZone, Effective Date and Expiration Date. The same price sheet name can be used in multiple versions. Currency is only necessary if it differs from the default document currency. Currency, Effective Date and Expiration Date can be placed on individual prices instead of on the price sheet. PriceZone is the only element that can only be specified on the price sheet element.
Price sheets in PIES are not required to correspond to printed price sheets. They may be digital-only price sheets.
Approaches:
-
For each trading partner, create a single price sheet name for each product line/price zone. Don’t include an Effective Date or Expiration date. Never change this price sheet. Instead, just add prices for new items to this price sheet, specifying the Effective Date on the price element.
To update prices, just change the prices on this single price sheet, producing a net change. All price levels can be included on a single price sheet.
This approach may work best for companies that don’t ordinarily organize prices into price sheets. The single price sheet simply serves to satisfy the requirement for a price sheet number on the price element.
-
For each trading partner, create a single price sheet name for each product line/price zone. Create a new price sheet (same price sheet name with a new price sheet number) for each major price sheet revision.
For example, a price sheet name might be “Carquest Clutches - US” with price sheet numbers like CC-US-2008, CC-US-2009, etc. The price sheet may have Effective Date and Expiration Date. Between major revisions, add prices for new numbers to the most recent full price sheet, putting the Effective Date and Expiration Date on the price rather than on the price sheet.
PIESCentral will use the most recent price sheet from each of the price sheet names selected in the document definition. This is the recommended approach for most companies.
-
For each trading partner, create a major revision price sheet name and one supplement price sheet name corresponding to the supplement frequency.
For example, if supplements are issued monthly, you might have “Carquest Clutches - US” and “Carquest Clutches - US NN01”, “Carquest Clutches - US NN02”, “Carquests Clutches - US NN03”, etc. Include all of these price sheet names in the document setup.
When a major revision is published, set the Expiration Date for the supplemental price sheets to match the Effective Date of the major revision.
Between major revisions, use the supplement price sheet names with suitable price sheet numbers to publish prices for new part numbers.
This approach corresponds closely with how printed price sheets work, however it is more complicated than necessary for PIES. Keep in mind that PIES will ultimately support continuous updates with net changes. That means that new part numbers might be added daily rather than monthly. There is no reason to limit new part number announcements and pricing to monthly supplements.
This approach should be used only when there is a strong business reason to tie PIES price sheets to printed price sheets.
⚠️Note: Price Sheets may be loaded “externally” using a data source and the “Price Sheet” tab of an import script, or “internally” using the Price Sheet Maintenance screen (through the Maintain > Pricesheets… function). If loaded internally, do not use price sheet mapping. Instead, simply use the desired Price Sheet Number created in Price Sheet Maintenance when importing prices. If only one price sheet is used, the sheet number can be entered in the Default column. Otherwise the sheet number must be included in the Price import source (or as a literal string in the sql expression).
On the Document Add/Edit screen you choose a Price Sheet Name and not a Price Sheet (Number). PIESCentral will always use the latest price sheet number having the selected Price Sheet Name.
⚠️Price Sheet Numbers are case-sensitive! We recommend making Price Sheet Numbers UPPER CASE to ensure consistency.