vendor item number on purchase order

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Aleksandar Totovic 16,765 on at

Like (0)

Report

Why not use Item Cross-Reference? You can set Vendor Item No. for each Item you want.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

You want to display vendor item no. in purchase order report, that you send to the vendor.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Aleksandar Totovic 16,765 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Saurabh Shah 4,560 on at

Like (0)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Andri Wianto 385 on at

Like (0)

Report

Use Vendor Item No., and place a small modification, like Saurabh said.

Was this reply helpful? Yes No