CRM Plus - Quotation

In standard Synergy you can configure your quotation but the options are limited. We have added description fields, workflow and Exact Globe sales order functionalities into Synergy quotation and sales cycle.

Make sure the RPA ConnectIt add-on is aded via the preference

Go to the Setup / Connection / Provider, open the provider Exact Globe And check if the provider is Active.

Go to RPA ConnectIt and go to Setup / Connection / Provider and create a new connection to Exact Globe. For Exact Globe only the SQL connection section is required for the quotation to work. The SQL connection makes use of the back office connection in System / Setup / Back office / Back office connection. This will be automatically filled in when setting up the connection

Go to the RPA ConnectIt menu and go to Setup / Templates / Import, import the ExactGlobeViews.xml from [CRM Plus Installer folder]\Templates\Exact Globe folder and the ExactSynergyView.xml from [CRM Plus Installer folder]\Templates\Exact Synergy folder. This will import the views. The views can be seen via the RPA ConnectIt menu, go to Reports / View / List.

The Exact Globe views were successfully imported

The Exact Synergy views we use in the quotation are: ExactSynergyItems, ExactSynergyVATCodes, ExactSynergyCostcenter, ExactSynergySelectionCode, ExactSynergyDeliveryMethod, ExactSynergyPaymentConditions, ExactSynergyWarehouse, ExactSynergyInvoiceCodes.

Go to Customers menu, and go to Setup > Other > Settings, you will find the following settings

Next quotation number This option allows the administrator to set the next quotation number which is used when creating a quotation.

Convert to back office sales order This option allows the quotation to convert into a sales order in Exact Globe.

Back office item prices This option will look up the item information and prices from Exact Globe.

Request type If an approval flow is required, this option allows the quotation header to be linked to a certain request type. Once it is linked, the quotation will have a workflow section and it will provide more control over each field as far as security, visibility, editability are concerned.

Standard there is a limited set of free fields, the number of free fields in the workflow request is extended. The extra fields and the number of extra free fields that are available:

Request type: Line This option allows the quotation line to be linked to a certain request type. It will also provide more control over each field as far as security, visibility, and editability are concerned.

Standard there is a limited set of free fields, the number of free fields in the workflow request is extended. The extra fields and the number of extra free fields that are available:

Generate quotation after This option allows the Generate Quotation button to show in a certain workflow status.

Generate sales order after This option allows the Generate Sales Order button to show in certain workflow status.

Show Next Action This option allows set visibility of the next action button (Approve,realise,Process).

Show signature field: After This option allows you to set the visibility of the signature after specific statuses such as Open, Approved, Realized, and Processed.

Expiry date: Days This option allows to set the expiry days.

Description line Width (px) This option allows to set the width of line description.

Description line Height Width (px) This option allows to set the height of line description.

Long description line Width(px) This option allows set width of the long description Quotation Lines.

Long description line Height(px) This option allows set height of the long description Quotation Lines.

Show cost & margin This option shows additional cost and margin fields on the line and on the summary. The back-office item prices option must be enabled.

Load template use current price This option allows retrieving the price not from Globe but directly from the template.

Copy use current price This option allows to set default option of update price when copying the Quotation.

Price precision This option allows to set Price precision on the quotation page. When not input, Price precision will be based on currency setting.

Amount precision This option allows to set Amount precision on the quotation page. When not input , Amount precision will based on currency setting.

Parent This option allows the line to have a parent item. Once the item is selected as parent, the item price will roll-up from the child item(s). Only the selected items will be converted into a sales order.

Sales order: Child Lines with price 0 This option allows the line to have Child Lines with price 0. Once the item is selected as parent, the item price will roll-up from the child item(s).

Automatically collapse all lines This option allows to set automatically collapse Child lines when there a Parent checked on Quotation line.

Use Synergy item translation This option will use the translation based on country from the contact person in the quotation. The translated description is coming from the Exact Synergy item translation option.

Iten translations based on account contact This option allows translate the item description based on language of account contact when checked.

Copy: Attachments This option will copy the generated quotation document and any attachment linked to the quote to the sales order in Exact Globe when the sales order is generated.

Don’t allow copy fields from template This option allows to exclude fields at Quotation header that will be load from template. Pattern will be as “PropertyName,PropertyName” and separated by comma. For example: “Description,YouReference”

Owner: Not linked By default, the owner in the quotation is the person in the Exact Globe sales order. By checking this option, instead of the person in Exact Globe, the account manager in Exact Globe will be filled in.

Generate sales orders: Selected lines This option allows to generate a sales order by line selection and the check-box column will be added to the quotation line in order to make selections.

