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 FO 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 - Internal documents |
  |
Manage document record setup - EDI documents |
  |
Manage document record setup - ODBC documents |
  |