EDX - Electronic Data eXchange#

General#

EDX - Electronic Data eXchange stands for the document exchange module of KUMAVISION 365. EDI documents are sent in different formats, e.g. EDIFACT, VDA, OpenTrans etc.. A converter takes over the conversion from the external format into the EDX internal XML format.

EDX then processes the converted messages and imports them into Microsoft Dynamics 365 Business Central. Required message acknowledgements are automatically sent within the internal document exchange. In the case of external EDI (electronic data interchange), the message acknowledgement must be coordinated with the EDI service provider.

The incoming messages are validated by the EDX module. This means that the message content is loaded into the EDX document and checked for accuracy, discrepancies and completeness. The user can manually correct the data in the EDX document and then create the corresponding Business Central document.

For incoming messages, a mapping between the external and the article units stored in Business Central is often required. For this purpose, the EDX module offers corresponding mapping tables.

The following diagram is intended to clarify the task EDX performs in the electronic document exchange:

Business processes#

The EDX module enables internal as well as external document exchange. BC documents can be exchanged within a group of companies as well as with external EDI partners.

Internal document exchange#

If there is a hierarchical company structure with several companies, then the document exchange can be implemented with the EDX module. Here, the documents of the individual companies can be exchanged among each other.

Prerequisites for internal document exchange:
* Main company and companies are in one databaseIn this case, the internal document exchange can be set up directly with the wizard.

• Main company and companies are located in separate databaseIn this case, the document exchange must be set up manually.
• There is a common network structure and all participants can access a shared network path

The following figure shows the document flow between customer and supplier in connection with the EDX module:

Main company = Customer Company = Supplier

External document exchange#

If documents are sent to an external partner (EDI), this is described below as external document exchange.

The external document exchange contains document types developed for use with EDI service providers. The EDI service provider receives the EDX messages, transforms them into the target format and transfers the messages to the recipient.

It is not absolutely necessary to use an EDI service provider. Depending on the requirements, the transformation and transfer can also be implemented as an in-house solution with corresponding modules.

Available vouchers#

The following documents are already available in XML format after installation:

Purchasing * Order outgoing * Order change outgoing * Order confirmation received * Purchasing delivery incoming * Purchase invoice incoming * Purchasing complaint outgoing

Sale * Sell order received * Sell order change incoming * Order confirmation outgoing * Sales offer starting * Outgoing delivery bill * Sales invoice starting * Sales credit outgoing * Sales complaint outgoing

Establishment#

The module has numerous configuration and customization options, which will be explained in more detail in the following chapters. The first part of the documentation covers all topics concerning administration and configuration. The second part describes the operation of the data exchange.

Entitlement rates#

About the installation of the EDX Apps are automatically different authorization sets integrated into your Business Central application. Assigning these authorization sets to your users or user groups ensures that the respective Users can get access to the connection and execute the functions depending on the assigned record.

Roll Center#

The EDX Role Center represents the central work platform for the entire EDX module. All necessary information regarding documents (incoming/outgoing), items (incoming/outgoing) and configurations are displayed with corresponding stacks in the role center. Incoming and outgoing documents are displayed as links in the Purchasing, Sales and Logistics overviews, indicating the number of each. A click on the link opens the relevant document or an overview of the documents. It is therefore possible to navigate from the role center to all EDX relevant documents.

Furthermore, all settings as well as error entries and system messages are displayed in additional overviews.

EDX Setup#

In the EDX Setup, settings can be made that are valid for the entire module. The EDX Setup can be called up via the "Facilities and extensions" > "Service connections" > "KVSEDX Setup" start page.

In the "Interface directory" tab, the directories for documents, test as well as the productive must be defined.

Further entries are not necessary for the time being, as these are made with the "EDX Setup Wizard". Further information can be found in the section with the same name.

For completeness, all fields of the EDX setup are explained in more detail below:

Inforegister General#

Inforegister interface directory#

Inforegister Azure Storage#

The Azure service connection is registered when you close the setup dialog. Before the Azure Connection Test action can be performed, the setup dialog must be closed and reopened.

