psdi.app.inventory

Class InventoryService

java.lang.Object

psdi.server.AppService

psdi.app.inventory.InventoryService

All Implemented Interfaces:

java.rmi.Remote, InventoryServiceRemote, MboServerInterface, MaxRemoteProxy, AppServiceRemote, Dependable, Service, ServiceRemote, FixedLoggerNames, FixedLoggers

public class InventoryService
extends AppService
implements InventoryServiceRemote

Inventory Service

Field Summary

Fields inherited from class psdi.server.AppService

currentState, dbManager, INIT, liveObjCount, load, LOAD, mxServer, name, RUN, running, stateCmdList, stateList, STOP, url

Fields inherited from interface psdi.app.inventory.InventoryServiceRemote

ADJUST_AVERAGE_COST, ADJUST_CURRENT_BALANCE, ADJUST_PHYSICAL_COUNT, ADJUST_STANDARD_COST, RECONCILE_CURRENT_BALANCE

Fields inherited from interface psdi.util.logging.FixedLoggers

APPLOGGER, CRONTASKLOGGER, CRONTASKMGRLOGGER, CRONTASKMGRSQLLOGGER, DBCONNECTIONLOGGER, DDLOGGER, DMLOGGER, EVENTLOGGER, EXCEPTIONLOGGER, MAILLOGGER, MAXIMOLOGGER, MTLOGGER, NULLMBOPOINTER, SECURITY, SENDFAILEDLOGGER, SERVICELOGGER, SQLLOGGER

Fields inherited from interface psdi.util.logging.FixedLoggerNames

appenderPrefix, LOGGERNAME_APP, LOGGERNAME_CRONTASK, LOGGERNAME_CRONTASKMGR, LOGGERNAME_DBCONNECTION, LOGGERNAME_DD, LOGGERNAME_DM, LOGGERNAME_DMPREVIEW, LOGGERNAME_EVENT, LOGGERNAME_EXCEPTION, LOGGERNAME_MAIL, LOGGERNAME_MAXIMO, LOGGERNAME_MT, LOGGERNAME_NULLMBOPOINTER, LOGGERNAME_SECURITY, LOGGERNAME_SENDFAILED, LOGGERNAME_SERVICE, LOGGERNAME_SQL, LOGGERNAME_SQL_CRONTASKMGR, LOGGERNAME_TXN, loggerPrefix

Constructor Summary

Constructors

Constructor and Description
InventoryService()
InventoryService(MXServer mxServer)

Method Summary

