Displaying the Open Items of the One-Time Vendor 

The next part of the scenario shows you how to drill down to the line items from your account monthly balances. You then change the standard screen layout so it better accommodates the analysis of one-time vendors. Finally, you manipulate the data to determine if you have had repeat business with any of your vendors which you have classified as one-time.

  1. On the Accounts Payable screen, select Account ® Display balances.
  2. On the Vendor: Initial Screen Balances Display screen, enter the following data:

    3. Field

    Europe

    North America

    Vendor

    1960

    3960

    Company Code

    1000

    3000

    Fiscal Year

    Current Year

    Current Year

  3. Select Enter to continue.
  4. On the Vendor: Account Balance Balances Display sreen, double-click on the period you just posted to in the prior step.

    5. The system displays a list of standard line items.

  5. To branch to another display, select Line layout... on the Period XX: Basic List screen.

    6. The system displays a dialog box with standard variants.

  6. Select Special variants.
  7. Double-click the line One-time account data.

    8. The system displays the line item list, including both the name and city of each vendor.

    Periodically, the accounts payable department analyzes the invoices posted to the one-time vendor account to determine if there has been recurring business with any vendors. You can do this analysis directly from the line item display.

  8. The procedure is to place your cursor on the Name column and select Totaling...

    9. The system groups all common vendors together based on the name and produces a total for each.

  9. Return to the Accounts Payable screen.