I want to pull up and put together information from a Purchase Order and the Sales Order it is connected to. I am having trouble finding a table connection to the two that doesn’t result in duplicate results. For example, I have PODetail going to Part going to OrderDtl. But it’s lining up data incorrectly. It is assigning SOs to POs that I know aren’t together.
Any suggestions?
My ultimate goal is to get the customer’s purchase order number to line up with our purchase order for it.
Correct. Just think about it logically for a second.
Spacely Sprockets sells sprocket A to 10 customers. Today you get 3 orders for 10 sprockets for 3 different customers. You happen to have 10 in inventory right now. You purchaser sees that you will need another 20 to meet demand, and you normally have 10 in stock. So the purchaser makes a PO for 30 sprockets. Which PO goes to which customer?
The answer is, POs and Sales orders aren’t inherently linked unless you use buy to order, so that’s not really a valid question.
If you’re just looking for the Customers PO number, that’s on the OrderHead table. (PONum.) But that has nothing to do with YOUR purchase order, that’s the PO that the customer is using to buy from you.
One thing I just remembered that I forgot to mention, which is probably a crucial part of this, so forgive me…
We do have a link. But it’s a customized field. In the PO screen, we had someone create this:
Which I can pull just fine because it’s in the POHeader table. Is there a way I can find the link through there? I would probably need to go back to the people who created this…
(I do not know why we do not do Buy To Order and instead opted for this)