Configuration & Administration

Permission sets

In order to use the modules, the appropriate authorization set must be assigned to the respective users.

The following are supplied with:

image-1647268401269.png

DEXPRO Core

The DEXPRO Core manages the individual DEXPRO apps and their documents per client.

All documents that have been entered and processed via the various DEXPRO modules in Microsoft Dynamics 365 Business Central are displayed. A global number series, which is used across all DEXPRO apps, is used to track individual documents. This offers the advantage that users only have to work with one number series per document.

Further information can be found here.

SQUEEZE Setup

In the SQUEEZE setup, both the connection to the SQUEEZE system and the processing within the app are set up.

Menu

Process

image-1647268682638.png

Setup Wizard

This is used to start the setup wizard. This guides the user step by step through all menu items.

Get API key

This function is used to set the API key for the configured API name from the connected SQUEEZE system.

Create jobs

The automated retrieval and processing of documents from SQUEEZE requires the setup of a background job. This can be done in via this function.

Copy setup

This copies the setup to other clients.

Master data

image-1647268712087.png

Initially Upload master data

Via the function "Upload master data for the first time" all accounts payable and accounts payable bank accounts are transferred to SQUEEZE for the first time.

Navigation

image-1694605936117.png

Using the SQUEEZE links menu item, you can see which vendor/vendor bank account has which ID on the squeeze page.

image-1647268848380.png

User specific setup

This menu item is used to access the user-specific setup. In this, different rules can be stored for each user.

Import queue entries

This menu displays a list of SQUEEZE vouchers that are ready to be imported into the SQUEEZE for BC app. By changing the system filter it is also possible to view already imported vouchers.

Via this menu item you reach the vendor-related setup. In this, deviating rules can be deposited per creditor.

Document classes setup

Via this menu item you reach the setup for the SQUEEZE document classes.

Fasttabs

General

In this Fasttab you can activate/deactivate the use of this app. Additionally you can see the version of the connected SQUEEZE system.

image-1647268934174.png

API

In this Fasttab the URL of the SQUEEZE system is specified. Furthermore, an API name is set and the corresponding API key is entered via the "Get API key" function.

image-1647268964817.png

Master data

To improve the quality of the readout, SQUEEZE requires the accounts payable information from Microsoft Dynamics 365 Business Central. In this Fasttab you enable/disable the master data Synchronization to SQUEEZE.

image-1647269134128.png

In the field "Client Master Data Tables Id" the ID of the SQUEEZE Company table is specified.

In the field "Creditor Master Data Tables Id" the ID of the SQUEEZE Creditor table is specified.

Number series

The number series for the SQUEEZE covers is indicated here.

image-1647269206724.png

Background jobs

The automated retrieval and processing of documents from SQUEEZE requires the setup of a background job. For this, the code unit 70954640 "DXP SQUEEZE Scheduled Tasks" is entered in the task queue item.

This background job is created automatically after the setup wizard is completed.

image-1647269240118.png

Job queue entries

Codeunit 70954640 "DXP SQUEEZE Scheduled" is entered as an item in the job queue entries.

image-1647269309478.png

Document Classes Setup

In the SQUEEZE document class setup, the mapping between the respective document class and your export interface is done. Furthermore, the field mapping of each document class is downloaded here, creating a set of standard fields and their usage in Microsoft Dynamics 365 Business Central.

The document class setup is cross-app and is managed via the DEXPRO Core.

Process

image-1647269521455.png

Download field mapping

This downloads the field structure of the SQUEEZE document class. These are needed for the metadata mapping.

Navigation

image-1647269553966.png

Metadata mapping

You can access the field mapping via this menu item. This defines which fields from the squeeze endpoint are transferred to the defined fields in Microsoft Dynamics 365 Business Central. The standard field mapping cannot be edited. Different mappings can be realized via the custom field mapping.

List

Document classes

This overview lists all the document classes that have been set up.

image-1647269475167.png

Card

Document class

Here, each document class is set up individually.

