Skip to Content
Oct 04, 2011 at 12:37 PM

Check that item is editable



I am building a maintenance tool that will remove items that have been set up but that have never been used in any transactions. Items that were set up accidentally, for example when uses the import utility in the B1 client to update items.

In other words it first needs to find editable items, and then I willdetermine if other criteria are being filled.

My question is: is there a field / flag anywhere in the OITM table or any other table that I can use in a query to see if the item is still editable ?

Obviously I don't want to have to check against each and every possible document table, to see if the item can be found there.