def Print_ARAgedBalDate(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print aged bal date")
# name report file: ex: AgedARDate-03
reportName = myTools.buildRepName("AgedARDate",pRepExt)
logging.debug('Print_AgedARDate: ' + reportName)
# make sure timeslips has focus
myTools.getFocus()
logging.debug('- open report')
type("r",KeyModifier.ALT)
type("b")
time.sleep(1)
myTools.pressDOWN(1)
time.sleep(1)
# move to Print To and choose CSV
myTools.pressSHIFTTAB(2)
time.sleep(1)
type("c")
# print the report
type(Key.ENTER)
time.sleep(1)
myTools.finishReport(reportName)
def fCreate_SlipListDetailed():
#---------------------------------------------------#
logging.debug('- fCreate_SlipListDetailed')
# make sure timeslips has focus
myTools.getFocus()
type(Key.F3,KeyModifier.CTRL) # create a report
time.sleep(1)
type("r",KeyModifier.ALT) # ud report
type("n",KeyModifier.ALT) # next
time.sleep(1)
type("s") # slip
type("n",KeyModifier.ALT) # next
time.sleep(1)
myTools.pressDOWN(2) # detailed Listing Simple
type("n",KeyModifier.ALT) # next
time.sleep(1)
type("n",KeyModifier.ALT) # next
type(Key.ENTER) # Open Report Entry
time.sleep(1)
type("s",KeyModifier.CTRL) # save
type(Key.ENTER) # OK
time.sleep(1)
type(Key.F4,KeyModifier.CTRL) # close report
time.sleep(1)
def fPrint_ARwRunBal(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print ARwRunBal")
# name report file: ex: UDSlip1-03
reportName = myTools.buildRepName("ARwRunBal",pRepExt)
logging.debug('fPrint_ARwRunBal: ' + reportName)
myTools.getFocus()
logging.debug('- open report list')
type("r",KeyModifier.ALT)
type("a")
time.sleep(1)
logging.debug('- choose report')
myTools.pressDOWN(2)
time.sleep(1)
# choose txt
myTools.pressSHIFTTAB(2)
time.sleep(1)
type("t")
time.sleep(1)
myTools.enterCurrentMonthOnList(pReportMonth)
# print the report
type(Key.ENTER)
time.sleep(1)
myTools.finishReport(reportName)
def fPrint_FeeAllocPer(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print FeeAllocPer")
# name report file: ex: PreBill-03
reportName = myTools.buildRepName("FeeAllocPer",pRepExt)
logging.debug('Print_FeeAllocPer: ' + reportName)
# make sure timeslips has focus
myTools.getFocus()
logging.debug('- open FeeAllocPer')
type("r",KeyModifier.ALT)
type("t")
time.sleep(1)
myTools.pressDOWN(3)
time.sleep(1)
# choose csv
myTools.pressSHIFTTAB(2)
type("c")
time.sleep(1)
myTools.enterCurrentMonthOnList(pReportMonth)
# print the report
type(Key.ENTER)
time.sleep(1)
myTools.finishReport(reportName)
def fHold_Time_NextBill_Hours():
#---------------------------------------------------#
logging.debug('- Hold_Time_NextBill_Hours')
# open Wakefield
type("Wakefield")
type(Key.ENTER)
time.sleep(1)
# move to page with Hold fields
if int(Settings.tsVersion) > 2014:
myTools.pressF6(5)
else:
myTools.pressF6(3)
# move to Hold time charges
if int(Settings.tsVersion) > 2014:
myTools.pressTAB(3)
else:
myTools.pressTAB(6)
time.sleep(1)
# set to "on next bill" until 5 hours
myTools.pressDOWN(1)
myTools.pressTAB(2)
type("5")
# save
time.sleep(1)
type("s",KeyModifier.CTRL)
def fLink_Accounts_Interest():
#---------------------------------------------------#
myTools.pressDOWN(3) # Interest comp
myTools.pressTAB(1)
type("Interest")
myTools.pressSHIFTTAB(1)
def fLink_Accounts_Suspense():
#---------------------------------------------------#
myTools.pressDOWN(1) # suspense comp
myTools.pressTAB(1)
type("Suspense")
myTools.pressSHIFTTAB(1)
def fLink_Accounts_Allowances():
#---------------------------------------------------#
myTools.pressDOWN(1) # allowances comp
myTools.pressTAB(1)
type("Allowances")
myTools.pressSHIFTTAB(1)
def fLink_Accounts_WO():
#---------------------------------------------------#
myTools.pressDOWN(1) # WO comp
myTools.pressTAB(1)
type("WriteOff")
myTools.pressSHIFTTAB(1)
def fProgressTotal_Setup1():
# - - - - - - - - - - - - - - - - - - - - - - - - - #
myTools.sectionStartTimeStamp("ba ProgressTot1")
logging.debug("ba ProgressTot1")
# open client
type("i", KeyModifier.CTRL)
time.sleep(1)
type("BA-ProgressTot")
type(Key.ENTER)
time.sleep(1)
# get to arrangement field for time
ba__Common.fMoveto_BAPage()
myTools.pressTAB(4)
# switch to minimum
type(Key.HOME)
myTools.pressDOWN(11)
# enter details
type(Key.TAB)
type(Key.ENTER)
time.sleep(1)
type("500")
time.sleep(1)
type(Key.ENTER)
# save and close
type("s", KeyModifier.CTRL)
type(Key.F4, KeyModifier.CTRL)
time.sleep(1)
type(Key.F4, KEY_CTRL)
myTools.sectionEndTimeStamp()
def fLink_Accounts_Refund():
#---------------------------------------------------#
myTools.pressDOWN(1) # Refund comp
myTools.pressTAB(1)
type("Refund")
myTools.pressSHIFTTAB(1)
def setupCustomFilter():
#---------------------------------------------------#
""" sets up custom filter Client List; only used by fPrint_PreBill_2 """
logging.debug('- setupCustomFilter')
wait("slip_trans_date.png",60)
time.sleep(1)
click("slip_trans_date.png")
time.sleep(1)
# switch to the client group
myTools.pressSHIFTTAB(1)
type("c")
time.sleep(1)
# choose Client List
myTools.pressTAB(1)
myTools.pressDOWN(7)
click("add_filter.png")
time.sleep(1)
# mark All
type(Key.INSERT)
time.sleep(1)
# remove Franklin
myTools.pressDOWN(5)
type(Key.F4,KeyModifier.SHIFT)
# press OK
myTools.pressTAB(1)
type(Key.ENTER)
time.sleep(1)
def fCreate_Maximum_RateRule():
#---------------------------------------------------#
logging.debug('- Create_Maximum_RateRule')
# new rule
type("n",KeyModifier.ALT)
type("Maximum")
myTools.pressTAB(1)
type("z")
time.sleep(1)
# rate
myTools.pressTAB(2)
type("4.5")
# maximum
myTools.pressTAB(4)
myTools.pressDOWN(2)
time.sleep(1)
# threshold
myTools.pressTAB(1)
type("1000")
# options
myTools.pressTAB(2)
type(Key.SPACE)
myTools.pressTAB(2)
type(Key.SPACE)
# save
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
# export to all
type(Key.INSERT)
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
def Print_TkCC(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print tkcc")
# name report file: ex: TkCC-03
reportName = myTools.buildRepName("TkCC",pRepExt)
logging.debug('Print_TkCC: ' + reportName)
# make sure timeslips has focus
myTools.getFocus()
logging.debug('- open report')
type("r",KeyModifier.ALT)
type("t")
time.sleep(2)
type("timekeeper cont")
time.sleep(1)
myTools.pressDOWN(1)
time.sleep(1)
type("o",KeyModifier.CTRL)
time.sleep(1)
logging.debug('- default options')
# options button
myTools.pressSHIFTTAB(4)
type(Key.ENTER)
time.sleep(1)
# default button
myTools.pressSHIFTTAB(4)
type(Key.ENTER)
time.sleep(1)
# show client breakdown
myTools.pressTAB(4)
type(Key.SPACE)
time.sleep(1)
# close dialog
type(Key.ENTER)
time.sleep(1)
logging.debug('- print report')
# move to Print To and choose CSV
myTools.pressTAB(2)
type("c")
time.sleep(1)
if pReportMonth != 13:
Filter_SplitClients()
# print the report
type(Key.ENTER)
time.sleep(1)
myTools.finishReport(reportName)
def fAbsoluteNoSlips_Setup(pBAClient):
#---------------------------------------------------#
myTools.sectionStartTimeStamp(pBAClient)
logging.debug(pBAClient)
# open client
myTools.openClient(pBAClient)
# get to arrangement field for both
ba__Common.fMoveto_BAPage()
myTools.pressTAB(3)
type(Key.RIGHT)
time.sleep(1)
type(Key.ENTER)
if int(Settings.tsVersion) > 2014:
type(Key.TAB)
# switch to absolute
type(Key.HOME)
myTools.pressDOWN(2)
# enter details
type(Key.TAB)
type(Key.ENTER)
time.sleep(1)
type("1000")
myTools.pressTAB(1)
time.sleep(1)
if int(Settings.tsVersion) > 2014:
type(Key.TAB)
type("n")
myTools.pressTAB(1)
time.sleep(1)
type("3")
myTools.pressTAB(1)
time.sleep(1)
time.sleep(1)
type("Absolute FF - NoSlips")
time.sleep(1)
# save and close
type(Key.TAB)
type(Key.SPACE)
type("s",KeyModifier.CTRL)
type(Key.F4,KeyModifier.CTRL)
time.sleep(1)
type(Key.F4,KeyModifier.CTRL)
myTools.sectionEndTimeStamp()
def fPrint_AgedClient(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print AgedClient")
# name report file: ex: PreBill-03
reportName = myTools.buildRepName("AgedClient",pRepExt)
logging.debug('Print_AgedClient: ' + reportName)
# make sure timeslips has focus
myTools.getFocus()
logging.debug('- open PayPerf')
type("r",KeyModifier.ALT)
type("c")
time.sleep(1)
myTools.pressDOWN(1)
time.sleep(1)
logging.debug('- set up report')
type("o",KeyModifier.CTRL)
# Options
myTools.pressSHIFTTAB(4)
type(Key.SPACE)
time.sleep(1)
# Default
myTools.pressSHIFTTAB(4)
type(Key.SPACE)
time.sleep(1)
# Show hours
myTools.pressTAB(10)
type(Key.SPACE)
time.sleep(1)
# Show Adjustment columns
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
# OK
type(Key.ENTER)
time.sleep(1)
# choose csv
myTools.pressTAB(2)
type("c")
time.sleep(1)
myTools.enterSlipFilter(pReportMonth,"yy")
# print the report
type(Key.ENTER)
time.sleep(1)
myTools.finishReport(reportName)
def fLink_Accounts_ClientEscrow():
#---------------------------------------------------#
myTools.pressDOWN(3) # clientescrow comp
myTools.pressTAB(1)
type("ClientEscrow-Comp")
myTools.pressSHIFTTAB(1)
time.sleep(1)
def fLink_Accounts_ProgBilling():
#---------------------------------------------------#
myTools.pressDOWN(1) # progbill comp
myTools.pressTAB(1)
type("ProgBilling-Comp")
myTools.pressSHIFTTAB(1)
time.sleep(1)
def fAdjustTimekeeperBoth_Setup(pBAClient):
# - - - - - - - - - - - - - - - - - - - - - - - - - #
myTools.sectionStartTimeStamp(pBAClient)
logging.debug(pBAClient)
# open client
myTools.openClient(pBAClient)
# get to arrangement field for both
ba__Common.fMoveto_BAPage()
myTools.pressTAB(3)
type(Key.RIGHT)
time.sleep(1)
type(Key.ENTER)
# extra TAB starting in TS2015
if int(Settings.tsVersion) > 2014:
type(Key.TAB)
# switch to adjust by timekeeper
type(Key.HOME)
myTools.pressDOWN(1)
# enter details
type(Key.TAB)
type(Key.ENTER)
time.sleep(1)
type("n",KeyModifier.ALT)
type("t")
type(Key.TAB)
type("25")
type(Key.TAB)
type(Key.RIGHT)
if int(Settings.tsVersion) < 2014:
myTools.pressTAB(3)
else:
type("d",KeyModifier.ALT)
time.sleep(1)
type("Adjust Timekeeper - Both")
time.sleep(1)
# save and close
type(Key.TAB)
type(Key.SPACE)
myTools.pressTAB(4)
type(Key.SPACE)
type("s",KeyModifier.CTRL)
type(Key.F4,KeyModifier.CTRL)
time.sleep(1)
type(Key.F4,KeyModifier.CTRL)
myTools.sectionEndTimeStamp()
def fCreate_Compound_RateRules():
#---------------------------------------------------#
logging.debug('- Create_Compound_RateRule')
# new rule
type("n",KeyModifier.ALT)
type("Compound2")
myTools.pressTAB(1)
type("z")
time.sleep(1)
# rate
myTools.pressTAB(2)
type("3")
myTools.pressTAB(5)
type(Key.SPACE)
myTools.pressTAB(2)
type(Key.SPACE)
# save
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
# export to all
type(Key.INSERT)
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
# new rule
type("n",KeyModifier.ALT)
type("Compound1")
myTools.pressTAB(1)
type("z")
time.sleep(1)
# rate
myTools.pressTAB(2)
type("3.5")
# Type
myTools.pressTAB(1)
myTools.pressDOWN(2)
# compound
myTools.pressTAB(2)
type("com")
# options
myTools.pressTAB(1)
type(Key.SPACE)
myTools.pressTAB(2)
type(Key.SPACE)
# save
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
# export to all
type(Key.INSERT)
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
def fPrint_ClientListValues(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print clientvalues")
# name report file: ex: UDSlip1-03
reportName = myTools.buildRepName("UDClient2",pRepExt)
logging.debug('Print_UDClient2: ' + reportName)
myTools.getFocus()
logging.debug('- open report list')
type("r",KeyModifier.ALT)
type("c")
time.sleep(1)
logging.debug('- choose report')
type("ud")
time.sleep(1)
myTools.pressDOWN(1)
time.sleep(1)
# choose CSV
myTools.pressSHIFTTAB(2)
time.sleep(1)
type("c")
time.sleep(1)
# print the report
type(Key.ENTER)
time.sleep(1)
# fill in path and name
type(Settings.repFolder + "\\" + reportName)
time.sleep(1)
# export column titles
myTools.pressTAB(2)
time.sleep(1)
type(Key.SPACE)
time.sleep(1)
# press ENTER to print
type(Key.ENTER)
# wait for report to complete
myTools.waitForReport()
# compare the report with baseline
reports_Compare.Compare_OneReport(reportName)
# close the report
type(Key.F4,KeyModifier.CTRL)
myTools.sectionEndTimeStamp()
def moveTo_NextTemplate():
#---------------------------------------------------#
if int(Settings.tsVersion) < 2015:
myTools.pressDOWN(1)
time.sleep(1)
type("o",KeyModifier.CTRL)
else:
myTools.pressF6(1)
time.sleep(1)
def fCreateOne(pName, pDownArrow):
#---------------------------------------------------#
logging.debug('-- create ' + pName)
type("n",KeyModifier.ALT)
time.sleep(1)
myTools.pressDOWN(pDownArrow+1)
type(Key.ENTER)
time.sleep(1)
type(pName)
type(Key.ENTER)
def fLink_Accounts_CashEscrowOut():
#---------------------------------------------------#
myTools.pressDOWN(3) # cashescout comp
type(Key.DOWN,KeyModifier.CTRL)
myTools.pressDOWN(37)
time.sleep(1)
myTools.pressTAB(1)
type("CashEscOut-Comp")
myTools.pressSHIFTTAB(1)
time.sleep(1)
def fLink_Accounts_CashEscrowIn():
#---------------------------------------------------#
myTools.pressDOWN(1) # cashescin comp
type(Key.DOWN,KeyModifier.CTRL)
myTools.pressDOWN(34)
time.sleep(1)
myTools.pressTAB(1)
type("CashEscIn-Comp")
myTools.pressSHIFTTAB(1)
time.sleep(1)
def fMinimumBoth_Setup(pBAClient):
#---------------------------------------------------#
myTools.sectionStartTimeStamp(pBAClient)
logging.debug(pBAClient)
# open client
type("i",KeyModifier.CTRL)
time.sleep(1)
type(pBAClient)
type(Key.ENTER)
time.sleep(1)
# get to arrangement field for both
ba__Common.fMoveto_BAPage()
myTools.pressTAB(3)
type(Key.RIGHT)
time.sleep(1)
type(Key.ENTER)
if int(Settings.tsVersion) > 2014:
type(Key.TAB)
# switch to minimum
type(Key.HOME)
myTools.pressDOWN(3)
# enter details
type(Key.TAB)
type(Key.ENTER)
time.sleep(1)
type("5000")
myTools.pressTAB(2)
if int(Settings.tsVersion) > 2014:
type(Key.TAB)
time.sleep(1)
type("Minimum FF - Both")
time.sleep(1)
# save and close
type(Key.TAB)
type(Key.SPACE)
type("s",KeyModifier.CTRL)
type(Key.F4,KeyModifier.CTRL)
time.sleep(1)
type(Key.F4,KeyModifier.CTRL)
myTools.sectionEndTimeStamp()
def Setup_Discounts():
# - - - - - - - - - - - - - - - - - - - - - - - - - #
logging.debug('Set Up Discounts')
# make sure timeslips has focus
myTools.getFocus()
logging.debug('- change a client')
type("i",KeyModifier.CTRL)
time.sleep(1)
type(Key.ENTER)
time.sleep(1)
myTools.pressF6(5)
myTools.pressSHIFTTAB(10)
time.sleep(1)
type("10")
type(Key.TAB)
type("30")
type(Key.TAB)
myTools.pressDOWN(2)
time.sleep(1)
type("s", KeyModifier.CTRL)
click("export_btn.png")
time.sleep(1)
type(Key.DELETE)
type(Key.UP)
type(Key.DOWN)
type(Key.DOWN, KeyModifier.SHIFT)
type(Key.DOWN, KeyModifier.SHIFT)
type(Key.F4)
time.sleep(1)
type(Key.TAB)
type(Key.INSERT)
type(Key.TAB)
type(Key.ENTER)
time.sleep(1)
type(Key.ENTER)
wait("export_successful.png", FOREVER)
type(Key.ENTER)
type(Key.F4,KeyModifier.CTRL)
time.sleep(1)
type(Key.F4,KeyModifier.CTRL)
def fPrint_AgedInv(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print AgedInv")
# name report file: ex: PreBill-03
reportName = myTools.buildRepName("AgedInv",pRepExt)
logging.debug('Print_AgedInv: ' + reportName)
# make sure timeslips has focus
myTools.getFocus()
logging.debug('- open AgedInv')
type("r",KeyModifier.ALT)
type("c")
time.sleep(1)
myTools.pressDOWN(2)
time.sleep(1)
logging.debug('- set up report')
type("o",KeyModifier.CTRL)
# Options
myTools.pressSHIFTTAB(4)
type(Key.SPACE)
time.sleep(1)
# Default
myTools.pressSHIFTTAB(4)
type(Key.SPACE)
time.sleep(1)
# Due values
myTools.pressSHIFTTAB(4)
type("d")
time.sleep(1)
# OK
type(Key.ENTER)
time.sleep(1)
# choose csv
myTools.pressTAB(2)
type("c")
time.sleep(1)
# print the report
type(Key.ENTER)
time.sleep(1)
myTools.finishReport(reportName)
def fPrint_FirmAssTot(pReportMonth,pRepExt):
#---------------------------------------------------#
myTools.sectionStartTimeStamp("print FirmAssTot")
# name report file: ex: PreBill-03
reportName = myTools.buildRepName("FirmAssTot",pRepExt)
logging.debug('Print_FirmAssTot: ' + reportName)
# make sure timeslips has focus
myTools.getFocus()
logging.debug('- open FirmAssTot')
type("r",KeyModifier.ALT)
type("b")
time.sleep(1)
type("f")
myTools.pressDOWN(1)
time.sleep(1)
logging.debug('- set up report')
type("o",KeyModifier.CTRL)
# Options
myTools.pressSHIFTTAB(4)
type(Key.SPACE)
time.sleep(1)
# Default
myTools.pressSHIFTTAB(4)
type(Key.SPACE)
time.sleep(1)
# OK
myTools.pressTAB(1)
type(Key.SPACE)
time.sleep(1)
# choose text
myTools.pressTAB(2)
type("t")
time.sleep(1)
myTools.enterSlipFilter(pReportMonth,"n")
# print the report
type(Key.ENTER)
time.sleep(1)
myTools.finishReport(reportName)
def Edit_DefaultClient():
# - - - - - - - - - - - - - - - - - - - - - - - - - #
logging.debug(' ')
logging.debug('Edit_DefaultClient')
# make sure timeslips has focus
myTools.getFocus()
# open client list
type("i",KeyModifier.CTRL)
time.sleep(1)
# open template client
type(Key.F6)
type(Key.ENTER)
time.sleep(1)
# switch to Funds Accounts page
myTools.pressSHIFTF6(3)
time.sleep(1)
# switch to Account list
myTools.pressTAB(3)
myTools.pressDOWN(1)
time.sleep(1)
type(Key.ENTER)
time.sleep(1)
# enter 25 for "balance falls below" and "replenishment"
if int(Settings.tsVersion) > 2014:
myTools.pressTAB(3)
else:
myTools.pressTAB(4)
time.sleep(1)
type("25")
myTools.pressTAB(1)
type("25")
myTools.pressTAB(2)
type(Key.SPACE)
type(Key.ENTER)
time.sleep(1)
type("s",KeyModifier.CTRL)
time.sleep(1)
type(Key.F4,KeyModifier.CTRL)
time.sleep(1)
type(Key.F4,KeyModifier.CTRL)
