Hi there,
How do I generate custom reports that include Salesman ( i created custom field on the sales invoice), Item (from Inventory Items), and the quantity ?
Custom reports are a work in progress, not yet implemented
can we add Qty field on the sales invoice reporting?
What quantity are you referring to and what “sales invoice reporting?”
when you create sales invoice, it will include product quantity (Qty). But it is not included in the custom report table (Select * from SalesInvoices). And also, is it possible to include the new custom field created in the Sales invoices into the custom report (Salesman)?
First of all, there is no specific quantity associated with any sales invoice. Quantities are attributes of line items. A sales invoice report cannot report a quantity, because it might contain 50 line items with different quantities.
Second, as you’ve already been told, there is no documentation on custom reports. So no one knows what is possible.
i required sales invoice report in format of
INVOICE NUMBER INVOICE DATE CUSTOMER NAME TAX AMOUNT TOTAL AMOUNT
is it possibel via custom report