For each record, you can define the range of data that is queried for export or import.
For example, you only want to export sales orders for a specific customer group. To do so, on the Range tab, add a record for the CustGroup field.
For more information on how to define ranges in the Range field, refer to Advanced filtering and query syntax.
1. | Click Connectivity studio Integration Design. |
2. | Click the Documents tab. |
3. | In the list, find and select the desired internal or ODBC document. |
4. | Click Edit. |
5. | In the Record section, in the Record list, find and select the desired record. |
6. | Click the Range tab. |
7. | Click New. |
8. | You can indicate if a range is added only for testing purposes. It is not applied in runtime. When testing is finished, you can remove the range. |
  | Select the Test check box. |
9. | In the Record field field, enter or select a value. |
  |
Note: You can only enter a range for a field that is also defined in the record fields. |
10. | You can apply ranges of these types: - Value: Enter a fixed value or a range of values using the advanced query syntax. - Custom: Enter a static method that defines the range. For example, you can use the SysQueryRangeUtil class to apply advanced date queries. Other examples are: 'curExt()' (gets the current company), 'strFmt("%1..%2", prevMth(today()), today())' (gets the orders from the last month), and 'DateTimeUtil::utcNow()' (filters on the current date/time). - Parameter: Enter an argument name that is defined in the BisDialogBase class. In this way, you can pass arguments to the message via code. This option only applies to D365 F&SCM documents. |
  | In the Range type field, select an option. |
11. | Define the range in line with the selected type. |
  | In the Range field, type a value. |
12. | Close the page. |
Related to | Notes |
---|---|
Manage document record setup - EDI documents |
  |
Manage document record setup - ODBC documents |
  |
Manage document record setup - Internal documents |
  |