Description
The Bill Detail tab under Accounts Payable>Bills>Detail aggregates all line item information entered in Bills, such as the expense lines with dimensions tagged against those lines, as well as Tax lines. You can use this tab to filter and review the contents of Bills all together in one place.
Note: When looking to review aggregate AP Bill details such as total amounts, tax amounts, values against certain Cost Centers, etc. - this table is an excellent resource to get all bill line details for review within the Table or out in excel.
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.