We set up a cross-reference on a stock item as a “Customer Part Number”. When we we load sales orders via EDI, the process works. Those orders come in with a customer part number and are loaded to the sales using our internal part number.
HOWEVER, when we load forecasting data, the cross reference does not work. Our EDI partner says it is erroring out with “Forecast.InventoryID: 'Inventory ID' cannot be found in the system”.
We are starting to build a workaround and contingency plans. Can anyone tell me if this is the way Acumatica was designed or is our setup wrong?!?!?! It seems odd to me that the cross reference would work for orders but not for forecasts.
Thanks - Shawn