Selected lines: All This option is to set default the check-box value to true (checked).

Item: Suggestions This option is to set how many item suggestions will be shown.

Suggestion Show by Selected Warehouse Stock This option displays the warehouse stock items based on the line warehouse. If it is not checked, it will display all stock.

Document subject” Quotation number This option allows the quotation number to be set as subject when the quotation is generated.

Quotation owner This option is to set the default value of the quotation owner: creator, account manager or account manager from Exact Globe.

Template When a request process flow template is setup and the quotation is the starting point, this option will start the process flow. When the quote is won (approved, realized or processed), automatically the next follow up request will be created.

Submit: Everyone By default, only the creator can submit the quotation. This option allows other users to submit the quotation.

Update Sales Order This option allows that a sales order still can be updated after the quotation has been changed and vice versa.

Signature This option allows the user to set the signature in the quotation when generate the quotation. The signature can also be added from the signature button at the top.

Total Line This option is to set the default value of Total Line items.

Show alert for item long description This option will display a popup after selecting the item with a long description.

Quotation visibility This option is to display Quotation based on the account manager or account manager creator

Manager specificcustomer This is only for showing with the specific Manager you set. User only can see the account from the manager from the account at CRM search

Quotation template based on account If it’s checked, it will display the Quotation template from the account itself.

Custom query item suggestion This custom item description is using a query to dynamically generate additional details on item suggestions. Example:”SELECT ‘SearchCode:’ + ISNULL(Items.SearchCode,”) AS AddDesc,Item.ItemCode As Item FROM Items”

Column item suggestion This column is used to link item when JOIN the table item suggestions. Example: “Item”

Column description suggestion This column allows for custom description suggestions based on the query. Example: “AddDesc”

Custom JavaScript Used to customize the JavaScript functionality for other custom actions.

Copy Remark Quotation To Remark Workflow When checked, the remark from the quotation will be copied to the remark in the workflow.

Quotation lines use default price list This column allows you to set the default pricelist as salesprice at the quotation lines.

Template document type This column allows you to set the document type as a body email template.

Quotation attachment document type This column allows you to set the document type as an attachment.

Quotation attachment word merge template This column allows you to set the WordMerge template as an attachment.

Quotation email Cc To set the default email cc.

Quotation email Bcc To set the default email bcc.

Quotation email from To set the default email “From”. There are three types to set the from email.

• Creator : set the email from based on the creator of the quotation
• Owner : set the email from based on the Owner
• Current user logged in : set the email from based on the user login.

To 1, To 2, To 3 These fields allow you to set the email recipients in the “To” field. You can specify up to three email addresses, and there are six types available for setting the email.

• Blank column: can set the email manually
• Creator: set the “To” based on the creator
• Owner: set the “To” based on the owner
• Current user (Name): Set the “To”: based on the Current user
• Contacts: set the “To” based on the Contacts
• Main Contact: set the “To” based on the Main Contact

Cc 1, Cc 2, Cc 3 These fields allow you to set the email recipients in the “Cc” field. You can specify up to three email addresses, and there are six types available for setting the email.

• Blank column: can set the email manually
• Creator: set the “Cc” based on the creator
• Owner: set the “Cc” based on the owner
• Current user (Name): Set the “CC”: based on the Current user
• Contacts: set the “Cc” based on the Contacts
• Main Contact: set the “Cc” based on the Main Contact

Bcc 1, Bcc 2, Bcc 3 These fields allow you to set the email recipients in the “Bcc” field. You can specify up to three email addresses, and there are six types available for setting the email.

• Blank column: can set the email manually
• Creator: set the “Bcc” based on the creator
• Owner: set the “Bcc” based on the owner
• Current user (Name): Set the “Bcc”: based on the Current user
• Contacts: set the “Bcc” based on the Contacts
• Main Contact: set the “Bcc” based on the Main Contact

Default template 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 These fields are for selecting a template directly from the document. You can set up to 10 default templates, and in the filter column, you can specify conditions. The conditions will be applied based on the criteria you define.

Email Suggestion From Cache When this box is checked, suggestions will be based on the cache. If it is not checked, suggestions will be retrieved from the database.

Email Suggestion Min Characters This column is used to set the number of characters required to display email suggestions. By default, it is set to 3 characters. The suggestions apply only to the “To,” “Cc,” and “Bcc” fields.

To add the extra fields, go to Modules > Customers > Setup > Other > Settings > Click Edit ,Click on the Request type or Request type: Line selected.

Select fields tab, then click add button

