Friday, October 26, 2018

Create a report to pull up sales order line items with no revenue commitment.

Solution/Workaround/Gotcha/Recommendation Details:

    ·         Navigate to ReportsSaved Searches > All Saved Searches > New.

    ·         Click Transaction.

    ·         In the Criteria tab > Standard subtab, set the following filters: 

         1.  Type = is Sales Order

         2.  Main Line = is false
     
         3.  Revenue Committing Transaction : Number = is empty
 
         4.  Rev. Rec. On Rev. Committment = true

    ·         Go to the Results tab > Columns subtab, set the following column fields:

 1.  Date

 
        2.  Type
     
        3.  Number
 
        4.  Item
 
        5.  Amount

    ·         Click Preview or Save.

No comments:

Post a Comment