(Below some examples, you can use this in query's so you can use them in recurring batches without the need to change it daily. Give it a try in a testenvironment to see if it meets your requirements. Simply key in the bold statement below in a datefield. In your case it would be (greaterThanDate(1)).
If you go into the Item master page and click on the Sales tab, you will see a place where you can put in an External Item Description.
I use this on the PO side, so the Vendor's information shows up on the PO when It is generated. You can put their customer #, their PO # and the part description. It works wonders.
I hope this helps..
Kristina Dummermuth Spare Parts Specialist
Frontmatec inc 8301 N.W. 101st Terrace #10 Kansas City, MO 64153 United States frontmatec.com
Fax : Email:
+1 816 891 0550 email@example.com
If you've found this thread useful, dive deeper into User Group community content by role