Skip to main content
Question

Sorting Date Issues - Inventory Transaction History per Part


Forum|alt.badge.img+12

Anyone else notice sorting issues within Inventory Transaction History per Part?

Scenario: Attempting to sort records in a chronological order by Creation Date and Time.  Randomly there are anomalies as per the below screenshot:

Date Format for reference is: MM/DD/YYYY

Environments: 22 SUPD 5 and 22 SUPD 4 (different environments).  No recent changes.  

 

Forum|alt.badge.img+8
  • Sidekick (Employee)
  • April 11, 2023

Hi.  Can you provide a print screen that shows your search criteria?  This will help.  Please review and advise when you can.  Thanks!  Jane


Forum|alt.badge.img+12
  • Hero (Partner)
  • April 11, 2023

Thanks for the reply, @Jane Perry.

I queried for only the part number.  No other search parameters were used.  I omitted the actual search value as it is unique to a customer’s environment.  

Please let me know if you have any suggestions or a ticket must be created.  

 


Upasari
Do Gooder (Employee)
Forum|alt.badge.img+4
  • Do Gooder (Employee)
  • April 12, 2023

Hi @astfarazt 

I faced the same issue. However the following steps worked for me.

  1. Sort creation time column descending.
  2. Click on the kebab button on creation time column and freeze the column.
  3. Then sort the created date column descending. 

 


Forum|alt.badge.img+12
  • Hero (Partner)
  • April 17, 2023

Thanks for the feedback.  Although, this seems strange.  Is freezing the column a requirement based on how the software was developed or is this just a workaround?

 


Forum|alt.badge.img+28
  • Superhero (Customer)
  • May 4, 2023

Freezing the column isn’t the key to the proper sort, however the order of doing the sort is.  You must sort by time first then by date in order to get the records aligned as you want.  The randomness of the records just doing date can’t be relied on to get the records ordered as desired.

This is actually true of most databases, the order of records in the table can’t be guaranteed to follow a time pattern, rather it is the primary key of the table that dictates that.  In the case of transaction history, unless there is only one site involved and only one time zone for the sites, it is very possible that the transactions look out of order by date when they are in fact sequenced by the transaction history ID.


PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • October 17, 2024

Our users are reporting this is an issue in this screen.  I still think adding Transaction History ID added to this screen would resolve the issue...


matt.watters
Superhero (Partner)
Forum|alt.badge.img+25
  • Superhero (Partner)
  • October 17, 2024

@PRODQ that or adding this which is in the overview page would do it.

 


PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • October 17, 2024
matt.watters wrote:

@PRODQ that or adding this which is in the overview page would do it.

 

Gets my vote!


Forum|alt.badge.img+28
  • Superhero (Customer)
  • October 19, 2024

The date created won’t work for multi-site instances where the sites are not in the same time zone.  We have transactions in four different time zones currently and will have eight when all sites are live, so date and time created is relative to the time zone where the transaction occurred.

Transaction history ID is the only one that would properly sequence across all sites.


PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • October 21, 2024
ShawnBerk wrote:

The date created won’t work for multi-site instances where the sites are not in the same time zone.  We have transactions in four different time zones currently and will have eight when all sites are live, so date and time created is relative to the time zone where the transaction occurred.

Transaction history ID is the only one that would properly sequence across all sites.

I’m all for Transaction ID ...


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings