Vendor's data integrity problem (item loc without a primary supplier)
Hello all,
I have a data integrity problem in SIM 13.2.4.
There are a supplier and its items in RMS. The vendor has been created in SIM by RIB's VendorCre message.
Now, all StockOrders or ASNs related to the vendor's items stick in staged_message with "Cannot have item loc without a primary supplier!" error.
I check some tables and I have entries in RK_ITEM_SUPP_COUNTRY, RK_STORE_ITEM_SOH and AS_ITM for this supplier and its items.
But there is no entry in the RK_ITEM_SUPPLIER and AS_ITM_RTL_STR.
When I try to populate the data to RK_ITEM_SUPPLIER manually (based on data in RMS) then the ASNs' and StockOrders' messages stick with PK_RK_STORE_ITEM_SOH constriant integrity validation error.