Vendor's Item Numbers

Post date: Jun 15, 2017 2:25:22 PM

When entering or modifying a line on a PO, there's a field called 'Vendor's item number'.  If you refresh the vendor information on this screen, it will populate that field with the appropriate vendor's item number from the 'master' table (icvendoritems).  Whatever is in the 'vendor's item number' on the PO line will be saved permanently on that PO line, even if you later change the vendor's item number in the 'master' table.

It's done this way so that EVEN IF you later change the vendor's item number in the 'master' table, the history of vendor's item numbers on each PO line is kept, and the original PO can be reproduced faithfully.

NOTE: If you add a line to a PO, and change the vendor's item number on the PO line screen, it DOES NOT update the 'master' vendor item number.  But updating the vendor's item number on a receipt WILL update the 'master' vendor's item number.  The assumption is that if you are updating the vendor's item number at the time of receipt, you are intending to CORRECT the vendor's item master table.

Here are the 'rules' for what gets updated when:

The vendor's item number on the PO line ONLY gets updated when someone goes into the line, edits it, and saves it.

The 'master' vendor's item number gets updated when: 1) someone edits it from the 'Edit vendor item information' link, which is on the 'IC Edit Items (1067)' screen, or 2) someone updates the vendor's item number on a receipt line.

Display:

On the 'IC Edit Purchase Orders (21)' screen, the vendor's item numbers that appear are whatever was saved on the PO line, and that may be different than what was last saved in the 'master' vendor's item table.  But the LINK on these vendor item numbers DOES lead to the 'Edit vendor's item numbers' function and allows you to update the MASTER TABLE ONLY.  To edit what appears on the PO line, go into the PO line and edit it.

On the 'IC PO Receiving (20)' report, the vendor's item number that appears is the one FROM THE PO LINE, not from the master file.  This is appropriate because that is what is actually entered on the PO line.

On the 'IC Display Item Information (1070)' screen, the 'vendor's item number' is what's in the 'master' table for that item.  (Remember: It could be different on individual PO lines.)