Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Custom View that includes Order and Order Product RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    Is anybody knows how to create custom view that includes sales order and order product? I want to list all orders including product. I'm having difficulty in doing this.

    Thanks!

    Friday, April 19, 2013 9:26 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Create your view on the order products, hence you could access the order details also. You have to sort the order products based on their order. However, I think this view could be useful. Because everyone wants to see the grouping based on an order. If your requirement is this, create a report which its primary entity is order and the related entity is order product. Then do a grouping based on the order. This could help you.


    My Weblog -- My Website

    Friday, April 19, 2013 10:21 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    In order you may filter your view in relation with order product but you can't include orderproduct's column directly. In order product there is a associated view where you can add both columns from order and orderproduct  Try by open orderproductassociatedview->add column->In record type you may see both order and order product. Try to use that!


    Sindu M


    Friday, April 19, 2013 10:44 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Create your view on the order products, hence you could access the order details also. You have to sort the order products based on their order. However, I think this view could be useful. Because everyone wants to see the grouping based on an order. If your requirement is this, create a report which its primary entity is order and the related entity is order product. Then do a grouping based on the order. This could help you.


    My Weblog -- My Website

    Friday, April 19, 2013 10:21 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, 

    In order you may filter your view in relation with order product but you can't include orderproduct's column directly. In order product there is a associated view where you can add both columns from order and orderproduct  Try by open orderproductassociatedview->add column->In record type you may see both order and order product. Try to use that!


    Sindu M


    Friday, April 19, 2013 10:44 AM