Where there are multiple ship-to records under a supplier, there are issues.
It seems the Ship From table is not properly maintained with item numbers when there are multiple ship from under a supplier. Further research is needed. Below are some notes:
Can't add item to PO (DET Ticket 3265507, CB ticket 271064 under PFP)
When selecting the item on the PO,
when the primary ship from is selected, the item shows up even though it is not in the "ship from tab"
when the non-primary ship from is selected, the item does not show up in the list
This is the query that shows the list of items you can select from on the PO:
Select top 1000 * from [PurchaseItemView]
Where ( WarehouseCode = 'MAIN' )
and ItemType NOT IN ('Gift Card', 'Gift Certificate')
and ( SupplierCode = 'SUP-000023' )
and ( LanguageCode = 'English - United States' )
and ( ShipFromCode = 'SFRM-000029' )
--and ItemName = 'NCD 0568R'
Where there are multiple ship-to records under a supplier, there are issues.
It seems the Ship From table is not properly maintained with item numbers when there are multiple ship from under a supplier. Further research is needed. Below are some notes:
Can't add item to PO (DET Ticket 3265507, CB ticket 271064 under PFP)
When selecting the item on the PO, when the primary ship from is selected, the item shows up even though it is not in the "ship from tab" when the non-primary ship from is selected, the item does not show up in the list
This is the query that shows the list of items you can select from on the PO: Select top 1000 * from [PurchaseItemView] Where ( WarehouseCode = 'MAIN' ) and ItemType NOT IN ('Gift Card', 'Gift Certificate') and ( SupplierCode = 'SUP-000023' ) and ( LanguageCode = 'English - United States' ) and ( ShipFromCode = 'SFRM-000029' ) --and ItemName = 'NCD 0568R'