I'm trying to make purchase orders that will automatically populate the line item portal with items that are available from the chosen vendor along with the prices and part numbers of that vendor. However, many of our items are purchased from multiple vendors, so each item has multiple vendors, part numbers, and prices associated with it.
When I create a new PO and select vendorA from the drop down list, I would like it to display all the items available from vendorA with thier part relevant numbers and cost. Then I can select the items we wish to order and generate a PO with the items I chose. But if I want to switch to vendorB, I need it to update the part number and price fields with those of vendorB.
How to achieve this is boggling my brain. So any help would be most appreciated.
Make sure the table with the vendor price contains the Vendor ID and the SKU. then pass the vendor id to the line item, the sku should already be there. Create a relationship from line items to vendor price table using the sku and the vendor ID. Use that relationship for the lookup.
Pueblo Systems, Inc.