Content Comparison

...

Overview

In Salesforce CRM, Sales Representatives will utilize use Opportunities and customized Quotes. Customize the Edit Quote page to include the following fields for a streamlined quoting process: for a more streamlined quoting process.

New Fields

Add these fields to the Product, Quote Line, and Item tables

• Base Material (lookup field)

  • Do not use any Configurator fields on the item table

• Bleed (lookup field)

• Width (numeric field with 2 decimals)

• Length (numeric field with 2 decimals)

On the Product table, add zzz to the front of all old custom fields

Fields for the Edit Quote Line Page

Field Details and Usage Instructions

• Base Material: Select from a picklist with 10–15 predefined options.

  • Convert lookup to picklist for a better user experience

• Width: Enter values ranging from 0 to 120 inches, with precision up to 2 decimal places.

• Length: Enter values ranging from 0 to 20 inches, with precision up to 2 decimal places.

• Bleed: Select from a picklist with 3–4 options.

  • Convert lookup to picklist for better user experience

• Content Description: Free text entry field.

• Unit Price: Automatically calculated based on preset pricing rules.

• Each Quote Line allows image

...

• upload.

Unit Price Calculation Logic

The Unit Price is calculated using this formula:

1. (Length (inches to 2 decimals) + Bleed (from bleed table) 

2. X 

3. (Width (inches to 2 decimals) + Bleed (from bleed table) 

4. / 

5. 144 (this is to get ft2) 

6. x 

7. Product Type Base Material Price $ (from Product Base Material Pricing Table) 

• Length and Width values are in inches, with up to 2 decimal places.

• Bleed values are derived value is from the Bleed Pricing Table.

• Product Type Base Material Price is sourced from the Product Material Pricing Table.

Bleed Pricing Table

This table can be modified in the future, including options for no bleed.

Base Material Pricing Table

Quote Discount

Discounts are applied based on a Discount Code associated with the Customer Account, affecting the entire quote.

Note: Salesforce Price Books are not required for the pricing and discount setup.

Automatic Product Creation

If the Upon saving a quote, if a product does not already exist, it is will be automatically created upon saving a quote. The product code follows this format:

Format: ABC123-XYRXYZ-10-09-001

• ABC123: 6-digit customer code Account Number (an error will display if the Customer Number is blank when saving a quote)

• XYRXYZ: Base Material code

• 10: Nearest integer for Width in inches (e.g., 10.5 inches becomes 11)

• 09: Nearest integer for Length in inches (e.g., 9.45 inches becomes 09)

• 001: Sequential number for each quote line

Sales Order Creation for Approved Quotes

• Each Opportunity may have multiple approved quotes.

• Quotes do not sync with Opportunities, and the Opportunity Amount is hidden.

• Add a button to generate a GoldFinch Sales Order.

• New items are created if they do not already exist in GoldFinch, with pre-configured item formulas and routing.

Raw Material Items

• Enter all raw materials directly in GoldFinch; these do not sync back to Salesforce.

• BOMs (Bill of Materials) and routings are predefined based on Material, with one Material potentially comprising multiple components.

• GoldFinch Sales prices are configured per Item and Customer Account.

• A Cross Reference Table is available to map the Customer Item Number with the GoldFinch Item Number.

Order Entry for Repeated Orders

All repeat orders are entered directly in GoldFinch Sales Order, allowing orders to be placed using either the Customer Item Number or the GoldFinch Item Number for efficient cross-referencing.

Field Details and Help:

• Material: Choose from a picklist with approximately 10 to 15 options.

• Width: Range from 0 to 120 inches with 2 decimals.

• Length: Range from 0 to 20 inches with 2 decimals.

• Bleed: Choose from a picklist with approximately 3 to 4 options.

• Content Description: Free text input.

• Unit Price: Automatically calculated based on predefined rules.

• Allow to update images per Quote Line.

Unit Price Logics  

1. (Length (inches to 2 decimals) + Bleed (from bleed table) 

2. X 

3. (Width (inches to 2 decimals) + Bleed (from bleed table) 

4. / 

5. 144 (this is to get ft2) 

6. x 

7. Product Type Price $ (from Product Pricing Table) 

Bleed Pricing Table:

We might need to change in future, plus could be the option one day for no bleed, hence the table. 

 Material Pricing Table 

Quote Discount: Automatically calculated based on the predefined Discount Code set up on the Account. Discount rules applied to the entire quote.

• Salesforce Price Books are not required for this setup.

Automatic Product Creation:

When saving a quote, if the product does not exist, automatically create a new product with the following format:

• Format: ABC123-XY-10-09-001

  • ABC = 6-digit customer code

    • When saving quote, error if Cusotmer Number is blank for the customer.

  • XY = Material Code

  • 10 = Nearest integer for Width in inches (e.g., 10.25 inches becomes 10)

  • 09 = Nearest integer for Length in inches (e.g., 9.25 inches becomes 09)

  • 001 = Sequential value for each quote line

Sales Order Creation for Approved Quotes:

• One Opporutnity can have multiple approved quotes.

• Do not sync quotes to opportunities.

• Hide Opportuntity Amount.

• Click a button to generate a Sales Order.

• Create new items if they do not already exist.

• Establish item formulas and routing.

• One opportunity can have multiple quotes

Raw Material Items:

• Enter all raw material items directly in GoldFinch; these will routing.

  • Base Material (new field)

  • Width (new field)

  • Length (new field)

  • Bleed (new field)

  • Content Description, to Description

  • Base Unit of Measure is EA

Raw Material Items

• Enter all raw materials directly in GoldFinch; these do not sync back to Salesforce.

• Predefine BOMs (Bill of Materials) and Routings routings are predefined based on Material.

  One Material can have

  , with one Material potentially having multiple components.

• Set up the sales price by Items GoldFinch Sales prices are configured per Item and Customer AccountsAccount.

• Configure a A Cross Reference Table is available to map the Customer Item Number with the GoldFinch Item No.Number.

Order Entry for Repeated Orders

...

All repeated repeat orders are entered directly in GoldFinch Sales Order . Orders can be entered using either the Customer Item NumberNo. or the GoldFinch Item Number for easy cross-referencingNo.