Welcome to the Community forum, rc68nyc.
When importing inventory parts with parent-child relationships into QuickBooks Desktop (QBDT) using the Advanced Import feature, you may encounter difficulties mapping the "SUBITEM IF" field.
To resolve this issue, you can use the "ListID" field to establish the parent-child relationships during the import process. Instead of mapping the "SUBITEM IF" field directly, make sure that each child item includes the ListID of its parent item in the "ParentRefListID" column in your Excel file. This will link the child items to their respective parent items. Before doing so, please make sure you create a backup of your company file for future use.
Then, during the mapping process in the Advanced Import feature, you can look for the "ParentRefListID" field and map it to the corresponding column in your Excel file that contains the ListID of the parent items. Before proceeding with the import, double-check your Excel file to ensure that the "ParentRefListID" column contains the ListIDs of the parent items for each child item.
By using the "ParentRefListID" field to establish the parent-child relationships and mapping it correctly during the Advanced Import process, you should be able to import your inventory parts with the appropriate parent-child structure into QBDT.
If you continue to encounter issues, you can consider reaching out to Customer Care Team. They can perform a screen-sharing session to help you further with the import process.
If you need other helpful articles in the future, you can always visit our site: Help articles for QuickBooks Desktop.
Keep me posted if you need further assistance while working in QuickBooks. I’ll be right here to help. Have a great day.