Modifier and Type	Method and Description
MboRemote	addReservation(MboSetRemote msr, java.lang.String pl_num, java.lang.String siteid, UserInfo userInfo, MXTransaction trans)
void	adjustCurrentBalance(MboRemote invBalances, java.lang.String newBalance, double stdcost, double avgcost, java.lang.String conditioncode) Adjusts the current balance.
void	adjustPhysicalCount(MboRemote invMbo, java.lang.String itemnum, java.lang.String location, java.lang.String siteid, java.lang.String binnum, java.lang.String lotnum, java.lang.String itemsetid, double physcnt, UserInfo userInfo)
MboSetRemote	autoSplitRecordSet(MboRemote invUseLineMbo, UserInfo userInfo)
void	canGoNegative(UserInfo userInfo, double toBeIssued, double curbal, double totalAvailable, MboRemote sourceMbo) Can negative balance be allowed?
void	canGoNegative(UserInfo userInfo, double toBeIssued, double curbal, double totalAvailable, MboRemote sourceMbo, java.lang.String costType) Can negative balance be allowed?
void	canGoNegative(UserInfo userInfo, double toBeIssued, double totalAvailable, MboRemote sourceMbo)
void	canGoNegative(UserInfo userInfo, double toBeIssued, java.lang.String itemnum, java.lang.String itemsetid, java.lang.String location) Can negative balance be allowed?
void	canGoNegative(UserInfo userInfo, double toBeIssued, java.lang.String itemnum, java.lang.String itemsetid, java.lang.String location, java.lang.String siteid) Can negative balance be allowed?
void	canGoNegative(UserInfo userInfo, double toBeIssued, java.lang.String itemnum, java.lang.String itemsetid, java.lang.String location, java.lang.String binnum, java.lang.String lotnum, java.lang.String siteid) Can negative balance be allowed?
void	changeStatus(MboRemote mbo, java.lang.String status, java.util.Date asOfDate, java.lang.String memo, long accessModifier)
void	createInvbalances(MboRemote invMbo, java.lang.String itemnum, java.lang.String location, java.lang.String siteid, java.lang.String binnum, java.lang.String lotnum, java.lang.String conditioncode, java.lang.String itemsetid, java.lang.String curbal, UserInfo userInfo) add inventory balance for existing inventory
MboRemote	createIssue(UserInfo userInfo, MboSetRemote issueSet, java.lang.String itemnum, java.lang.String location, java.lang.String siteid, java.lang.String ownersysid1) Generates an issue record and adds the new mbo to a pre-named set.
MboRemote	createIssue(UserInfo userInfo, java.lang.String itemnum, java.lang.String location, java.lang.String siteid, java.lang.String bin, java.lang.String lot, java.lang.String rotasset, double qty) Returns a MatUseTrans mbo and set the columns based on the parameters passed.
MboRemote	createIssueForNonStock(UserInfo userInfo, MboSetRemote issueSet, java.lang.String itemnum, java.lang.String itemsetid, java.lang.String location, java.lang.String siteid, java.lang.String ownersysid1) IJ23801:TS003101968:new method to create matusetrans for non-stock items
MboRemote	createMiscReceipt(UserInfo userInfo, MboSetRemote existingReceiptSet, java.lang.String itemnum, java.lang.String toStoreLoc, java.lang.String siteid, java.lang.String ownersysid) Returns a MatRecTrans Mbo for the caller to perform the miscellaneous receipts functionality - a return without a corresponding issue.
MboRemote	createPickList(MboSetRemote msr, java.lang.String pldescription, java.lang.String plnum, java.util.Date reqdate, java.lang.String storeroom, java.lang.String siteid, UserInfo userInfo, MXTransaction trans)
MboRemote	createReturnForIssueStoreloc(MboRemote issueMbo)
void	destroy() Unregister event listeners.
MboSetRemote	findItemsForPhysCount(UserInfo userInfo, java.lang.String location) Find the elligible balances records for physcical count by items due to be counted.
MboSetRemote	getBalances(UserInfo userInfo, java.lang.String itemnum, java.lang.String itemsetid, java.lang.String location, java.lang.String siteid) Find the balances records and return the set.
MboSetRemote	getBalancesForInventorySet(MboSetRemote inventorySet) returns the set of InvBalances across all itemnum/location/binnum/lotnum combinations for a given set of Inventory itemnum/location combinations
MboSetRemote	getBins(UserInfo userInfo, java.lang.String location, java.lang.String binnum) Retuns an invbalances set for a given binnum(wildcard) and storeloc
double	getConversionFactor(UserInfo userInfo, java.lang.String fromUOM, java.lang.String toUOM, java.lang.String itemSetID) Returns the conversion factor that will convert the "from" unit of measure (UOM) to the "to" unit of measure.
double	getConversionFactor(UserInfo userInfo, java.lang.String fromUOM, java.lang.String toUOM, java.lang.String itemSetID, java.lang.String itemNum) Returns the conversion factor that will convert the "from" unit of measure (UOM) to the "to" unit of measure.
MboRemote	getConversionFactorToStoreroom(MboRemote mbo, java.lang.String tostoreloc, java.lang.String tositeid) set the the conversion factor , to bin and lot for the item transfer based on the to store rom location
double	getCurrentBalance(UserInfo userInfo, java.lang.String itemnum, java.lang.String itemsetid, java.lang.String location, java.lang.String binnum, java.lang.String lotnum) Creates an Inventory Set using the itemnum/location parameters passed.
java.lang.String	getDefaultLotNum(MboRemote mbo) getDefaultLotNum() Returns the first lotnum found in the InvLots table with a valid useby date
java.lang.String	getItemSetIdFromSite(UserInfo userInfo, java.lang.String siteid) returns the itemset id when siteid is passed
MboSetRemote	getItemsInStore(UserInfo userInfo, java.lang.String storeroom) Returns an MboSetRemote of ITEM's in the specified Storeroom
MboSetRemote	getLineSplitForRotItems(MboSetRemote assetmsr, MboRemote invUseLineMbo, UserInfo userInfo)
MboSetRemote	getLineSplitRecords(MboSetRemote invbalmsr, MboRemote invUseLineMbo, UserInfo userInfo)
MboSetRemote	getLots(UserInfo userInfo, java.lang.String itemnum, java.lang.String itemsetid, java.lang.String location, java.lang.String binnum) Retuns an invbalances set for a given item/location/bin.
MboSetRemote	getMatReceiptSet(UserInfo ui, java.lang.String ponum) Returns a set of MatRecTrans records that are yet to be approved.
MboSetRemote	getReservationsForMR(UserInfo userInfo, java.lang.String mrnum) Retuns a set of reservations required by the passed MR.
MboSetRemote	getReservationsForWO(UserInfo userInfo, java.lang.String wonum) Retuns a set of reservations required by the passed work order.
MboRemote	getStoreroom(UserInfo userInfo, java.lang.String location, java.lang.String siteid) Method to update all Gl Account for current Storeroom
java.util.Vector	getUnauthInvSet()
java.lang.String	getUnitConversionFactor(UserInfo userInfo, java.lang.String fromUOM, java.lang.String toUOM, java.lang.String itemSetID, java.lang.String itemNum)
void	init() Initialization
boolean	isCourierOrLabor(UserInfo userInfo, java.lang.String location) returns true if the location is of type COURIER or LABOR
void	isMRValid(UserInfo userInfo, java.lang.String mrnum) Check if this mr is valid or if the mr is in approved status
boolean	isSameStoreroomTransfer(MboRemote sourceMbo) Checks if the transfer is between same storeroom.
MboRemote	isWOValid(UserInfo userInfo, java.lang.String wonum) Check if this work order is valid or if the wo is in approved status
boolean	isZeroNewPhysCnt(long uniqueId) IJ29192 returns true if this passed invuselineid exists in the vector
void	previewReconcile(MboSetRemote invBalSetMbo)
void	previewReconcile4InventoryCounting(UserInfo userinfo)
MboSetRemote	reconcile(MboSetRemote invBalSetMbo)
void	setAdjustmentType(int type, MboRemote invAdjust) Sets adjustmenttype based on the passed type to the INVADJUSTMENT object.
void	setZeroNewPhysCnt(long uniqueId, boolean toRemove) IJ29192:
MboSetRemote	updateAllInventory(MboSetRemote invBalSetMbo, UserInfo userInfo)
MboRemote	updateInventory(MboRemote invMbo, java.lang.String itemnum, java.lang.String location, java.lang.String siteid, java.lang.String itemsetid, UserInfo userInfo) Method to update GL Account
void	updateInvUseLines(MboSetRemote msr, java.lang.String plnum, MXTransaction trans)
void	validateBinLot(Inventory inv, java.lang.String binnum, java.lang.String lotnum) This method takes location,binnum,lotnum and checks the ITEMNUM/LOCATION/BINNUM/LOTNUM combination against the INVBALANCES table.
MboRemote	validateInventory(UserInfo userInfo, java.lang.String item, java.lang.String itemsetid, java.lang.String location) checks the ITEMNUM/LOCATION combination against the Inventory table.

