Make Inactive & May Not Be Placed on PO

When do you want to make the item inactive.

Situation 1) I mark some items as do not order and i want to mark it inactive as the quantity goes 0 or less.

Write a sql command in dynamics Administrator so simple.

Bye,

The instructions say SQL commands are only for those experienced in this. There is no help on-line for this. I don't know these things. I bought a program to automate things for me, not try to try and program it myself. Making old unwanted items not show up on new PO's is a very simple, obvious part of POS work. Why is this not a built in part of the software? Is it designed this way to keep me on a string with Microsoft?

Tim - I think Arif doesn't understand that 99 percent of RMS users do not know SQL, or that Microsoft doesn't include a crash course on SQL or XML or editing qrp files with the RMS documentation, or that the Inventory Wizard is mostly useless. You have run into one of the biggest weaknesses of this software, and we are all hoping that version 3 will address these.

In the meantime, you are stuck with version 2. There's a lot of good help on this newsgroup, but in my opinion, it cannot replace working with a savvy reseller. If it's in the budget, engage an RMS certified reseller that can help you with queries and software support.

Anyway, here are the queries you can run. FIRST BACKUP YOUR DATABASE AND RUN AFTER HOURS IF POSSIBLE.

To set an item as "may not be placed on PO" if it's quantity in stock is zero, run UPDATE ITEM SET DONOTORDER = 1 WHERE QUANTITY = 0

Remember to backup that database....

H> The instructions say SQL commands are only for those experienced in this.

Another SQL script to set "may not be placed on PO" if item is inactive: update Item set DoNotOrder=1 where Inactive=1

And if you can find some support (reseller, database developer...) they can make a trigger to the Item table that automatically sets DoNotOrder=True if the item is marked inactive.

Koit Lahesoo