We define the lowest level of our inventory part items as a SKU number. There can be multiple parent levels. For example we would have a category, style name and then multiple SKUs underneath for each color.

Optical

    [name removed]

        AYO0823BLKB

        AYO0823REDR

When defining the specific inventory part, the Item Name/Number is AYO0823REDR and the "Subitem of" is Optical:[name removed]. 

I need to be able to produce a "sales by customer detail" report with a column containing the actual Item Name/Number value as I have defined it. I need just AYO0823REDR. However, ALL sales reports that include the 'Item' column, always displays the Parent and Child levels as well. So it shows Optical:[name removed]:AYO0823REDR.

Our products are sold at the SKU level (item name/number level) and I need that on a sales report to be downloaded, for many reasons i will not go into. I just need it but I cannot find a way to do it.

In Company Preferences there is a setting for 'Reports - Show Items by" and you can select "Name only", "Description only" or both. This doesn't help. "Name only" then displays "Optical:[name removed]:AYO0823REDR" and description just shows the description and both of course shows both. I need the lowest level only.

Quickbooks obviously has the ability to do this because if you run an "Inventory Stock Status" by item report and include the Item column on the report, it displays exactly what I want to have in the sales report, in this case AYO0823REDR. How can i do this on a sales report?