Advanced Product Tab Programming

Configuration programming for most parts should follow the normal rules and conventions. However, on occasion there may be a need to depart from the normal rules and conventions to handle special situations.

SDA provides several approaches to handle these special situations:

 

 

Designate the part as a manual calculation item by entering a “Y” in the Part Master’s ManualItem field. This will instruct SDA to not overwrite the description, list price and cost columns in product tabs that are inserted into a SDA quotation.

 

Designating a part with ManualItem = Y is useful for promotional part numbers where the price/cost is not fixed and must be calculated.

 

 

 

Using zerocostversion is useful when a vendor has a “buy one get one free” type of program where a certain quantity of the part number is at the normal price/cost and a certain quantity of the same part number is at a $0 price/cost.

 

 

=IF([Excel formula],”InclCustAfter”,””)

 

 

=IF([Excel formula],”InclCustBefore”,””)

 

 

=IF([Excel formula],”InclAfter”,””)

 

 

=IF([Excel formula],”InclBefore”,””)

 

 

For the customer output includes lines (InclCustAfter and InclCustBefore), only enter information into the Description column (Column D) in addition to the formula in Column A, as that is the only column that will be conveyed to customer outputs.

 

 

Return to Creating and Updating Configuration Tabs Section