Matrix Form!!


Does Anyone have any Idea to make to create a matrix form and then Export that data to excel or show it to reports?[:D]

I want to achievd is that to show all the Item Quantity base on the Posted sales Invoice

This is my requirements:

Matrix header is the All item tht trnsact in the base in the posted sales invoice.

Matrix Body is the Quantity of all the item base in posted sales invoice.

The Left Side is the Invoice header(e.g Sales Invoice No…Sell-to Customer…etc)

And I want to show all the in the reports or Export to Excel…just asking for Idea how to do it…but if you have done It can i download it?[:D]

Hoping for your reply…TY

Have a look on FORM - 7117 (Sales Analysis Report).

It may help you to achieve your requirement.