Sorting the order of printing Sales Invoice in RTC

hewajithhewajith Member Posts: 96
edited 2009-12-18 in NAV Three Tier
Hi,

I want to sort lines on sales invoice (206) as following order, Resources, Item the GL acc

Also I want to do in in RTC

Can anyone help me on that.

Thank you.

Answers

  • BeliasBelias Member Posts: 2,998
    Did you already try to create a key in sales invoice line (if you're talking about report 206) for the fields you need and then sort the dataitem with that key?
    (i'm just guessing, anyway)
    P.S.: you probably do not want to maintain this key in sql...think about it...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • hewajithhewajith Member Posts: 96
    Thank you for your reply
    Can't I use Expression in report layout to make these changes
  • BeliasBelias Member Posts: 2,998
    hewajith wrote:
    Thank you for your reply
    Can't I use Expression in report layout to make these changes
    i've no idea on what are you talking about :mrgreen:
    what is "Expression in report layout"?
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • hewajithhewajith Member Posts: 96
    I am sorry,

    I meant visual studio report layout for NAV2009.
    You can use expression to do some changes in Vsual studio report layout (I also don't know much about that)
  • bennie_de_beerbennie_de_beer Member Posts: 43
    Hi,

    You could try one of the following in report layout (VS):
    1. Change the sorting of the group by right clicking and then select 'Edit Group'. You will see a 'sorting' tab. By default the report sorts by Sales_Line_No. You can change this to 'SalesLineType.Value' and descending (it should then sort by Resources then Item and then G/L Account).

    or try
    2. Insert 2 more groups below the detail line and copy all the cell values (you will then have 3 groups exactly the same). Use an expression statement (IIF........) for each group to turn off the visibility based on the Line Type (Resources, Items, G/L Account).

    I haven't tried the above myself but it is worth a go.

    Cheers.
  • hewajithhewajith Member Posts: 96
    Thank you Bennie

    It solved the problem
Sign In or Register to comment.