We have all of our items and locations tied to one subsidiary. I use a template to make inventory adjustments, by location and items. All mapping have worked for a long time. Until, we added a new single location that was assigned a different subsidiary than all the others. It also has only 3 items associated with it.
Now when I try to do a CSV upload with our original items, locations and subsidiary, it is giving me the invalid item reference key for subsidiary error. We have double checked all items, locations, etc and the subsidary is still set correctly. I have also tried changing the pencil icon on the CSV upload to Provide Default value, instead of using the internal ID. But it still returns the same error. Is there anything you can think of that I now need to add to the CSV upload that is missing. Columns I use for the upload are below and I have double checked each column's settings along with the various account settings.
External ID | Date | Subsidiary | Adjustment Account | Posting Period | Memo | Department | Adjustment Type | Brand | Item | Memo (Line) Item Name | Adjust Qty. by | Location (Line) | Department (Line) | Brand (Line) | Inventory Detail: LOT Quantity | Inventory Detail: LOT Expiration Date | Inventory Detail: Issue LOT Number | Bin |
|---|