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.


Application Consultant Application Consultant View staging journal View staging journal Use the staging journal to monitor the staged records.If you use staging in your inbound process, you receive data with message that stores the data staging journal.If you monitor staging journals, the statuses are important. Refer to 'See also'. Procedure 1. Go to Connectivity studio > Common > Staging > Staging Journals. 2. In the list, click the link of the desired journal type. 3. In the left pane, in the list, find and select the desired journal. 4. On the Data tab, in the list, find and select the desired record. 5. Click the Error tab. 6. Click Validation errors. 7. Close the page. 8. Close the page. Solve validation errors and warnings Solve validation errors and warnings 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. Procedure 1. Go to Connectivity studio > Common > Staging > Staging Journals. 2. In the list, click the link of the desired journal type. 3. In the left pane, in the list, click the link of the desired journal. 4. Click Edit. 5. Sub-task: Solve error or cancel record with error. 6. On the Data tab, in the list, find and select the desired record. 7. In the Approved field, select 'Cancelled'. 8. Sub-task: Solve warning or accept record with warning. 9. Try to solve the warnings that occurred on the records. If a record warning cannot be solved or is not an issue, you can decide to accept the record. If the journal is processed further, accepted records are processed. On the Data tab, in the list, find and select the desired record. Note: You can also accept all record warnings in one go. To do so, on the Data tab, click 'Accept all warnings'. 10. In the Approved field, select 'Accepted'. 11. Sub-task: Cancel journal. 12. In the Journal status field, select 'Cancelled'. 13. Close the page. 14. Close the page. Approve staging journal Approve staging journal 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. Procedure 1. Go to Connectivity studio > Common > Staging > Staging Journals. 2. In the list, click the link of the desired journal type. 3. In the left pane, in the list, find and select the desired journal. 4. Click Edit. 5. On the Data tab, in the list, find and select the desired record. 6. In the Approved field, select 'Approved'. 7. In the Journal status field, select 'Approved'. 8. Close the page. 9. Close the page. Start Start Is the journal  status 'Rejected'? Is the journal  status 'Rejected'? End End Yes No

Activities

Name Responsible Description

View staging journal

Application Consultant

Use the staging journal to monitor the staged records.

If you use staging in your inbound process, you receive data with message that stores the data staging journal.
If you monitor staging journals, the statuses are important. Refer to 'See also'.

Solve validation errors and warnings

Application Consultant

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.

Approve staging journal

Application Consultant

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.

See also

Provide feedback