You asked "How can I export inventory list by matrix?"
ANSWER
The only way to export inventory is to
1) open the Inventory Center
2) choose the Gold (Send To) Arrow icon at the top of the Inventory Center screen.
FILTER THE EXPORT
You must apply a FILTER of some sort if you only want to see Matrix items.
I recommend choosing a DEPARTMENT as the filter.
---1) Click on the Binocular Icon
---2) Lookup the Department Name
---3) Choose OK
The only items being displayed in the list will be items assigned to that department.
I suggest that the List be sorted by Description (click on the Description column title) before choosing to Export with the Gold arrow icon.
You will be prompted to send the export to a FILE and perhaps to Excel
Instead of filtering by department, you could filter by Category (the icon to the right of the binocular icon)
NOTE: Choosing the M icon will only export matrix headers and not the individual items.
Further Refinements
When you use the above steps All information about an item is being exported including pricing, stock counts, vendor, etc.
If you do not need that much information in the export, you can choose which fields to export. For example you may only want the SKU, Description, and Cost
--- 1) open the Inventory Center
--- 2) right mouse click on an inventory item
--- 3) choose Define View
--- 4) choose NEW
--- 5) after giving it a name remove titles from the right side box to the left side box. Anything left on the right side will be exported.
--- 6) choose OK or Finish
Now you can export this information as described above.
NOTE: Right mouse click on an inventory item and choose Reset View to be able to see all fields of all inventory items again.
The Help File has additional information about each of these activities.