Methods inherited from class psdi.server.AppService

checkSecurity, configure, freeDBConnection, freeMboSet, getCriteria, getCriteriaList, getCurrentState, getDBConnection, getLiveObjCount, getLoad, getMaximoDD, getMaxVar, getMboSet, getMXServer, getName, getProfile, getProxy, getSchemaOwner, getServiceInfo, getServiceLogger, getSetForRelationship, getSetFromKeys, getStateCmdList, getStateList, getURL, initCriteriaList, isAppService, isRunning, isSingletonService, restart, setName, setProxy, setRunning, setURL, verifyUser, verifyUser

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface psdi.server.AppServiceRemote

checkSecurity, getCriteria, getCurrentState, getLiveObjCount, getMboSet, getName, getSchemaOwner, getSetForRelationship, getSetFromKeys, getStateCmdList, getStateList, getURL, verifyUser, verifyUser

Methods inherited from interface psdi.server.ServiceRemote

isAppService, isSingletonService, restart

Constructor Detail

InventoryService

public InventoryService()
                 throws java.rmi.RemoteException

Throws:

java.rmi.RemoteException

InventoryService

public InventoryService(MXServer mxServer)
                 throws java.rmi.RemoteException

Throws:

java.rmi.RemoteException

Method Detail

init

public void init()

Initialization

Specified by:

init in interface Service

Overrides:

init in class AppService

See Also:

This listener gets setup.

destroy

public void destroy()

Unregister event listeners.

Specified by:

destroy in interface Service

Overrides:

destroy in class AppService

See Also:

AppService.destroy()

setAdjustmentType

public void setAdjustmentType(int type,
                              MboRemote invAdjust)
                       throws MXException,
                              java.rmi.RemoteException

Sets adjustmenttype based on the passed type to the INVADJUSTMENT object.

Specified by:

setAdjustmentType in interface InventoryServiceRemote

Parameters:

type - Adjustment based on valuelist ITTYPE

invAdjust - the non-persistent mbo InvAdjustment

Throws:

MXException

java.rmi.RemoteException

See Also:

InventoryService.setAdjustmentType(int, psdi.mbo.MboRemote)

getItemsInStore

public MboSetRemote getItemsInStore(UserInfo userInfo,
                                    java.lang.String storeroom)
                             throws MXException,
                                    java.rmi.RemoteException

Returns an MboSetRemote of ITEM's in the specified Storeroom

Specified by:

getItemsInStore in interface InventoryServiceRemote

Parameters:

storeroom - the storeroom for which you seek a list of items

userInfo - passed by the caller

Returns:

MboSetRemote

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getItemsInStore(psdi.app.inventory.UserInfo, java.lang.String)

createIssue

public MboRemote createIssue(UserInfo userInfo,
                             MboSetRemote issueSet,
                             java.lang.String itemnum,
                             java.lang.String location,
                             java.lang.String siteid,
                             java.lang.String ownersysid1)
                      throws MXException,
                             java.rmi.RemoteException

Generates an issue record and adds the new mbo to a pre-named set.
This method also checks integration rules using the ownersysid passed into the method. The method will accomplish the following:

1. - check to ensure itemum/itemsetid/location parameters contain some value
2. - used the itemum/itemsetid/location parameters to create an InventorySet
3. - get the first inventory mbo of that set, and call InventoryRemote.createIssue(1,2)

InventoryRemote.createIssue(1,2) will do the following:

1. - check integration rules for the INVISS flag ("can caller create a matusetrans?") integration rules will be checked using the inventory ownersysid and parameter ownersysid1
2. - create a matusetrans mbo, add it to parameter issueSet, and return the mbo which was just added

Specified by:

createIssue in interface InventoryServiceRemote

Parameters:

userInfo - user information to instantiate matusetrans set

issueSet - the set which caller would like the new MatUseTrans mbo to be added (pass null if no particular set need be used)

itemnum - the itemnum of the inventory record which should be issued

location - the location of the inventory record which should be issued

siteid - the site where the inventory is out. * @param ownersysid1 the ownersysid of the matusetrans which caller has received (via integration, most likely) and would like to insert into Maximo

Returns:

MboRemote which will contain either null or the newly generated MatUseTrans mbo.

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#createIssue(psdi.app.inventory.UserInfo, psdi.app.inventory.MboSetRemote, java.lang.String, java.lang.String, java.lang.String, java.lang.String)

