Post Master

EDL Cost Report

File Selection

Select an Excel or CSV file containing your Edit Decision List (EDL).
Select an Excel file containing your ClearTable Log with cost information.

Column Configuration

The system will match AX File Numbers in your cost log to the same number of characters in the "File Name" field of your EDL.

Then, it will extract the vendor name from the specified column in your cost log and add it to a new "Vendor" column in the EDL report.

The cost information will also be added to a new "Cost" column in the output.

Select which column in your cost log contains the AX file numbers.

Select which column in your cost log contains the vendor information.

Select which column in your cost log contains the cost information.

When checked, items with the same AX number will only be counted once in the total cost calculation.

About EDL Cost Report

The EDL Cost Report matches AX file numbers from your cost log to the "File Name" field in your EDL.

It extracts vendor names and costs from the specified columns in your cost log and adds them to new "Vendor" and "Cost" columns in the output report.

The system automatically handles duplicate costs, flagging them in the output file for your reference.