Afterwards, the action "Azure connection test" can be executed.

The following actions are performed during the test: * Create Readme.txt file in container * List files in container * Read in the "Readme.txt" file * Delete the "Readme.txt" file.

Information register partner#

Inforegister numbering#

All incoming EDX documents are first stored in EDX intermediate tables. For these EDX documents number series are necessary. If the EDX module is used exclusively for outgoing documents, then the specification of number series is not necessary.

Information register web service#

Inforegister error handling#

Inforegister XML#

Inforegister Reorganization#

Inforegister BC Configuration#

Inforegister Facility Overview#

The fields on the "Setup Overview" info tab give an overview of which points are already set up in EDX.

EDX Setup Wizard#

To make the setup of the connection as comfortable as possible for the user, a setup wizard has been developed to guide you through the individual steps. This setup wizard can be called up via the EDX Setup menu ribbon ("More options" > "Action" > "Setup" > "EDX setup wizard").

The EDX setup wizard is started.

The "General" selection is used to create the document types as well as number series for incoming messages.

If you want to send purchase orders, delivery bills or invoices to another client, then select the "internal document exchange" function. For more information, see the "Internal document exchange" setup section.

EDX Document types#

When installed, the EDX module already has some document types which can be used for internal and external document exchange.

Establishment#

The EDX document types are created using the "EDX Setup Wizard" action within the EDX setup.

You can view the "EDX document types" using the call of the same name via the user search. The individual fields are explained in more detail below:

Distribution of EDX document types#

All EDX document types have a prefix that can be used to assign an area.

The areas are divided as follows:

EDX Partner#

In order to be able to exchange documents, one or more partners must first be defined in the EDX module. These partners can be created based on existing accounts payable or accounts receivable.

EDX partners are managed under a code consisting of the respective Business Central creditor or debtor number and a prefix.

Before creating the EDX partner, the "Our account number" field must be defined in the vendor/customer.

Example for "Our account number": Role of the supplier: For customer 1000, 61000 is entered in the "Our account number" field. Role of the customer: For vendor 61000, 1000 is entered in the "Our account number" field.

Partner type debtor#

A new EDX partner is created directly from the partner overview. To do this, first call up the "EDX partners" via the user search.

The action "Create customer" creates a new EDX partner based on a customer.

For the EDIFACT UNB segment to be created, the fields GLN, data sender as well as recipient ID can be used.

The fields Data sender and Recipient ID are not subject to a format check. Accordingly, an ODETTE-Id, DUNS-No. etc. can be entered.

For the transmission of XInvoices to an EDI service provider, the "Routing Id." is required. see "IT Standards Coordination Office".

Basically all above mentioned fields have to be coordinated with the EDI service provider. The fields are transmitted within the CC messages invoice, credit bill as well as delivery bill in the element "Routing".

G/L account and unit mapping#

G/L accounts mapping#

In the internal document exchange, for example, it is possible to send purchase orders to an internal partner. Since no lines of the type resource can be entered in purchase orders, a mapping is necessary at this point. The G/L account mapping is opened directly from the "EDX Partner Overview" for the selected EDX partner.

One resource or G/L account no. can be entered per partner.

Example:
Partner V01254796
Resource: Cargo
G/L account no. 3400 (Internal freight)

These inputs lead to the following result: If a purchase order is sent, in which a line with the type G/L account and the no. 3400 exists, then this line is created at the recipient in the sales order as resource "Freight".

Units mapping#

A unit mapping is necessary to change the customer's unit code to your own unit code.

Example:
A customer orders 5 PCS, the unit code in BC is Piece. In this case, a mapping must be created for the translation from PCS to Piece.

The unit mapping is called up via the "EDX Partner Overview" via the menu ribbon.

It is not necessary to store a unit mapping for each EDX partner and article. As a rule, the unit "PCS" must be converted to the Business Central unit "piece" for all EDX partners and articles.

The following sequence is used to determine the unit mapping:

