IsNull Error

[SBarnes]

We have a customer that is getting an error on one user about an invalid number of arguments to isnull when they go into the sales order screen.

I suspect it may be related to the form settings for that particular user and form as logging in on the same machine doesn't get the error. for other users

Is there any settings data we can delete from the database that may fix this?

[Mike.Sheen]

If you want to remove the user settings for a particular user for the sales order form, the following will do that :

Code: Select all

DELETE FROM SY_UserProfile WHERE UserID = (SELECT StaffID FROM HR_Staff WHERE Username = 'Username') AND Section = 'JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm'

Just substitute 'Username' in the above with the staff username you're having a problem with.

[Mike.Sheen]

Actually, you should change that criteria on the section to be starting with :

Code: Select all

DELETE FROM SY_UserProfile WHERE UserID = (SELECT StaffID FROM HR_Staff WHERE Username = 'Username') AND Section LIKE 'JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm%'

Because we append the grid name to the section for grid xml - eg : 'JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm.grdLines.Default'

[SBarnes]

It ended up being a faulty customer filter which as stopping the screen loading, I had to drill back up from the debtor to figure it out.