Free text field (1-15) This field is used for fields with alphanumeric values, for example: ‘Description1’. To set the label, click edit button, then rename the term from Free: … to the label we want, for example: ‘Description’. To set the visibility, click the check box that you want to change

Free guid field (1-15) This field is used for fields with GUID values, for example: ‘5D883DBE-2622-4F0F-BE92-75B269EF14C2’ In the selection section, select Reference, for example: ‘Accounts’, to display the data ‘Accounts’ on the browser, and in the Selection field to filter data, you can see the Example in the below Selection section.

Free number field (1-15) This field is used for fields with numeric values, for example: ‘1000’. To set the editability, click the check box that you want to change. We can also edit the Security level and select the Role to set the Role or Security level who can edit the field. To set mandatory, click the check box that you want to change.

Free yes/no field (1-15) This field is used for fields with yes/no values, when the yes/no field is selected it means yes.

Free amount field (1-15) This field is usually used for fields that contain the amount or price, for example ‘400,000.00’

Free date field (1-15) This field is used for fields with date values, for example: ‘08-04-2022’.

Free comment field (1-15) This field is usually used in remarks fields that require a long description.

After adding Extra field, new section ‘Extra’ will appear with the extra fields added.

The setup of Word Merge documents is completed in the path of Modules > Documents > Setup > Word Merge > Templates > (Specific Template).

Open the specific template and go to the Settings subheading. You will see two new option fields at the bottom of the screen.

The first option “Convert to PDF” when checked will create both the Word Document (.docx) and the PDF Document (.pdf) and store them as a attachments in the Document.

The second option “Replace Document with PDF” when checked will create the Word Document (*.docx) and store it as an attachment in the Document.

The third option “Convert to PDF & Replace Document with PDF” when both are checked will create only the PDF Document (*.pdf) and store them as an attachment in the Document.

Add how to generate quotation until create a word merge Go to Modules > Customers > Entry > Quotation. Fill in all the required fields to create a quotation, then click Generate Quotation button.

Select the template to use

Fill in the subject in the Header section, then click create letter button

Word merge document has been created successfully. You can find this document in Modules > Documents > Reports > Documents > Search > Show

This feature allows you to create quotations in PDF directly from the use of Exact Word merge. Three possible options to use this feature are: Create a Word Merge Document and Save it as a *.DOCX file (Standard Synergy Functionality)

Create a Word Merge Document and Save it as a *.PDF file

Create a Word Merge Document and Save it as a *.DOCX file and a *.pdf file

Below is the result of word merge:

Exact Word Merge now allows you the flexibility to create additional entities and fields for the metadata and schemas used in generating Word Merge templates. For more detail you can following this link: https://www.exactsoftware.com/docs/DocView.aspx?DocumentID=%7bc74db887-b974-432c-a978-b3ccd42cfe05%7d

ExactGlobeItems / ExactSynergyItems ExactGlobeItems (Line), TaxCode (Line), ExactGlobeCostcenter (Header), ExactGlobeSelectionCode (Header), ShippingViaCode (Header), PaymentCondition (Header), Warehouse (Header), InvoicesCode (Header).

This view is used in the Item field in the quotation line, when create a new quotation via Modules / Customers / Entry / Quotation / Quotation section / type in manually or click F2 in the Item field.

ExactGlobeVATCodes / ExactSynergyVATCodes This view is used in the Tax Code field in the quotation line, when create a new quotation via Modules / Customers / Entry / Quotation / Quotation section / type in manually or click F2 in the Tax Code field.

ExactGlobeCostcenter / ExactSynergyCostcenter This view is used in the Shipping via field in the quotation header, when create a new quotation via Modules / Customers / Entry / Quotation / Conditions section / click browse field or click F2 in the Cost centre field.

ExactGlobeSelectionCode / ExactSynergySelectionCode This view is used in the Selection code field in the quotation header, when create a new quotation via Modules / Customers / Entry / Quotation / Conditions section / click browse field or click F2 in the Selection code field.

ExactGlobeDeliveryMethod / ExactSynergyDeliveryMethod This view is used in the Shipping via field in the quotation header, when create a new quotation via Modules / Customers / Entry / Quotation / Quotation sections / click browse field or click F2 in the Shipping via field.

ExactGlobePaymentConditions / ExactSynergyPaymentConditions This view is used in the Payment condition field in the quotation header, when create a new quotation via Modules / Customers / Entry / Quotation / Conditions section / click browse field or click F2 in the Payment condition field.

ExactGlobeWarehouse / ExactSynergyWarehouse This view is used in the Warehouse field in the quotation header, when create a new quotation via Modules / Customers / Entry / Quotation / Conditions section / click browse field or click F2 in the Warehouse field.