createIssue

public MboRemote createIssue(UserInfo userInfo,
                             java.lang.String itemnum,
                             java.lang.String location,
                             java.lang.String siteid,
                             java.lang.String bin,
                             java.lang.String lot,
                             java.lang.String rotasset,
                             double qty)
                      throws java.rmi.RemoteException,
                             MXException

Returns a MatUseTrans mbo and set the columns based on the parameters passed.

Specified by:

createIssue in interface InventoryServiceRemote

Parameters:

userInfor - user information to instantiate matusetrans set

itemnum - Item to be issued.

location - the storeroom location where the item is being out.

siteid - the site where the inventory is out.

bin - the bin in the storeroom where the item is being issued out.

lot - the lot where the item is stored if this item is a lot tracking one.

rotasset - the piece of asset to be issued if the item is rotating.

qty - quantity needed for this issue.

Returns:

MboRemote the MatUseTrans set created

Throws:

none

java.rmi.RemoteException

MXException

See Also:

psdi.app.inventory.InventoryService#createIssue(psdi.app.inventory.UserInfo, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, double)

getItemSetIdFromSite

public java.lang.String getItemSetIdFromSite(UserInfo userInfo,
                                             java.lang.String siteid)
                                      throws MXException,
                                             java.rmi.RemoteException

returns the itemset id when siteid is passed

Specified by:

getItemSetIdFromSite in interface InventoryServiceRemote

Parameters:

userInfo -

siteid -

Returns:

Throws:

MXException

java.rmi.RemoteException

See Also:

InventoryService.getItemSetIdFromSite(psdi.security.UserInfo, java.lang.String)

createMiscReceipt

public MboRemote createMiscReceipt(UserInfo userInfo,
                                   MboSetRemote existingReceiptSet,
                                   java.lang.String itemnum,
                                   java.lang.String toStoreLoc,
                                   java.lang.String siteid,
                                   java.lang.String ownersysid)
                            throws MXException,
                                   java.rmi.RemoteException

Returns a MatRecTrans Mbo for the caller to perform the miscellaneous receipts functionality - a return without a corresponding issue. This is treated as Transfer in.

Specified by:

createMiscReceipt in interface InventoryServiceRemote

Parameters:

UserInfo - user information to instantiate matrectrans set

receiptSet - the MboSet the caller desires to save all receipts

itemnum - the itemnum being returned

toStoreLoc - the sotreroom to return the item to.

siteid - the site where the inventory is out. * @param ownersysid the MIC/external systems usage

Returns:

MboRemote the MatRecTrans set created

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#createMiscReceipt(psdi.app.inventory.UserInfo, psdi.app.inventory.MboSetRemote, java.lang.String, java.lang.String,java.lang.String ,java.lang.String)

getCurrentBalance

public double getCurrentBalance(UserInfo userInfo,
                                java.lang.String itemnum,
                                java.lang.String itemsetid,
                                java.lang.String location,
                                java.lang.String binnum,
                                java.lang.String lotnum)
                         throws MXException,
                                java.rmi.RemoteException

Creates an Inventory Set using the itemnum/location parameters passed.
The first inventory mbo of that set will be used to call upon the InventoryRemote.getCurrentBalance(1,2) method.

Specified by:

getCurrentBalance in interface InventoryServiceRemote

Parameters:

userInfo - the User information

itemnum - the itemnum of the inventory record for which a balance is requested.

itemsetid - the item set identifier of the inventory record for which a balance is requested.

location - the location of the inventory record for which a balance is requested.

binnum - the binnum of the invbalance record for which a balance is requested.
if binnum passed into this method as null, it will not be considered when retrieving balance set!
if binnum passed into this method as "", it will be treated as a null (eg. select curbal where binnum is null)

lotnum - the lotnum of the invbalance record for which a balance is requested.
if lotnum passed into this method as null, it will not be considered when retrieving balance set!
if lotnum passed into this method as "", it will be treated as a null (eg. select curbal where lotnum is null)
NOTE: only lotted items can consider lotnum - no lotnums allowed in DB for items which don't have a type of LOTTED

Returns:

double the current balance using the parameters provided.

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getCurrentBalance(psdi.app.inventory.UserInfo, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)

getBalances

public MboSetRemote getBalances(UserInfo userInfo,
                                java.lang.String itemnum,
                                java.lang.String itemsetid,
                                java.lang.String location,
                                java.lang.String siteid)
                         throws MXException,
                                java.rmi.RemoteException

Find the balances records and return the set.

Specified by:

getBalances in interface InventoryServiceRemote

Parameters:

userInfo - the User information

itemnum - the itemnum of the inventory record for which a balance is requested.

itemsetid - the item set identifier of the inventory record for which a balance is requested.

location - the location of the inventory record for which a balance is requested.

Returns:

MboSetRemote the balances records

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getBalances(psdi.app.inventory.UserInfo, java.lang.String, java.lang.String,java.lang.String, java.lang.String)

getBalancesForInventorySet

public MboSetRemote getBalancesForInventorySet(MboSetRemote inventorySet)
                                        throws MXException,
                                               java.rmi.RemoteException

returns the set of InvBalances across all itemnum/location/binnum/lotnum combinations for a given set of Inventory itemnum/location combinations

