How does DBA prompt you to reorder?   We must have a default or something wrong because we are never warned to re-order.   In the archives I have read where some users describe being warned or triggered to reorder, without having to print a re-order report.   How does that happen?  When and where do you see the warning?  
 
I am wondering if we are suppose to see a pop-up at when the sales order is converted to a work order.  The reorder amounts / levels in IN-B are set to 1  
 
 
Note:  We do not use MRP or EVO
 
Thanks
Laura  
 
 
 
 
 

Here is an alternative:
 
Command on the Task Manager
C:\Windows\SysWOW64\wscript.exe C:\VBScripts\dba_reorder.vbs
 
 
VBScript  
' =============
' CODE START HERE
' =============
Dim Connection
Dim Recordset
Dim var_sql
Dim Response
Dim the_sku
Dim the_DSN
 
'Variables
 the_DSN = "DSN=MYODBC_CONNECTION"
 the_sku = "MY_PART_ID"
 
Set Connection = CreateObject("ADODB.Connection")
Set Recordset = CreateObject("ADODB.Recordset")
Connection.Open the_DSN
 
var_sql = "SELECT BKIC_PROD_UOH FROM BKICMSTR WHERE BKIC_PROD_CODE = '" & the_sku & "' AND BKIC_PROD_RLVL > BKIC_PROD_UOH;"  
Recordset.Open var_sql,Connection
 
If Recordset.EOF Then
     'Do nothing No records criteria not met
Else
     Do While NOT Recordset.Eof
           var_sql = "Item : " & the_sku & " units on hand below Re-order Level. UOH : " & Recordset("BKIC_PROD_UOH")
           Response = msgbox(var_sql, VBCritical, " DBA/EVO")
           Recordset.MoveNext    
     Loop
End If
 
Recordset.Close
Set Recordset=nothing
Connection.Close
Set Connection=nothing
 
' ============
' DONE END
' ============
 
Change the SKU and your EVO/DBA Connection
You have a trigger !!! Have fun....
 

 
Kelloggs

Evo's Triggers will pop-up a window.
My script will pop-up a windows using your windows task manager.
 
Why don't you guys use Evo?
 
 
 
Kelloggs

Quote from Laura Oliver on 05/20/15 at 05:19:03:

 
You need to start using MRP. You don't have to eat the whole enchilada, just get your items in order (proper BOMs, lead times, etc) and run MR-F. Then, run the Order Action Report (MR-H) and that will show you what you don't have, or sub-assemblies you have to make.
 
Quote from Laura Oliver on 05/20/15 at 05:19:03:

 
That gave me a good laugh to start my day. You sound like my wife, who is way smarter and more talented than me in many ways, and yet she thinks she is stupid because she can't do math in her head and computers baffle her...