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.
Thanks!
*This post is locked for comments
Use Vendor Item No., and place a small modification, like Saurabh said.
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.
Saurabh shah
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.
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?
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.
Why not use Item Cross-Reference? You can set Vendor Item No. for each Item you want.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (