Get Dimensions/Purchaser Code from Buy-from vendor instead of Pay-to vendor?

olly7

Good afternoon -

I am looking for a way to create a cross-vendor relationship which I don't think exists with NAV 2013 R2 out-of-the box.

Say we have a vendor who makes furniture components - we use one of our Global Dimensions to assign this vendor under our Furniture business unit. At some later date, the same vendor starts making lighting components - we create a new vendor card which is identical to the original, in all but only 3 ways:

> The new vendor card has business unit dimension value 'Lighting'
> The new vendor card has a different Purchaser Code assigned (as these purchase orders will be handled by a different employee)
> The new vendor card is linked back to the original (parent) vendor card using the 'Vendor No.' field on the Invoicing tab

When a new PO is created for the new (child) vendor, it pulls the business unit dimension value and Purchaser Code from the parent vendor card, nullifying the purpose of creating the new vendor with different dimension/Purchaser Code values. I have looked at the code in the Pay-to Vendor No. OnValidate trigger in the Purchaser Header table 38 and this is as expected out-of-the-box.

Is there any way to have the new PO pull the dimensions and Purchaser Code of its immediate (Buy-from) Vendor No, rather than the parent (Pay-to) vendor, without customizing? Has anyone had a similar requirement and found an alternative solution?

Thank you!

RockWithNAV

See there's nothing Impossible if it really needed you can do customisation and meet your requirement. Dimension part you can do whatever you want even you can add more than 2 Global Dimension, the only thing is you need to study first and understand the architecture.