1. Mapping with EDX Search partner, article and reference code
2. Search mapping with article and reference code
3. Mapping with EDX Partner and reference code search
4. Search mapping with reference code

The unit mapping is used with the following documents: * Sell orders * Sales order changes * Purchase order confirmations * Purchasing deliveries * Purchase Invoices

For the outgoing documents, the unit mapping is performed only in the "Clearing Center Messages". * born sale delivery * born sales invoice * Order * Order confirmation

Additions/Detractions Mapping#

In EDX additions/deductions mapping, additions and deductions can be assigned to articles, resources, G/L accounts and fields in the document header.

Examples: * G/L account for the surcharge advertising costs * Item as freight charges * Amount incl. VAT" field from the sales header as an insurance surcharge.

Only fields from the sales header can be used. Amounts and percentages can be specified. These two fields are disabled for lines surcharges/discounts. The "Position" field is filled automatically and is only information for the user.

The addition and deduction codes are selected from a separate table.
The surcharge/discount mapping is only used for external outgoing document dispatch with Clearing Center. This includes the following documents: * Order confirmation * Booked sales invoice * Booked sales credit

Service GTIN Mapping#

With the "EDX Service GTIN Mapping" resources, G/L accounts etc. can be provided with a GTIN. The stored GTIN is sent within the service invoice as well as credit note.

EDX Occupancy device#

For each EDX partner different voucher types can be defined. With the "EDX voucher setup" the vouchers are assigned to the EDX partner as well as configured.

With the action "New" an EDX voucher is assigned to a previously created EDX partner. The fields of the EDX voucher setup card are explained in more detail below.

Inforegister General#

Inforegister transfer#

Inforegister Azure / File Transfer#

Inforegister Azure Forwarding#

The forwarding parameters are sent to an "Azure Logic App" or "Power Automate". The Azure Logic App is not part of EDX. For processing the parameters below, a corresponding "Azure Logic App" or "Power Automate" must be created in the customer project. For the creation of the "Azure Logic App" the template "EDX_Outbound_Message" can be used.

When using the forwarding parameters, the GS1 messages "GS1 APP REC ACK IMP" as well as "GS1 APP REC ACK EXP" must be assigned to the EDX partner.

**Example CC Invoice message is to be transmitted to EDI service provider EDI1 via SFTP. The message is to be placed on the destination FTP server in the /inbound directory.

Set the following forwarding parameters:

FTP information register#

The FTP parameters must be set up when the FTP transfer type is selected.

Inforegister e-mail#

Information register processing#

The processing parameters for the incoming as well as outgoing messages are defined in this info register.

Info tab Advanced#

Function "Field settings document check "#

The function "Field settings for document check" in the ribbon defines which fields of the EDX document are checked or transferred to the Business Central document.

Set up task queue item#

Automated message sending/receiving is done by setting up the task queue items. These are created using the EDX setup wizard. See EDX Setup.

Process distribution within the task queue items#

The following task queue items are created using the EDX Wizard:
CodeUnit: 5487951 EDX Job Queue

GLN facility#

In addition to the GLN in the customer, further GLNs are required for the creation of an EDIFACT message. With EDIFACT, the message recipient is transmitted in the UNB segment. The GLN of the message recipient may differ from the GLN of the customer.

According to EDIFACT, GLN's are mapped in the following segments:

))

GLNGlobal Location Number

The GLN's are entered in the following Business Central master data:

Message receiver (UNB)#

The GLN for the message recipient/sender (UNB) is entered directly at the EDX partner in the "GLN" field.

Debtor (NAD segment)#

The GLN for the customer (NAD segment) is entered directly on the customer card in the "GLN" field in the "Invoicing" info tab.

Delivery to address (NAD segment)#

The GLN for the Delivery to Address (NAD segment) is entered directly on the Customer Card > Delivery to Addresses in the "GLN" field in the "General" info tab.

The transmission of the above GLN's is supported by the XMLPorts for EDI service providers (prefix CC).

Set up e-mail dispatch#

As described in the previous sections, EDX automatically sends mails if, for example, an error has occurred during processing.

The following items must be set up to send mail:

SMTP mail setup#

The SMTP server must be set up via the SMTP mail setup. This setup depends on the technical conditions of the environment and should be done by the company's IT department.

BC Administration (Management Console)#

Mail is usually sent using the Business Central instance JOBQUEUE01. Since this is a process without client service, it is necessary that the base URL is entered.

The URL of a Business Central instance with the Enable Client Services option enabled must be entered in the Windows Client Base URL field.

Example:
DynamicsNAV://srvnav:7246/NAVProd01/

This base URL is then used, for example, for the PageLinks within the error mail.

Internal document exchange#

Set up with the EDX Setup Wizard#

The internal document exchange can be set up completely via the EDX Setup Wizard if both clients are present in one database.

The setup for the internal document exchange can now be started with the action "EDX Setup Wizard".

After starting the wizard, the following parameters must be set: * Set the function of the wizard to "internal document exchange". * Set role of the current client. * Selection of the communication interfaceCurrently, the
interfaces "File transfer" and "Azure Storage" are available. * Use purchase price as sales priceThe
price from the sent purchase order is transferred to the sales order.
see Field control. * Selection of the client with which messages are to be exchanged. * Assignment of customer and vendor according to the clients.

After executing the action "Finish" the reconciliation of the field "Our account number" between the customer and the vendor takes place. In both clients, the required EDX partners and the related intercompany documents are assigned.

Manual setup#

If the clients exist in different databases, then the setup must be done manually.

The following messages are to be set up on the customer side:

The following messages are to be set up on the supplier side:

When setting up the intercompany documents manually, the EDX file paths must be configured manually.

The output message is configured first. The associated path must be stored temporarily. The input message can then be configured. The path from the previously configured output message must be used here.

The message recipient and sender can thus communicate via the same directory.

The following steps must be carried out using the "IC PURCHASE ORDER" example. The EDX basic setup must already have been carried out and partners must have been created. This process must be performed for all incoming messages: * Open client "Customer". * Create EDX document facility for document "IC PURCHASE ORDER" and buffer path. * Switch to the "Supplier" client. * Create EDX document setup for document "IC SALES ORDER" using the path of the outgoing document.

Shipping order / load carrier#

To use the outgoing message "CC DESPATCH ADVISE" (DESADV), it is necessary to set up the shipping orders including the load carriers.

The general information about setting up the shipping orders and load carriers can be found in the corresponding manual "KUMAVISION Shipping Processing". In the following, you will only find notes on the relevant settings for the outbound message mentioned above.

Setup storage location#

In order to be able to assign the load carriers/packages in the shipping order, the option "Shipping order" must be selected in the field "Shipping processing" in the storage location or must remain free.

Shipping order setup#

Use the Shipping and Load Carrier Setup menu item to set up your shipping orders. If you want to ship load carriers with information about the NVE/SSCC, the fields "Company ID" must be filled with the base number (GLN) of the company, and "Load Carrier ID Numbers" with a number series. Instead of storing the number series here in general, these can also be stored specifically for individual load carriers. In addition, the option "Create check digit for carrier ID" must be activated so that the check digit specified by GS1 can be calculated and added for the NVE/SSCC.

!!! note "Note In the field "Company ID" a reserve digit (see GS1 specification) must be prefixed before the base number, so that a correct NVE/SSCC can be generated.

In order for a NVE/SSCC to be generated automatically, the option "Assign load carrier ID on order release" must also be activated.

The NVE/SSCC has a total length of 18 digits (see GS1 specification). Therefore, the combination of company ID with reserve digit, number series of the load carrier and check digit must be exactly 18 digits long. If this is not the case when releasing a shipping order and the option "Assign load carrier ID when releasing order" is activated, a corresponding note appears.

Load carrier setup#

The required load carriers can be set up via the "Load carrier" menu item. If load carriers including NVE/SSCC are to be transferred, the option "ID mandatory" should be set here. If no number series is stored in the "Load carrier ID number" field in the shipping order or if a different number is to be used for the respective load carrier, a previously created number series can be selected here.

