Table Builder

I am trying to build a report that will show me the quantity of base-level components needed for a specific sales order which contains many assemblies that have sub-assemblies. We use a project code as a dimension which is tied to the sales order.

I don't see "sales order number" in the various lists of tables, and every other report I've tried to generate gives me an error, something to the effect of "field name'([Item], [No.]) is qualified with a table name that is not a link table of that function.". I assume I'm building this incorrectly. Can someone point me in the right direction please?



Please sign in to leave a comment.