All,
We’ve been doing many different DMTs to upload data into our new environment and have got used to trawling through the field help to match fields we require etc but I’m encountering an error on DMT’ing resources / resource groups:
A valid Input Warehouse is required Table: resource Msg: A valid ‘In’ Bin is required
Also, the DMT tool only lists “Resource Groups” but no “Resources”. Does one area cover both?
Do you have the AMM module if so you need to provide location information in your DMT.
Hi @jgiese.wci
I can confirm we do have AMM installed and licensed.
Location was in the DMT source and and set to YES.
We didn’t have Resource#Location in the DMT but testing by adding that and setting to YES still returns the same error.
There are only those two references to “Location” within that DMT so not sure what else to add
You have to provide the warehouse and bin in and out of that resource. If you do it at the group level you can let that cascade down to resource, but you have to have those values filled in at the group level for sure.
Same field names for resource but just Resource# I believe.
Your last comment seemed to be the answer.
The required field popup doesn’t state if you fill in the group field you need to fill in the corresponding #Resource field. Adding matching #resource fields seemed to fix the issue.
I am adding items to the source file now to test in full.
That was it. If you use a ResourceGroup field add the corresponding Resource field i.e. #Resourceabcxyz
Thanks for that
