Definition of Grid: The Active Quotes Grid is a collection of all quotes that are marked as Valid regardless if they are expired or not | |
Column Name | Definition |
BillToAttentionBill To Attention | Contact name of person sending billing invoice to |
BillToCompanyBill To Company | Where you are sending the Billing Invoice to |
BillToLocationBill To Location | Location name in Company Information of Bill To Company record |
BillToMain Bill To Main Fax | Fax number of Bill To Company |
BillToMain Bill To Main Phone | Phone number of Bill To Company |
BillToMarket Bill To Market Type | The Market Type drop down assigned to the Bill To Company Information/record |
Cancelled | If the project was cancelled through the Project > Cancel This Project |
CancelledByCancelled By | Name of user who cancelled the project |
CancelledDateCancelled Date | Date the project was cancelled |
CancelledReasonCancelled Reason | Reason the porject was cancelled |
Ceiling | The Commission Plan ceiling. Configured in the Administrator Application |
ConfirmedWithConfirmed With | Person who signed quote or who authorized order, pulls from Order Entry |
ContractTypeContract Type | The type of contract with the customer, pulls from Order Entry |
CorporateDivisionIDCorporate Division ID | The ID of the corporate division that this project is under. Used to pull the corporate division name |
CreateDateCreate Date | Date of quote creation |
CreatedByCreated By | User name who created quote |
CustomerPOCustomer PO | The customer PO number, set in the Order Entry module |
DecisionDateDecision Date | The decision date assigned in the Project Information module |
DeliverToAttentionDeliver To Attention | The Attention To for the Deliver To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
DeliverToCompanyDeliver To Company | The Company Name for the Deliver To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
DeliverToLocationDeliver To Location | The Location (City, Area, or other naming scheme to separate multiple locations for the same company) for the Deliver To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
DeliverToMain Deliver To Main Fax | The Fax Number for Deliver To on this specific quote. Set in the company information screen when creating the company - entered on quote, then pulled through to Order Entry/Invoice |
DeliverToMain Deliver To Main Phone | The Phone Number for Deliver To on this specific quote. Set in the company information screen when creating the company. Entered on Quote, then pulled through to Order Entry/Invoice |
DiscretionaryTaxDiscretionary Tax | The Discretionary Tax amount on the quote/option. Only applicable to some states. |
DiscretionaryTaxCreditDiscretionary Tax Credit | The Discretionary Tax * The Salesperson Sales Credit on the project |
EstCommCostEst Comm Cost | The cost (sum) based on the BOM where the line item is marked commissionable |
EstCommMarginEst Comm Margin | The sum of profit in the BOM Module for the specific quote/option that is commissionable |
EstCommProfitEst Comm Profit | The sum of profit in the BOM Module for the specific quote/option that is commissionable |
EstCommRateEst Comm Rate | The average commission rate in the BOM module for the specific quote/option |
EstCommSaleEst Comm Sale | The sell (sum) based on the BOM where the line item is marked commissionable |
EstimatedCommissionEstimated Commission | The sum of Commission based on the BOM |
EstimatedCostEstimated Cost | The sum of cost in the BOM Module for the specific quote/option |
EstimatedLaborCostEstimated Labor Cost | The cost in the BOM where the product type is a Labor Product Type for the specific quote/option. Labor Product Types can be configured in Tools > Configure Labor Product Types |
EstimatedLaborSaleEstimated Labor Sale | The sell in the BOM where the product type is a Labor Product Type for the specific quote/option. Labor Product Types can be configured in Tools > Configure Labor Product Types |
EstimatedNonCommCostEstimated Non Comm Cost | The cost (sum) based on the BOM where the line item is not marked commissionable |
EstimatedNonCommSaleEstimated Non Comm Sale | The sell (sum) based on the BOM where the line item is not marked commissionable |
EstimatedSaleEstimated Sale | The sum of sale in the BOM Module for the specific quote/option |
ExpiresOnExpires On | The last date quote is valid for. Quote expiration date |
Floor | The commission plan floor. Configured in the Administrator Application. |
GSA | Checkbox indicating the project is a Direct Bill, pulls from Project Information module |
InstallToAttentionInstall To Attention | The Attention To for the Install To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
InstallToCompanyInstall To Company | The Company Name for the Install To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
InstallToLocationInstall To Location | The Location (City, Area, or other naming scheme to separate multiple locations for the same company) for the Install To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
InstallToMain Install To Main Fax | The Fax Number for Install To on this specific quote. Set in the company information screen when creating the company - entered on quote, then pulled through to Order Entry/Invoice |
InstallToMainPhoneInstall To Main Phone | The Phone Number for Install To on this specific quote. Set in the company information screen when creating the company. Entered on Quote, then pulled through to Order Entry/Invoice |
Last Modified By | The name of user who made changes to the quote last |
Last Modified Date | The last time the quote was changed |
Last Print Date | The last time the quoted was printed |
Last Printed By | The name of the user who printed the quote last |
LastStatusChangeDateLast Status Change Date | The date on which the project status was last changed. The status should be changed automatically based on action items (setup in administrator), but can also be manually changed. |
MostLikelyMost Likely | Checkbox indicating the option(s) on this quote will most likely be ordered |
OrderBook Order Book Date | The date the order was booked on in the Order Entry module |
OrderInvoiceDateOrder Invoice Date | The date the order was invoiced on. Found in the order entry module |
OrderNameOrder Name | The name of the order, set in the Order Entry module |
OrderNoteOrder Note | The Order Note entered in the Order Entry window |
OrderStatusOrder Status | The Status of the order. This is a manual and an automated change. You can and should have the status change based on Workflow , Action Items being checked out and completed. You can include the manual update of the status in your workflow as Completion Tasks on Action Items. This will help you better manage where an order is at in the process. |
OrderTypeOrder Type | The type of order, based on the order entry module "Order Type" drop down |
PrimaryContactPrimary Contact | The name of the Primary Contact from the Project Information screen |
PrimaryContactCompanyPrimary Contact Company | The company the Primary Contact is associated with |
PrimaryContactDirectPhonePrimary Contact Direct Phone | The direct phone number of the Primary Contact |
PrimaryContactEmailPrimary Contact Email | The email address of the Primary Contact |
PrimaryContactMainPhonePrimary Contact Main Phone | The main phone of the Primary Contact |
PrimaryContactMobilePhonePrimary Contact Mobile Phone | The mobile phone of the Primary Contact |
Priority | The priority field in the View Quotes tab. This allows you to assign a sort order to the quotes in the window. |
Probability | Probaility Probability %assigned in the Project Information module |
ProjectContactTypeProject Contact Type | The Project Contact Type from the primary contact on the project (drop down that is project-specific and can be changed accordingly as necessary) |
ProjectIDProject ID | The Project number |
ProjectNameProject Name | The Project Name, pulls from Project Information (Best practice is to put the Company name plus Project name i.e. Bank of Texas - Global Task Chairs for Office 101) |
ProjectOrderIDProject Order ID | The Order ID of the particular order |
ProjectQuoteIDProject Quote ID | The Quote Number of quote, pulls from Bill of Materials / Quote module in View Quotes tab |
ProjectStatusProject Status | The Project Status, pulls from Project Information. This is a manual and an automated change. You can and should have the status changed based on Workflow, Action Items being check out and completed. You can include the manual update of the status in your workflow as a Completion Task. |
ProjectTypeProject Type | The Project Type, pulls from Project Information (The Project Type defines workflow/Action Items) |
QuoteDescriptionQuote Description | Description of quote typed in the View Quotes module |
QuoteNameQuote Name | Name of quote which is automatically the same as the option name from the BOM when initially creating a quote by flipping to the View Quotes tab, but can be manually changed |
QuotePrintTypeQuote Print Type | Type of quote (Line Item or Phase) that is being printed |
RequestedCompleteRequested Complete | The date that the order installation is requested to be completed on. Set in the Order Entry module. |
RequestedInstallStartRequested Install Start | The date that the order installation is requested to be started on. Set in the Order Entry module. |
RequestedShipRequested Ship | The date that should be requested of the vendor for when product should be shipped. Set in the Order Entry Module |
Saleprice | The sell (sum) which does not include any tax amount based on the BOM |
SalePriceCreditSale Price Credit | The Sale Price * The Salesperson Sales Credit on the project |
SalesCreditSales Credit | The percent of sales credit/commission for the salesperson on the project |
Salespeople | A list of all salespeople on the project |
Salesperson | Salesperson assigned as the primary salesperson to the project in the Project Information Window |
SalesTaxSales Tax | The tax (sum) based on the BOM |
SalesTaxCreditSales Tax Credit | The Sales Tax * The Salesperson Sales Credit on the project |
Ship To Main Fax | The Fax Number for Ship To on this specific quote. Set in the company information screen when creating the company - entered on quote, then pulled through to Order Entry/Invoice |
ShipToAttentionShip To Attention | The Attention To for the Ship To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
ShipToCompanyShip To Company | The Company Name for the Ship To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
ShipToLocationShip To Location | The Location (City, Area, or other naming scheme to separate multiple locations for the same company) for the Ship To on this specific quote. Entered on the Quote, then pulled through to Order Entry/Invoice |
ShipToMainPhoneShip To Main Phone | The Phone Number for Ship To on this specific quote. Set in the company information screen when creating the company - entered on quote, then pulled through to Order Entry/Invoice |
ShipViaShip Via | What you would like to ship product by, pulls from order entry |
StatusChangeDaysStatus Change Days | The number of days since the last status change on the project |
SubmittedToCustomerSubmitted To Customer | The date of when the quote was proposed/submitted to the customer which can be manually added in the View Quotes module |
TeamMembersTeam Members | The Team Members on the project, pulls from Project Information |
TermsOfSaleTerms Of Sale | The terms of sale for the invoice .Pulls from the Invoice module |
UseProfitMarginUse Profit Margin | Pulls from the Vendor company record for Direct Bill vendors. Used to set the Vendor Commission to the profit margin on each line item |
Valid | Field from the View Quotes tab in the Bill of Materials / Quotes module of a project and indicates quote is current and relevant |
ValidOptionsCountValid Options Count | The number of options checked off for specific quote |
...