Hi. We are putting into place a procedure to monitor our tooling work - this will include linking to Sales Orders received from the Customers and Purchase Orders placed with Suppliers. We are using UD01 as the ‘Header’ table for the information. I am creating a dashboard for this to be monitored and have a summary tab that groups everything together with total ordered, invoiced, etc.My problem is that I also want a detail tab but as we could have multiple Sales Order Lines and / or Purchase Order lines for one lot of work and all my attempts have resulted in the SO rows and the PO rows being linked together (see pic). The problem with this is that we want to use grouping and summarizing and it is obviously then giving false results. I feel like I should know how to do this but I am going round in circles… can anyone help?
Hi, Is there a way to filter a custom UD field which is binded to user code list based on the referance category for the part added to the sales order line.Our users add a new part to a Sales Order Line which is a finished goods machine they then have to select an engine (User Code list) from a combo box dropdown. Currently this list shows all engines but we want to be able to filter the list based on the Part added to the order line from the Ref Category from the Part table.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.