Vendor Aging Detail Report

Purpose: Use the Vendor Aging Detail Report to review a list of purchase order lines that are not yet either shipped or canceled. The report lists lines that are currently in Held, In Process, or New Order status within a specified range of current due dates.

Used for the Supplier Direct Fulfillment module.

Selection options: Optionally, you can restrict the purchase order lines listed on the report by:

How to generate this report: Available if Use Vendor Portal is selected at the Tenant screen. At the Run Reports screen:

Click the plus sign next to the Drop Ship folder in the left-hand navigation pane.
Highlight the Vendor Aging Detail Report. The center of the screen displays the related Report Options.
Select:
- Organization: The organization to include on the report. Defaults from the organization associated with the Default Shipping System from your user profile, but you can override this default. The Data Formats defined for the organization are used on the report.
- Vendor: Optionally, select a single vendor to have the report include only lines on purchase orders that are assigned to that vendor. Otherwise, leave this field blank to include all eligible purchase order lines regardless of vendor.
- Brand: Optionally, select a single brand to have the report include only purchase order lines associated with that brand. Otherwise, leave this field blank to include all eligible purchase order lines regardless of brand.
- Line Status: Optionally, select a line status of Held, In Process, or New Order to have the report include only purchase order lines that are currently in the selected status. Otherwise, leave this field blank to include all eligible purchase order lines regardless of status.
- Date range: Select either:
  - Rolling Dates: Select one of the date ranges available from this field to include purchase order lines that have current due dates during this range of dates. See Rolling Dates for more information on rolling date options); or,
  - From and To dates: Enter or select the first and last current due dates to include purchase order lines whose current due dates are during this range of dates. The From and To dates can be the same, and can be the current date.
  Revised due date? If the vendor has revised the due date for a purchase order line, the report uses the revised due date to determine whether to include the line on the report. Lines whose revised due dates are within the date range are included, even if their original due dates are not within the range of dates.
- Export to PDF: Select this option to generate a PDF version of the report that you can review in a PDF viewer.
- Export to Excel: Select this option to generate the report in .XLSX format, which you can open in a spreadsheet application.
  
  Note:
  You must select either Export to PDF or Export to Excel, or both.
- Email List: Optionally, enter one or more valid email addresses, separated by semicolons (;), to receive the report.
  
  Note:
  If you select both Export to PDF and Export to Excel, each email recipient receives two separate emails, each with a version of the report attached.
Click Run Report.

For more information: See Viewing generated reports.

Language and formats: The language, date, time, and number formats on the report are from the Data Formats defined for the organization.

Truncated data? If the data in any column exceeds the allotted width, it is truncated. For example, if the item description exceeds the allotted width of that column, any additional characters beyond that width are omitted. The specific number of characters that fit in each column varies because different characters have different widths: for example, a W is wider than an I.

Contents:

Organization Name and report title
Report Criteria heading: Each of the selection options entered at the Run Reports screen or the Schedule Report window is indicated here. The report lists All for each option that you did not select as a restriction.
- Vendor
- Brand
- Line Status
- Date Range: The range of dates entered at the Run Reports screen, or calculated based on the Rolling Dates selection at the Run Reports screen or the Schedule Report window
Report results: The results are sorted alphabetically by vendor name, alphabetically by brand name, alphanumerically by item code, and then in chronological order, and include:
- The vendor name for the vendor that has purchase order lines included on the report. Asterisks print if the vendor has been anonymized.
- The brand name for the brand that has purchase order lines included on the report.
  
  There is a page break and subtotal for each vendor/brand combination.
For each purchase order line included on the report:
- Item No: Your item number or code, including the SKU code, if any.
- Vendor Item No: The vendor’s item number or code. Vendor item records are created in Order Broker when Order Broker receives a purchase order from the originating system. When the purchase order originates in Order Management System, this is the vendor item number (WVNI).
- Item Description: Your description of the item.
- Units: The total number of open units for the item, brand, and vendor.
- Value: Your extended purchase order unit price for the item, brand, and vendor. Truncated if it exceeds the allotted space of up to 13 positions, including separating characters such as periods and commas.
- Line Status: The current line status.
- Due Date: The current due date for the item.
- Future Due Days: The number of days remaining until the due date. Included only if the current due date is in the future. Calculated by subtracting the current date with the current due date for the item. For example, if today’s date is 8/24 and the current due date is 8/25, the Future Due Days is 1.
- Past Due Days: The number of days that the purchase order line is past due. Included only if the current due date is the same as the current date, or is in the past. Calculated by subtracting the current due date for the item from the current date. For example, if today’s date is 8/24 and the current due date is 8/22 the Past Due Days is 2.
Totals: The total number of units and extended value for the vendor and brand. Extended value is truncated if it exceeds the allotted space of up to 13 positions, including separating characters such as periods and commas.
Grand Totals: The total number of units and extended value for the vendor, across all brands. Extended value is truncated if it exceeds the allotted space of up to 13 positions, including separating characters such as periods and commas.

The footer on each page of the report lists:

the date and time when the report was generated, in MM/DD/YYYY HH:MM AM format
the current page number and total number of pages (for example, Page 1 of 6)

The Data Formats defined for the organization control the formatting of the report.