Report showing invoice lines


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.

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


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

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

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.

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

1 Like

Guide to draw sqllite database for writing reports into crystal reports