RE: SYS020B - Calculate available Inventory Qty's

This is simply a standard program that returns an available inventory (see
logic manual).  It is used by BPCS (inv300, etc..).

Turns out you must use it with sys921 which will return to the calling
program the warehouses in a facility and their nettable flags.

Therefore, if you want to use these standard programs supplied by SSA to get
available inventory by facility you need to use them both.

Mark 



-----Original Message-----
From: Alister Wm Macintyre [mailto:macwheel99@xxxxxxxxxxx] 
Sent: Monday, May 17, 2004 2:38 PM
To: SSA's BPCS ERP System
Subject: Re: SYS020B - Calculate available Inventory Qty's


We're 405 CD MM

As a general rule none of the programs starting with digit 0 as in 001-099
and especially dangerous are the SYS ones should be run without thorough
research as to their function.

Some of them are designed to zero out master BPCS files and reset values 
like in a conversion.

I hope that you are using a test environment when you run any SYA001-SYS099 
to see what they do.

There are some that are not intended to be run stand-alone.
In other words, some other program internally has a CALL to get some info.
For example someone is on INV300 or some other inquiry program. They set
their filters - they interested in the whole item corporate, or 
just within a facility, or just within a warehouse, and BPCS calculates for 
them what the on-hand is.
Well perhaps the routine, subroutine, or CALLed program depends on whether 
the data needs to come from file IIM ILN ILI IWI or whatever and such a
called program would normally be run when the CALLER program 
already knows what to tell it, based on what the user fed into the inquiry 
probram.

, you wrote:
>We're 6.1.2 MM.
>
>Anyone use this program?  According to the documentation below, if you 
>call it sending it item and facility you get on hand (available) for 
>the facility.  This does not appear to be the case based on tests we 
>ran. Apparently, you must also send it the warehouses, which defeat the 
>purpose of using it (i.e. you must find all wh's in the facility and 
>check there nettable flag), unless I am missing something here.  Any 
>input is appreciated.
>
>
>
>SYS020B
>
>Calculates inventory quantities.
>
>
>RTPARM
>
>1
>
>A
>
>
>
>AS/SET run-time parameter
>
>
>W1PROD
>
>15
>
>A
>
>Input
>
>Item number for which inventory quantities should be calculated
>
>
>W1FAC
>
>2
>
>A
>
>Input
>
>Optional.  If provided, quantities will be calculated across this 
>entire facility.
>
>
>W1WHS
>
>2
>
>A
>
>Input
>
>Optional.  If provided, quantities will be calculated across just this 
>warehouse.
>
>
>W1VWDS
>
>200
>
>A
>
>Input
>
>Optional.  If provided, quantities will be calculated across all (up 
>to) 100 warehouses in this array.
>
>
>W1QOH
>
>13,3
>
>P
>
>Input/Output
>
>On-hand balance for the item.  Will only be calculated if this value is 
>non-zero as input.
>
>
>W1QAC
>
>13,3
>
>P
>
>Input/Output
>
>Quantity allocated to customer orders for the item.  Will only be 
>calculated if this value is non-zero as input.
>
>
>W1PRDA
>
>13,3
>
>P
>
>Input/Output
>
>Quantity allocated to manufacturing orders for the item.  Will only be 
>calculated if this value is non-zero as input.
>
>
>W1QIT
>
>11,3
>
>P
>
>Input/Output
>
>Quantity in transit for the item.  Will only be calculated if this 
>value is non-zero as input.
>
>
>W1QORD
>
>11,3
>
>P
>
>Input/Output
>
>Purchasing Quantity on Order for the item.  Will only be calculated if 
>this value is non-zero as input.
>
>
>Mark Richards
>Senior Systems Analyst
>
>Tel: 616-546-3949
>Fax: 616-392-2323
>Email:  <mailto:richarma@xxxxxxxxxxxx> richarma@xxxxxxxxxxxx
>
>
>
>Hart & Cooley
>
>Web Site <http://www.hartandcooley.com/>
>
>
>Hart & Cooley, Information Technology
>500 E. 8th ST | Holland, MI 49423 | USA (Map) 
><http://www.mapquest.com/maps/map.adp?countryid=250&addtohistory=&count
>ry=US
>&address=500+E.+8th+St.&city=Holland&state=MI&zipcode=49423&historyid=&subm
i
>t=Get+Map>
>
>
>_______________________________________________
>This is the SSA's BPCS ERP System (BPCS-L) mailing list
>To post a message email: BPCS-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
>or email: BPCS-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/bpcs-l.


_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.