Show Only Invoiced Items in Report

Scott_Meja · 2009-03-17

In Sales Order Report i need to show the report only with the items that are invoiced i.e the items whose quantity to Invoice field is filled in sales order,the quantity Invoiced field.
I have Sales Header as parent DataItem & Sales Line & sales Comment Line , Integer are indented under Sales Header DataItem.

what code should be written in report to see the items that are invoiced and on which trigger of Sales Line DataItem?

mohana_cse06 · 2009-03-17

if u invoice the Sales Order, the order will be moved from sales header table to sales invoice header table.how can u show from SO.? :-k

Savatage · 2009-03-17

as above is it a sales order report or a posted sales inv report.

either way. View the properties of the "Sales Line" dataitem or "Sales invoice line" (whichever)

drill into the DataItemTableView
In the table filter add your new filter (ie) Qty invoiced <> 0 or whatever you need to show or eliminate

Show Only Invoiced Items in Report

Comments

Categories