I'm troubleshooting a CSV import of sales orders. I'm getting the error "Invalid item reference key XXXX for subsidiary 2." I've tried to specify the item by name and by internal ID. the item subsidiary is the same as the customer subsidiary, which has ID 2. the item and the customer are not inactive. the item is a matrix item and a serialized assembly. any ideas of what I can try to get it working?

Hello Can you show me your mapping? And check if is an Item Filter set in the Custom Form, and it filters out the item being set.

to avoid import issue you may want to activate everything (items, customers, etc.) upload and then inactivate it if necessary

It's normally to do with the item not being associated with the same subsidiary as the subsidiary of the sales order. e.g. Your sales orders are going to subsidiary 1 and your items are listed under subsidiary 2. Make sure your items are inherited by all subsidiaries. Make sure the "Include Children" is ticked on in the item record under the Subsidiary name, or at least ensure that the subsidiary where your sales orders are being posted is the same subsidiary your products belong to.