public class InvBalances extends Mbo implements InvBalancesRemote
See Inventory Package description.
This is a site level object.
The key attribute(s) in this object are as follows: SiteId,ItemSetID, Itemnum, Location, Binnum, Lotnum
The attributes in this object are as follows:
| Attribute Name | Description | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AdjustedPhysCnt | Non-persistent attribute used to maintain new physical count for the item in the bin. Editable for an existing InvBalances object. If value is provided, an Adjust Physcial Count function will take place and the object's PhysCnt column will be updated to the new count. See PhysCnt for more information. | ||||||||||||||||||
AdjustedPhysCntDate | Non-persistent attribute used to maintain new physical count date for the item in the bin. Editable for an existing InvBalances object. If value is provided and the new physical count is also provided, an Adjust Physcial Count function will take place and the object's PhysCntDate column will be updated to the new date. See PhysCntDate for more information. | ||||||||||||||||||
| Binnum | Bin number of the storage location. One of four members of this object's key. This attribute is not required. See Inventory.Binnum.
| ||||||||||||||||||
Curbal | Current balances at this storage location. | ||||||||||||||||||
Itemnum | Inventory Item Number.
One of four members of this object's key. This attribute is required.
| ||||||||||||||||||
ItemSetID | Identifier of the itemset identifier for this object.
| ||||||||||||||||||
LocationThis inventory item's storeroom | location.
One of four members of this object's key. This attribute is required.
Lotnum
| Lot Number of the item at the storage location. One of four members of this object's key.
This is a required attribute for a lotted item. This is a read-only attribute for
an item that is not lotted. Item.Lottype
determines whether or not this is a lotted item.
OrgId | Identifier of the | organization for this object.
PhysCnt | Balance from last physical count at this storage location.
| PhysCntDate | Date of last physical count at this storage location.
| Reconciled | Flag to indicate whether or not the balance has been reconciled.
| ShelfLifeNon-persistent attribute used to maintain InvLot.ShelfLife through the InvBalances object. For lot-tracking items only. | Item.Lottype
determines whether or not this is a lotted item. See the ShelfLife attribute defined in ShelfLife for more information.
SiteId | Identifier of the | site for this object.
UseByNon-persistent attribute used to maintain InvLot.UseBy through the InvBalances object. For lot-tracking items only. | Item.Lottype
determines whether or not this is a lotted item. See the UseBy attribute defined in UseBy for more information.
|
MatRecTrans,
MatUseTrans,
Inventory| Modifier and Type | Field and Description |
|---|---|
static MboSetRemote |
distinctBinSet
stores the set of distinct bins from the InvBalances table from the InvBalances
table or binsHash.
|
MULTILANGCOPY, phantomList, phantomQueueALLROWS, CHANGEDBY_USER, COUNT_ADDITIONS, COUNT_AFTERSAVE, COUNT_DATABASE, COUNT_DELETED, COUNT_EXISTING, DBCONFIG, DELAYVALIDATION, DELAYVALIDATIONONLY, DISCARDABLE, GOTCOMPLETEWHERE, HIDDEN, NO_RELATEDMBOS_OF_OWNERSCHILDREN_FETCH, NOACCESSCHECK, NOACTION, NOADD, NOCOMMIT, NODELETE, NONE, NOOVERWRITE, NOSAVE, NOSETVALUE, NOUPDATE, NOVALIDATION, NOVALIDATION_AND_NOACTION, NOVALIDATION_AND_NOACTION_ALLOWCROSSOVER, READONLY, REBUILD, REQUIRED, SAMEVALUEVALIDATION, SETBYPARENT, USER| Constructor and Description |
|---|
InvBalances(MboSet ms)
InvBalances Constructor
Construct the InvBalances object
|
| Modifier and Type | Method and Description |
|---|---|
void |
add()
Sets the default the values for a new InvBalance record.
|
MboRemote |
adjustCurrentBalance(double newBalance)
adjustCurrentBalance called without passing control account and shrinkage account
|
MboRemote |
adjustCurrentBalance(double newBalance,
java.lang.String controlacc,
java.lang.String shrinkageacc)
Adjusts the current balance.
|
void |
adjustLifoFifoCurrentBalance(double newBalance)
Adjusts the current balance for Lifo/Fifo items.
|
MboRemote |
adjustPhysicalCount(double quantity,
java.util.Date pCountDate)
Adjusts the inventory physical count.
|
void |
appValidate()
last minute validate before save().
|
protected boolean |
canAddConditionCode()
Can we allow condition code for the new InvBalances object?
|
void |
canDelete()
Checks whether this object can be deleted.
|
boolean |
checkWMATStatus()
Check to see if record exists in WOMATSTATUSSYNC table.
|
MboRemote |
createInvTrans(double quantity,
double unitcost,
boolean isreconcile)
This method creates invtrans record for the current balance adjustment for Lifo/Fifo items fr consumption.
|
protected MboSetRemote |
getBins()
returns the distinct set of bins for this InvBalance's siteid.
|
double |
getCurrentBalance()
Get the current balance.
|
double |
getNewBalanceForReconcile()
This method calculates the the new current balance for the invbalance record.
|
double |
getPhysicalCount()
Returns the current Physical count
|
void |
init()
Initialization routine.
|
MboRemote |
previewReconcileBalances()
This method is used to set value for non persistent attribute
|
MboRemote |
reconcileBalances()
Reconciles balances is done at the bin/lot level.
|
void |
reconcileBalancesLifoFifo(java.lang.String controlacc,
java.lang.String shrinkageacc,
java.lang.String remark)
Method to reconcile balance adjustments for the inventory of LIFO/FIFO cost type.
|
void |
reconcileLifoFifoCurrentBalance(double physcnt)
This method updates the curbal and reconciled flag.
|
void |
save()
Saves the invbalances record if it is created; for a lotted item, creates
invlot record if the lot number does not exist.
|
void |
setAutoCreateInvLot(boolean flag)
For a lotted item,returns true if invLot is to be automatically created or
returns false if invlot is not be be automatically created.
|
protected void |
setExpirationDateForThisLot()
Update the expiration date for all inventory balances having the same lot as
the current Mbo.
|
protected void |
setShelfLifeForThisLot()
Update the shelf life for all inventory balances having the same lot as
the current Mbo.
|
void |
updateCurrentBalance(double quantity)
Updates the "curbal" (current balance) field with the value passed in
|
void |
updateLifoFifoQtyAndCreateInvTrans(boolean isreconcile)
This method checks if the item is Condition enabled.
|
void |
updateLifoFifoQtyAndCreateInvTrans(java.util.HashMap condBalMap,
boolean isreconcile)
This method call updateLifoFifoQuantity () for each entry in the Hash map.
|
void |
updateLifoFifoQtyAndCreateInvTrans(java.util.Vector invBalanceVec,
java.lang.String conditionCode,
boolean isreconcile)
This method update invlifofifocost table and adjustcurrent balance for Lifo/Fifo items.
|
addMboSetForRequiredCheck, addToDeleteForInsertList, andEvaluateConditions, blindCopy, checkFieldAccess, checkMethodAccess, checkMethodAccess, checkQualifiedRestriction, checkRecordLock, checkSiteOrgAccessForSave, clear, clearRelatedSets, clearRelatedSets, commit, copy, copy, copy, copyFake, copyValue, copyValue, createComm, delete, delete, deleteDoclinks, determineRequiredFieldsFromERM, duplicate, enableMethod, evaluateCondition, evaluateCondition, evaluateCtrlConditions, evaluateCtrlConditions, evaluateRestriction, excludeObjectForPropagate, findAllNullRequiredFields, fireEvent, generateAutoKey, generateContentUID, getAlwaysFlags, getAttrRestrictionFlag, getAttrRestrictions, getBoolean, getByte, getBytes, getCheckpoint, getClientLocale, getClientTimeZone, getCommLogOwnerNameAndUniqueId, getCondition, getDatabaseValue, getDate, getDeleteForInsertList, getDocLinksCount, getDomainFilterWhere, getDomainIDs, getDouble, getESId, getExistingMboSet, getFetchIndex, getFieldExceptions, getFlags, getFloat, getIgnoreLockCheck, getInitialValue, getInsertCompanySetId, getInsertItemSetId, getInsertOrganization, getInsertOrgForSite, getInsertSite, getInstanciatedMboSet, getInstanciatedMboValue, getInt, getIntegrationService, getKeyValue, getLanguageRecordRowStamp, getLinesRelationship, getList, getLockedByDisplayName, getLockedByUserID, getLong, getMatchingAttr, getMatchingAttr, getMatchingAttrs, getMaxMessage, getMboCtx, getMboData, getMboDataSet, getMboForAttribute, getMboForAttributeStatic, getMboInitialValue, getMboList, getMboLogger, getMboRecordData, getMboServer, getMboSet, getMboSet, getMboSet, getMboSetInfo, getMboSetInfo, getMboValue, getMboValueData, getMboValueData, getMboValueData, getMboValueDataForDownload, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMXTransaction, getName, getOrgForGL, getOrgSiteForMaxvar, getOwner, getProfile, getPropagateKeyFlag, getProxy, getRecordIdentifer, getRecordMboName, getRecordType, getRelatedSets, getRelatedWhere, getRelatedWhere, getRelationshipNameToLangTable, getResourceName, getRowRestrictionFlag, getRowStamp, getRowStampObject, getSecurityLogger, getSiteOrg, getSqlLogger, getString, getString, getStringInBaseLanguage, getStringInSpecificLocale, getStringTransparent, getSynonymValueWhere, getTenantId, getTenantIdForNoMboRecordData, getThisMboSet, getTranslator, getUniqueIdentifer, getUniqueIDName, getUniqueIDValue, getUniqueLanguageIDRecord, getUserInfo, getUserName, getValidateOrder, hasFieldAccess, hasHierarchyLink, hasLockSaveRights, hasRelatedQbe, hasUniqueID, initFieldFlagsOnMbo, initRelationship, isApiBatchError, isAppLockEnabled, isAutoKeyed, isBasedOn, isChangeByUserWhenSetFromLookup, isDuringInit, isEAuditFieldModified, isESigFieldModified, isFlagSet, isForDM, isLocked, isLocked, isLockedByMe, isMasterTenant, isMboLockedByMe, isModified, isModified, isNew, isNoSql, isNull, isOptionGranted, isSelected, isSkipCopyField, isValid, isZombie, lock, modify, moveFieldFlagsToMboValue, needCallInitFieldFlag, orEvaluateConditions, propagateKeyValue, removeCtx, removeRelatedSet, resolveNoSqlWhere, rollbackToCheckpoint, select, setAppDefaultValue, setApplicationError, setApplicationRequired, setAutokeyFields, setCopyDefaults, setDatabaseDefaultValues, setDatabaseDefaultValues, setDefaultValue, setDefaultValues, setDeleted, setDuringInit, setEAuditFieldModified, setESId, setESigFieldModified, setFetchIndex, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlags, setFlag, setFlag, setFlags, setForDM, setHierarchyLink, setIgnoreRecordLockCheck, setLangCodeDefault, setMboCtx, setMLValue, setModified, setModifiedForIntegrationOnly, setNewMbo, setNoSql, setPropagateKeyFlag, setPropagateKeyFlag, setProxy, setReadonlyWhenParentIsReadonly, setRecordType, setReferencedMbo, setReferencedMbo, setResolveNoSqlWhere, setResourceName, setTenantIdForNoMboRecordData, setUniqueIDValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueFromSequence, setValueNull, setValueNull, sigopGranted, sigopGranted, sigopGranted, sigopGranted, sigOptionAccessAuthorized, skipCopyField, smartFill, smartFind, smartFind, smartFind, smartFindByObjectName, smartFindByObjectName, smartFindByObjectNameDirect, startCheckpoint, thisToBeUpdated, throwRequiredException, toBeAdded, toBeDeleted, toBeSaved, toBeUpdated, toBeValidated, undelete, undeleteDoclinks, unlock, unselect, useDataSecurity, validate, validateAttributes, validateKeyUniqueness, valueChangedclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitaddMboSetForRequiredCheck, addToDeleteForInsertList, blindCopy, checkMethodAccess, clear, copy, copy, copy, copyFake, copyValue, copyValue, createComm, delete, delete, duplicate, evaluateCondition, evaluateCtrlConditions, evaluateCtrlConditions, excludeObjectForPropagate, generateAutoKey, getBoolean, getByte, getBytes, getCommLogOwnerNameAndUniqueId, getDatabaseValue, getDate, getDeleteForInsertList, getDocLinksCount, getDomainIDs, getDouble, getExistingMboSet, getFlags, getFloat, getIgnoreLockCheck, getInitialValue, getInsertCompanySetId, getInsertItemSetId, getInsertOrganization, getInsertSite, getInt, getKeyValue, getLinesRelationship, getList, getLockedByDisplayName, getLong, getMatchingAttr, getMatchingAttr, getMatchingAttrs, getMaxMessage, getMboData, getMboDataSet, getMboInitialValue, getMboList, getMboSet, getMboSet, getMboSet, getMboValueData, getMboValueData, getMboValueData, getMboValueDataForDownload, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMXTransaction, getName, getOrgForGL, getOrgSiteForMaxvar, getOwner, getPropagateKeyFlag, getRecordIdentifer, getSiteOrg, getString, getString, getStringInBaseLanguage, getStringInSpecificLocale, getStringTransparent, getThisMboSet, getUniqueIDName, getUniqueIDValue, getUserInfo, getUserName, hasHierarchyLink, hasLockSaveRights, isAutoKeyed, isBasedOn, isFlagSet, isForDM, isLocked, isLocked, isMasterTenant, isMboLockedByMe, isModified, isModified, isNew, isNull, isOptionGranted, isSelected, isZombie, lock, propagateKeyValue, rollbackToCheckpoint, select, setApplicationError, setApplicationRequired, setAutokeyFields, setCopyDefaults, setDeleted, setESigFieldModified, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlag, setFieldFlags, setFlag, setFlag, setFlags, setForDM, setIgnoreRecordLockCheck, setMLValue, setModified, setNewMbo, setPropagateKeyFlag, setPropagateKeyFlag, setReferencedMbo, setReferencedMbo, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull, sigopGranted, sigopGranted, sigopGranted, sigOptionAccessAuthorized, smartFill, smartFind, smartFind, smartFind, smartFindByObjectName, smartFindByObjectName, smartFindByObjectNameDirect, startCheckpoint, thisToBeUpdated, toBeAdded, toBeDeleted, toBeSaved, toBeUpdated, toBeValidated, undelete, unlock, unselect, validate, validateAttributespublic static MboSetRemote distinctBinSet
public InvBalances(MboSet ms) throws MXException, java.rmi.RemoteException
ms - (The calling MBOSet)MXExceptionjava.rmi.RemoteExceptionpublic void updateCurrentBalance(double quantity)
throws MXException,
java.rmi.RemoteException
updateCurrentBalance in interface InvBalancesRemotequantity - New value for the "curbal" attributenoneMXExceptionjava.rmi.RemoteExceptionInvBalances.updateCurrentBalance(double)public double getPhysicalCount()
throws MXException,
java.rmi.RemoteException
getPhysicalCount in interface InvBalancesRemotenone - noneMXExceptionjava.rmi.RemoteExceptionInvBalances.getPhysicalCount()public double getCurrentBalance()
throws MXException,
java.rmi.RemoteException
getCurrentBalance in interface InvBalancesRemotenone - noneMXExceptionjava.rmi.RemoteExceptionInvBalances.getCurrentBalance()public void init()
throws MXException
init in class Mbonone - noneMXExceptionpublic void add()
throws MXException,
java.rmi.RemoteException
| Attribute Name | Attribute Value |
|---|---|
| itemnum | Current itemnum |
| itemsetid | Current itemsetid |
| location | Current location |
| reconciled | false |
| curbal | 0(zero) |
| physcnt | 0(zero) |
| physcntdate | Current date |
add in interface MboRemoteadd in class Mbonone - MXApplicationException - | GROUP | KEY | REASON |
|---|---|---|
| inventory | invBalNoAdd | if the owner of this object is not Inventory |
MXExceptionjava.rmi.RemoteExceptionpublic MboRemote adjustPhysicalCount(double quantity, java.util.Date pCountDate) throws MXException, java.rmi.RemoteException
adjustPhysicalCount in interface InvBalancesRemotepCountDate - Physical Count Datequantity - New PHYSCNT quantityMXApplicationException - if the item is rotating
| GROUP | KEY | REASON |
|---|---|---|
| inventory | adjPhysCntItemRotating | if the item is rotating |
MXExceptionjava.rmi.RemoteExceptionInvBalances.adjustPhysicalCount(double, java.util.Date)public MboRemote adjustCurrentBalance(double newBalance) throws MXException, java.rmi.RemoteException
adjustCurrentBalance in interface InvBalancesRemoteMXExceptionjava.rmi.RemoteExceptionInvBalances.adjustCurrentBalance(double)public MboRemote adjustCurrentBalance(double newBalance, java.lang.String controlacc, java.lang.String shrinkageacc) throws MXException, java.rmi.RemoteException
newBalance - The new balancecontrolacc - control accountshrinkageacc - shrinkage accountMXApplicationException - | GROUP | KEY | REASON |
|---|---|---|
| inventory | adjCurBalItemRotating | if the item is rotating |
| inventory | adjCurBalNoChange | if there is no change in the balance |
MXExceptionjava.rmi.RemoteExceptionpublic MboRemote reconcileBalances() throws MXException, java.rmi.RemoteException
The Current ( Expected ) Balance = Physical Count (INVBALANCES.PHYSCNT) + Transfers In (after the physical count date) - Transfers Out (after the physical count date) + Returns (after the physical count date) - Issues (after the physical count date).
reconcileBalances in interface InvBalancesRemotenone - MXApplicationException - | GROUP | KEY | REASON |
|---|---|---|
| inventory | invbalCannotReconcile | if the InvBalance record has already been reconciled |
MXExceptionjava.rmi.RemoteExceptionInvBalances.reconcileBalances()public void canDelete()
throws MXException,
java.rmi.RemoteException
canDelete in class MboMXAccessExceptionMXApplicationException - | GROUP | KEY | REASON |
|---|---|---|
| access | notauthorized | if the owner is not Inventory |
| inventory | noDeleteInvBal | if the balance is greater than zero for this set |
MXExceptionjava.rmi.RemoteExceptionpublic void setAutoCreateInvLot(boolean flag)
throws MXException,
java.rmi.RemoteException
setAutoCreateInvLot in interface InvBalancesRemoteflag - true or false to indicate if an invlot is to be automatically
created.noneMXExceptionjava.rmi.RemoteExceptionInvBalances.setAutoCreateInvLot(boolean)public void appValidate()
throws MXException,
java.rmi.RemoteException
appValidate in class MboinvbalAlreadyExistsMXExceptionjava.rmi.RemoteExceptionpublic void save()
throws MXException,
java.rmi.RemoteException
save in class Mbonone - noneMXExceptionjava.rmi.RemoteExceptionprotected MboSetRemote getBins() throws MXException, java.rmi.RemoteException
MXExceptionjava.rmi.RemoteExceptionprotected boolean canAddConditionCode()
throws MXException,
java.rmi.RemoteException
MXExceptionjava.rmi.RemoteExceptionprotected void setExpirationDateForThisLot()
throws MXException,
java.rmi.RemoteException
MXExceptionjava.rmi.RemoteExceptionprotected void setShelfLifeForThisLot()
throws MXException,
java.rmi.RemoteException
MXExceptionjava.rmi.RemoteExceptionpublic void adjustLifoFifoCurrentBalance(double newBalance)
throws MXException,
java.rmi.RemoteException
newBalance - The new balanceMXExceptionjava.rmi.RemoteExceptionpublic MboRemote createInvTrans(double quantity, double unitcost, boolean isreconcile) throws MXException, java.rmi.RemoteException
quantity - unitcost - MXExceptionjava.rmi.RemoteExceptionpublic double getNewBalanceForReconcile()
throws MXException,
java.rmi.RemoteException
MXExceptionjava.rmi.RemoteExceptionpublic void reconcileBalancesLifoFifo(java.lang.String controlacc,
java.lang.String shrinkageacc,
java.lang.String remark)
throws MXException,
java.rmi.RemoteException
MXExceptionjava.rmi.RemoteExceptionpublic void updateLifoFifoQtyAndCreateInvTrans(boolean isreconcile)
throws MXException,
java.rmi.RemoteException
MXExceptionjava.rmi.RemoteExceptionpublic void updateLifoFifoQtyAndCreateInvTrans(java.util.HashMap condBalMap,
boolean isreconcile)
throws MXException,
java.rmi.RemoteException
HashMap - MXExceptionjava.rmi.RemoteExceptionpublic void updateLifoFifoQtyAndCreateInvTrans(java.util.Vector invBalanceVec,
java.lang.String conditionCode,
boolean isreconcile)
throws MXException,
java.rmi.RemoteException
HashMap - MXExceptionjava.rmi.RemoteExceptionpublic void reconcileLifoFifoCurrentBalance(double physcnt)
throws MXException,
java.rmi.RemoteException
physcnt - MXExceptionjava.rmi.RemoteExceptionpublic boolean checkWMATStatus()
throws MXException
MXExceptionpublic MboRemote previewReconcileBalances() throws MXException, java.rmi.RemoteException
MXExceptionjava.rmi.RemoteException