General

image-1694690581281.png

In this fastab the name of the document class, the next process step, as well as the automatic enrichment of the positions is set up.

Squeeze

image-1694690612479.png

Autocomplete:

In the case of documents without a purchase order reference, the system can remember and recall the items read in and the account assignment applied to them for each vendor. There are three options that can be selected for this.

  1. Never: Disables the function and hides the button in the validation page
  2. Manual: Applying the autocomplete data is done manually by clicking the button "Autocomplete". Die Speicherung der Metadaten für die Autovervollständigung wird automatisch beim Abschluss des Validierungsprozesses ausgeführt

    image-1694690158591.png

  3. Automatic: Creating and applying the data for auto-completion is done automatically
    1. When creating the SQUEEZE document, the entries are applied
    2. When the validation is completed, the entries are created/updated
Automatic validation:

Enable this option to have Squeeze for BC automatically validate incoming receipts. Please note that this function works only in case of perfectly plausible data.

Download attachments:

Enable this switch to automatically download SQUEEZE attachments when creating a new document.

Transfer attachments to target document:

Here you can set whether the SQUEEZE attachments are to be transferred to the target document.

Account assignment code:

Specifies the account assignment setup to be used when performing the account assignment in the validation process.

API Settings

At this point, the ID of the connected squeeze client corresponding to the document class is stored, as well as the ID of the pull export interface and the correct line table ID. The default values do not necessarily match the setup in the squeeze client and should be cross-checked.

Order Match

The purchase order reconciliation is used for the automated check of the read out positions with those of the still open purchase orders in Microsoft Dynamics 365 Business Central. In this Fasttab, the permissible amount & quantity tolerances for the matching are set up. Additionally, it can be defined whether the matching should take place on purchase orders or deliveries. If "Replace data" is active, the amounts and descriptions of the items will be replaced with those of the order/delivery after matching.

Vendor Related Setup

In this setup, vendor-specific settings are made per SQUEEZE document class. This is done for vendors that deviate from the set client standard.

In addition to the auto-completion of positions, deviating amount and quantity tolerances can also be set up here.

List

image-1647269412335.png

Card

image-1694689730264.png

Autocomplete:

In the case of documents without a purchase order reference, the system can remember and recall the items read in and the account assignment applied to them for each vendor. There are three options that can be selected for this.

  1. Never: Disables the function and hides the button in the validation page
  2. Manual: Applying the autocomplete data is done manually by clicking the button "Autocomplete". Die Speicherung der Metadaten für die Autovervollständigung wird automatisch beim Abschluss des Validierungsprozesses ausgeführt

    image-1694690158591.png

  3. Automatic: Creating and applying the data for auto-completion is done automatically
    1. When creating the SQUEEZE document, the entries are applied
    2. When the validation is completed, the entries are created/updated
Automatic validation:

Enable this option to have Squeeze for BC automatically validate incoming receipts. Please note that this function works only in case of perfectly plausible data.

Account assignment code:

Specifies the account assignment setup to be used when performing the account assignment in the validation process.

Order Match

The order reconciliation is used for the automated check of the read out positions with those of the still open orders in Microsoft Dynamics 365 Business Central. In this FastTab, the permissible amount & quantity tolerances for the matching are set up. Additionally, it can be defined whether the matching should take place against purchase orders or deliveries. If "Replace data" is active, the amounts and descriptions of the items will be replaced with those of the purchase order/delivery after matching.

 

Account Assignment Setup

Here you will find the account assignment setup. If you have standard account assignments for certain VAT. You can store them here.

image-1729153814670.png

As soon as an account assignment setup with setup lines has been created and stored in a document class or an vendor related setup, it will be used automatically.

When importing a document from Squeeze, the recognized VAT. records are checked against the setup lines of the stored account assignment setup. If matching entries are found, a check is made to determine whether lines with the stored account assignments may be created. In the standard case, this is only done if Squeeze does not supply any items.

