6.3 – Filter Transform

Before we import the orders into Sage200, we want to filter out the additional charge lines without a value.

  1. Drag a filter transform and connect it to the Aggregate transform.

  1. Double click to open its setup; rename its Transform Id to Filter.

  1. Click on the Field Mapping tab, and select the OrderDetails transaction.

  1. Enter formula:
    • %LineType = 0 Or %LineType = 3 Or (%LineType = 2 And %StoredValue <> 0)

The result of the formula must evaluate to a True or False value, where a False value will mean the record is removed (or filtered) from the dataset.

  1. Press refresh.
  2. The 1st Order will have ‘Assembly’ and ‘TwoManSupplement’ removed.

  1. Save the transform and close.
Step 7: SOP Import>