Specified by:

getBalancesForInventorySet in interface InventoryServiceRemote

Parameters:

inventorySet - the set of itemnum/(store)location combinations for which the InvBalances set is requested

Returns:

invBalances the set of InvBalances

Throws:

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getBalancesForInventorySet(psdi.mbo.MboRemote)

getUnauthInvSet

public java.util.Vector getUnauthInvSet()

canGoNegative

public void canGoNegative(UserInfo userInfo,
                          double toBeIssued,
                          java.lang.String itemnum,
                          java.lang.String itemsetid,
                          java.lang.String location,
                          java.lang.String siteid)
                   throws MXException,
                          java.rmi.RemoteException

Can negative balance be allowed?

Specified by:

canGoNegative in interface InventoryServiceRemote

Parameters:

UserInfo - The userInfo of the calling mbo.

toBeIssued - quantity to be issued out of the storeroom bin

itemnum - Item Number

itemsetid - Item Set Identifier

location - The storeroom

Throws:

MXException

java.rmi.RemoteException

See Also:

InventoryService.canGoNegative(psdi.security.UserInfo,double, java.lang.String,java.lang.String,java.lang.String,java.lang.String)

canGoNegative

public void canGoNegative(UserInfo userInfo,
                          double toBeIssued,
                          java.lang.String itemnum,
                          java.lang.String itemsetid,
                          java.lang.String location)
                   throws MXException,
                          java.rmi.RemoteException

Can negative balance be allowed?

Specified by:

canGoNegative in interface InventoryServiceRemote

Parameters:

UserInfo - The userInfo of the calling mbo.

toBeIssued - quantity to be issued out of the storeroom bin

itemnum - Item Number

itemsetid - Item Set Identifier

location - The storeroom

Throws:

MXException

java.rmi.RemoteException

See Also:

InventoryService.canGoNegative(psdi.security.UserInfo,double, java.lang.String,java.lang.String,java.lang.String)

canGoNegative

public void canGoNegative(UserInfo userInfo,
                          double toBeIssued,
                          double totalAvailable,
                          MboRemote sourceMbo)
                   throws MXException,
                          java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

canGoNegative

public void canGoNegative(UserInfo userInfo,
                          double toBeIssued,
                          java.lang.String itemnum,
                          java.lang.String itemsetid,
                          java.lang.String location,
                          java.lang.String binnum,
                          java.lang.String lotnum,
                          java.lang.String siteid)
                   throws MXException,
                          java.rmi.RemoteException

Can negative balance be allowed?

Parameters:

UserInfo - The userInfo of the calling mbo.

toBeIssued - quantity to be issued out of the storeroom bin

itemnum - Item Number

itemsetid - Item Set Identifier

location - The storeroom

binnum - The bin

lotnum - lot number if item is tracked by lot

Throws:

MXException

java.rmi.RemoteException

canGoNegative

public void canGoNegative(UserInfo userInfo,
                          double toBeIssued,
                          double curbal,
                          double totalAvailable,
                          MboRemote sourceMbo)
                   throws MXException,
                          java.rmi.RemoteException

Can negative balance be allowed?

Parameters:

UserInfo - The userInfo of the calling mbo.

toBeIssued - quantity to be issued out of the storeroom bin

curbal - the current balance in the bin.

totalAvailable - The total available balance

Throws:

negativeBalisNotAllowed - Will not let transaction proceed if the issue will cause the current balance to go negative if MaxVars NEGATIVECURBAL is set to "DISALLOW".

negativeAvailisNotAllowed - Will not let transaction proceed if the issue will cause the total available balance to go negative if MaxVars NEGATIVEAVAIL is set to "DISALLOW".

MXException

java.rmi.RemoteException

isSameStoreroomTransfer

public boolean isSameStoreroomTransfer(MboRemote sourceMbo)
                                throws MXException,
                                       java.rmi.RemoteException

Checks if the transfer is between same storeroom.

Parameters:

sourceMbo -

Returns:

Throws:

MXException

java.rmi.RemoteException

canGoNegative

public void canGoNegative(UserInfo userInfo,
                          double toBeIssued,
                          double curbal,
                          double totalAvailable,
                          MboRemote sourceMbo,
                          java.lang.String costType)
                   throws MXException,
                          java.rmi.RemoteException

Can negative balance be allowed?

Parameters:

UserInfo - The userInfo of the calling mbo.

toBeIssued - quantity to be issued out of the storeroom bin

curbal - the current balance in the bin.

totalAvailable - The total available balance

sourceMbo - The calling mbo.

costType - The cost type of the item.

Throws:

negativeBalisNotAllowed - Will not let transaction proceed if the issue will cause the current balance to go negative if MaxVars NEGATIVECURBAL is set to "DISALLOW".

negativeAvailisNotAllowed - Will not let transaction proceed if the issue will cause the total available balance to go negative if MaxVars NEGATIVEAVAIL is set to "DISALLOW".

MXException

java.rmi.RemoteException

findItemsForPhysCount

public MboSetRemote findItemsForPhysCount(UserInfo userInfo,
                                          java.lang.String location)
                                   throws MXException,
                                          java.rmi.RemoteException

Find the elligible balances records for physcical count by items due to be counted.
The formula for items due to be counted:
Invbalances.physcntdate + inventory.ccf <= system date.