In addition, it is possible to set up whether an account assignment setup may be used automatically for validation.

This should not be set as default in the document class setup, as this would then apply to all vendors and documents. This option makes more sense for individual vendors (vendor related setup).

For automatically use, you can additionally activate that all squeeze lines of a document are overwritten with the configured account assignment setup lines. ("Overwrite squeeze lines" checkbox).

Account assignment setup

Setup lines are managed separately for each account assignment code.

image-1729154022362.png

This is where the individual VAT. records for which standard account assignments are to be set.

Account Assignment Type "One Account"

image-1729154104849.png

The selection of the account type corresponds to the BC standard:

image-1694685560820.png

The description can be customized as desired after selecting the number.

Account Assignment Type "Standard Purchase Code"

image-1729154166674.png

Here you can choose the standard purchase code from the recurring purchase lines.

image-1729154341289.png

 

Field Mapping

In Metadata Mapping, the field mapping of each document class is downloaded, creating a set of standard fields and their usage in Microsoft Dynamics 365 Business Central.

image-1647269686928.png

Metadata assignment

Additional SQUEEZE fields which deviate from the standard add.

image-1647269784785.png

After assignment:

image-1647269826827.png

Custom Field Mapping

You may always want to write certain information in certain fields in your process that deviates from the standard field assignment. In the following example, the service date recognized by Squeeze is always written in the “Booking date” field - in addition to the standard behaviour. The service date therefore remains filled.

Open the field assignment in the document class setup:

image-1729154979516.png

Then open the “User-defined field assignment”:

image-1729155003286.png

Then make the desired assignment:

image-1729155021876.png

User specific setup

In this setup, user-specific settings are made. This gives users the option of setting the app individually to their working method and peripheral devices.

image-1694684573345.png

Squeeze Master Data Tables

Standard Tables

Unless deactivated, this master data is automatically synchronized with the Squeeze client. It is still necessary to upload the master data initially.

The “Uses external ID” field is supported from Squeeze version 2.13 and allows you to manage Squeeze master data from third-party software. In this case BC.

image-1749562924866.png

Generic Master Data Tables

To transfer additional master data to Squeeze, maintain it in the generic master data table setup.

image-1749562974280.png

Attachment of the table to be transferred

The table to be transferred is entered in the “BC table no.” field or selected via the drilldown. The name can then be adjusted in the “Squeeze table name” field. The “Synchronization activated” field is used to specify whether this table is currently to be synchronized or not.

Selection of the fields to be transferred

You can access the setup via the “Field Selection” menu item.

image-1749563004478.png

The fields to be synchronized are selected here.

image-1749563077651.png

Creation of the Squeeze master data table from BC

Once a BC table has been entered and its fields selected for synchronization, a new squeeze table can now be created from BC. The “Create squeeze table” button is available for this purpose.

image-1749563117489.png

After creation, the “Squeeze table ID” field is set in the overview.

The new table is now available on the squeeze page.

image-1737716310362.png

The selected fields have now been automatically created here as columns.

image-1737716340239.png

Synchronization of the data

After creating the squeeze table, the user is asked whether a synchronization task should be created.

image-1749563175364.png

If this is active, the master data is automatically transferred at the set frequency. Alternatively, the master data can also be transferred manually once using the “Synchronize now” button.

Deleting the master data table

When deleting a list entry, you are asked whether the Squeeze master data table should also be deleted.

image-1749563206460.png

If this is confirmed, the squeeze table created from BC will be irretrievably removed.

 

SQUEEZE

The SQUEEZE page must also be prepared for fetching documents from Microsoft Dynamics Business Central.

Each document class that is to be retrieved from Microsoft Dynamics Business Central requires its own export interface of the type "Pull". In addition, the document class ID, the export interface ID and the master data table ID must be stored in Microsoft Dynamics Business Central in the setup for the SQUEEZE document classes.

If the latest SQUEEZE for BC version is not used, the following batch class properties must be set in the SQUEEZE client:


MicrosoftTeams-image.png