Hello Erik,
I am trying to add a value to a report (10074 Sales-Invoices). Similar to the default, it reports our sales order quantity in our default unit of measure (eaches). Several customers have requested that this also be reported in cases. The problem seemed straight forward enough. I created a flow field from table 5404 Ituem unit of measure flow field no 3 Qty per unit of measure with filters on Item No and fitler code=CA to table 113 sales invoice line and to the report. This did exactly what I wanted. On posted sales invoice lines, the quantity per case is present and it is correct for each item code.
So I export my report 10074 to RDP to edit with Microsoft Report Builder. I also chose a posted sales invoice and exported it to Excel to see my data. Well, the data became disjoined. The quantity per case created new data lines that are not associated with their relative item code in Excel. That makes the math (which I planned on doing in Report Writer, each/quantity per case) unreliable. Is there some set up I need to do to properly connect the subform data to the header as the data is generated?
Thanks,
Eric
Hi Eric,
The 100xx reports are designed (by Microsoft) in such a way that ReportExtensions (What SOD creates to add fields to them) doesn’t work for line elements on the reports. The lines are shadow-copied and the lines that prints are from the shadow-table. It’s not possible to add fields to the shadow table.
It’s beyond the Simple Object Designer capabilities to work with the lines on these reports.
Have you tried report 1306 instead?