This browse displays a set of the Line Item from A/P Bills. This window can be opened in two different ways.

1. FROM THE MAIN MENU

   The first way to view these Line Items is directly from the A/P Main Menu. This method lets you display these Line Items in four different ways:

   • Select Quick Lookup to view all expenses entered into Accounts Payable and immediately locate them. There are two Quick Lookup tabs:
   • Transaction ID This lets you search for a line item by typing in the Transaction ID on that tab.
   • Expense Account Select a GL expense account to display only line items charged to that G/L account. You can further limit the line items displayed by selecting a Vendor ID. This will display only line items charged to a particular G/L account and purchased from
   • Select Query to create a custom list of records using a Query. This allows you to create a targeted browse or report to answer more complicated questions than can be obtained You use the Query tab to locate records matching a particular set of parameters that you may be looking for. Once you have made your query selections a browse box containing matching line items will appear.

2. FROM THE VENDOR BROWSE

   You may also open this browse box from inside the Vendor Browse. This lets you instantly view all expenses from the selected vendor, sorted by G/L Account.

Special Buttons

In any of the above browse windows the following functions are available:

[View]	View the vendor invoice for the selected line item in detail. You can easily clone a Bill once by pressing [View] to display the Bill, then pressing the [Clone] button at lower left.
[Print]	Print a report of the selected line items or use the Query Window to create your own list. This button is disabled when you select the Transaction ID tab in Quick Lookup mode.
[Query]	This button is available only on the Query tab. It lets you select your own group of records using the Query Window. You can save your queries for immediate recall.
[Source]	View the Source Transaction. If this line item was generated from a sales order you can view that sales order with this key.

Query Examples

Most often, the reports you will generate from this browse are printed from the Query Mode. Here are two examples of Queries you will often use:

HOW DO I PRINT A LIST OF PAID EXPENSES FOR THE MONTH SORTED BY EXPENSE ACCOUNT?

1.  Go to the A/P Line Item History menu and select [Query]. A list of Saved Queries will open.

2.  Press [Insert New]

3.  In Filter Criteria #1, enter ‘Payment Date’

4.  In Filter Operator #1, enter ‘>=’

5.  In Filter Value #1, enter the starting date

6.  In Filter Criteria #2, enter ‘Payment Date’

7.  In Filter Operator #2, enter ‘<=’

8.  In Filter Value #2, enter the ending date

9.  In Sort Criteria #1 select ‘Account’

10. Save the query with some sort of description.

11. Select the query. After a few seconds the screen will redisplay.

12. Press [Print]

13. In the Print Options window the Subtotal on ‘Account’ and Include Detail boxes should be checked. If they are not, check them.

14. Press [Proceed] to print.

If you wanted to limit the report to a single account (such as freight or COGS), you could add a third criteria to the filter after step #9.

HOW DO I PRINT A LIST OF EXPENSES FOR ONE G/L ACCOUNT OVER A RANGE OF DATES?

1.  Go to the A/P Line Item History menu and select [Query]. A list of Saved Queries will open.

2.  Press [Insert New]

3.  In Filter Criteria #1, enter ‘Account’

4.  In Filter Operator #1, enter ‘=’

5.  In Filter Value #1, enter the account to select

6.  In Filter Criteria #2, enter ‘Invoice Date’

7.  In Filter Operator #2, enter ‘>=’

8.  In Filter Value #2, enter the starting date

9.  In Filter Criteria #3, enter ‘Invoice Date’

10. In Filter Operator #3, enter ‘<=’

11. In Filter Value #3, enter the ending date

12. In Sort Criteria #1 select ‘Vendor ID’

13. Save the query with the description ‘CoGS Expense Report For February 2001.

14. Select the query. After a few seconds the screen will redisplay.

15. Press [Print]

16. In the Print Options window check the ‘Subtotal on Vendor ID’ and the ‘Include Detail’ boxes.

17. Press [Proceed] to print.