Hi I am trying to add sales header information to report 113 Customer Item Sales. I have added the Sales Header Data item and linked it to the ledger entry data item on Document number. As I am trying to get a meaningful Shipped Not Invoiced Report I have altered the DataItemTableView to only show lines where the invoiced qty is zero. Whilst I can access and print any fields from the Customer or Item Ledger Entry dataitems if I add a new section from the Sales Header anything I put on there will not print on the report. I am sure I am missing a simple point here but it is REALLY frustrating! Steve
Item Ledger entries are not related to the Order (= Sales Header table), but to Posted Shipment and/or Posted Invoice. If you want to show the order for shipped-not-invoiced entries, you’ll first have to lookup the Posted Shipment and get the order no. from that record. Be aware, though, that the shipment and the invoicing are (can be) two different entries in the Item Ledger, which makes filtering complicated. You also will have noticed that the report is using the GroupFooter to display the item lines (GroupTotals = Item No.) Believe you are better off when the report would use the Sales Lines table. John