Please note the information on the NVE/SSCC from the chapter "Shipping order setup".

Create DESADV#

The outgoing message "CC DESPATCH ADVISE" is generated from a booked dispatch order with EDX partner.

In order for a valid DESADV file to be created and, if necessary, further processed by an EDI converter, the following requirements must still be met when creating shipping orders.

The shipping order must refer to a booked sales delivery, otherwise no valid EDX partner can be transferred to the booked shipping order.

Each line with packaging materials/cargo carriers must be assigned to at least one delivery line.

Incoming documents#

Incoming documents are first temporarily stored in EDX documents.

Data flow of an incoming document#

The incoming message is first read into the EDX inbox. The system creates an EDX inbox item and stores the message in the item.

The EDX intermediate document is then created from the EDX incoming item. Within the EDX intermediate document, the user can intervene and correct data. Furthermore, the user can reject the EDX intermediate document if necessary or create a Business Central document from it.

EDX input items#

All incoming documents are first stored in the EDX Inbox table. When the business process for this document is completely finished, then the item will be automatically transferred to the "EDX Inbox Archive".

EDX Edit and reprocess incoming items#

The "View file" function can be used to download the XML message of the selected EDX input item and edit it if necessary. The "Save files" function downloads the XML message from all selected input items and saves it in a selected folder.

The file must be saved with the action "Show file" and then save.

If an EDX inbound item runs into an error because, for example, a field length in the EDX intermediate document is exceeded or the XML structure is incorrect, the XML message can be downloaded from the EDX inbox, edited, and uploaded again for new processing.

Using the "Upload message" function, the XML message can be uploaded again to the document directory on the server.

After the successful upload, the message will be processed again.

Manual processing of an EDX document#

For the processing of EDX documents, a basic distinction is made between two cases.

Incoming EDX document, the BC document has not yet been created.

Example:
A sales order is received. The corresponding BC document has not yet been created.
When the incoming EDX document is created, it results in a new BC sales order.

Incoming EDX document, the BC document already exists.
Example:
An incoming EDX order confirmation refers to an already existing Business Central order.

Before a Business Central document can be created from an incoming EDX intermediate document, the incoming EDX document must first be checked. After a successful check, the EDX document receives the status "Ready for creation". All EDX documents with this status can be transferred to a corresponding Business Central document.

EDX Intermediate document#

The EDX intermediate documents contain partly identical fields as the BC documents (see EDX sales order). Special EDX fields and their related functionality are described below.

EDX messages/errors
If there are any system messages or errors specifically for this document, they can be retrieved via the look-up.

EDX status * Unprocessed
The EDX document was created automatically. No further processing steps have been performed yet. * Error:
An error occurred while processing the document. * Ready to put on
The EDX document is checked and can be created. * BC Document created
A BC document was created from the EDX document already created. This item is now completed and will be moved to the EDX incoming archive * Inconsistent data
There is already an existing BC document for the incoming EDX document. * Rejected
The incoming document was rejected * Manual processing
If it is not possible to create an incoming EDX document as a BC document, it will receive the status "Manual processing". * Archived
EDX documents that have already been archived. * Deleted
EDX documents that have been deleted by the user.

EDX Voucher Check#

During the verification, the system performs a validation of the data. In the process, the field contents are checked. The validation of the field contents is based on the settings made in the document setup.

If errors are detected, the EDX document receives the status "Error". In the field "Error" on the document header or the document lines the number of occurred errors is indicated. You can open related error items using the Look-Up button.

If errors are detected, they can be corrected directly in the EDX document. Each field change in the EDX document is logged. By means of a lookup on the field "EDX Note" these changes can be retrieved.

After manual correction in the EDX voucher, the action "Check" must be executed again. After all errors have been corrected, the BC document can be created using the "Create" action.

Processing of EDX documents with status "Inconsistent data"#

During the check, the data of the EDX document is compared with the data of the Business Central document. This is the case, for example, with an incoming order change.

