Hello everyone,

I'm trying to create my own balance sheet report, through the account_reporting module.

So far so good, I'm getting pretty much what I want. But I do have a question.

My data appears to be alphanumerically sorted on the Code field. Now, I need to display record code 19 between record codes 15 and 16. The trick I've used is to give it a "15 (19)" code, so that it works. But I'd like to know if there's a better way, so that only "19" appears in the Code column. I was thinking maybe play with the Sequence field ? Could anyone explain what the purpose of the Sequence field is and how it works ?

Thanks,
Egg

If sequence field exist in any object by default list will be sorted on sequence field otherwise it will take id field by default if _order is not defined on object.