ExactGlobeInvoiceCodes / ExactSynergyInvoiceCodes This view is used in the Invoice code field in the quotation header, when create a new quotation via Modules / Customers / Entry / Quotation / Conditions section / select combo box in the Invoice code field. Refer to RPA ConnectIt manual in the installer, see paragraph View builder, maintain View and maintainView column.

For the item lookup/browser in the quotation lines, the ExactGlobeItems view is used. You can make changes to this view if more columns are needed. Instructions for maintaining a view can be found in the RPA ConnectIt manual.

After you have imported the view, you will see several item views that can be used:

• ExactGlobeItems
• xactGlobeItems2 — also makes use of item classes in Exact Globe
• ExactGlobeItemsByCustomerPriceList — the customer is passed on as a parameter to the view and to Exact Globe, to only show items linked to the pricelist associated with the customer.

To use a view other than the standard view rename the view you want to use to ExactGlobeItems (first rename the default view to ExactGlobeItemsDefault for example).

The quotation also can be shown to the customer via customer portal. Some additional setup is needed to make the quote available for the customer.

The customer menu is not available in the customer portal. To give the customer access to the quotation page and quotation search page add a new link widget to the customer workspace.

For the quotation page add a widget which is using the following link GLMSysCRMPlusQuotationMaint.aspx?BCAction=0

For the quotation search page add a widget which is using the following link GLMSysCRMPlusQuotationSearch.aspx

CRM Plus quotation integrates with standard Synergy sales cycle, from opportunity to quotation. Instructions for creating sales cycles and their use can be found in documents provided by Exact Software.

Go to Modules > Customers > Setup > Opportunity management > Sales cycles. Click New button to create new Sales cycles.

Fill in the description header, description line, then press f2 or click browse to select a request type, then select request status in the combo box, and click Save button to save new cycles.

Opportunity

Go to Modules > Customers > Entry > Entry > Opportunity to create new opportunity. Fill in the description field, select Account, select Contact, fill in the Probability (%) field, select Project, fill in Planned amount field, select End Date, select Source, select Sales cycles, select Currency, then fill in remarks field, and click save to save the opportunity.

Opportunity will be created

Click View flow button to view the flow. Click in the request number to see the request details.

Click approve button to approve the request.

The status will update to: Approved. Then click again in the request number

Process it, until Process flow.

The status will update to: Processed and Completed.

Click on Quotation number to the next step. Select an item, and approve the quotation.

The status will update to: Approved. Then click again in the quotation number

Process it, until Process flow

The status will update to: Processed and Completed.

Open the quotation again, then click Generate Quotation button

Select template

Filled in the subject, then click Create letter button

Word merge document will be created, click Close button

Click on the Create Sales Order button

The Sales Order will be created

Open Exact Globe to check the Sales Order that has been created, via Order/Entries/Sales Orders. Sales Order that has been created will appear at the top of the Sales Orders menu

Double click or click on the Open button to see the details

Quotation is ready for use

There’s a script file on the installer folder named “GLMSysCRMPlusQuotationAddOn.js”, in this script we can add another custom script inside the functions which related to those specific function.

function GridRowAddded() {
  //your custom code here
}

function QuotationItemChangedAddOn(index, itemcode) {
  //your custom code here
}

function QuotationQuantityOrPriceChangedAddOn(row, action) {
  //your custom code here
}

Below is the details when will the function be called.

• GridRowAdded: This function will be called when the row of Quotation Line being added.

• QuotationItemChangedAddOn: This function will be called when the item field on the Quotation Line is being changed. “index” parameter determine from which index Quotation Line is being called, “itemcode” parameter determine from which itemcode is function being called.

• QuotationQuantityOrPriceChangeAddOn: This function will be called when the quantity or price field on the quotation line is being changed. “row” parameter determine from which row Quotation Line is being called, “action” parameter determine from which action is being called was its quantity changed or price changed.

The available action:

ItemChanged = 0 QuantityChanged = 1 PriceChanged = 2 DiscountPercentageChanged = 3 NetPriceChanged = 4 CurrencyChanged = 5 AmountChanged = 6 DeliveryDateChanged = 7 DiscountAmountChanged = 8 DeleteLine = 11 TaxCodeChanged = 12 ItemPriceChanged = 13 PriceListChanged = 14 UnitChanged = 15 GetItemSuggestion = 16 AvailableStock = 17 NettPriceHistory = 18 NettPriceHistoryCount = 19

For example :

QuotationItemChangedAddOn(index, itemcode) {
  //your custom code here
}

CalculatLineAmountAddOn(index);{
  //your custom code here
}

