Notifications
Announcements
No record found.
When attempting to generate an Item - Inventory Valuation Report in RMS, we get and Error #5: Invalid Procedural Call or Argument. This occurs on both computers.
We have re-indexed and checked the database in the Administrator.
Hi seminolebs,
What Filters are you using on the report?
Do you get the same error if you filter for 1 Item Lookup Code for 1 day?
I get the same result no matter what day, group of days, or all items or just a singular item. I upgraded SQL Server 2005 Express to SQL Server Express 2014 but result is the same.
Do you get any results when you run the following query?
SELECT ID, * FROM ItemValueLog WHERE OldAmount > 10000 OR OldAmount < -10000
Todd,
Your query did find the problem and I was able to delete the bad record with the following;
DELETE ItemValueLog WHERE ID = (id)
Thanks for the help
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,143
Jainam M. Kothari 1,694 Super User 2025 Season 2
YUN ZHU 1,067 Super User 2025 Season 2
