Inventory move entering BP and BP location may result in error related to constraint cbpartnerlocation_mmovement. The constraint is incorrectly defined:
CONSTRAINT cbpartnerlocation_mmovement FOREIGN KEY (c_bpartner_location_id) REFERENCES c_location (c_location_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED, Should be: CONSTRAINT cbpartnerlocation_mmovement FOREIGN KEY (c_bpartner_location_id) REFERENCES c_bpartner_location (c_bpartner_location_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED,
_
Environment
None
Attachments
1
Activity
Show:
Michael Powacht September 3, 2017 at 8:04 AM
Issue can be closed, I don't seem to have the necessary JIRA privilege.
Inventory move entering BP and BP location may result in error related to constraint cbpartnerlocation_mmovement. The constraint is incorrectly defined:
CONSTRAINT cbpartnerlocation_mmovement FOREIGN KEY (c_bpartner_location_id)
REFERENCES c_location (c_location_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED,
Should be:
CONSTRAINT cbpartnerlocation_mmovement FOREIGN KEY (c_bpartner_location_id)
REFERENCES c_bpartner_location (c_bpartner_location_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION DEFERRABLE INITIALLY DEFERRED,
_