Report-18

Bill Line Item Report

Bill details grouped by Bill Line Item Caption. You can search for a specific Bill Line Item Caption or Bill Line Item Type.

Report-18 recommendations

  • The report is limited to 10,000 line items, it may be helpful to limit the report to a subset of data, set a filter such as Topmost place, Building group, Vendor, or Commodity.
  • To avoid lines with a zero or null value, set the filter, Bill line value to not equals 0 (zero).

Report-18 tip

You can use this report to see information only line items. (Info_Cost, Info_Demand, Info_Use)

Set your filters for Report-18

  1. Set the Bill line caption or Bill line item type.
  2. Set the Bill line value not equal to zero.

Other filters to consider for Report-18

  1. Active accounts only
    Decide whether to include only active accounts.
    If this filter is not applied, your report includes both active and inactive accounts.
  2. Chargebacks or Vendor Bills
    Use the Bill is from external vendor filter:
    • Select yes to show only vendor bills.
    • Select no to show only chargeback bills.
    • Leave blank to include both.
  3. Void bills
    Include if you want a full audit history.
    Exclude to focus only on valid financial activity.

Example filters for Report-18