Credit-Check App powered by Creditsafe#
Overview#
With the Credit-Check App powered by Creditsafe you can check the solvency of your (future) customers, partners or service providers, reduce your credit risk and thus build long-term successful business relationships. KUMAVISION Credit-Check App powered by Creditsafe gives you easy access to the world's most widely used credit report "Creditsafe", directly from Microsoft Dynamics 365 Business Central1.
The Credit-Check App powered by Creditsafe offers you the following advantages:
- Daily updated credit check reports incl. inquiry logging
- Queries from Business Central incl. direct contact creation
- Company monitoring
- Automatic data update cycle
- Address validation for matching and updating of company & address data in Business Central
- Pre-built workflows for setting credit limits or blocking a contact based on the credit rating
- Cost control and budget security through fixed price model
You reduce your processing times and identify risks at an early stage to avoid bad debt losses. Outdated data and double entries are a thing of the past - always work with validated customer/vendor and contact data with correct company name and address.
Introduction Credit-Check App powered by Creditsafe#
See the following playlist for more videos explaining the app's functions:
Link to Microsoft App Source "KUMAVISION Credit-Check App powered by Creditsafe"
More learning resources#
Besides this article, you can consult the following user-friendly resources to learn more about the Sales Order Status feature:
Product videos
To see all videos about the app, use the general search function in Microsoft Dynamics 365 Business Central1 and enter Product Videos. Pick a video from the page and run it.
Tours
You can also take a tour explaining the app’s most important features. When you’re on a page that includes Sales Order Status content, go to the ribbon at the top, choose the Help icon, and then select Take a Tour in the first About… FactBox.
Setup#
In order to use the Credit-Check App powered by Creditsafe, some settings have to be made in advance. On the one hand, this concerns the setup and assignment of users and permission sets and the basic setup of the "Creditsafe Global Gateway Services" for credit reporting. The individual setup steps for the connection are listed and explained in more detail below.
Registration#
After successful installation, the app must be registered for use free of charge. Please return to the Business Central Role Center and confirm the pop-up prompt for registration.
User permission#
By installing the Credit-Check App powered by Creditsafe, three different permissions are automatically integrated into your Business Central application. By assigning these permissions to your user or user groups, you ensure that the respective users have access to the integration and, depending on the assigned set, are allowed to view or request credit reports.
| Permission Sets | Description |
|---|---|
| KVSCRSSETUP | This permission set grants the respective user full access rights to the application. • set up the application • create new queries • view credit reports |
| KVSCRSEDIT | This permission set grants the user the following access rights: • create new queries • View credit reports |
| KVSCRSVIEW | This permission set grants the user the following access rights: • View credit reports |
Wizard Creditsafe Credit Check#
For the setup, you can use a wizard that guides you through each of the required steps. You can open the wizard via Assisted Setup > Set up Credit Check. Alternatively, you can perform the setup manually.
| Wizard Step | Description |
|---|---|
| Welcome | At the beginning, a welcome message appears. Click Next to continue. |
| Creditsafe Account | If you already have a Creditsafe account, click Next to continue. If you do not have an account. Please click on the following link to activate your free trial access with Creditsafe: Link to Creditsafe Belgien Link to Creditsafe Germany Link to Creditsafe France Link to Creditsafe Italy Link to Creditsafe Netherlands Link to Creditsafe Great Britain Link to Creditsafe United States of America |
| Connection information | Add your connection informations and click Next to continue. |
| Service URL | Add the URL for the Creditsafe web service. By default, this field is filled with the URL commonly used in Germany: https://connect.creditsafe.com/v1 |
| Setup user | You can create a new user via the Setup User button. The corresponding fields are explained below: Creditsafe User Name: Add your username provided by Creditsafe for the connection. This field is mandatory. Creditsafe Password: Add your password provided by Creditsafe for the connection here. The password will be stored encrypted in the database. Close the User Setup page and click Next in the wizard. |
| Modify Countries | In Microsoft Dynamics 365 Business Central1, country codes are used like Creditsafe. As the codes utilized in both systems do not necessarily match, it is necessary to assign the Business Central country codes to the corresponding Creditsafe country codes. By the Modify Countries action, the country codes from Creditsafe will be queried and then assigned in Microsoft Dynamics 365 Business Central1. A connection to the Creditsafe service is required to retrieve data. If you have not yet granted access to this service, you can authorise access either once or permanently. After the countries have been retrieved from the Creditsafe service, the current list will appear on the Business Central page. There, all Creditsafe countries for which you have authorisation will be shown. If a corresponding Business Central code exists for a Creditsafe country code, the assignment will be made automatically in the Country Code field. Please check the assignments and adjust, if necessary, by selecting the country code from Business Central.Using the Preferred Language field, you can select the desired language for a credit report from the respective country by clicking the selection button. Only the languages supported by the Creditsafe API for queries in that country will be displayed. This field is only visible if you use the Creditsafe Connect API; it does not appear when using the Creditsafe Global Gateway Service. Close the Creditsafe Countries page by clicking OK and click Next in the wizard to proceed to the next installation step. |
| Basic settings | In the "Basic settings" window you can make various settings as well as defaults. Default E-Mail address for Offline Report: If a report cannot be requested online, you have the option within the app to request an offline report from Creditsafe. To ensure that this report can be sent to you easily by e-mail and for any queries on the part of Creditsafe, please use the "Default e-mail address for offline report" field to specify which e-mail address should be used for this purpose. Default Language: Use the "Default language" field to specify the language in which you would like to receive the credit check reports. If the report is available in the selected language, it will be retrieved accordingly. Default Language (secondary): Use the "Default language (alternative)" field to specify the alternative language in which you would like to receive the credit check reports. If the report is not available in the default language, the alternative default language will be used for retrieval. If there is no report in the alternative language either, the available language of the report will be used. Note: Please note that the languages stored here only have an effect if you use the Creditsafe Global Gateway Service for the query. When using the Creditsafe Connect API, it is possible to make language settings for the reports to be called up in the respective country settings of the Creditsafe countries. Default Country: Select as default country the Creditsafe country code through which a company search should be performed by default. In the company search, you can search for companies that are not yet created in your database as contacts, customers or vendors. In this case, as well as in cases where the "Country code" field of the contacts, customer or vendor is empty, the country specified here will be suggested for the search, but can be overwritten in the search window. Default Matchtype: When you search for a company on Creditsafe, specifying the company name, the search is performed for the entire term or partial words. Specify here the search type you want to use to search for companies by default. Possible values are: MatchBeginning: Searches at the beginning of the company name for the exact term specified Example: "Testfirma GmbH & Co. KG" will be found by "Test", "Testfirma", "Testfirma Gmb" etc. MatchBlock: Searches for a partial text within the company name Example: "Testfirma GmbH & Co. KG" is found by "estfirm", "GmbH", "irma" etc. MatchAnyPars: Searches for text blocks in the company name - One block per search term Example: "Alpha Bravo charlie Co. KG" is found by "alph ravo", "lpha harl" etc. MatchWords: Searches for whole words regardless of the order Example: "Testfirma GmbH & Co. KG" is found by "gmbH Testfirma", "KG GmbH" etc MatchBlockOrWords: Combination of MatchBlock and MatchWords Searches partial texts as well as whole words regardless of the order. ExactValue Searches for the entire exact partial text Example: "Testfirma GmbH & Co. KG" is found by "testfirma gmbH & co. kg". ClosestKeywords Searches for any keyword using a "fuzzy" logic (similar to fuzzy search) Example: "Alpha Bravo charlie Co. KG" is found by "brava", "brawo" etc. The possible search modes vary depending on the country used. If you have any questions about this, please contact your Creditsafe representative. The default setting for Germany is "MatchWords". |
| Default DE Reason Code | In Germany, it is mandatory that a cause code for the query is transmitted in the course of a credit check query. In this field, specify the default DE cause code to be used by default. You can override the DE cause code within the company search. The code specified here is used only as a default value. Possible values are: • Credit Decisioning • Credit – Assessment – Future business connection (with credit risk) • Credit – Assessment – Existing business connection (with credit risk) • Realisation check receivables collection • Purchase Contract – Intention of signature of purchase contract (with credit risk) • Goods Credit Insurance (with credit risk) • Contract – Intention of signature of leasing or rent contract (with credit risk) • Insurance Contract – Intention of signature of a insurance contract (with credit risk). The default setting is Credit – Assessment – Existing business connection (with credit risk). Click Next in the current step of the setup wizard to proceed to the next installation step. |
| Advanced settings | In the advanced settings you can define which automation steps should be executed by the connection and how the application should react to changed data. Modify Name & Address Use this field to specify how the application should handle changed company or address data in the course of retrieving credit check reports. The possible options are: Prompt User Unless the query is run in the background, if name or address information is changed, a page will open prompting the user to accept individual or all of the changed data. Always Changed company name or address information is always automatically transferred to the address master by the application. There is no separate query to the user. Never Changes to the company name or address data will not be accepted. The default value of the application is: Prompt User Regular Update Interval The application provides a batch run that is used to update the existing credit check reports at a regular interval. This run is executed every day and, depending on the date formula stored here, checks whether the last successfully retrieved credit check report is out of date. If this is the case, a current report is automatically retrieved. The default value of the application is: 6M. This will automatically update credit reports every 6 months. Request Report with Job Queue Provided that this toggle is activated, credit check reports for known Creditsafe addresses are queried in the background. The advantage of this method is that the user does not have to wait for the query and the processing of the result, but can continue working in parallel. The prerequisite for background processing is that the contact/customer/vendor to be queried already contains an assigned Creditsafe ID. If this is not the case, the company search is started and the query cannot be performed automatically in the background due to the required selection of the correct company. Job Queue Category Code Provided that the task queue is to be used for querying credit check reports in the background, you can specify a category for grouping the queue entries here. Notify On Success Provided that this toggle is activated to be informed about the notifications after a background check has been performed and a new credit report is available. The system automatically generates a notification, the link to which allows you to branch directly to the master record of the contact/customer/vendor. Click Next in the current step of the setup wizard to proceed to the next installation step. |
| Portfolios | Via portfolios, it is possible in Creditsafe to group selected companies and, for example, to enable monitoring of a group. Select the Modify Portfolios function to retrieve the portfolios already stored in Creditsafe and save them in a Microsoft Dynamics 365 Business Central1 table. Once retrieved, the portfolios will be shown in a Microsoft Dynamics 365 Business Central1 page. For more information on managing portfolios, see "Managing Portfolios“. Click Next in the current step of the setup wizard to proceed to the next installation step. |
| Job queue entries | Job queue entries allow you to manage automations that perform time-based or change-based updates to credit reports in conjunction with the Creditsafe connection. Select the Open Job Queue Entries action to open the Job Queue Entries page. In this page, two jobs have been integrated by "Credit-Check App powered by Creditsafe", but not activated. Thus, you can decide for yourself whether automatic updates should occur or not. Codeunit 70259982 - KVSCRSJobUpdatePortfolio This job is called by default once a day on each weekday and updates the companies named in a portfolio if they have undergone a change by Creditsafe. The batch automatically queries the portfolios and if changed companies are named by the query, the updated credit check reports for these companies are obtained in the background. Codeunit 70259981 - KVSCRSJobIntervalUpdateReport This job is called by default once a day on each weekday and updates the companies whose last successfully retrieved credit check report is older than the date specified due to the date formula in Update Cycle in combination with the current date. The batch checks the date of the last report for all assigned Creditsafe companies in the master data and performs the credit check queries for the corresponding companies in the background. Click Next in the current step of the setup wizard to proceed to the next installation step. |
| Workflows | Workflows can be used to perform actions in Microsoft Dynamics 365 Business Central1 depending on events or record changes. This logic has been extended by Credit-Check App powered by Creditsafe to include the event of a new successful credit report retrieval. Select the Open Workflows action to get to the list of workflows where you can create new workflows based on workflow templates. Two workflow templates have been created automatically: • Block a Customer or vendor due to a creditsafe credit check report • Set a credit limit for a customer based on the creditsafe credit check report Both workflow templates are assigned to the new category Creditsafe and can be used to set the credit limit or block a customer/vendor based on the values of a new credit report. Click on Next in the current step of the setup wizard to proceed to the next installation step. |
| Assign Contacts | The action Assign Contacts can be used for the first assignment of Creditsafe IDs to already created contacts. Before the credit check reports of a contact/customer/vendor can be retrieved, an assignment to a Creditsafe ID is mandatory. While this step is done automatically for the selected master record in the course of the individual retrieval of a report from the contact/customer/vendor card, an assignment can be made at this point for all already created contacts via the action Assign Contacts. If a contact is linked to a customer or vendor, the Creditsafe ID will also be assigned to the linked record. After calling the action, a Creditsafe company search will be executed with the default parameters for the search mode and the DE cause code. You can still narrow down the contacts to be searched within the call by setting appropriate filters on the contacts. For example, only the contacts with a country/region code "DE" for Germany are retrieved. Likewise, other arbitrary filters are possible for restriction. Since this process makes a query to the Creditsafe system for each record, this process takes a corresponding amount of time. After the search has been completed, a page is shown with all contacts that have not yet assigned a Creditsafe ID. In the column Number of found Creditsafe companies you can see how many companies were found for the search entry. By clicking on the number, you can view the different companies. Using the action New > Assign unique IDs, you can automatically include all IDs that could be uniquely assigned ("Number of found Creditsafe companies" = 1) in the assignment. For all contacts for which more than one entry was found, you have to make an assignment manually by clicking on the number in the column Number of found Creditsafe companies and a subsequent selection of the corresponding company entry. If no company can be assigned to a contact ("Number of found Creditsafe companies" = 0), you can open the company search by clicking on the number and adjust the transferred search parameters for a new individual search. After adjusting the search parameters (e.g. by removing the address and/or the postal code) and calling up the search again (shortcut: Ctrl+F), the company can be found and is assigned by clicking on "OK". Click "Next" in the current step of the setup wizard to proceed to the next installation step. |
| Vendor Rating Connection | This setup step is only available if the app "Vendor Rating Management“ of KUMAVISION AG is installed parallel to this app! Vendor Rating Authentication Type This field is only visible in on-premise environments! The field can be used to control whether the authentication of the API connection should be done via OAuth2 authentication or Basic Authentication. Vendor Rating User ID This field is only visible in on-premise environments! In this field, the user ID must be entered, via which data is passed on to the Vendor Rating Management module. Password This field is only visible in on-premise environments! The user's password must be entered in this field to ensure connection via the API interface. Vendor Rating AAD-Application This field is only visible in SaaS environments or when selecting the Vendor Rating Authentication Type OAuth2! In this field, select the "Azure Active Directory Application" to be used for authentication against the API. Vendor Rating Connection Client Secret This field is only visible in SaaS environments or when selecting Supplier Rating Authentication Type OAuth2! The "secret key" (Client Secret) of the Azure AD App registration must be stored in this field. Use Vendor Rating Connection This field controls whether to establish an API connection to the Vendor Rating Management (VRM) module. This field contains the following options: Undecided: No decision has been made yet whether to establish a connection between this app and the VRM module. This value is the initial value of the setup. Yes: A connection between this app and VRM module is to be established. In this case, the other fields in the interface setup must be filled in. No: The interface between this app and VRM module should not be used. Vendor Rating Type Code This field is used to set the rating type from the vendor rating module for credit checks. The "Assist" button for this field can be used to reference an existing rating type with the code CREDITSAFE. If no corresponding rating type exists yet, it will be created automatically. Note: If there is not yet an rating type with the code CREDITSAFE, it must be created via the Assist button. A corresponding rating type is necessary to pass the information between the module Credit-Check powered by Creditsafe and the VRM module. |
| Finish setup wizard | This completes the setup of the "Credit-Check App powered by Creditsafe". Click the Finish action to exit the Setup Wizard and close the page. |
If you subsequently want to change setup parameters, you can restart the setup wizard at any time or alternatively open the Credit-Check powered by Creditsafe - Setup via the search icon. In the setup area, the following individual setup steps can also be performed:
- Set up Creditsafe service
- User Setup
- Creditsafe Countries
- Creditsafe Portfolios
- Job Queue Entries
- Workflows
- Vendor Rating Connection (provided that the app "Vendor Rating Management" of KUMAVISION AG is also installed in parallel.)
Vendor Rating Connection#
If the "KUMAVISION Vendor Rating Management“ functionality and the Credit-Check powered by Creditsafe app installed, these two applications can be set up in such a way that credit checks are automatically included in the vendor rating.
Communication between the two functionalities takes place via an API connection, with API calls generally being authenticated via service-to-service authentication.
Only in an on-premise environment, a basic authentication by means of user ID and web service access key can be used as an alternative.
Note
For the general setup of a Service-to-Service (S2S) authentication for API access, please refer to the standard guidance from Microsoft1. https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/automation-apis-using-s2s-authentication However, when assigning user permissions in the Business Central page (Azure Active Directory application map), additively add the user permission record KVSVRMSETUP!
To activate the interface to the supplier rating, the following setups must be made:
| Field | Description |
|---|---|
| Vendor Rating Authentication Type | This field is only visible for On-Premise environments! Using this field you can decide, whether to use OAuth2-Authentication or Basic Authentication for API connection. |
| Vendor Rating User ID | This field is only visible for On-Premise environments! This field must be used to enter the user through which the API interface passes data to the vendor rating functionality. |
| Password | This field is only visible for On-Premise environments! The password of the selected user must be entered in this field to secure the connection via the API interface. |
| Vendor Rating AAD-Application | This field is only visible in SaaS environments or when selecting the Vendor Rating Authentication Type OAuth2! In this field, select the "Azure Active Directory Application" to be used for authentication against the API. |
| Vendor Rating Connection Client Secret | This field is only visible in SaaS environments or when selecting Supplier Rating Authentication Type OAuth2! The "secret key" (Client Secret) of the Azure AD App registration must be stored in this field. |
| Use Vendor Rating Connection | This field controls whether to establish an API connection to the Vendor Rating Management (VRM) functionality. This field contains the following options: Undecided: No decision has been made yet whether to establish a connection between this app and the VRM functionality. This value is the initial value of the setup. Yes: A connection between this app and VRM functionality is to be established. In this case, the other fields in the interface setup must be filled in. No: The interface between this app and VRM functionality should not be used. |
| Vendor Rating Type Code | This field is used to set the rating type from the vendor rating functionality for credit checks. The Assist button for this field can be used to reference an existing rating type with the code CREDITSAFE. If no corresponding rating type exists yet, it will be created automatically. Note: If there is not yet an rating type with the code CREDITSAFE, it must be created via the Assist button. A corresponding rating type is necessary to pass the information between the Credit-Check powered by Creditsafe and the VRM functionality. |
Action "Test Vendor Rating API Connection"#
This action can be used to test the API connection to the Vendor Rating Management (VRM) functionality. The system issues a corresponding message here whether the connection could be established or not.
Functionality#
Through the API interface between the Credit-Check powered by Creditsafe (CRS) and Vendor Rating (VRM) functionalities, vendor rating entries are formed based on the credit reports, which can be processed by the vendor rating functionality.
The rating classification (A - E) from the credit report is used as the basis for the vendor rating entry. If a rating score is stored for the classification, this is transferred to the vendor rating item.
Note
Within the interface between Credit-Check powered by Creditsafe and Vendor Rating Management, one vendor rating entry is generated for each credit check.
Use credit check#
Query credit report#
Two different ways are offered for retrieving the credit check information. The use of the respective step depends, for example, on whether a business relationship already exists with the company to be queried and thus the data record has already been created as a customer, vendor or contact, or whether it is a matter of initiating a new business relationship and thus no master data record exists yet.
While it is possible to retrieve current credit check information from the respective master record for existing data records, the company search is used for new companies.
Credit rating retrieval via the Creditsafe Company Selections#
To find a company via the Creditsafe Company Selections and retrieve a credit report, open the Creditsafe Company Selections page via the search icon.
In the Creditsafe Company Selections, search information can be entered and a search based on the Creditsafe company database can be started.
Use the "Name", "Address", "Post Code", "City", "Country", "Creditsafe ID", "Creditsafe SafeNumber" and "VAT ID" fields to narrow down the results accordingly.
Use the German Reason Code selection field to specify the reason for the query. In Germany, a legitimate interest in a credit report is legally required. Therefore, please use the selection field to specify the reason for the query.
After entering the search criteria, you can start the company search via the Find action.
The companies found are shown in the hit list. If a company has already been created in your database as a master data record (customer, vendor or contact), then the corresponding hit is shown in color.
In addition to the basic company information, you can also see from the list whether the online report, monitoring, basic report or complete report options are available.
This information is based on the country-specific settings and your individual contract information with Creditsafe.
If a master data record already exists for a hit and the entry is highlighted in color, you can open the respective master data card via Open.
If the respective entry does not yet exist as a master record, you can create the corresponding master record via Start "...create".
By clicking on Get Report you can call up a credit check report for the respective match the respective hit without having to create the data record as a master data record.
In this case, however, the credit check report cannot yet be anchored to a master data record and is therefore offered for download.
Creditworthiness retrieval from the master data#
FactBoxes have been integrated into contact, customer, and vendor cards, which show the most important credit check information for the respective master data records directly.
If you have opened a master data record for which no credit report has yet been created and no Creditsafe ID has been assigned, this FactBox will be empty.
To retrieve a credit report for this contact, click on the heading Last Creditsafe Credit-Check in the FactBox and select the action Do Credit Check.
If no Creditsafe ID has been assigned yet, the Creditsafe Company Search will open first. Select the corresponding hit in order to assign the unique ID.
The credit check report is then retrieved. In addition to the credits check data, the complete address data is also included in the Creditsafe report, so that if there are any differences between the data already stored and the results of the credit check report, the Creditsafe address comparison is displayed. Here you have the possibility to transfer single or all changed field information into the current master record.
Subsequently, the data record is automatically updated and the FactBox Last Creditsafe Credit-Check is displayed with the valid data of the credit report.
View credit information#
FactBox data#
FactBoxes have been integrated within the contact, customer and vendor cards, which directly shown the most important credit check information for the respective master record.
The values shown are:
- Rating (international)
- Rating Description
- Provider-Rating (national)
- Provider-Rating Description
- Proposed Credit Limit
- Main Activity Code
- Main Activity Description
- Latest Turnover
- Number of Employees
- Last Credit Check Report
- Creditsafe ID
- Creditsafe No.
- No. of Portfolios
- Changed Address data
View credit report#
Select the action Last Credit Report / Show Credit Report to shown the PDF report of the last credit query.
Show XML data file#
In addition to the transferred credit check data and the PDF report, by calling the action Last Credit Report / Show XML data file to call up the underlying data file.
Here contains all the information about the company that is also shown in the PDF report.
This file ensures that, for example, at a later point in time, further information on the companies can be imported and interpreted in Business Central tables.
In addition to the allocation to industries, current employee figures and balance sheet information, this also concerns Notes on management / shareholder structure and positive/negative changes.
For an exact representation and description of the data included, please contact your Creditsafe contact.
Reset creditsafe assignment#
If an incorrect Creditsafe ID has been assigned to a company by mistake, the company must be informed accordingly.
To remove the link again. To do this, the incorrectly assigned contact / customer / vendor is called up.
If you call up the Delete Credit check information action within the Last Creditsafe Credit-Check FactBox, the assignment is cancelled.
Credit Check reports that have already been retrieved are marked as Invalid and are no longer used for the display. Consequently, the new company search can be started and the correct company assigned via the Last Credit report / Query Credit Check call.
Note
No retrieved reports or log entries are deleted.
Update address data#
Integration with the Creditsafe WebService not only provides credit check data but also enables the direct transfer of up-to-date and validated address information into Microsoft Dynamics 365 Business Central1. This ensures that no outdated address information is present in the address database.
Depending on the setup, you can specify whether changed address data should be applied automatically, by user query or not at all.
If this setting has the option Prompt User, the user is informed of the changed values with a change mask depending on the processing type of the query.
If background processing is disabled or if the query is from the company search, a change of address page is shown immediately after the report has been retrieved.
If background processing is activated, the Changed address data field in the Last Credit Check Report FactBox for the contact/customer/vendor is shown with the value Yes. In this case, the identical page opens only after clicking on the value Yes.
Within the page the existing address from the data master is shown.
You can transfer any individual value from the master record or the Creditsafe record to the resulting record in the above display by clicking on the value.
If you want to apply all values of a record, you can click the Apply All button either in the Database or Creditsafe column.
Furthermore, the values in the Resulting record area can also be edited manually.
After data maintenance has been completed, you can transfer the values from the resulting data record to the master record using the Update customer or Update vendor or Update contact action.
Afterwards the selected data will be taken over into the master data record. The page Creditsafe address matching closes and the value Changed address data within the FactBox is reset to the value No.
If you do not want to perform any update, you can simply close the Creditsafe Address Matching page. In this case, no changes will be made to the master record and the value Changed address data within the FactBox will remain with the value Yes.
Manage portfolios#
In portfolios at Creditsafe, companies can be grouped in order to be able to monitor them and to start actions depending on events.
The portfolios are exchanged bi-directionally between the (protected) Creditsafe website and your Business Central system, so that a group created in Business Central is also visible from the website access and the contained companies can be seen and edited from both systems.
To create a portfolio in Microsoft Dynamics 365 Business Central1 or check the existing portfolios, open the Creditsafe Portfolios page from the Credit-Check powered by Creditsafe - Setup.
Update portfolios#
Since, in principle, portfolios can be created not only via Credit-Check App powered by Creditsafe, but additionally via the Creditsafe web interface, they must be compared against each other.
While portfolios created in Microsoft Dynamics 365 Business Central1 are automatically transferred to Creditsafe in the background, the Creditsafe website cannot automatically write to the Business Central database.
In order to nevertheless transfer the portfolios created there to Business Central, the action Update portfolios has been developed. After calling this function, a connection to the Creditsafe service is established and the portfolios stored there are retrieved and compared with the portfolios already created in Business Central.
Create portfolio#
To create a new portfolio from Microsoft Dynamics 365 Business Central1, create a new record in the Creditsafe Portfolios page via New action. After you have given the new portfolio a name and the record has been inserted, it is automatically transferred to the Creditsafe service in the background and created there as a new portfolio as well.
Delete portfolio#
To delete an existing portfolio from Microsoft Dynamics 365 Business Central1, switch to the corresponding record in the Creditsafe Portfolios page and start the Delete action.
The portfolio will be deleted in the Business Central database and the delete command will be passed to the Creditsafe service in the background.
Include companies in portfolio#
In order for a company to be monitored within a portfolio, it must be assigned to the portfolio. There are two different ways to do this, which can be used from the respective starting point of the call.
Note
Please note that only companies can be assigned to a portfolio if the property Monitoring possible is activated for the corresponding data set. This property depends on the respective data set as well as on your Creditsafe contract. If you have any questions, please contact your Creditsafe advisor.
Portfolio list - add company#
Provided that you have called the portfolio list from the Credit-Check powered by Creditsafe - Setup, you can call the list of companies assigned to this portfolio by selecting a record and calling the action Companies.
Within the opened list Creditsafe Portfolio Companies you can create a new assignment via New and add the related company to the portfolio by specifying the corresponding Creditsafe ID.
Company card - Add to portfolio#
If you have opened the contact, customer or vendor card of a company that you have assigned to a Portfolio, you can add a portfolio to the FactBox by clicking on No. of Portfolios to open the Creditsafe Portfolio Company page.
Within the opened Creditsafe Portfolio Companies list, you can create a new assignment via New and add the company to the respective portfolio by specifying the corresponding portfolio.
Remove company from portfolio#
To remove a company from monitoring within a portfolio, there are two different ways that can be used starting from the respective starting point of the call.
Portfolio list - remove company#
Open the portfolio list from the Credit-Check powered by Creditsafe - Setup, you can use selecting a record and invoking the Companies will bring up the list of companies that are are allocated to this portfolio.
Within the opened Creditsafe Portfolio Company list, you can use Delete to delete remove an existing assignment. The change is sent directly after the action to the Creditsafe service forwarded, so that the assignment is also removed on the Creditsafe website.
Company card - Remove from portfolio#
If you have opened the contact, customer or vendor card of a company that you want to remove from a portfolio, within the FactBox you can use the link of No. of Portfolios to open the Creditsafe Portfolio Company page.
Within the opened Creditsafe Portfolio Company list, you can use Delete to delete remove an existing assignment. The change is sent directly after the action to the Creditsafe service forwarded, so that the assignment is also removed on the Creditsafe website.
Creditsafe Requests#
In the Creditsafe Requests, every query made against the Creditsafe web service is procollated. You can open this page via the search icon.
In this list, all performed queries are listed chronologically. The query parameters are shown as well as the date & time and the user ID of the querier. Furthermore, the response data as well as the response date and time are listed. The status and the status description are also included, so that in the event of an error, the status description can be used for troubleshooting.
Depending on the query type, the actions can be used to display the credit check report or the response XML data structure.
Set up Job Queue Entries#
Two Job Queue Entries have been automatically created via the Credit-Check powered by Creditsafe - Setup. The list of Job Queue Entries can be opened via the search icon.
Update cycle#
The job queue entry "KVSCRSJobIntervalUpdateReport" is based on the code unit 70259981 and can be used to trigger a regular update of the credit check reports depending on the setup parameter Update cycle.
The job start time is set to "04:00" by default and can be customized.
Note
The update run only takes into account companies for which online report retrieval is possible. If only an offline report is available for a company due to company or country restrictions, it will not be automatically re-requested.
Update portfolio#
The job queue entries "KVSCRSJobUpdatePortfolio" is based on code unit 70259982 and is used to query the created portfolios at regular intervals and to automatically update the credit check reports for the changed master data in the event of changed data. The start time of the task is set to the value "02:00" by default and can be customized.
Via the creation of the job queue entry, both job are created as Recurring tasks with a Number of minutes between executions of 1440, which corresponds to a daily run. If a different rotation is desired, the parameters of the task queue items can be changed here.
Note
The update run only takes into account companies for which online report retrieval is possible. If only an offline report is available for a company due to company or country restrictions, it will not be automatically re-requested.
Set up workflows#
About the setup of Credit-Check App powered by Creditsafe two workflow templates have been created, which are can be used to create workflows that react in the background to changes in credit check.
Workflow template KVSCREDITSAFE-BLOCK - "Block a customer/vendor due to a credit report"#
The workflow template "KVSCREDITSAFE-BLOCK" / "Create a customer/vendor based on a credit report Block" is set up by default in such a way that when a new credit check report is created for a customer or vendor, if the valuation of the report shows the value "D" or "E", first the credit limit is set according to the proposed credit limit of the credit report and then the Master record is locked.
Workflow template KVSCREDITSAFE-LIMIT - "Set credit limit based on credit report"#
The workflow template "KVSCREDITSAFE-LIMIT" / "Set credit limit based on credit report" sets on the basis of a newly prepared credit check report for a customer, the credit limit is increased to the level set by Creditsafe proposed value unless the valuation of the customer corresponds to the value "D" or "E".