COM API

LineItemRows property

Example | Applies To

This property returns the LineItemRows collection from page number iPageNum.

Important: In INVOICES 5-5 and later, there is normally only one line item collection per invoice, and you access it through page 1, i.e. Invoice.LineItemRows(1). You can use Field.LineItemPageNum to find out what page the line item cell is on.

Setting UseGeometricLineItemMatching to 1 in Eiglobalextra.ini gives you the INVOICES 5-4 type of line item matching in INVOICES 5-5 and INVOICES 5-6. That results in the old behavior in the API, as well, namely one line item collection per page. You will also get one line item collection per page if there are "many" pages on the invoice—by default 10 pages. It is possible to change this limit by specifying LargeTableLimit in Eiglobal.ini.

Background: In INVOICES 5-4, there was a line item collection on each page. This design could not handle line items where a line item’s rows spanned two pages (for example if the beginning of a line item was on page 1 and the rest was on page 2). For INVOICES 5-5 and later, the line item matching was improved to handle line items with multiple rows in a better way. This implied that there could only be one line item collection per invoice. You still access the collection through page 1 for the sake of backwards compatibility.

Syntax

object.LineItemRows(iPageNum As Long) [= value]

Part

Description

object

An expression that evaluates to an Invoice object.

iPageNum

The number of the page that contains the table you want to return.

value

A LineItemRows collection.

BankAccountRows property

VATRows property