Versions Compared

Version Old Version 8 New Version Current
Changes made by

Scott Zhuo

Scott Zhuo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
stylenone

...

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:Fields for Edit Quote Page: 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

Line No.

Base Material

Width

Length

Bleed

Content Description

Unit Price

Quantity

Line Amount

1

2

Field Details and

...

Usage Instructions

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

    • Convert lookup to picklist for a better user experience

  • Width: Range Enter values ranging from 0 to 120 inches, with 2 decimalsdecimal places.

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

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

    • Convert lookup to picklist for better user experience

  • Content Description: Free text inputentry field.

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

  • Allow to update images per 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) 

  

Tables 

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

Option 

Amount 

  

Bleed 1 

0.2” 

  

Bleed 2

  

  

about 4 options

  

  

  

  1. Material Pricing Table 

...

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

  • Bleed value is from the Bleed Pricing Table.

  • Base Material Price is from the Material Pricing Table.

Bleed Pricing Table

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

Option

Amount

Bleed 1

0.2"

(additional options as needed)

Base Material Pricing Table

...

Name

Code

Amount ($/

ft2

ft²)

 

 

Material A 

Currency

Minimum In2 (Square Inches)

Material A

4 digit Code

$4.

25 

30

CAD

  

1

Material

B 

A

$6

$3.

30 

30

CAD

  

11

Material

C 

A

$8

$2.

40 

30

  

  

  

  

  

CAD

51

Quote Discount

...

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

Discount Code

Discount %

Tier 1

20%

Tier 2

25%

Tier 3

30%

rules on the entire quote.

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

Automatic Product Creation

...

When Upon saving a quote, if the a product does not already exist, automatically create a new product with the following it will be automatically created. The product code follows this format:

Format: ABC123-

...

RXYZ-10-09-001

  • ABC =

    ABC123: 6-digit

    customer code

  • XY = Material Code

    • 10 =

    Account Number (an error will display if the Customer Number is blank when saving a quote)

  • RXYZ: Base Material code

  • 10: Nearest integer for Width in inches (e.g., 10.

    25

    5 inches becomes

    10

    11)

  • 09

    =

    : Nearest integer for Length in inches (e.g., 9.

    25

    45 inches becomes 09)

  • 001

    =

    : Sequential

    value

    number for each quote line

Sales Order Creation for Approved Quotes

...

  • Each Opportunity may have multiple approved quotes.

  • Do not sync quotes to opportunities.

  • Hide Opportuntity Amount.

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

  • Add a button to generate a GoldFinch Sales Order.

  • Create new New items are created if they do not already exist .

  • Establish item formulas and routing.

  • One opportunity can have multiple quotesin GoldFinch, with pre-configured BOMs (Bill of Materials) and 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 material items materials directly in GoldFinch; these will do not sync back to Salesforce.

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

    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 NoNumber..

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.