RMS Error #5: Invalid Procedural Call or Argument

(0) Share

Report

Posted on by seminolebs

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.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

ToddB Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
seminolebs 80 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ToddB Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi seminolebs,

Do you get any results when you run the following query?

SELECT ID, * FROM ItemValueLog WHERE OldAmount > 10000 OR OldAmount < -10000

Was this reply helpful? Yes No
Suggested answer

seminolebs 80 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No