Vendor Item No.

(0) Share

Report

Posted on by CILGroup

397

Hi,

I am just working with the two fields on item card (Vendor No., Vendor Item No.). If we enter data here, shouldn't that data be automatically posted to the ITEM VENDOR and ITEM CROSS REFERENCE tables?

I thought this was happening but it doesn't. If this is the case, then where does the Vendor Item No. field from the Item card get used?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (5)

Verified answer

tpupko 2,048 on at

Like (0)

Report

Hi,

System uses Vendor No. field in Item card in MRP for identify Vendor to Purchase Item. If you want to enter in Purchase documents Vendor item number you can use Cross reference table to identify Vendor Item number

Tataina

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report

Please refer to Vendor Item No. Field, Item Vendor Table information: msdn.microsoft.com/.../hh172328(v=nav.90).aspx. The program enters this item number as a default in the Vendor Item No. field on purchase lines if you enter the vendor number from the Vendor No. field in the Item Vendor table on lines of quotes, orders, invoices, and credit memos or on requisition lines.

Was this reply helpful? Yes No
Verified answer

RobertasR 5,004 on at

Like (0)

Report

Hi,

Vendor Item No. field on the card is a simplified version of Cross-References, and it doesn't copy to Item Vendor or Item Cross References tables.

When you put item on the Purchase Order, the value in the 'Vendor Item No.' from the Item Card will be copied to the purchase line field 'Vendor Item No.', so you could use it in printing, or intercompany functionality. And that is pretty much it.

The Cross Reference / Item Vendor, however, have much more features, like automatically finding Item No. based on the Cross-Reference No. on the purchase line, adding Vendor Variants, lead times, etc. When you create an entry in table 'Item Cross References' it will be copied to 'Item Vendor'.

Robertas

PS. Please Verify if it answers your question. Thanks.

Was this reply helpful? Yes No
CILGroup 397 on at

Like (0)

Report

Thanks for the responses. We just thought that by entering a default vendor / vendor item no on the item card that it would also automatically post a record in the item vendor and cross reference files.

It just means we have to enter the data twice (once on the item card, then again cross reference file which in turn automatically posts a record to the item vendor file).

Was this reply helpful? Yes No
Verified answer

tpupko 2,048 on at

Like (0)

Report

Hi,

What the reason that you want to have same data in two places:

- Vendor Item no

- Cross reference

If you need to have Vendor item number in documents you can use cross reference table only.

Was this reply helpful? Yes No
Verified answer

mmv 11,471 on at

Like (0)

Report

Not necessary that you need to enter it at both the places. It's purely upon your requirement. You may use the Cross References.

Was this reply helpful? Yes No