Sage 100

Scenario:  client will be processing physical inventory and wants users to see a message upon login that Physical Inventory is in Progress or some such verbiage.  Can this be scripted?  

We've already talked about locking users out and/or modifying roles to keep them from processing txns that touch inventory.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

I can't think of anything other than a used-defined script assigned to each screen that you want to warn.  You can check IM_Physical for records and, if found, MessageBox 'Physical Inventory in Process'.  I don't have Sage 100 installed on my PC here, but the VBScript would be something like:

oPhys = 0: retVal = 0 : cnt = 0

Set oPhys = oSession.GetObject("IM_Physical_svc")
retVal = oPhys.MoveFirst() ' start at the beginning
Do Until cBool(oPhys.EOF)   ' count the number of records in IM_Physical
   cnt=cnt+1
   retVal = oPhys.MoveNext()
Loop
if cnt > 0 then
   retVal = oSession.AsObject(oSession.UI).MessageBox("", "Physical Inventory in Progress","Title=Warning,Icon=!")
end if

This is counting all records each time you enter the screen, but you could limit it to counting just a few for confirmation.

------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------

Original Message:
Sent: 6/25/2020 8:23:00 AM
From: Steve Iwanowski
Subject: RE: v4.5 Advanced. Can a message be popped up upon login?

I can't think of anything other than a used-defined script assigned to each screen that you want to warn.  You can check IM_Physical for records and, if found, MessageBox 'Physical Inventory in Process'.  I don't have Sage 100 installed on my PC here, but the VBScript would be something like:

oPhys = 0: retVal = 0 : cnt = 0

Set oPhys = oSession.GetObject("IM_Physical_svc")
retVal = oPhys.MoveFirst() ' start at the beginning
Do Until cBool(oPhys.EOF)   ' count the number of records in IM_Physical
   cnt=cnt+1
   retVal = oPhys.MoveNext()
Loop
if cnt > 0 then
   retVal = oSession.AsObject(oSession.UI).MessageBox("", "Physical Inventory in Progress","Title=Warning,Icon=!")
end if

This is counting all records each time you enter the screen, but you could limit it to counting just a few for confirmation.

------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------

The only places it would really be necessary to see the message are posting registers in modules that update inventory (for them, it would be BOM, PO, SO, IM).  I'll pass this information along and see if they want to pursue this avenue.  Thank You!

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Original Message:
Sent: 06-25-2020 09:20
From: Lee Graham
Subject: v4.5 Advanced. Can a message be popped up upon login?

I don't think Logging In is a "scriptable event".?? Are there particular Sage tasks where you would want to add the message?

--

Friendly Systems, Inc.

Sage 100 (Mas90/200), Sage 300 (Accpac), SageCRM, xTupleERP
Visit us on the web at www.friendlysystems.com
Office:?? 678.273.4010 ext 4
Mobile: 404.202.9065
Fax:?????????? ??678.273.4012
See our blog at www.friendlysystems.com/blog

Original Message:
Sent: 6/25/2020 8:23:00 AM
From: Steve Iwanowski
Subject: RE: v4.5 Advanced. Can a message be popped up upon login?

I can't think of anything other than a used-defined script assigned to each screen that you want to warn.  You can check IM_Physical for records and, if found, MessageBox 'Physical Inventory in Process'.  I don't have Sage 100 installed on my PC here, but the VBScript would be something like:

oPhys = 0: retVal = 0 : cnt = 0

Set oPhys = oSession.GetObject("IM_Physical_svc")
retVal = oPhys.MoveFirst() ' start at the beginning
Do Until cBool(oPhys.EOF)   ' count the number of records in IM_Physical
   cnt=cnt+1
   retVal = oPhys.MoveNext()
Loop
if cnt > 0 then
   retVal = oSession.AsObject(oSession.UI).MessageBox("", "Physical Inventory in Progress","Title=Warning,Icon=!")
end if

This is counting all records each time you enter the screen, but you could limit it to counting just a few for confirmation.

------------------------------
Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
------------------------------

I'm wondering what is in the water.  I was asked something very similar last week by a client.  They want a pop up warning to stop users from doing any transactions in Sage 100 on "days" where they will freeze inventory.  They want a "calendar set up" and since some people start work at 4 am and they Freeze Inventory at 7 am, they want to "STOP" or to at least warn users that "TODAY IS INVENTORY DAY" and to "stay out of Sage 100 until you receive your inventory sheets later this morning.  :(  Who thinks up this stuff?

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

@Madeline Stefanou Clearly, yours and my clients are on a similar wavelength!  :-)​

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Original Message:
Sent: 06-25-2020 11:59
From: Madeline Stefanou
Subject: v4.5 Advanced. Can a message be popped up upon login?

I'm wondering what is in the water.  I was asked something very similar last week by a client.  They want a pop up warning to stop users from doing any transactions in Sage 100 on "days" where they will freeze inventory.  They want a "calendar set up" and since some people start work at 4 am and they Freeze Inventory at 7 am, they want to "STOP" or to at least warn users that "TODAY IS INVENTORY DAY" and to "stay out of Sage 100 until you receive your inventory sheets later this morning.  :(  Who thinks up this stuff?

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 6/25/2020 12:06:00 PM
From: Barbara Goldstein
Subject: RE: v4.5 Advanced. Can a message be popped up upon login?

@Madeline Stefanou Clearly, yours and my clients are on a similar wavelength!  :-)​

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

You can block people from logging in using instlock.txt...
The Information Center is just a static html file in the Launcher folder (workstation for Advanced / Premium, server for Standard).  If running a terminal server you could probably swap that out (the whole thing or just the top image) easily enough.


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 06-25-2020 11:59
From: Madeline Stefanou
Subject: v4.5 Advanced. Can a message be popped up upon login?

I'm wondering what is in the water.  I was asked something very similar last week by a client.  They want a pop up warning to stop users from doing any transactions in Sage 100 on "days" where they will freeze inventory.  They want a "calendar set up" and since some people start work at 4 am and they Freeze Inventory at 7 am, they want to "STOP" or to at least warn users that "TODAY IS INVENTORY DAY" and to "stay out of Sage 100 until you receive your inventory sheets later this morning.  :(  Who thinks up this stuff?

------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------

What about setting the warehouse to a Restricted status?

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

That would work great, but this client is on v4.5 and will probably upgrade never.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------

Original Message:
Sent: 06-25-2020 13:18
From: Mary Jo Krueger
Subject: v4.5 Advanced. Can a message be popped up upon login?

What about setting the warehouse to a Restricted status?

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

If you just want to block the postings, perhaps you could find the associated programs in MAS90\##\ and rename them temporarily.  It's kind of a heavy-handed approach, but should work.  (Renaming the journal reports would likely still allow Deferred posting).

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 06-25-2020 17:11
From: Barbara Goldstein
Subject: v4.5 Advanced. Can a message be popped up upon login?

That would work great, but this client is on v4.5 and will probably upgrade never.

------------------------------
Barbara Goldstein
Sr. Consultant
DSD Business Systems
San Jose CA
800.627.9032 x221
------------------------------


Original Message:
Sent: 06-25-2020 13:18
From: Mary Jo Krueger
Subject: v4.5 Advanced. Can a message be popped up upon login?

What about setting the warehouse to a Restricted status?

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176