Often, shipping instructions that are stored in RMS are exported to another business system using the Comma Delimited file format. It is often important that with each export, all new and only new records are exported. To facilitate this, RMS can keep a record of the maximum record timestamp (date/time that a record was created stored in the Imported field). It then checks this timestamp with each export, exporting only the records that have been created later than the existing maximum timestamp. Follow these step by step instructions to use this feature.
1. Create a report based on the ShippingInstructions dataset. See Creating Custom Reports for all of the details on how to create a custom report.
Note: At this time, this feature works only with reports run in a Batch that are based on the ShippingInstrucitons custom report dataset with an output option using the Comma Delimited file format.
2. The Fields Chosen for the report must include a calculated version of the Imported field:
Convert(varchar,Imported,121)
Choose the Imported field, so it is displayed in the Chosen Fields list box, then highlight it and click the Edit button. Paste the expression above. This converts the output of the Imported field to include milliseconds. Edit the Alias of this field and change it to ImportedTrack. RMS is "listening" for any report that has a ImportedTrack field name and expects it to be a timestamp formatted the way that the Convert function provides, so it is important to follow these instructions exactly. You can give this column a size of 0 so that it doesn't display when the report is viewed in the RMS Report Viewer. Regardless of the size given, it will not show up in the comma delimitted export file.
3. The filter for the report must include the following:
Imported > (SELECT CAST(REFERENCE_VALUE AS DATETIME) FROM T_PROGRAM_REFERENCE WHERE REFERENCE_LABEL = 'BOLLastExported')