To avoid having to manually compare the existing Business Central sales order with the EDX order change, EDX checks the discrepancies and displays them clearly.

If any discrepancies are found, the EDX status will be set to "Inconsistent Data". With a click on the lookup field "EDX Error" all deviations are displayed.

Example:
An order change for an item with a quantity increase from 20 pieces to 30 pieces was received.

The EDX status is set to "Unequal data".

By clicking on the EDX error number (line), a dialog is displayed in which the deviations are shown.

The "Apply changes" selection determines whether the displayed change is to be transferred to the Busniess Central document. The "Value EDX" column shows the currently transferred value. The "Value BC" column shows the current value of the Business Central document.

After defining which changes are to be accepted, the action "Accept changes" must be executed.

Delete EDX document#

Deleting an EDX document depends on the status. If the EDX status contains one of the following values, deletion is not possible:
BC Document created
Rejected
Manual processing
Archived

If the document is not in this status, the EDX document can be deleted with the action "Delete EDX document".

After executing the action "Delete EDX voucher", a dialog box appears with the note that a deletion reason must be specified and whether you actually want to delete the voucher. This query must be confirmed with "Yes".

Subsequently, the reasons that led to the deletion of the message can be recorded.

Create EDX document#

The "Create" action transfers the EDX intermediate document to the associated Business Central document.

Reject EDX document#

It is possible to reject incoming EDX vouchers.

The rejection is transmitted to the message sender if the "Receipt confirmation check" field has been activated in the EDX document device.

Rejection reasons must be recorded before the action is completed.

EDX document with "Manual processing" status#

EDX documents with the status "manual processing" indicate that the EDX document cannot be created or confirmed as a Business Central document. This may be due to the following reasons: * The existing document has already been delivered * Reservations are available * A clear assignment of the document is not possible * A clear assignment of the lines is not possible * There are deviations that cannot be processed automatically

Since these EDX documents cannot be processed by the system, further processing must be performed by the user.

The EDX document is closed by archiving it.

Automatic processing#

Automatic processing" can be activated within the "EDX voucher setup". The received voucher will be checked automatically. If no errors occur during the check, the Business Central voucher is created.

Up to now, incoming sales orders have been processed automatically.

Outgoing document#

Outgoing EDX documents are not transferred to an EDX intermediate document. When the EDX message is created, an EDX outgoing item is created directly.

EDX information#

Each outgoing document contains information that is required for transmission. This information is displayed in the "EDX" info tab.

Below you will find a more detailed explanation of the fields of the info register that are required for the transfer:

Manual processing#

Send EDX document manually#

Manual document dispatch takes place directly from the associated Business Central document with the action "Send EDX document".

EDX output items#

All sent documents are first saved in the "EDX Outbox" overview. When the process is complete, the system automatically transfers the item to the EDX Outbox Archive overview.

EDX status * Unprocessed:
The document has been transferred to the EDX module. This item has not been sent yet. * Error:
An error occurred while processing the item. For more details, see the Error Log field.
If the error occurred due to insufficient file permissions, then the EDX document can be processed again after correcting the permissions. For this purpose, the action "Reprocess" is selected.
If the transfer type is set to FTP, the FTP error is displayed directly. * Dispatched:
The item was transmitted to the partner. With the columns "Messages" as well as "Errors" information about the outgoing item can be retrieved.

Action "Show file"
This action displays the document contained in the item.

Action "BC Voucher Display
This action displays the corresponding BC document.

Display archived BC document" action
Display of the archived document.

Automatic processing#

So far, the following outgoing documents can be sent automatically:

• Sale

deliveryShipping takes place when booking.

• Sales

InvoiceShipping takes place when booking.

• OrderShipping will be done upon approval.
• Order changes

The shipment takes place when the order is released.

If the order is released and has already been sent via EDX, then an order change is automatically sent.
A check for quantity or date changes is currently not provided.

The automatic dispatch of Business Central documents can be controlled within the EDX document facility.

The following conditions apply to the EDX occupancy facility: * The EDX partner must be of type Customer or Vendor. * The EDX "Transfer date from" must be greater than or equal to the work date.

