Skip to main content
Solved

unknown column error on project dashboard

  • 24 June 2024
  • 4 replies
  • 43 views

Hi!

looking at the project dashboard in the sales demo, I am getting this error when switching between projects.  I have a feeling this is in regards to a table but I am not sure.  Has anyone seen this and been able to resolve?

 

4 replies

nhatnghetinh
Rank
Userlevel 7
Badge +5

Hi @iqraharrison 

I tried with version 2023.R1 and it works well.

 

 

Best Regards,

NNT

Hi Everyone. If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*
iqraharrison
Rank
Userlevel 7
Badge +8

@nhatnghetinh hi! this is happening in 24R1 build 4 and 5 (at least that’s where i’ve tested it) but I just met with acumatica to discuss this and it seems to be working on the version 24.100

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
Rank
Userlevel 7
Badge

Hi @iqraharrison were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
iqraharrison
Rank
Userlevel 7
Badge +8

@Chris Hackett hi! i ended up submitting a ticket to acumatica.  we found that MySQL was causing issues.  I worked with our internal IT department to set up the local and cloud hosted instances with the MS SQL and we no longer had any issues!  We also noticed an increase in the instance’s speed!

I provided acumatica with all the details and they escalated it to the development to look into, however, we were able to close the case since our issue was resolved by changing the database type

thanks!

Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings