i guess we have to do this with SQL... the idea is to export the table (or backup) then use SQL to update the orderpoint qty to zero. this would stop ERP from trying to create draft PO for items not required due to low seasonal demand. For any given product this could be maintain a stock of 10 in summer and 1 in winter. In spring we load up the 'Summer' orderpoint values and 'Autumn / Fall' we would load up the 'Winter' orderpoint values
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 10/7/13, 8:21 AM|
|Seen: 707 times|
|Last updated: 3/16/15, 8:10 AM|