ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Where is trigger reorder warning ?
http://www.istechforum.com/YaBB.pl?num=1431974479

Message started by Laura Oliver on 05/18/15 at 11:41:19

Title: Where is trigger reorder warning ?
Post by Laura Oliver on 05/18/15 at 11:41:19

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

Title: Re: Where is trigger reorder warning ?
Post by Lynn_Pantic on 05/18/15 at 15:04:12

Triggers are only in Evo, not DBA. They are defined at Settings US-G.

Title: Re: Where is trigger reorder warning ?
Post by Kelloggs on 05/19/15 at 11:15:40

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....

:P

Kelloggs

Title: Re: Where is trigger reorder warning ?
Post by Laura Oliver on 05/20/15 at 05:19:03

Maybe I am not looking for a " trigger " ....?

I suppose I am looking for a pop-up in DBA that tells us we cant do that job because the raw material is not in house.
I probably used the wrong word
" trigger"

OH and Kelloggs, I am flattered that you think I am that smart.
Blessings,
Laura

Title: Re: Where is trigger reorder warning ?
Post by Kelloggs on 05/20/15 at 09:06:51

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?

8-)

Kelloggs

Title: Re: Where is trigger reorder warning ?
Post by Laura Oliver on 05/22/15 at 08:01:41

I am embarrassed to say we just haven't taken the time to use EVO. Every time I open EVO I get confused and go back to DBA.

I have a feeling that since that demanding MBA guy keeps hanging around our office we will soon embark on the EVO journey.

Title: Re: Where is trigger reorder warning ?
Post by David Waldmann on 05/27/15 at 05:04:21

Laura Oliver wrote:

I suppose I am looking for a pop-up in DBA that tells us we cant do that job because the raw material is not in house.

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.

Laura Oliver wrote:

OH and Kelloggs, I am flattered that you think I am that smart.

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...
;D

Title: Re: Where is trigger reorder warning ?
Post by shadowcaster on 05/27/15 at 17:31:28

I second the use the MRP thing

spend some time on it
its worth it