INV Inventory Item Upload & RDF Conversion

Hello Andy!

I wanted to see if I could get your thoughts on an issue I’m running into while testing the INV Item Upload report/functionality.  In my attempts to test this report, I am struggling with the creation of new parts–more specifically in the creation of new parts in the children organizations.  Creating in Global has proven to be straightforward.  However, part of our current item creation process is creating in the Global org and assigning to multiple other organizations in the same load (currently via API Wizard.)

For example, we have many parts that use a source type of “Inventory” because they are produced internally.  At the Global org, they are set up as Buy/Purchased.  There are multiple organizations where they are essentially assigned with the same attributes as the Global org.  The challenge is these parts are set to be sourced from another organization where the part has not been created yet.  In that source organization, the part would be created using the “Copy From Template” column to apply a separate template to set up the part as Make rather than Buy.

When attempting to create these parts in the same upload, the Global and “Make” orgs process successfully.  However, the other organizations fail the load with an error.  The organizations where the part should be sourced from the “Make” organization fail and state the “Item does not exist in this source organization [Source_Subinventory]”.

I tested loading a part at Global and the organization the part is sourced from in the same load.  Then after this load completed successfully, I ran a load for the part in the “Buy” organizations via a separate load.  Would there be any way to combine the loading of the same part that is both a “Make” part and a “Buy” part with it being set to be sourced to the “Make” org in the same load?

I’m attaching two Excel Upload files for your review as well–one with the parts and specs to be loaded and the other with the same parts and the messages received after failing to load all orgs properly.

Is it possible I am not doing something properly, or will we need to do separate loads for this to work as intended?

Thanks for any feedback/recommendations.