part list (new) bug

  • I ran a query to get a list of all of our parts (there are over 3000 of them) by going to Parts → Part List, hitting submit, and then changing the “Rows per page” to 500.
  • I browsed through the parts 500 at a time to find the part I was looking for. I noticed that some parts that show up on both page 3 and page 4, e.g. PRT11-2051. Other parts don’t show up at all, e.g. PRT11-2002 no matter what page you go to (note, this part is an active part, and otherwise shows up if you specifically search for it).

Can you please take a look at this @cetecerp19?

(edit1: the link was perhaps not working, so I removed it)

I am concerned if this kind of issue is present for other queries as well, in the event that you are using the same functions on the back end.. sometimes we need to look through pages of parts if we don’t remember the exact part # or description (which was the case here), so we would never find certain parts due to this bug.

edit2: the same thing happens when you restrict the table to show 100 parts at a time. PRT11-2051 appears on multiple pages.. I’m sure there are a lot of other parts that do too.

Hi @vikas

I am happy to take a look at this. I’ll begin testing now.

  • Cetec ERP Support

Hi @vikas

Thank you for bringing this to our attention, and I sincerely apologize for the delay in our response. Our support team strives to answer every forum question, but since we have to prioritize Enterprise and Standard support tickets, this can impact our response times, depending on the volume of tickets and margin of support members. Regardless, I am sorry, and I appreciate you posting here.

I pulled a backup of your environment and, since your deployment of Cetec ERP version 4.20, I’m not seeing any of the issues you reported. I tested each scenario and was not able to replicate.

Could you let me know if this issue is still occurring in your environment? I realize it’s been almost three weeks. If you have the bandwidth to investigate further, I’ll make sure you receive a quicker response.

Thank you again for your patience and for bringing this to our attention. My hope is the 4.20 deployment fixed any issue here - please let me know if you are seeing otherwise.

Sincerely,
Cetec ERP Support

Last I checked, the problem was still there in 4.20. I’ll upload some documents for you to compare.

Thank you @vikas I would appreciate that greatly. If you can show me what you’re seeing, I’ll work hard to get it fixed for you quickly.

  • Cetec ERP Support

I just did it. I uploaded an excel spreadsheet here.

To generate a list of the “displayed” data:

  • I went to the new parts list and hit submit.
  • Firefox lets me display 500 at a time, so I used that. I’m pretty sure this is not browser dependent, as I was seeing this issue in Chrome before.
  • I copied and pasted the data into Excel (into a sheet called “By Page”)
  • I added a column for “Page” for the page index I was on. There are 3092 parts, so there are 7 pages total (6 * 500 + 92)

I then compared it to the list that is generated when you hit “Export”, which also had 3092 entries.

You can scroll down the “By Page” table and visually see the entries that are on multiple pages if the parts are sorted by PRCPart in the worksheet.

I ran some pivot tables. Out of 3092 entries:

  • There are 430 duplicates in the displayed data.
  • There are no duplicates in the exported data (as expected)
  • If you compare the “exported” data to the displayed data, there are 874 entries that are missing, 313 that are duplicates.

As you can see, this is not an edge case of one or two records.. hope this helps.

@vikas

This is phenomenal work by you. Well done, I really appreciate it.

You’re right, this definitely needs review and cleaning up. I’m going to create an internal ticket for our engineering team and have them pinpoint what is going on.

Thanks again for your time, effort, and detail. I’ll get this fixed up for you as promptly as possible.

  • Cetec ERP Support

@vikas I just directly emailed you. Please let me know if you received it!

  • Cetec ERP Support

@vikas

Thank you for your time today. I have escalated this issue to our engineering team for review with the test cases we have built out. I will keep you posted.

  • Cetec ERP Support

@vikas

We have a fix for this that should appear in your environment in the next 7-10 days. Thanks for your diligence in helping our team identify this!

  • Cetec ERP Support