Specified by:

findItemsForPhysCount in interface InventoryServiceRemote

Parameters:

userInfo - User Information to instantiate the mbo set

location - storeroom where the count is taking place.

Returns:

MboSetRemote the elligible balances records

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#findItemsForPhysCount(psdi.app.inventory.UserInfo, java.lang.String)

getBins

public MboSetRemote getBins(UserInfo userInfo,
                            java.lang.String location,
                            java.lang.String binnum)
                     throws MXException,
                            java.rmi.RemoteException

Retuns an invbalances set for a given binnum(wildcard) and storeloc

Specified by:

getBins in interface InventoryServiceRemote

Parameters:

userInfo - user information

location - Location

binnum - binnum

Returns:

An InvBalances set.

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getBins(psdi.app.inventory.UserInfo, java.lang.String, java.lang.String)

getLots

public MboSetRemote getLots(UserInfo userInfo,
                            java.lang.String itemnum,
                            java.lang.String itemsetid,
                            java.lang.String location,
                            java.lang.String binnum)
                     throws MXException,
                            java.rmi.RemoteException

Retuns an invbalances set for a given item/location/bin.

Specified by:

getLots in interface InventoryServiceRemote

Parameters:

userInfo - user information

itemnum - item number

itemsetid - item set identifier

location - Location

binnum - binnum

Returns:

An InvBalances set

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getLots(psdi.app.inventory.UserInfo, java.lang.String, java.lang.String, java.lang.String, java.lang.String)

getReservationsForWO

public MboSetRemote getReservationsForWO(UserInfo userInfo,
                                         java.lang.String wonum)
                                  throws MXException,
                                         java.rmi.RemoteException

Retuns a set of reservations required by the passed work order.

Specified by:

getReservationsForWO in interface InventoryServiceRemote

Parameters:

userInfo - user information to instantiate the mbo set

wonum - work order number

Returns:

An InvReserve set

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getReservationsForWO(psdi.app.inventory.UserInfo, java.lang.String)

getReservationsForMR

public MboSetRemote getReservationsForMR(UserInfo userInfo,
                                         java.lang.String mrnum)
                                  throws MXException,
                                         java.rmi.RemoteException

Retuns a set of reservations required by the passed MR.

Specified by:

getReservationsForMR in interface InventoryServiceRemote

Parameters:

userInfo - user information to instantiate the mbo set

wonum - mr num

Returns:

An InvReserve set

Throws:

none

MXException

java.rmi.RemoteException

See Also:

psdi.app.inventory.InventoryService#getReservationsForMR(psdi.app.inventory.UserInfo, java.lang.String)

isWOValid

public MboRemote isWOValid(UserInfo userInfo,
                           java.lang.String wonum)
                    throws MXException,
                           java.rmi.RemoteException

Check if this work order is valid or if the wo is in approved status

Parameters:

userInfo - user information to instantiate wo set

wonum - The work order number

checkApproved - to check if this work order is an approved one.

Throws:

none

MXException

java.rmi.RemoteException

isMRValid

public void isMRValid(UserInfo userInfo,
                      java.lang.String mrnum)
               throws MXException,
                      java.rmi.RemoteException

Check if this mr is valid or if the mr is in approved status

Parameters:

UserInfo - user information to initiate the mboset

mrnum - The mr number

Throws:

none

MXException

java.rmi.RemoteException

getMatReceiptSet

public MboSetRemote getMatReceiptSet(UserInfo ui,
                                     java.lang.String ponum)
                              throws MXException,
                                     java.rmi.RemoteException

Returns a set of MatRecTrans records that are yet to be approved.

Specified by:

getMatReceiptSet in interface InventoryServiceRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

InventoryService.getMatReceiptSet(psdi.security.UserInfo, java.lang.String)

validateBinLot

public void validateBinLot(Inventory inv,
                           java.lang.String binnum,
                           java.lang.String lotnum)
                    throws MXException,
                           java.rmi.RemoteException

This method takes location,binnum,lotnum and checks the ITEMNUM/LOCATION/BINNUM/LOTNUM combination against the INVBALANCES table.

Specified by:

validateBinLot in interface InventoryServiceRemote

Parameters:

inv - inventory object

binnum - frombin or tobin

lotnum - fromlot or tolot

Throws:

MXApplicationException("inventory","noBalanceRecord") - if InvBalances record does not exist

MXException

java.rmi.RemoteException

See Also:

FldMatRecTransBin

validateInventory

public MboRemote validateInventory(UserInfo userInfo,
                                   java.lang.String item,
                                   java.lang.String itemsetid,
                                   java.lang.String location)
                            throws MXException,
                                   java.rmi.RemoteException

checks the ITEMNUM/LOCATION combination against the Inventory table.

Specified by:

validateInventory in interface InventoryServiceRemote

Parameters:

userInfo - user information to instantiate Locations set

item - itemnum

itemsetid - item set identifier

location - fromstoreloc or tostoreloc

Throws:

MXApplicationException("inventory","invbalNotInInventory") - if Inventory record does not exist

MXException

java.rmi.RemoteException

See Also:

FldMatRecTransBin

isCourierOrLabor

public boolean isCourierOrLabor(UserInfo userInfo,
                                java.lang.String location)
                         throws MXException,
                                java.rmi.RemoteException

returns true if the location is of type COURIER or LABOR

Specified by:

isCourierOrLabor in interface InventoryServiceRemote

Parameters:

userInfo - user information to instantiate Locations set

location - key for the Locations object to test to see if type is Courier or Location

Throws:

MXApplicationException("locations","invalidlocation") - if location does not exist in the Locations object

MXException

java.rmi.RemoteException

See Also:

FldMatRecTransToBin

getDefaultLotNum

public java.lang.String getDefaultLotNum(MboRemote mbo)
                                  throws MXException,
                                         java.rmi.RemoteException

getDefaultLotNum() Returns the first lotnum found in the InvLots table with a valid useby date

Specified by:

getDefaultLotNum in interface InventoryServiceRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

FldMatUseTransItemNum.action()

getConversionFactor

public double getConversionFactor(UserInfo userInfo,
                                  java.lang.String fromUOM,
                                  java.lang.String toUOM,
                                  java.lang.String itemSetID,
                                  java.lang.String itemNum)
                           throws MXException,
                                  java.rmi.RemoteException

Returns the conversion factor that will convert the "from" unit of measure (UOM) to the "to" unit of measure.
This method checks the Conversion table as follows:

1. - If the "form" & "to" units of measure (UOMs) are the same, returns 1.
2. - Checks the conversion table for a match for the UOMs and item and returns the factor, if found.
3. - If no match is found, checks the table for the inverse conversion factor for the UOMs and item and returns 1/factor, if a match is found.
4. - If no match is found, checks the conversion table for a match for the UOMs, with null item value, and returns the factor, if found.
5. - If no match is found, checks the table for the inverse conversion factor for the UOMs, with null item value, and returns 1/factor, if a match is found.
6. - If no match is found, throws an exception.

Specified by:

getConversionFactor in interface InventoryServiceRemote

Parameters:

UserInfo - The userInfo of the calling Mbo.

fromUOM - The unit of measure(UOM) to be converted from.

toUOM - The unit of measure to be converted to.

itemSetID - The item set identifier to be used.

itemNum - The item identifier to be used.

Throws:

ParametesAreRequired - if either UOM parameter is empty.

FactorDoesNotExist - if a valid relationship does not exist.

MXException

java.rmi.RemoteException

See Also:

InventoryService.getConversionFactor(psdi.security.UserInfo,java.lang.String,java.lang.String,java.lang.String,java.lang.String)

getUnitConversionFactor

public java.lang.String getUnitConversionFactor(UserInfo userInfo,
                                                java.lang.String fromUOM,
                                                java.lang.String toUOM,
                                                java.lang.String itemSetID,
                                                java.lang.String itemNum)
                                         throws MXException,
                                                java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

getConversionFactor

public double getConversionFactor(UserInfo userInfo,
                                  java.lang.String fromUOM,
                                  java.lang.String toUOM,
                                  java.lang.String itemSetID)
                           throws MXException,
                                  java.rmi.RemoteException

Returns the conversion factor that will convert the "from" unit of measure (UOM) to the "to" unit of measure.
This method checks the Conversion table as follows:

1. - If the "form" & "to" units of measure (UOMs) are the same, returns 1.
2. - If no match is found, checks the conversion table for a match for the UOMs, with null item value, and returns the factor, if found.
3. - If no match is found, checks the table for the inverse conversion factor for the UOMs, with null item value, and returns 1/factor, if a match is found.
4. - If no match is found, throws an exception.

Specified by:

getConversionFactor in interface InventoryServiceRemote

Parameters:

UserInfo - The userInfo of the calling Mbo.

fromUOM - The unit of measure(UOM) to be converted from.

toUOM - The unit of measure to be converted to.

itemSetID - The item set identifier to be used.

Throws:

ParametesAreRequired - if either UOM parameter is empty.

FactorDoesNotExist - if a valid relationship does not exist.

MXException

java.rmi.RemoteException

See Also:

InventoryService.getConversionFactor(psdi.security.UserInfo,java.lang.String,java.lang.String,java.lang.String)

adjustCurrentBalance

public void adjustCurrentBalance(MboRemote invBalances,
                                 java.lang.String newBalance,
                                 double stdcost,
                                 double avgcost,
                                 java.lang.String conditioncode)
                          throws MXException,
                                 java.rmi.RemoteException

Adjusts the current balance.

Parameters:

newBalance - The new balance

Throws:

MXException

java.rmi.RemoteException

getConversionFactorToStoreroom

public MboRemote getConversionFactorToStoreroom(MboRemote mbo,
                                                java.lang.String tostoreloc,
                                                java.lang.String tositeid)
                                         throws MXException,
                                                java.rmi.RemoteException

set the the conversion factor , to bin and lot for the item transfer based on the to store rom location

Parameters:

mbo -

tostoreloc -

Returns:

Throws:

MXException

java.rmi.RemoteException

createInvbalances

public void createInvbalances(MboRemote invMbo,
                              java.lang.String itemnum,
                              java.lang.String location,
                              java.lang.String siteid,
                              java.lang.String binnum,
                              java.lang.String lotnum,
                              java.lang.String conditioncode,
                              java.lang.String itemsetid,
                              java.lang.String curbal,
                              UserInfo userInfo)
                       throws MXException,
                              java.rmi.RemoteException

add inventory balance for existing inventory

Parameters:

invMbo -

itemnum -

location -

siteid -

binnum -

lotnum -

conditioncode -

itemsetid -

curbal -

userInfo -

Throws:

MXException

java.rmi.RemoteException

adjustPhysicalCount

public void adjustPhysicalCount(MboRemote invMbo,
                                java.lang.String itemnum,
                                java.lang.String location,
                                java.lang.String siteid,
                                java.lang.String binnum,
                                java.lang.String lotnum,
                                java.lang.String itemsetid,
                                double physcnt,
                                UserInfo userInfo)
                         throws MXException,
                                java.rmi.RemoteException

Parameters:

invMbo -

itemnum -

location -

siteid -

binnum -

lotnum -

itemsetid -

physcnt -

userInfo -

Throws:

MXException

java.rmi.RemoteException

previewReconcile

public void previewReconcile(MboSetRemote invBalSetMbo)
                      throws MXException,
                             java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

previewReconcile4InventoryCounting

public void previewReconcile4InventoryCounting(UserInfo userinfo)
                                        throws MXException,
                                               java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

reconcile

public MboSetRemote reconcile(MboSetRemote invBalSetMbo)
                       throws MXException,
                              java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

createReturnForIssueStoreloc

public MboRemote createReturnForIssueStoreloc(MboRemote issueMbo)
                                       throws MXException,
                                              java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

updateInventory

public MboRemote updateInventory(MboRemote invMbo,
                                 java.lang.String itemnum,
                                 java.lang.String location,
                                 java.lang.String siteid,
                                 java.lang.String itemsetid,
                                 UserInfo userInfo)
                          throws MXException,
                                 java.rmi.RemoteException

Method to update GL Account

Parameters:

invMbo -

itemnum -

location -

siteid -

itemsetid -

userInfo -

Returns:

Throws:

MXException

java.rmi.RemoteException

getStoreroom

public MboRemote getStoreroom(UserInfo userInfo,
                              java.lang.String location,
                              java.lang.String siteid)
                       throws java.rmi.RemoteException,
                              MXException

Method to update all Gl Account for current Storeroom

Parameters:

userInfo -

location -

siteid -

Returns:

Throws:

java.rmi.RemoteException

MXException

updateAllInventory

public MboSetRemote updateAllInventory(MboSetRemote invBalSetMbo,
                                       UserInfo userInfo)
                                throws MXException,
                                       java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

createIssueForNonStock

public MboRemote createIssueForNonStock(UserInfo userInfo,
                                        MboSetRemote issueSet,
                                        java.lang.String itemnum,
                                        java.lang.String itemsetid,
                                        java.lang.String location,
                                        java.lang.String siteid,
                                        java.lang.String ownersysid1)
                                 throws MXException,
                                        java.rmi.RemoteException

IJ23801:TS003101968:new method to create matusetrans for non-stock items

Parameters:

userInfo -

issueSet -

itemnum -

itemsetid -

location -

siteid -

ownersysid1 -

Returns:

Throws:

MXException

java.rmi.RemoteException

createPickList

public MboRemote createPickList(MboSetRemote msr,
                                java.lang.String pldescription,
                                java.lang.String plnum,
                                java.util.Date reqdate,
                                java.lang.String storeroom,
                                java.lang.String siteid,
                                UserInfo userInfo,
                                MXTransaction trans)
                         throws MXException,
                                java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

updateInvUseLines

public void updateInvUseLines(MboSetRemote msr,
                              java.lang.String plnum,
                              MXTransaction trans)
                       throws MXException,
                              java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

changeStatus

public void changeStatus(MboRemote mbo,
                         java.lang.String status,
                         java.util.Date asOfDate,
                         java.lang.String memo,
                         long accessModifier)
                  throws MXException,
                         java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

autoSplitRecordSet

public MboSetRemote autoSplitRecordSet(MboRemote invUseLineMbo,
                                       UserInfo userInfo)
                                throws MXException,
                                       java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

getLineSplitRecords

public MboSetRemote getLineSplitRecords(MboSetRemote invbalmsr,
                                        MboRemote invUseLineMbo,
                                        UserInfo userInfo)
                                 throws MXException,
                                        java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

getLineSplitForRotItems

public MboSetRemote getLineSplitForRotItems(MboSetRemote assetmsr,
                                            MboRemote invUseLineMbo,
                                            UserInfo userInfo)
                                     throws MXException,
                                            java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

addReservation

public MboRemote addReservation(MboSetRemote msr,
                                java.lang.String pl_num,
                                java.lang.String siteid,
                                UserInfo userInfo,
                                MXTransaction trans)
                         throws java.rmi.RemoteException,
                                MXException

Throws:

java.rmi.RemoteException

MXException

setZeroNewPhysCnt

public void setZeroNewPhysCnt(long uniqueId,
                              boolean toRemove)
                       throws MXException,
                              java.rmi.RemoteException

IJ29192:

Parameters:

uniqueId -

toRemove - - true if to remove the invuselindid from vector

Throws:

MXException

java.rmi.RemoteException

isZeroNewPhysCnt

public boolean isZeroNewPhysCnt(long uniqueId)
                         throws MXException,
                                java.rmi.RemoteException

IJ29192 returns true if this passed invuselineid exists in the vector

Parameters:

uniqueId -

Returns:

Throws:

MXException

java.rmi.RemoteException