function QuotationQuantityOrPriceChangedAddOn(row, action) {
  CalculatLineAmountAddOn(row);
}

Below an example to recalculate the amount field 3 as “total price” and total amount when item changed / quantity changed / Price changed based on another free fields.

function CalculatLineAmountAddOn(index) {
  var amountPrecision = SysGetValue('AmountPrecision');
  var qty = parseFloat(SysGetValue(index + ' LineQuantity').replace(",", ""));
  var pricePerUom = parseFloat(SysGetValue(index + '_LinePrice').replace(",", ""));
  var cartagePrice = parseFloat(SysGetValue(index + '_LineAmountField2').replace(",", ""));

  if (isNaN(cartagePrice)) {
    cartagePrice = 0;
    SysSetValue(index + ' LineAmountField2', SysFormatNumber(0, amountPrecision));
  }

  var totalPrice = pricePerUom + cartagePrice;
  var amount = (pricePerUom + cartagePrice) * qty;
  var taxPercentage = parseFloat(SysGetValue(index + 'LineTaxPercentage').replace(",", ""));

  if (isNaN(taxPercentage)) {
    taxPercentage = 0;

    var taxAmount = amount * (taxPercentage / 100);
    var totalAmount = amount + taxAmount;

    SysSetValue(index + 'LineAmountField3', SysFormatNumber(totalPrice, amountPrecision));
    SysSetValue(index + ' LineAmount', SysFormatNumber(totalAmount, amountPrecision));

    UpdateSummaryAddOn();
  }
}

When an error message like this appears, please contact your implementation partner or us so that we can review your Exact Synergy Enterprise license from Exact and determine if changes were made to it that affect the GLM Licensing.

Error Message CRMPlus No valid license installed. Number: 140965:101:007 Name: Exact Synergy Enterprise.

We are recommending that accounts before they update their Synergy License (either for new Functionality, Annual Contract or Additional Users – we are contacted first so that we may review and if necessary, provide a new license proactively.)

It could be that when another pricelist is selected an ‘Object reference not set to an instance of an object’ message is shown as in the screenshot below. To solve this, follow the steps described in Add Exact Globe Browsers. After this run IISRESET or clear the cache from Synergy via System > Reports > Activity Session as the browsers are stored in the cache.

When this error message is shown when generating the sales order, the property UnitCode is missing from the business component ‘BOSalesOrderLineEG’. Standard this property is not available, the installation xml folder has a modified Repository.Sales.xml which has this property. The Repository.Sales.xml would be overwritten when an Exact Synergy update is done, this could be an update of a service pack or update to a newer version of Exact Synergy. To solve this, try to re-install the installation and do a rebuild of the repository in System > Setup > Repository > Rebuild.

After the repository rebuild run IISRESET or clear the cache from Synergy via System > Reports >Activity > Session as the browsers are stored in the cache.

When this error message is shown when generating the sales order, make sure the username and password that entered on the RPA Exact Globe connection are correct.

When accessing synergy through another machine/server the back office cannot authenticate without fixed credential and will show the error ‘Error accessing entity service: The caller was not authenticated by the service’ after choosing an item in the quotation lines.

To solve this, make sure the back office connection is using fixed credentials, you can go to back office connection, go to System go to / Setup /Back office / Back office connection.

The user must exist in Exact Globe with the same user name (System / HR & Security / People). In the error that is shown, it will also show the username that is missing. For the user that is created, access to Exact Globe is not needed. After creating the user in Exact Globe, you can continue.

When clicking for example Shipping via browser and you see the ‘You have insufficient rights to perform this operation’ import the ExactGlobe views again from the Templates\Exact Globe folder. In the ExactGlobe views the view are set to security level so that the customer also can browse on the data.

This error will appear in the process of generating quotation, when Configuration: Exact Word Merge Integrator configuration is not set to Active.

To activate Configuration: Exact Word Merge Integrator, Open Exact Lightweight Integration Server Console (ELIS), then Connect to the server, click on Exact Word Merge Integrator, then tick Active to Word Merge Name to be activated, then click Yes.

This error will appear

This issue occurs when trying to create a sales order. The problem is caused by the metadata for salesorderline Exact Globe not being copied or installed yet. To fix it you can Install the CRMPlus Globe 419 is already on the installer with folder name “CRM Plus Quotation – Setup -2021108”, When install it you can pointing to the directory Exact Globe folder for example “C:\Program Files (x86)\Exact Software”or you can copy manually the XMD folder to the XMD folder on the Exact Globe folder.

If the column designed to display numerical values in the output, then changes the domain into ‘5NumberPresc0’.