i was interested in trying to get the cancelled cheques reconciled through automation. after trying to record a macros while trying to clearing some cheques, all i see is the connection created to the COMAPI for the company link. shouldn't it create or compse the views to the appropriate views?
would someone be able to guide me on what the composed views should look like. or is this not possible to create?
I believe it should start as follows:
Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink
Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE)
Dim BKH As AccpacCOMAPI.AccpacView
Dim BKHF As AccpacCOMAPI.AccpacViewFields
mDBLinkCmpRW.OpenView "BK0845", BKH
Set BKHF = BKH.Fields
Dim BKD As AccpacCOMAPI.AccpacView
Dim BKDF As AccpacCOMAPI.AccpacViewFields
mDBLinkCmpRW.OpenView "BK0840", BKD
Set BKDF = BKD.Fields
BKH.Compose Array(Nothing, BKD)
BKD.Compose Array(BKH, Nothing, Nothing, Nothing, Nothing)
BKH.Browse "BANK = 'MAIN' AND SERIAL =74", True
BKH.Read
MsgBox BKH.Fields("FSCYEAR").Value
MsgBox BKH.Fields("SERIAL").Value
BKH.Fields("RECSTATUS").Value = 5
BKH.Update