coral-erm / coral

CORAL ERM main repository
http://coral-erm.org/
Other
52 stars 64 forks source link

Error message in Acquisitions #772

Open TPLKelli opened 1 month ago

TPLKelli commented 1 month ago

Hello,

I am trying to enter new Cost History in the eRM Acquisitions tab for one of our resources. I keep getting an error message "Incorrect integer value: 'NaN' for column 'coral_resources_prod'. 'ResourcesPayment'.'priceTaxExcluded' at row 1. I've tried using both Edge and Chrome and the same error occurs.

I did not enter tax information because I have never entered tax information in this form. Why is it asking for it now and can I stop it?.

Also, it deleted my Cost History for this resource when I selected cancel after receiving the error message. That should not happen.

Thank you for the help. Kelli

Adie8 commented 3 weeks ago

I am also seeing this error.

snew-lib commented 3 weeks ago

We're having the same problem - this field used to accept a null value, and now does not. We did find that entering a 0 in each of the tax fields works.

Adie8 commented 3 weeks ago

Ah that's a good workaround! Thanks!

On Mon, Aug 26, 2024 at 11:37 AM Sarah New @.***> wrote:

We're having the same problem - this field used to accept a null value, and now does not. We did find that entering a 0 in each of the tax fields works.

— Reply to this email directly, view it on GitHub https://github.com/coral-erm/coral/issues/772#issuecomment-2310616839, or unsubscribe https://github.com/notifications/unsubscribe-auth/BKZRKX6BQPKOAGGAUGFWPXLZTNKTXAVCNFSM6AAAAABM6OHRTSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMJQGYYTMOBTHE . You are receiving this because you commented.Message ID: @.***>

-- Adrian Graham, MSIS e-Resources Librarian / Associate Professor Austin Community College - South Austin Campus 1820 W Stassney LN, Austin, TX 78745 512.223.9179 researchguides.austincc.edu/adriangraham

LibrarianMike commented 3 weeks ago

Equinox has a fix in the works for this issue that should be included in the next release.

Adie8 commented 3 weeks ago

Yay! Because when I entered 0 in the tax fields in wiped out my past cost history. :( Gonna hold off for now!