psdi.app.invoice

Class InvoiceCost

java.lang.Object

psdi.mbo.Mbo

psdi.app.invoice.InvoiceCost

All Implemented Interfaces:

java.rmi.Remote, InvoiceCostRemote, MboConstants, MboRemote, MaxRemoteProxy

public class InvoiceCost
extends Mbo
implements InvoiceCostRemote

Mbo object to represent InvoiceCost. InvoiceCost object contains the accounting distribution/charge details for the invoice line. The cost of an individual invoice line is spread to more than one general ledger account, work order, location, or piece of asset. Each invoice line should have at least one invoice cost line.

See Invoice Package description.

The key attributes for this object are InvoiceNum, InvoiceLineNum and CostLineNum.

The attributes in this object are as follows:

Attribute Name	Attribute Description
ChargeStore	Yes/No field. Yes indicates that the cost for this line item should be accumulated in the Inventory Cost field on the asset with which this line is associated.
CostLineNum	Unique system generated invoice cost line number.
AssetNum	The asset to which costs for the service should to be charged. Foreign key to Asset.
FinCntrlID	Financial Control Identifier.
GLCreditAcct	The general ledger account code to be credited for this cost distribution line.
GLDebitAcct	The general ledger account code to be debited the cost of this invoice line item, taken from the PO line (if one is specified).
InvoiceLineNum	The invoice line number to which this invoice cost line is associated.
InvoiceNum	Identifier of the invoice.
LineCost	The amount to be charged to the work order, location, asset, or debit GL account, named for this line.
Location	Location where the materials and services were used, displayed from the PO line. Foreign key to Location.
Memo	Note entered by user regarding this distribution.
OrgID	Organization Identifier.
Percentage	The percent of invoice line cost represented by the cost distribution line you are entering.
Quantity	The quantity to be charged to the work order, location, asset, or debit GL account, named for this line.
RefWO	The referenced work order number
SiteID	Site Identifier.
TaskID	The work order's task id associated with this line item.
UnitCost	Cost per unit of the item, displayed from the invoice line.
Vendor	Supplier of the invoice. Foreign key to Company.
WONum	Work order number to be charged. Foreign key to WO.
ICT1 - ICT3	Extra fields.

Author:

Jenny Wang, Aman Thakur, Ganesh Murthy

Field Summary

Fields inherited from class psdi.mbo.Mbo

MULTILANGCOPY, phantomList, phantomQueue

Fields inherited from interface psdi.mbo.MboConstants

ALLROWS, 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 Summary

Constructors

Constructor and Description
InvoiceCost(MboSet ms) Construct the InvoiceCost object

Method Summary

Modifier and Type	Method and Description
void	add() This is called when a new invoice cost is added to the InvoiceCost MboSet collection.
void	appValidate() Pre-save validation method.
void	canDelete() Can this invoiceCost be deleted? It cannot be deleted if it is readonly and also if it is not the only invoicecost for this invoiceline.
void	checkWOAssetLocGLDebitForCost() If at least one of the following: WONUM, LOCATION, ASSETNUM or GLDEBITACCT does not have a value, and the related invoiceline does not have an item belonging to a storeroom, return error.
void	clearInvCostPOLine() Clear the fields copied from poline on deleting the polinenum on the InvoiceLine.
MboRemote	createReceipt() This function is called first when a receipt is created for a invoicecost line.
void	createReceiptForProrate() Create material receipt for prorated cost of the invoice line, if updateinventory is true and there are balance in the storeroom, which its invoice cost is not distributed.
void	delete(long accessModifier) Delete the invoicecost record after checking if it can be deleted.
java.lang.String[]	getValidateOrder() Validation Order for InvoiceCost attributes.
boolean	hasReceipt() Does this invoicecost has the corresponding receipt?
void	init() Initialized Invoice cost mbo.
boolean	isEditabilitySetByPO() Method to indicate if the editibility of the invoice cost fields should be set based on the corresponding poline info.
void	setReadonly() convenient function to set certain fields to readonly or not.
MboRemote	writeToInvoiceMatch(MboRemote receipt) Write the invoicematch between the cost and the receipt.
MboRemote	writeToInvoiceMatch(MboRemote receipt, double qty, double cost) This method writes the invoice match between this cost line and the receipt specified.

Methods inherited from class psdi.mbo.Mbo

addMboSetForRequiredCheck, addToDeleteForInsertList, andEvaluateConditions, blindCopy, checkFieldAccess, checkMethodAccess, checkMethodAccess, checkQualifiedRestriction, checkSiteOrgAccessForSave, clear, copy, copy, copy, copyFake, copyValue, copyValue, createComm, delete, 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, getMboValue, getMboValueData, getMboValueData, getMboValueData, getMboValueDataForDownload, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMXTransaction, getName, getOrgForGL, getOrgSiteForMaxvar, getOwner, getProfile, getPropagateKeyFlag, getProxy, getRecordIdentifer, getRecordMboName, getRelatedWhere, getRelatedWhere, getRelationshipNameToLangTable, getResourceName, getRowRestrictionFlag, getRowStamp, getRowStampObject, getSecurityLogger, getSiteOrg, getSqlLogger, getString, getString, getStringInBaseLanguage, getStringInSpecificLocale, getStringTransparent, getSynonymValueWhere, getTenantId, getThisMboSet, getTranslator, getUniqueIdentifer, getUniqueIDName, getUniqueIDValue, getUniqueLanguageIDRecord, getUserInfo, getUserName, hasFieldAccess, hasHierarchyLink, hasLockSaveRights, hasRelatedQbe, hasUniqueID, initFieldFlagsOnMbo, initRelationship, isApiBatchError, isAutoKeyed, isBasedOn, isChangeByUserWhenSetFromLookup, 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, setDefaultValue, setDefaultValues, setDeleted, 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, setReferencedMbo, setReferencedMbo, setResolveNoSqlWhere, setResourceName, 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, sigOptionAccessAuthorized, smartFill, smartFind, smartFind, smartFindByObjectName, smartFindByObjectName, smartFindByObjectNameDirect, startCheckpoint, thisToBeUpdated, toBeAdded, toBeDeleted, toBeSaved, toBeUpdated, toBeValidated, undelete, unlock, unselect, useDataSecurity, validate, validateAttributes, validateKeyUniqueness, valueChanged

Methods inherited from class java.lang.Object

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

Methods inherited from interface psdi.mbo.MboRemote

addMboSetForRequiredCheck, addToDeleteForInsertList, blindCopy, checkMethodAccess, clear, copy, copy, copy, copyFake, copyValue, copyValue, createComm, 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, smartFindByObjectName, smartFindByObjectName, smartFindByObjectNameDirect, startCheckpoint, thisToBeUpdated, toBeAdded, toBeDeleted, toBeSaved, toBeUpdated, toBeValidated, undelete, unlock, unselect, validate, validateAttributes

Constructor Detail

InvoiceCost

public InvoiceCost(MboSet ms)
            throws java.rmi.RemoteException

Construct the InvoiceCost object

Throws:

java.rmi.RemoteException

Method Detail

init

public void init()
          throws MXException

Initialized Invoice cost mbo. Set some fields to readonly when fetched from database.

Overrides:

init in class Mbo

Throws:

MXException

add

public void add()
         throws MXException,
                java.rmi.RemoteException

This is called when a new invoice cost is added to the InvoiceCost MboSet collection. The field defaults and field flags are set here. The table below shows the default values for each of the attributes listed.

Attribute Name	Attribute Value
chargestore	No
costlinenum	Add one to the existing maximum value
glcreditacct	Vendor's apsuspenseacc(if applicable)
invoicenum	Owner Invoice's invoicenum
linecost	Owner InvoiceLine's linecost
percentage	100
quantity	Owner InvoiceLine's quantity
unitcost	Owner InvoiceLine's unitcost
vendor	Owner InvoiceLine's vendor

Specified by:

add in interface MboRemote

Overrides:

add in class Mbo

Throws:

MXException

java.rmi.RemoteException

canDelete

public void canDelete()
               throws MXException,
                      java.rmi.RemoteException

Can this invoiceCost be deleted? It cannot be deleted if it is readonly and also if it is not the only invoicecost for this invoiceline.

Overrides:

canDelete in class Mbo

Throws:

MXException

java.rmi.RemoteException

delete

public void delete(long accessModifier)
            throws MXException,
                   java.rmi.RemoteException

Delete the invoicecost record after checking if it can be deleted. invoiceqty, linecost and unitcost are set back to editable if there is only one invoicecost remained.

Specified by:

delete in interface MboRemote

Overrides:

delete in class Mbo

Parameters:

accessModifier - The bitwise flag specified to determine if certain normal security checks are to be bypassed for this delete request. For example: if the accessModifer is NOACCESSCHECK, then the check for the object's NODELETE flag and the call to the object's canDelete() method will not be performed. If the accessModifer is NONE, then all the access checks are performed before this object is marked delete.

Throws:

MXException

java.rmi.RemoteException

See Also:

Mbo.delete(long)

clearInvCostPOLine

public void clearInvCostPOLine()
                        throws MXException,
                               java.rmi.RemoteException

Clear the fields copied from poline on deleting the polinenum on the InvoiceLine. Also set fields to default values where ever applicable. This is called by the field action of clearing invoiceline's polinenum.

