Ordering - Managing Trek backorders

Written By Ascend knowledge base (Administrator)

Updated at October 3rd, 2024

To get started, reach out to your Trek representative (if they haven’t contacted you yet). Trek has a backorder spreadsheet that your rep should review with you to help create a plan going forward.

Once your plan is set, you might need to adjust or remove some backorders in Ascend.

To make the process easier we recommend using the sorting features in Ascend and Excel to easily find Orders that need to be updated.

  1. Open your (completed) backorder spreadsheet in Excel and use the Filter to sort by Order Number.
  2. Navigate to Database Explorer > Orders in Ascend.
    1. Update the Date Range to start at 4/1/2020 and finish with today’s date. This may take a few moments to load.
    2. Use the Filter in the Status column to only select Submitted statuses (uncheck Unsubmitted and Received).
      Screenshot with the Status column open and 3 Submitted statuses selected
    3. Use the Filter in the Vendor column to narrow your results to just Trek orders.
      Screenshot with the Filter in the Vendor column open
    4. Sort by Order Number there as well.
      Screenshot with the PO# column highlighted and the filter arrow pointing down

From here, you can more easily find and delete or update the corresponding Orders in Ascend.

KB22-190