def fLink_Accounts_Refund(): #---------------------------------------------------# myTools.pressDOWN(1) # Refund comp myTools.pressTAB(1) type("Refund") myTools.pressSHIFTTAB(1)
def fChoose_CSV_Print(pReportName): #---------------------------------------------------# logging.debug('- fChoose_CSV_Print') # 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; press ENTER type(Settings.repFolder + "\\" + pReportName) time.sleep(1) # export titles myTools.pressTAB(2) time.sleep(1) type(Key.SPACE) time.sleep(1) # OK type(Key.ENTER)
def fPrint_InvoiceListing(pReportMonth, pRepExt): # ---------------------------------------------------# myTools.sectionStartTimeStamp("print invoicelist") # name report file: ex: UDSlip1-03 reportName = myTools.buildRepName("InvList", pRepExt) logging.debug("Print_InvoiceList: " + reportName) myTools.getFocus() logging.debug("- open report list") type("r", KeyModifier.ALT) type("a") time.sleep(1) logging.debug("- choose report") type("i") time.sleep(1) # choose txt myTools.pressSHIFTTAB(2) time.sleep(1) type("t") time.sleep(1) myTools.enterYearToDateOnList(pReportMonth) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
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 setupReport(): #---------------------------------------------------# # open report 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) # close dialog myTools.pressTAB(1) 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) # print the report type(Key.ENTER) time.sleep(1)
def fImport_DefaultLayout(): #---------------------------------------------------# fImport_Layout("Low Detail") logging.debug('- assign layout') type("a",KeyModifier.ALT) time.sleep(1) # shift tab to open/templates control myTools.pressSHIFTTAB(1) time.sleep(1) # press RIGHT to Template Clients myTools.pressRIGHT(1) time.sleep(1) # press TAB to client list myTools.pressTAB(1) time.sleep(1) #press F4 to mark template type(Key.F4) time.sleep(1) # assign type("a",KeyModifier.ALT) type(Key.ENTER) time.sleep(1) # confirm and close type(Key.ENTER) time.sleep(1) type(Key.F4,KeyModifier.CTRL) 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 fLink_Accounts_Allowances(): #---------------------------------------------------# myTools.pressDOWN(1) # allowances comp myTools.pressTAB(1) type("Allowances") myTools.pressSHIFTTAB(1)
def fPrint_BABill(pBAClient, pBillNum): # ---------------------------------------------------# """ backs up the database ("-before") prints the bill to text file approves the bill backs up the database ("-after") """ baBillName = pBAClient + str(pBillNum) backup_Data.fBackup_Checkpoint(baBillName + "-before") myTools.sectionStartTimeStamp("ba bill") logging.debug("BA_Bill: " + baBillName) type("b", KeyModifier.CTRL) time.sleep(1) click("remove_filters.png") time.sleep(1) type(Key.ENTER) type(Key.DOWN) type(Key.TAB) type(Key.SPACE) type(pBAClient) time.sleep(1) type(Key.F4) type(Key.ENTER) myTools.pressSHIFTTAB(3) type("t") type(Key.ENTER) time.sleep(1) type(Settings.repFolder + "\\" + baBillName + ".txt") # for checkmark in findAll("checkmark.png"): # click(checkmark) time.sleep(1) type(Key.ENTER) time.sleep(1) if exists("replace_msg.png"): type(Key.ENTER) time.sleep(1) wait("approve_bill.png", FOREVER) click("approve_bill.png") type(Key.ENTER) time.sleep(1) if exists("select_report_to_print.png"): type(Key.ESC) type(Key.F4, KeyModifier.CTRL) time.sleep(1) type("n") myTools.sectionEndTimeStamp() backup_Data.fBackup_Checkpoint(baBillName + "-after")
def fPrint_BillsToText(pReportName): #---------------------------------------------------# logging.debug("- print bills to text") type("b",KeyModifier.CTRL) time.sleep(1) myTools.pressSHIFTTAB(3) # get to Print To time.sleep(1) type("t") # ensure Text File is selected time.sleep(1) # print bills to text logging.debug('-- print button') type(Key.ENTER) logging.debug('Printing: ' + pReportName) # fill in path and name; press ENTER type(Settings.repFolder + "\\" + pReportName) time.sleep(1) type(Key.ENTER) if exists("replace_it-1.png"): type(Key.ENTER) time.sleep(1) fWait_ForBills() fClose_ReportEntry()
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 fLink_Accounts_Interest(): #---------------------------------------------------# myTools.pressDOWN(3) # Interest comp myTools.pressTAB(1) type("Interest") myTools.pressSHIFTTAB(1)
def fLink_Accounts_WO(): #---------------------------------------------------# myTools.pressDOWN(1) # WO comp myTools.pressTAB(1) type("WriteOff") myTools.pressSHIFTTAB(1)
def fPrint_FlatFee(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print FlatFee") # name report file: ex: ARAgedBal-03 reportName = myTools.buildRepName("FlatFee",pRepExt) logging.debug('Print_FlatFee: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("c") time.sleep(1) type("f") 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 fLink_Accounts_Suspense(): #---------------------------------------------------# myTools.pressDOWN(1) # suspense comp myTools.pressTAB(1) type("Suspense") myTools.pressSHIFTTAB(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 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_ProgBilling(): #---------------------------------------------------# myTools.pressDOWN(1) # progbill comp myTools.pressTAB(1) type("ProgBilling-Comp") myTools.pressSHIFTTAB(1) time.sleep(1)
def fLink_Accounts_ClientEscrow(): #---------------------------------------------------# myTools.pressDOWN(3) # clientescrow comp myTools.pressTAB(1) type("ClientEscrow-Comp") myTools.pressSHIFTTAB(1) time.sleep(1)
def fSetup_PayDist(): # ---------------------------------------------------# myTools.sectionStartTimeStamp("setup pay dist") logging.debug("- set up pay dist") myTools.getFocus() # open client list type("i", KeyModifier.CTRL) time.sleep(2) # open Nahant type("n") type(Key.ENTER) time.sleep(1) # get to payment distribution fields if Settings.tsVersion > "2014": myTools.pressF6(8) time.sleep(1) myTools.pressTAB(6) time.sleep(1) else: myTools.pressF6(5) time.sleep(1) myTools.pressSHIFTTAB(7) time.sleep(1) # First Pay = Newest type("n") time.sleep(1) # Order = Costs/Fees/Int myTools.pressTAB(1) type("c") time.sleep(1) # First Pay = Charge Type myTools.pressTAB(1) type("c") time.sleep(1) # save type("s", KeyModifier.CTRL) time.sleep(1) fExport_ClientSettings() type(Key.F4, KeyModifier.CTRL) time.sleep(1) type(Key.F4, KeyModifier.CTRL) myTools.sectionEndTimeStamp()
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 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 Print_FeeAlloc(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print fee alloc") # name report file: ex: FeeAlloc-03 reportName = myTools.buildRepName("FeeAlloc",pRepExt) logging.debug('Print_FeeAlloc: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report') type("r",KeyModifier.ALT) type("t") time.sleep(2) type("fee") 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) # close dialog myTools.pressTAB(1) 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) # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def fCreate_OneFinanceCharge(pClient,pCliNum,pMonth,pAmount): #---------------------------------------------------# logging.debug('- Create_OneFinance: ' + str(pMonth) + "-" + pClient + " = " + str(pAmount)) time.sleep(1) # choose client type(pClient) time.sleep(1) type(Key.ENTER) time.sleep(1) # switch page if Settings.tsVersion > "2014": myTools.pressF6(7) else: myTools.pressF6(4) time.sleep(1) # go to field if Settings.tsVersion > "2014": myTools.pressSHIFTTAB(4) else: myTools.pressSHIFTTAB(3) time.sleep(1) # set "next bill" type("ne") time.sleep(1) myTools.pressTAB(1) time.sleep(1) # enter finance charge type(pAmount) time.sleep(1) myTools.pressTAB(1) # description type("a",KeyModifier.CTRL) financeText = "Finance charge for: " + pClient + ": Month: " + str(pMonth) time.sleep(1) type(financeText) time.sleep(1) # save type("s",KeyModifier.CTRL) time.sleep(1) # close client info type(Key.F4,KeyModifier.CTRL) time.sleep(1)
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_PreBill_1(pReportMonth,pRepExt): #---------------------------------------------------# """ print pre-bill 1 - use myTools.enterSlipFilter for slip filter thru current month - default sorts - default options """ myTools.sectionStartTimeStamp("print PreBill 1") # name report file: ex: PreBill-03 reportName = myTools.buildRepName("PreBill",pRepExt) logging.debug('Print_PreBill: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open worksheet') type("b",KeyModifier.ALT) type("p") time.sleep(1) logging.debug('- set up worksheet') # 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 print_ProdPeriod(pReportMonth,pRepExt): #---------------------------------------------------# myTools.sectionStartTimeStamp("print ProdPer") # name report file: ex: ProdPer-03 reportName = myTools.buildRepName("ProdPer",pRepExt) logging.debug('Print_ProdPeriod: ' + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug('- open report list') type("r",KeyModifier.ALT) type("s") time.sleep(1) logging.debug('- set up report') type("prod") time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) # 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 CSV myTools.pressTAB(2) type("c") time.sleep(1) myTools.enterSlipFilter(pReportMonth,"y") # print the report type(Key.ENTER) time.sleep(1) myTools.finishReport(reportName)
def print_DaysToPay(pReportMonth, pRepExt): # ---------------------------------------------------# myTools.sectionStartTimeStamp("print daystopay") # name report file: ex: DaysToPay-03 reportName = myTools.buildRepName("DaysToPay", pRepExt) logging.debug("Print_DaysToPay: " + reportName) # make sure timeslips has focus myTools.getFocus() logging.debug("- open report") type("r", KeyModifier.ALT) type("a") time.sleep(2) type("d") 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) # close dialog myTools.pressTAB(1) 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) # 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)