Bill Detail Lines

Created by Travis Lander, Modified on Thu, 28 Sep, 2023 at 1:19 PM by Travis Lander

Description

The Bill Detail tab under Accounts Payable>Bills>Detail aggregates all line item information entered in Bills. You can use this tab to filter and review the contents of Bills all together in one place.

Bill Details Available

Many of the columns of the Bill Detail page reference the Bill that the line item falls under:

Number - Unique identifier for the Bill.
Status - Current status of the Bill (Created, Partial Payment, Voided, Paid, Approved)
Item - The Item/Description for the Bill (see icons below to determine between them).
Vendor - Vendor of Bill.
Location - Location of Bill.
Invoice Date - Date of Bill.
Created Date - the date the Bill was created.
Last Updated - the date of the most recent update to the Bill.
Ledger Account - For Description line items, this will be the alternate side of the journal entry from the AP Account. For Item type line items, this will be the Bill Account set up when creating the Item.
Cost Center - Cost Center associated with Bill (if any).
Product - Product associated with Bill (if any).
Job - Job associated with Bill (if any).
Custom Dimensions - Custom Dimension associated with Bill (if any).
Default Sales Price - the default sales price for the Item.
Default Purchase Price - the default purchase price for the Item.
Amount - Price per Description/Item.
Quantity - Number of Description/Item.
Tax - Tax entered manually or from a Tax Code (if any).
Total - Quantity * Amount + Tax Amount.

The Items column can be either a Description/Item:

The clipboard icon indicates a Description for the line item

The triangle icon indicates an Item for the line item

Bill Details Table Actions

Filters - Filter what appears in the table based on one or more fields available in the table.
Saved Views - You can create a set of filters that you would like to save to be able to quickly filter a table.
Column Selector - Hide and reveal extra columns and the number of rows visible in the table per page.
Export - Table data can be exported using the export button at the top of the table.
Click the blue highlight text under the Number column to bring up the original Bill for the line item.
Click the blue highlight text of the Item in the Item column to bring up the Item details.
Click the blue highlight text of the Vendor to bring up the full Vendor details.