The following conditions apply to the BC documents delivery bill, invoice and purchase order: * The "EDX Partner" field has a value. * The document date is greater than or equal to the "EDX transmission from". * The "EDX Status" is "Unprocessed".

The following condition applies to the BC delivery bill: * The "Sales to customer" field must match the "BC partner no." from the EDX voucher setup.

The following condition applies to the BC bill: * The "Invoice to Customer" field must match the "BC Partner No." from the EDX document setup.

Reset EDX status#

With the action "Reset EDX status" documents can be sent again.

Enhancements in "Internal document exchange#

Purchasing deliveries without goods receipt#

In the case of purchasing deliveries, it was previously always assumed that the storage location used was posted by goods receipt. The processing of purchase deliveries has been changed so that now also storage locations without goods receipt can be used. In this case, the field "Quantity current delivery" in the respective order line is initialized with the reported delivery quantity.

The document must be posted by the user.

Purchase deliveries with batch / serial number#

Batch/serial numbers are now supported for purchase deliveries.

The batch/serial number to be delivered is entered in the sales order. The batch is then transferred to the recipient with the posted sales delivery.

The transmitted batches/serial numbers can be retrieved in the "EDX Purchasing Delivery" using the line menu.

After checking / creating the EDX purchase delivery, the item tracking data is transferred to the purchase order.

After posting the order, the item/batch is available on the storage location.

Additions/deductions in "internal document exchange"#

Surcharges/discounts can now be used in internal document exchange. The prerequisite is that the "Sales price without VAT" field is activated in the field control for the sales order received. Otherwise, the order line will be created without a sales price.

Article variants in "internal document exchange"#

The article variants are now supported in the internal document exchange.

Order date in "internal document exchange#

When sending the order, the "planned date of receipt of goods" is transmitted from the order. Further processing looks like this:

Remark texts#

During internal document exchange, the "remarks" are transferred from the Business Central order, header as well as line. On receipt, the remarks are saved in the EDX sales order. Likewise, comments can be reported back with the EDX order confirmation. In this case, the remarks are stored in the EDX purchase order confirmation.

Received remarks are not transferred to the Business Central sales order or the Business Central purchase order. Otherwise, it would no longer be possible to distinguish between remarks entered by the user and remarks from the other party.

Receive delivery schedules#

In the internal document exchange, previously sent purchase orders/framework orders can be received as delivery schedules. The setup for sending purchase orders can be done as described above. On the receiver side the message "IC SALES DELFOR" is set up.

When a delivery schedule is received, a delivery schedule and a scheduling agreement are created for each order/article. This functionality is only available within the KUMAVISION factory365.

Direct delivery#

When sending a purchase order with reference to a sales order (direct delivery), the data of the sales order is also transmitted.

Upon receipt, the data of the direct delivery is transferred to the EDX intermediate document for sales orders.

Further processing of this data must be implemented in the customer project.

Master data export#

The EDX Framework provides the following documents for the master data export:

Example: In the following example, the document "BASE CUSTOMER" is assigned to the EDX Partner C10000.

Subsequently, the configuration for the export fields is made with the action "Field setting for document check". Only the customer fields selected in the "Create field content" column will be exported.

If one of the specified fields is changed in a customer, then the export of the customer is performed automatically.

The output has the following format: )

Productive -/Test database#

When copying the production database to the test database, overlaps may occur in the interface directory area. Furthermore, it should be ensured that test messages do not get into the productive system.

The steps required to secure the production database are explained in more detail in the following sections.

Before the copy#

Before the production database is copied to the test database, all task queue items (all clients) should be set to "Wait".

After copying the production database to the test database#

When the production database is copied to the test database, there is usually an overlap of the interface directories. The document directories in the production and test databases are identical. This can lead to the fact that current EDI documents are not imported into the productive but into the test database.

For this case a security query was integrated, which is displayed when opening the test database.

If the query is answered with "Current database is the test database", the option "Test environment" is automatically activated in the EDX setup.

