Enabling "Ext." columns, such as Ext. List/Buy/Sell are the only way to get Subtotals for groups in Calculation.
Here is a summary of many commonly used columns in the Calculation:
- Attribute Note: Open column for adding multiple lines of notes to a part. Double click the field to add and see full notes and descriptions per line item. Exports in PMX, SIF, OFDA XML, and Excel formats.
- Attribute Description: Open column for adding descriptions for Attribute Notes. Double click the field to add and see full notes and descriptions per line item. Exports in PMX, SIF, OFDA XML, and Excel formats.
- Base: Dealer cost to the customer before adding up-charges
- Buy: Cost to the dealership
- Buy %: Percentage off List (i.e. 50/10/5)
- Catalog: Manufacturer's product catalog
- Category: Various uses per manufacturer, either within a catalog or pricing
- Comment: Open column for adding notes for shipping or installation purposes; does not export to all .sif formats unless using Custom SIF
- Company: Manufacturer
- Complete: Indicates if all options are selected; only works for specific manufacturers
- Description: Part description
- Ext. Buy: Quantity times Buy; will show subtotal at the group level
- Ext. List: Quantity times List; will show subtotal at the group level
- Ext. Profit: Quantity times Profit; will show subtotal at the group level
- Ext. Sell: Quantity times Sell; will show subtotal at the group level
- Ind. Tag: Individual or Installation Tag on each product; double-click in the cell to edit tag in Calculations and drawing view
- Lead Time: Product lead time when provided by the manufacturer
- List: Published price list
- Main Product: Shows which Main Product an Additional Product originates from.
- Manual Sort: Click-and-drag individual lines to reorder
- Margin %: Percentage between sell and buy
- Markup %: Percentage added to Buy
- Material Quantity: Used in conjunction with a COM, user can manually add quantities for custom materials. Cost for the quantity will be calculated based on the Price Per Unit entered in the COM dialog.
- Numeric Option Value: Used for catalog products that have stretch capabilities. Shows the distance of the length, width, height, depth, etc. that the product is stretched to in the drawing.
- Options: Codes for finish options
- Part Number: Part number found in catalog
- Part Key: Unique identifier used by CET
- Preview: Shows thumbnail image of catalogue symbols
- Profit: Difference between Sell and Buy amounts
- Quantity: Number of items in the drawing; double click to edit the amount to order (will not affect drawing; qty in the drawing will still show in parentheses when changed)
- Reconfiguration: Shows existing, proposed, or inventory status if Reconfiguration category has been applied from Part Tagging; Category automatically exists if you have installed the Reconfiguration Tool extension
- Sell: Price to client
- Sell %: Percentage between Sell and List
- SKU: Number assigned to a product by the manufacturer
- Source: Indicates where the part was inserted from. For example:
- CAD = AutoCAD drawing
- PL = picklist
- PS = ProjectSymbols
- Catalogues = CET Catalogues
- CET = PGC Symbols
- TAG1, TAG2, TAG3: Part Tagging categories
- Upcharge: Additional costs for options
Other available columns include: Area, Depth, Feature Description, Height, Length, Media Weight, Package Count, Part Key, Pricelist, SKU, TOC, Vendor, Volume, Weight, and Width.
Comments
0 comments
Please sign in to leave a comment.