Invoice Info - Manuel ordering on BP has bad impact on Dates/DocumentNo

[Nicolas Micoud]

Hi,

If you order the content of the grid on the Business Partner column, Dates and DocumentNo are ordered randomly whereas it would be "better" if dates keep ordered ASC or DESC.

I have no idea for managing this - not sure if is possible to user several columns for ordering the content of a grid (first, order on BP, then on DateInvoiced, ...).

Is not a blocker, but is annoying (I got this feedback from a customer).

wdyt?

Regards,

Nicolas

[Omondi Austine Bunde]

Hi Nicholas, basically you can't order by two columns as it has been said but you can order by either date or  document number if you want it to be so. i suggest ordering by date created will automatically order the document number. Thanks.

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/75389451-07f1-4e6b-bba0-dba4bc9e3ff4n%40googlegroups.com.

[Norbert Bede]

hi,

not sure i understood properly, but when i edited in app dictionary invoice info order by field changed to: C_Bpartner_ID then DateOrdered, then i got proper order. (first BP, then date)

n

[Nicolas Micoud]

Hi,

Sure, the ORDER BY clause is used when you refresh the panel.

But once you click on a column header, you lost the "default" order by (which is expected).

My use case is when you manually click on the BPartner header column.
Lines are now sorted using this criteria, ie ORDER BY bp.Name

I would like to have ORDER BY bp.Name, i.DateInvoiced

[Galih Pribadi]

Hi Nicolas, 

Maybe this idea can solve your issue :

Try to edit Invoice Window from Application Dictionary :

-Make sure table 'C_BPartner bp' joined in Query

-Edit SORT BY C_BPartner.name, C_Invoice.DateInvoiced

Thanks

To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/31c81983-a351-4ca5-82a1-0ee4da3d9f82n%40googlegroups.com.

[Carlos Antonio Ruiz Gomez]

Hi Nicolas, what have worked for me is click first on the "second" column to order, and then click on the first column.

In your case it would be like clicking first on DocumentNo, and then clicking on Date.

Can you please check?

Regards,

Carlos Ruiz

Am 03.11.23 um 07:38 schrieb Nicolas Micoud:

Hi,

Sure, the ORDER BY clause is used when you refresh the panel.

But once you click on a column header, you lost the "default" order by (which is expected).

My use case is when you manually click on the BPartner header column.
Lines are now sorted using this criteria, ie ORDER BY bp.Name

I would like to have ORDER BY bp.Name, i.DateInvoiced

Le jeudi 2 novembre 2023 à 18:13:14 UTC+1, Norbert Bede a écrit :

hi,

not sure i understood properly, but when i edited in app dictionary invoice info order by field changed to: C_Bpartner_ID then DateOrdered, then i got proper order. (first BP, then date)

n

On Thursday, November 2, 2023 at 2:42:55 PM UTC+1 omondiaus...@gmail.com wrote:

Hi Nicholas, basically you can't order by two columns as it has been said but you can order by either date or  document number if you want it to be so. i suggest ordering by date created will automatically order the document number. Thanks.

On Thu, 2 Nov 2023 at 16:35, Nicolas Micoud <nicolas...@gmail.com> wrote:

Hi,

If you order the content of the grid on the Business Partner column, Dates and DocumentNo are ordered randomly whereas it would be "better" if dates keep ordered ASC or DESC.

[Nicolas Micoud]

Hi Carlos,

It doesnt't work.

Seems that when clicking on a header row, "previous" selection is erased.

In other words, I click on DocumentNo or DateInvoiced, records are sorted accordingly.
And when clicking on BPartner, the ORDER BY clause become "ORDER BY bp.Name".

I guess that if it has worked for you one day, means that something has been broken recently"?

wdyt?

Regards,

Nicolas

[Carlos Antonio Ruiz Gomez]

Hi Nicolas, attaching a video of my test.

From what I see, this works fine in Windows, but not on Info Windows.

Regards,

Carlos Ruiz

Am 06.11.23 um 07:19 schrieb Nicolas Micoud:

[Nicolas Micoud]

Hi Carlos,

I confirm this is working fine in windows (and I never noticed that, thanks for the tip!)
But not in info windows.

Nicolas