When using the standard warehouse locations data entity, I kept getting an error that the "Field WarehouseAisleId must be filled in."
This is odd because the wmslocation table, the entity and the staging table all have the Mandatory property set to "No" for this field.
While investigating, I found that in the WhsLocationBuild class, "createNewLocation()" method, the system sets wmsLocation.aisleid to '--' (yes, it's hard-coded, sigh).
Also, the data entity specifically checks that the field is filled in during the validateWrite() method. To get around this, I added:
'--' as WarehouseAisleId
to my script that exports the data out of my legacy application.
Hope this helps!
Thanks for the post!
ReplyDeleteThis worked perfectly! Thank you!
ReplyDeleteGlad I could help!
Delete