def fBill_BillFields(): #---------------------------------------------------# myTools.sectionStartTimeStamp("bill fields") logging.debug("fBill_BillFields") buName = Settings.tsVersion + "-bill-12b" backup_Data.fRestore_Backup(buName) reportName = "BillFields-13-" + Settings.tsVersion + ".txt" myTools.getFocus() # make sure timeslips has focus if int(Settings.tsVersion) < 2016: # to get around a defect in pre-2016 type("i",KeyModifier.CTRL) # open client info and close it to load custom fields time.sleep(1) type("o",KeyModifier.CTRL) time.sleep(1) type(Key.F4,KeyModifier.CTRL) time.sleep(1) type(Key.F4,KeyModifier.CTRL) bill_ImportLayout.fImport_BillLayout("Fields") # import the layout fSet_BillDate(12) # set billing data to 12/27 for text bills fPrint_BillsToText(reportName) # print all bills to one text file reports_Compare.Compare_OneReport(reportName) myTools.sectionEndTimeStamp()
def fFundsAccouts_Setup(): # - - - - - - - - - - - - - - - - - - - - - - - - - # myTools.sectionStartTimeStamp("funds account") logging.debug('FundsAccount_Setup') # make sure timeslips has focus myTools.getFocus() # switch date to 1/27/13 fSet_BillDate(1) fBankAccount_Create() # open client list type("i",KeyModifier.CTRL) time.sleep(1) clientList = ["Hadley","Halifax"] count = 0 for oneCli in clientList: count += 1 fFundsAccount_Create(oneCli,count) type(Key.F4,KeyModifier.CTRL) myTools.sectionEndTimeStamp()
def fBill_BillFields(): #---------------------------------------------------# myTools.sectionStartTimeStamp("bill fields") logging.debug("fBill_BillFields") reportName = myTools.monthToName(13,"-BillFields-",".txt") myTools.getFocus() # make sure timeslips has focus bill_ImportLayout.fImport_BillLayout("Fields") # import the layout fSet_BillDate(12) # set billing data to 12/27 for text bills fPrint_BillsToText(reportName) # print all bills to one text file reports_Compare.Compare_OneReport(reportName) myTools.sectionEndTimeStamp()
def create_Layouts(): #---------------------------------------------------# myTools.sectionStartTimeStamp("create layouts") logging.debug('create_Layouts') myTools.getFocus() fSet_BillDate(1) # set bill date to prep delete of dates from layout report_UDSlip.fCreate_SlipListDetailed() report_UDSlip.fCreate_SlipFields() report_UDSlip.fCreate_SlipListCalc() report_UDClient.fCreate_ClientListHistory() report_UDClient.fCreate_ClientListValues() report_UDInvoice.fCreate_InvoiceListFields() report_UDInvoice.fSort_InvoiceListFields() report_UDFunds.fCreate_FundsListFields() report_UDFunds.fSort_FundsListFields() report_Statement.fImport_Statement() report_FirmAssTot.fSetup_FirmAssTot() report_PBWorksheet.fSetup_PreBill() report_TkCollections.fSetup_TkCollections() report_AgedARBalDate.fSetup_AgedARBalDate() report_ARwRunBal.fSetup_ARwRunBal() report_FundsWRunBal.fSetup_FundsWRunBal() report_InvoiceListing.fSetup_InvoiceListing() myTools.sectionEndTimeStamp() bill_Setup.fSetup_BillReport() bill_ImportLayout.fImport_BillLayout("Bill with Taxes") backup_Data.fBackup_BillData(0,"a") # backup before first bill
def fReview_Arrangements(): #===================================================# logging.debug(' ') logging.debug('Review_Arrangements') fLogHeader() # make sure timeslips has focus myTools.getFocus() # set billing data to 12/27 for ba bills fSet_BillDate(12) ba_AdjustTotal_Time.fAdjustTotal_Time() ba_AdjustTotal_Exp.fAdjustTotal_Exp() ba_AdjustTotal_Both.fAdjustTotal_Both() ba_AdjustTimekeeper_Time.fAdjustTimekeeper_Time() ba_AdjustTimekeeper_Exp.fAdjustTimekeeper_Exp() ba_AdjustTimekeeper_Both.fAdjustTimekeeper_Both() ba_AdjustTask.fAdjustTask() ba_AdjustExpense.fAdjustExpense() ba_Absolute_Time.fAbsolute_Time() ba_Absolute_Exp.fAbsolute_Exp() ba_Absolute_Both.fAbsolute_Both() ba_Absolute_NoSlips.fAbsolute_NoSlips() ba_Minimum_Time.fMinimum_Time() ba_Minimum_Exp.fMinimum_Exp() ba_Minimum_Both.fMinimum_Both() ba_Maximum_Time.fMaximum_Time() ba_Maximum_Exp.fMaximum_Exp() ba_Maximum_Both.fMaximum_Both() ba_FlatFeePlus_Time.fFlatFeePlus_Time() ba_FlatFeePlus_Exp.fFlatFeePlus_Exp() ba_FlatFeePlus_Both.fFlatFeePlus_Both() ba_Contingency_Time.fContingency_Time() ba_Contingency_Exp.fContingency_Exp() ba_Contingency_Both.fContingency_Both() ba_MinimumHours.fMinimumHours() ba_Percent.fPercent() ba_ProgressTotal.fProgressTotal() ba_ProgressActivity.fProgressActivity() ba_InterimTotal.fInterimTotal() ba_InterimActivity.fInterimActivity() ba_SlipsRoundMin.fSlipsRoundMin() ba_SlipsRoundDol.fSlipsRoundDol() ba_Precision.fPrecision() ba_Replacement_Time.fReplaceTimeA() ba_Replacement_Time.fReplaceTimeB() ba_Replacement_Time.fReplaceTimeC() ba_Replacement_Expense.fReplaceExpenseA() backup_Data.fBackup_Checkpoint("after-ba") reports_PostBill.fPrint_PostbillReports(13,"a")
def fPrint_PostbillReports(pMonth,pAorB): #---------------------------------------------------# # print various reports to check db values and calculations fSet_BillDate(pMonth) Settings.PartOfRepName = myTools.padZero(pMonth) + pAorB + "-" + Settings.tsVersion csvExt = ".csv" txtExt = ".txt" if (pMonth == 13) or (pMonth == 1): logging.debug('!!! SKIP FEE ALLOCATION PERIOD REPORT') else: report_FeeAllocPer.fPrint_FeeAllocPer(pMonth,csvExt) report_ARwRunBal.fPrint_ARwRunBal(pMonth,txtExt) report_FundsWRunBal.fPrint_FundsWRunBal(pMonth,txtExt) report_ARHistory.fPrint_ARHistory(pMonth,csvExt) report_InvoiceListing.fPrint_InvoiceListing(pMonth,txtExt) """ report_AvailableWIP.fPrint_AvailableWIP(pMonth,csvExt) report_MissingTime.fPrint_MissingTime(pMonth,csvExt,pAorB) report_ClientsNotBilled.Print_ClientsNotBilled(pMonth,csvExt) report_FirmAssList.fPrint_FirmAssList(pMonth,csvExt) report_PayPerf.fPrint_PayPerf(pMonth,csvExt) report_AgedARBal.Print_ARAgedBal(pMonth,csvExt) report_AgedARBalDate.Print_ARAgedBalDate(pMonth,csvExt) report_AgedClient.fPrint_AgedClient(pMonth,csvExt) report_AgedInv.fPrint_AgedInv(pMonth,csvExt) report_ARwRunBal.fPrint_ARwRunBal(pMonth,txtExt) report_ARHistory.fPrint_ARHistory(pMonth,csvExt) report_UDSlip.fPrint_SlipListDetailed(pMonth,csvExt) report_UDSlip.fPrint_SlipFields(pMonth,csvExt) report_UDSlip.fPrint_SlipListCalc(pMonth,csvExt) report_UDClient.fPrint_ClientListHistory(pMonth,csvExt) report_SlipTotalsWeekly.Print_SlipTotalsWeekly(pMonth,csvExt) report_TkHistory.Print_TkHistory(pMonth,csvExt) report_TkContribution.Print_TkContribution(pMonth,csvExt) report_TkCC.Print_TkCC(pMonth,csvExt) report_FundsBal.fPrint_FundsBal(pMonth,csvExt) report_Taxes.Print_Taxes(pMonth,csvExt) report_TOWorksheet.Print_Worksheet(pMonth,csvExt) report_PBWorksheet.fPrint_PreBill(pMonth,txtExt) email_Send.fSend_Text("rep-half " + str(pMonth) + pAorB) report_SlipListing.fPrint_SlipListing(pMonth,csvExt) report_BillStage.fPrint_BillStage(pMonth,csvExt) report_FirmAssTot.fPrint_FirmAssTot(pMonth,txtExt) report_ProdPeriod.print_ProdPeriod(pMonth,csvExt) report_ProfPeriod.print_ProfPeriod(pMonth,csvExt) report_Markup.print_Markup(pMonth,csvExt) report_SlipSummary.print_SlipSummary(pMonth,csvExt) report_Statement.fPrint_Statement(pMonth,txtExt) # report_Budgets.printCliBudget(pMonth,csvExt) # report_Budgets.printTkBudget(pMonth,csvExt) # report_Budgets.printFirmBudget(pMonth,csvExt) report_UDInvoice.fPrint_InvoiceListFields(pMonth,csvExt) report_InvoiceListing.fPrint_InvoiceListing(pMonth,txtExt) report_GLXfer.Print_GLXfer(pMonth,csvExt) if (pMonth == 13): # skip some reports for ba clients logging.debug('') logging.debug('!!! SKIP UD FUNDS REPORT') logging.debug('!!! SKIP HOLD REPORT') logging.debug('!!! SKIP SPLIT BILL DIST') logging.debug('!!! SKIP FUNDS w/RUNNING BAL') logging.debug('!!! SKIP FUNDS LIST') else: report_UDFunds.fPrint_FundsListFields(pMonth,csvExt) report_Hold.Print_Hold(pMonth,csvExt) report_SplitBill.fPrint_SplitBill(pMonth,csvExt) report_FundsWRunBal.fPrint_FundsWRunBal(pMonth,txtExt) report_FundsList.fPrint_FundsList(pMonth,csvExt) if (pMonth == 13) or ((pMonth == 1) and (pAorB == "a")): # fee allocation cannot be run without some payments entered logging.debug('') logging.debug('!!! SKIP COLLECTIONS REPORT') logging.debug('!!! SKIP FEE ALLOCATION REPORT') logging.debug('!!! SKIP PAYMENT DISTR REPORT') logging.debug('!!! SKIP AGED WIP REPORT') else: report_TkCollections.Print_TkCollections(pMonth,txtExt) report_FeeAlloc.Print_FeeAlloc(pMonth,csvExt) report_PayDistr.Print_PayDistr(pMonth,csvExt) report_AgedWIP.fPrint_AgedWIP(pMonth,csvExt) # report_UDClient.fPrint_ClientListValues(pMonth,csvExt) # report_DaysToPay.print_DaysToPay(pMonth,csvExt) # email_Send.fSend_Email("rep " + str(pMonth) + pAorB) """ email_Send.fSend_Text("rep-all " + str(pMonth) + pAorB)