Specified by:

clearInvCostPOLine in interface InvoiceCostRemote

Throws:

MXException

java.rmi.RemoteException

createReceipt

public MboRemote createReceipt()
                        throws MXException,
                               java.rmi.RemoteException

This function is called first when a receipt is created for a invoicecost line.

Specified by:

createReceipt in interface InvoiceCostRemote

Throws:

MXException

java.rmi.RemoteException

createReceiptForProrate

public void createReceiptForProrate()
                             throws MXException,
                                    java.rmi.RemoteException

Create material receipt for prorated cost of the invoice line, if updateinventory is true and there are balance in the storeroom, which its invoice cost is not distributed. The material receipt will have quanity and linecost being 0, but with a non-zero prorate cost. Create invtrans when updateinventory is false or any remaining quantity not covered by the receipt. This is only called when there is only one invoicecost.

Specified by:

createReceiptForProrate in interface InvoiceCostRemote

Throws:

MXException

java.rmi.RemoteException

hasReceipt

public boolean hasReceipt()
                   throws MXException,
                          java.rmi.RemoteException

Does this invoicecost has the corresponding receipt?

Specified by:

hasReceipt in interface InvoiceCostRemote

Throws:

MXException

java.rmi.RemoteException

writeToInvoiceMatch

public MboRemote writeToInvoiceMatch(MboRemote receipt,
                                     double qty,
                                     double cost)
                              throws MXException,
                                     java.rmi.RemoteException

This method writes the invoice match between this cost line and the receipt specified. Since multiple receipts can be matched to the same invoicecost due to partial receiving, the quantity or cost needs to be specified as parameters. This method will be called during invoicematching of the invoice line when the invoice is being approved. It is called on the invoicecost with costnum=1. If there are multiple receipts matched to this invoiceline, this method will be called multiple times. The detailed information about what should be written to the invoicematch table is omitted here because the overloaded function is already written.

Specified by:

writeToInvoiceMatch in interface InvoiceCostRemote

Parameters:

The - receipt which is the match or one of the matches of the invoiceline.

qty - matched quantity in invoice's order unit.

coust - matched cost in invoice's currency.

Throws:

MXException

java.rmi.RemoteException

See Also:

overloaded form which the invoicecost is completely matched with only the receipt specified.

writeToInvoiceMatch

public MboRemote writeToInvoiceMatch(MboRemote receipt)
                              throws MXException,
                                     java.rmi.RemoteException

Write the invoicematch between the cost and the receipt.

Specified by:

writeToInvoiceMatch in interface InvoiceCostRemote

Throws:

MXException

java.rmi.RemoteException

setReadonly

public void setReadonly()
                 throws MXException,
                        java.rmi.RemoteException

convenient function to set certain fields to readonly or not.

Throws:

MXException

java.rmi.RemoteException

isEditabilitySetByPO

public boolean isEditabilitySetByPO()
                             throws MXException,
                                    java.rmi.RemoteException

Method to indicate if the editibility of the invoice cost fields should be set based on the corresponding poline info. The following rules apply: 1) If the poline related to the owner invoice line is already distributed, return true i.e. cannot distribute invoiceline. 2) Only lines which are direct issue and are not distributed at the poline level should be allowed distribution here.

Returns:

boolean True if editability should be based on poline info, false otherwise.

Throws:

MXException

java.rmi.RemoteException

appValidate

public void appValidate()
                 throws MXException,
                        java.rmi.RemoteException

Pre-save validation method. Based on a maxvar value check if the GL debit and credit accounts are required for this transaction. If at least one of the following: WONUM, LOCATION, ASSETNUM or GLDEBITACCT does not have a value, and the related invoiceline does not have an item belonging to a storeroom, return error. Also validate the debit GL Account and credit GL Account to be fully specified.

Overrides:

appValidate in class Mbo

Throws:

MXApplicationException - (invoice, WOAssetLocGLDebitNull) One of the following does not have a value: wonum, assetnum, location, or gldebitacct.

MXException

java.rmi.RemoteException

getValidateOrder

public java.lang.String[] getValidateOrder()

Validation Order for InvoiceCost attributes.

Overrides:

getValidateOrder in class Mbo

checkWOAssetLocGLDebitForCost

public void checkWOAssetLocGLDebitForCost()
                                   throws MXException,
                                          java.rmi.RemoteException

If at least one of the following: WONUM, LOCATION, ASSETNUM or GLDEBITACCT does not have a value, and the related invoiceline does not have an item belonging to a storeroom, return error.

Specified by:

checkWOAssetLocGLDebitForCost in interface InvoiceCostRemote

Throws:

MXException

java.rmi.RemoteException

See Also:

checkWOAssetLocGLDebitForCost()