Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Section


Column
width60%

Image Removed

Introduction

This Vendor report is an IRW report (IRW Documentation) and gives you the option to build and sort your Vendor list. This is not used very often as the vendor grid is a user-friendly way to view all of your vendors and their information. The grid can also easily be exported to Excel, where this report has an option to export into a comma delimited file.

With this report, you can customize the columns of information based on the criteria in the sort field.

Table of Contents

Table of Contents
excludeTable of Contents|Introduction


...

In the Select Statement, you can choose to leave it blank, thus selecting ALL Vendors. OROr, you can choose to select a single Vendor or a subset of Vendors based on Vendor setup APVNM.ACV.

...

Each IRW report in AMS has a feature to help you build the report, showing you a list of available codes and descriptions. More documentation can be found here: Integrated Report Writer Documentation.

To use the wizard place your cursor in the SELECT statement and click on the drop-down arrow that appears at the end of the field.

...

<> Not Equal to

> Greater Than

< Ledd Less Than

~ Containes

| Does Not Contain

...