Return history loaded to is_fictive location
SQL
SELECT location_id, loc_status, is_fictive, t_ep_organization_ep_id, last_update_date FROM CCWDMP.LOCATION WHERE LOCATION_ID IN (3, 7, 8, 9) ORDER BY T_EP_ORGANIZATION_EP_ID
shows t_ep_organization_ep_id of 3 corresponds to multiple location_id 3, 7, 8, 9 but the only combination of location_id 3 and t_ep_organization_ep_id of 3 has is_fictive as 0 (the details are attached).
I loaded one item to t_ep_organization_id of 3 with return history of 11. The integration interface has insert combination feature checked. However, the sales data table shows all the location_id of 3, 7, 8, 9 have return history of 11 so the total return history for this organization becomes 44, which should only be 11 for this organization. What i shall do to make return history to load for the combination of location_id 3 and t_ep_organization_ep_id?