Class BR_Transaction_bus

Inherits

CI_Account_val, CI_BankCode_val, SY_Customization, SY_Maint, SY_MaintSet

Properties

LOCAL cMainTable$="BR_Transaction"  
LOCAL cIsSysDB=isFALSE  
LOCAL cResetIOList$=CPL("IOLIST cReset.CurrentBankBalance, "+"cReset.OutstandingCheckTotal, cReset.NumberOutstandingChecks, "+"cReset.OutstandingDepositTotal, cReset.NoOutstandingDeposits, "+"cReset.OutstandingAdjustTotal, cReset.NumberOutstandingAdjust")  
PROPERTY AllowGLPostingCheck  
PROPERTY AllowGLPostingDepAdj  
PROPERTY EnablePositivePay   * Read Only *
PROPERTY EnableWireTransfers$   * Read Only *
PROPERTY NewRecords  
PROPERTY ErrorLog  

Object handler for SY_JournalErrorLog

Methods

FUNCTION ClearResetValues()  
FUNCTION CommitRow()  
FUNCTION GetDefaultClearDate$()  

Retuns the Default Cleared Date @Return cDefaultDate$ value

FUNCTION MatchBankFeedTransaction(bankCode$, type$, refNo$, adjustType$, amt, datePosted$, key$)  

Finds matching BR_Transaction record for a bank feed transaction

ParameterDescription
bankCode$ [input, string] Bank code
type$ [input, string] "C" for check or "A" for adjustment
refNo$ [input, string] Check number for check or reference number for adjustment
adjustType$ [input, string] Adjustment type
amt [input, numeric] amount
datePosted$ [input, date] Date posted from the bank
key$ [output, string] BR_Transaction key of the record found, null if no unique match was found
Returns [numeric] Success if one uniquie match is found, Warning if multiple matches are found, or Failure if no match is found
ValueDescription
retWARNING(-1)
retFAILURE(0)
retSUCCESS(1)
FUNCTION ResetRow()  
FUNCTION ResetRow(key$)  
FUNCTION SetAcceptFlag(value)  
FUNCTION SetClearCheck(checkWhere$, rowsChanged$, clearingDate$)  

Collect inputs from BR_Check_Clearing_UI. Clearedbank and cleared date value set based upon the selection type

ParameterDescription
checkWhere$ [input string] , where clause from selection grid used for selecting checks/dep&adj to clear
rowsChanged$ [input string] , SEP separated list of row keys that have been cleared
clearingDate$ [input string] , value to set ClearedDate$

@Return a boolean value

FUNCTION SetClearCheck(checkWhere$, rowsChanged$, clearingDate$, AdjType$)  

Collect inputs from BR_Dep_Clearing_UI. Clearedbank and cleared date value set based upon the selection type

ParameterDescription
checkWhere$ [input string], where clause from selection grid used for selecting checks/dep&adj to clear
rowsChanged$ [input string], SEP separated list of row keys that have been cleared
clearingDate$ [input string], value to set ClearedDate$
AdjType$ [input string], value to set AdjType$

@Return a boolean value

FUNCTION SetHeader(coObj)  
FUNCTION UpdateCheckToAP(brTransRec$, brTransIOL$)  

This function will update ClearedBank$ and ClearedDate$ to AP_TransactionPaymentHistory and AP_CheckHistoryHeader tables and also write to Error log if the records are not found in these tables

ParameterDescription
brTransRec$ [input, string] Record from BR_Transaction
brTransIOL$ [input, string] IOL for BR_Transaction

@Return - retSUCCESS if AP tables are updated successfully @Return - retFAILURE if there is any error during WRITE @Return - retWARNING if User-defined Error Log messages are raised when the records are not found in AP tables

FUNCTION ValidateGroupPositivePay()  
FUNCTION ValidateGroupWireTransfer()  
FUNCTION Write()  

Properties inherited from: SY_Customization

cDummyIol$

Properties inherited from: SY_Maint

cActionWrite, cActionDelete, cActivityLogFilePrefix$, DocDateWarnDisplayed, DocDateWarnStatus, EditState, RecordChanged, FirstFailure$, DocumentTotal, ReadOnlyReason$, UDTValidation$, ViewOnly, CurrentPrecision, DocDateWarnForceOff, DocDateWarnObject, ScriptObject, ImportTest, SkipNullCheck$, AFSRequiredFields$

Properties inherited from: SY_MaintSet

FileChanged

Methods inherited from: CI_Account_val

ClassOverrideAccount(), ClassValidateAccount(), ResetAccountIndex()

Methods inherited from: CI_BankCode_val

ClassValidateBankCode()

Methods inherited from: SY_Customization

GetCustomizations(), PostTableRead(), PreNextRecord(), PreTableWrite()

Methods inherited from: SY_Maint

ChangedRecordCompare(), ChangedRecordInfo(), Clear(), ClearRecord(), ConfirmDelete(), CopyFrom(), ExportToCSV(), GetColumnInfo(), GetColumnProperties$(), GetDefaults(), GetOrigRecord$(), GetPropertyValue(), GetValidationGroups$(), ResetDocDateWarnState(), SetCopyKeyValue(), SetDocDateWarnDisplayed(), SetDocDateWarnOff(), SetKey(), SetKeyValue(), SetPartialRecord(), SetRecord(), SetToReadOnly(), SetValue(), SetValues(), Write(), ActivityLogCreateFile(), ActivityLogPrepare(), ActivityLogSetMessage$(), ActivityLogWrite(), CallScript(), CheckForAdvancedFieldSettings(), CheckForScripts(), CheckNullRequiredField(), PERFORM ChildValidate(), ClassValidateDate(), ClassValidateTelephoneNo(), ClearSetFiles(), ColInfoInitAll(), ColInfoInitDefaults(), CommitRow(), GetPropertyCommon(), InitColInfo(), InitScriptEngine(), InitSearchForUpdate(), InitWorkTable(), IsColInIOList(), IsValid(), LoadColInfo(), OpenMainTable(), ParseExtField(), PreWriteScripts(), RemoveColToSkip(), ResetRow(), RetrieveColInfo(), SetDefaults(), SetFilter(), SetMode(), SetParentHandle(), SetValueNoValidate(), StoreColToSkip(), ValidateAll(), ValidateAllRecord(), ValidateColInfo(), ValidateRule()

Methods inherited from: SY_MaintSet

ClearSetFiles(), CommitRow(), QuickRowLoad(), ResetRow(), SeedDetailRow(), SetFilter(), SetMode()