Sorting the order of printing Sales Invoice in RTC

hewajith

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.

Belias

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...

hewajith

Thank you for your reply
Can't I use Expression in report layout to make these changes

Belias

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
what is "Expression in report layout"?

hewajith

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_beer

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.

hewajith

Thank you Bennie

It solved the problem