Is there a way that my NAV purchase orders can have our standard item number on most of the time, except for where there is a specific vendor item number in there in which case it will use that one? We don't have many vendor items numbers yet but will be building up our bank.
Why not use Item Cross-Reference? You can set Vendor Item No. for each Item you want.
If you want to see Vendor Item No., on Purchase Order form, you need to show column "Cross-Reference No." on PO Line. You can see this Vendor Item No. if you configure this on Item card.
You can also enter new item by lines entering "Cross-Reference No." instead of No.
If you want to show this data on PO report, you need to make small customization.
I Agree with Aleksandar, You can use Cross reference functionality where you can set the vendor's Item code against your internal item code and this cross reference number is also available in PO line.
Second option, If Vendor's Item code is common across all vendors for an item then you can define it on Item Card.
Now, to print, Vendor's Item code instead of internal item code. you can make a condition in report that if Cross reference number is exist on PO line then it should print Cross reference number else Item code. This is very small modification that you need to do on purchase order report.
Same is applicable for second option of item card but in that case, you need to check item table for the vendor's Item code field value.
Thanks, but from what I can learn of this it's like the other way round, I think cross references mean that you can put in the vendor's number and it will pick up our internal number for the purchase order.
I was looking for a way that means we put in our internal number and but it will show a different number on the purchase order to the vendor which is their item number - and obviously there may be more than one vendor each with their own different code.
You want to display vendor item no. in purchase order report, that you send to the vendor.
Manish R Sharma | Techno-Functional Consultant Microsoft Dynamics NAV
ok - is it possible to set the report so that if there is a vendor item number in there is uses it, otherwise it puts our item number in there - so we only need 1 column?
Use Vendor Item No., and place a small modification, like Saurabh said.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics