Forum Discussion
Helper IIData from another table filters out empty fields (should be visible)
Helper IISales orders has a unique numbers, yes. These have relationship to Sales Lines so I can get articles each order contains. Sales Lines have relationship to Shipments, where I can get shipment numbers.
Sorry, I wasn't clear enough in my original post. I said 2 tables but there is 3 actually.
Sales Order Header:
order 46225
Sales Lines
order 46225
article 1
article 2
article 3
Shipments
order 46225 shipment SH123345
article 1
article 2
article 3
Solution SageThen the Sales Order Header should have a one to many relationship to both Sales Lines and Shipments on the Order ID column
- Matt78
I did that but for some reason when I add Shipments in the matrox it gives error it cannot determine relationships between the fields.
- JoeBarry
Can you share a screen shot of the top rows of each table. I need to see what format they have
- Matt78
Sales Order Header
Sales Order Lines
Shipments
- JoeBarry
Add to the Matrix, the No_ from Sales Order 1st (This is the shared dimension). Then add the columns you need from the Sales Line Items, then the Shipments.
- Matt78
Relationships should be ok but it still gives error when I add shipments to the matrix