All clients with active EDX setup should be opened once after copying the database. Furthermore, the interface directories must be copied from the "Prod." subdirectory to "Test".

EDX voucher setup (FTP)#

If documents with the transfer type FTP are entered in the "EXD document setup" (test database), then these must be changed to "File transfer".

Task queue items#

The task queue items can now be reactivated in both databases.

Test indicator#

The "Test Indicator" is used to mark incoming as well as outgoing messages during the EDI test phase. For EDIFACT messages, this indicator is contained in the UNB segment (Interchange Header). The message recipient can use this indicator to control whether the message is transferred to the production or test system.

However, this "test indicator" is not available in all message formats (VDA, OpenTrans, etc.).

In the EDX document facility, it is possible to set whether the message (order, delivery bill, invoice, etc.) is a test message.

Effect of the test indicator on processing in Business Central:

Receipt of a sales order with test indicator
. The test indicator is transferred from the Business Central sales order to the delivery as well as invoice. This means that if a Business Central sales order was received as a test message, then the outbound delivery/invoice messages will also be marked as a test message.

Azure FileSync#

Azure FileSync can be used to exchange files between networks. Synchronization between source and destination directories can take up to several minutes.

If time-critical messages need to be exchanged, which is the case, for example, when messages are provided for a label printer, then the switch should be made to FTP file transfer.

EDX MasterDataExport#

With the EDX Master Data Export the following master data can be exported:

• Article sub-tables
  Article variants, article units as well as article references
• Customer sub-tables
  Contacts
• Vendor

Establishment#

The setup of the AddOn is done with the EDX setup.

EDX Setup#

At the beginning, the necessary setups are done via the setup wizard. This setup wizard can be called up via the EDX Setup menu ribbon ("More options" > "Action" > "Setup" > "EDX setup wizard"). The EDX setup wizard is started. Via the selection "General" the required document types as well as number series are created.

EDX Document types#

After setup via the setup wizard, the following document types are available:

Setting up the document types#

For each EDX partner different voucher types can be defined. With the "EDX voucher setup" the previously created voucher types are assigned to the EDX partner as well as configured.

Field settings#

The "Field settings for document verification" function in the EDX document setup card ribbon allows you to configure which fields are to be exported from the associated master data table.

Master data export#

The master data export takes place automatically as soon as a change is made to the master data record. Here, only field changes that were specified in the field settings are monitored.

Example:
The article description has been changed for an article. After the data record has been saved, the export takes place.

The output file contains the following elements:

)

Calculated fields#

Currently, only the calculated field "Stock" is provided. Calculated fields of the debtor or creditor are not provided by this AddOn, but can be implemented in the project.

Bulk data export#

At the beginning of a project, a function is usually needed to export all records of a table.

This can be controlled via the "Collective item" option within the document setup.

As soon as you activate the switch, all records of the table will be exported during the next data export. Afterwards, the "Collective export" option will be deactivated automatically.

EDX OpenTrans 1.0#

With the EDX AddOn OpenTrans 1.0 the following OpenTrans messages are provided:

• DISPATCHNOTIFICATION (shipping notification)
• INVOICE (Invoice)
• ORDER (sell order)
• ORDERRESPONSE (order confirmation)

Establishment#

The setup is done with the EDX setup.

EDX Setup#

At the beginning, the necessary setups are done via the setup wizard. This setup wizard can be called up via the EDX Setup menu ribbon ("More options" > "Action" > "Setup" > "EDX setup wizard"). The EDX setup wizard is started. Via the selection "General" the required document types as well as number series are created.

EDX Document types#

After setup, the following document types are available:

Setting up the document types#

The document types listed above are then assigned to an EDX partner.

Field settings#

The field setting is only available for the OpenTrans message "OT1.0 SALES ORDER". See EDX "Field setting for document verification".

Processing#

The processing of OpenTrans 1.0 messages is done in EDX standard. Incoming sales orders are provided as "EDX sales order". The order confirmation can be created via the corresponding Business Central sales order. The sales delivery and sales invoice can be sent manually or automatically.