In Connectivity studio, you can use the staging concept to validate data in an intermediate area before it is further processed. This is usually used to import data into D365 FO from another system. In this way, you can validate the data before it is written into the D365 FO database.
Use the staging journal to monitor the data validation.
One predefined generic staging journal table is available for Connectivity studio: 'BisStagingBufferOrderJournal'. Usually, you only use this generic table if you have a limited number of simple integrations. So, integrations that integrate one smaller table.
If you want to use staging for integrations with multiple tables or bigger tables, you are advised to develop a customized staging journal table instead of using the generic staging journal table.
This flow explains how to monitor staging journals using the generic staging journal table. You can monitoring a customized staging journal table in a similar way.
If the validations are not met, errors or warnings are reported in the staging journal. Usually, issues as shown in the staging journal are data related.
If it appears that issues are not data related, extend your issue investigation to the messages that import data to or export data from the the staging journal.
If you use staging in your inbound integration process, the records that you receive are stored in the staging order journal. These records are validated according to the applicable journal validation setup. If the applicable validation rules are not met, an error or warning is given. Before the records can be processed further, review the errors and warnings and take appropriate actions. If journal validation errors or warnings are given, you have these options:
Solve the errors or warnings.
Cancel the records with errors.
Accept the records with warnings.
Cancel the journal.
You cannot accept staging journals or lines with errors. If you do so, and approve the staging journal, the journal or line with errors is again set to Rejected.
If all errors and warnings of a staging journal are solved, accepted, or canceled, approve the staging journal. The staging journal is again validated according to the applicable journal validation setup. If the applicable validation rules are met, the staging journal status is set to Approved. Approved staging journal can be further processed by the message that imports the staging journal records into D365 FO.