Report showing invoice lines

1

Hi,

How do I get a report or export of Sales Invoice lines - including customer name, invoice no, line description, price, paid etc

Thanks in advance.

2

or can I use custom reports? if so, what is the table name for invoice line items?

Thx

3

There is no built-in capability for such a report. Custom reports is a work in progress with no documentation yet.

4

OK thanks Tut. Do you know the table name - so I can extract using SQL via custom reports?

5

No. Nor do I know if there is a table containing all the information you listed. I don’t know anything about the database structure.

6

Do you know if anyone has tied crystal reports to the SQLLite database in the single user environment?

1 Like
7

Guide to draw sqllite database for writing reports into crystal reports