ئhGoveC 8g.TEditg .TComboBoxɵg .TRadioButtongTCustomEdit.SetReadOnly$<>gTCustomComboBox.ClearlgTCustomComboBox.SetItemIndexRlcdToolWinZkcdRXSplit f TRxSplitterf`g .TRxSplitterqOLcdExtCtrlsZkfTPanelERfTTimerg.TPanel.=g.TTimerwtvgTTimer.SetEnabledNcdMenusZkf TMainMenuIɷf TMenuItemg .TMainMenug .TMenuItem}gTMenuItem.SetVisible橔gTMenuItem.SetEnabledߩcdRXDBCtrl f TRxDBGridWg .TRxDBGridygTRxDBGrid.GetSelCountlgTRxDBGrid.GotoSelectiongTRxDBGrid.SelectAllgTRxDBGrid.UnselectAllcdDBGridsZkfTColumn*gTDBGridColumns.GetColumngTColumn.SetVisiblegTCustomDBGrid.GetDataSource9.FcdGridsZkcdComCtrlsZkf TTreeViewf TPageControl^f TTabSheetvTfTDateTimePicker3wf TTreeNodeMg .TTreeViewJg .TPageControlnGg .TTabSheetr+g.TDateTimePicker`gTPageControl.SetActivePage!j-gTCustomForm.GetClientRectBj-gTCustomForm.GetFloatingDj-gTCustomForm.LoadedEj-gTCustomForm.NotificationFj-gTCustomForm.PaintWindowHj-gTCustomForm.QueryInterfaceJj-gTCustomForm.ReadStateKj-gTCustomForm.SetParentBiDiModeNj-gTCustomForm.SetParentPj-gTCustomForm.UpdateActionsQj-gTCustomForm.ValidateRenameSj-gTCustomForm.WndProcUj-gTCustomForm.Createj-gTCustomForm.CreateNewj-gTCustomForm.Destroyj-gTCustomForm.AfterConstructionj-gTCustomForm.BeforeDestructionj-gTCustomForm.CloseQueryj-gTCustomForm.DefaultHandlerj-gTCustomForm.SetFocusj-gTCustomForm.SetFocusedControlj-gTCustomForm.ShowModalj-gTCustomForm.WantChildKeyj-g%TScrollingWinControl.AdjustClientRecthg&TScrollingWinControl.AutoScrollEnabledhgTCustomForm.Closej-g Application2gTApplication.ProcessMessages~NgTCustomForm.Hidej-gScreenf TShiftState࣫gTComponent.UpdateRegistry2gTComponent.WriteState2gTComponent.SafeCallException+2gTPersistent.Assign0g .TStringList<*fTStringsRg+f.1gssCtrlcdSysUtilsZkgExtractFilePath~ gStrToIntgTwoDigitYearCenturyWindow gIntToStrJ 7gDateN g FloatToStrFǜf TFloatFormat5XgffFixedAgTrim~ g EncodeDateg FileQueryڟ8ceFmxUtilsXg ExecuteFileW$ce DubiousTests gDubiousErrorTestptaceDCEdit g DCEditForm/Q, mnuHelpAboutBa,qTransactionsFromDateq,qTransactionsToDate,mnuFileCloseTabB, TabCompletedL,PanelCompleted<,DBNavCompleted(,RxDBGridCompletedPayableD,qCompletedPayable ,dsCompletedPayable, lblTestData2 ,mnuToolsSelectMainDatabaseItemB ,mnuToolsSelectTestDatabaseItemB! ,RxDBGridMultiManualD1 ,MuliManualDualListDialogA , qMultiManual Q , dsMultiManuala ,qMultiManualServiceIDq ,qMultiManualRent ,qMultiManualCall ,qMultiManualOther ,qMultiManualGSTAmt ,PanelDCExpense< , rbDCExpense8 , rbDCRevenue8 ,qMultiManualBatchTypeID ,navMultiManual(!,qMultiManualID!,mnuViewRefreshItemB!!, uqMultiManual1!,qLastBatchBatchA!,qLastBatchPeriodQ!,qLastBatchAccountNoa!,qLastBatchInvoiceq!,qLastBatchTotalPayable!,qLastBatchOpeningBalance!,qLastBatchPaymentsReceived!,qLastBatchTotalAdjustments!,qLastBatchGSTAmount!,qLastBatchGSTAdjustment!,qMultiManualFromDate!,qMultiManualToDate!,qMultiManualRateDescription",edtPaymentsReceived4",qCompletedPayableBatchID!",qCompletedPayablePayableDate1",!qCompletedPayablePlatinumFileNameA",qCompletedPayableReleasedQ",qCompletedPayableSupplierNamea",qCompletedPayableCentreq",qCompletedPayableActivity",qCompletedPayableElement",qCompletedPayableSubledger", qCompletedPayablePayableDetailID",qCompletedPayablePayableID",qCompletedPayablePeriod",qCompletedPayableAmountExGST",qCompletedPayableGSTAmount",qCompletedPayableAmountIncGST#,TabCompletedDetailL#,PanelCompletedDetail ORDER BY tBatch.id DESCUSVW3ۉ]MU3Uhd0d ESVW؅~UUEEE3ZYYdhE_^[]USERNAMEU3QQQQQQSV3Uhrd0d E;u;uYM,U,,v;uLMU ;uLMU;un \ `M4U44Rt;uLtMU|;|  $    MU(M(U싃$ ;un  M U; M8U3Ћ0;0(83ҋ0MTU苃@EЋЋ00xGt8t UDUDD3ҋ80MlU苃@EЋЋ00xGt8t U U  U苃@EЋQ;uGM U  ֋3ZYYdhyEE^[] BatchSummary CompletedCompletedDetail CESummary AdjustmentDubiousDubiousResolution AdminSummaryReleaseTransactnsDCTransactionsDCTransactionsAuto RDServiceIDS؋‹;u*3;u;3ҋ3ҋ,;uL=t 3ҋ:;u*3;uS343ҋl;u*3lut;u*3tA|;u^3|(3ҋ;u*3;uS33ҋH;u*3;u530;u[30D 3ҋTThp;Tu13ҋTTTh7;u/3ҋ [SVW؋N|F3׋ЋGNu3ҋ_^[UjjIuQSVW3UhXd0d غpQ4Q4Q4Q4hhU苆uhEU싃Q4U䋆 ME캠U싃Q4U䋆( MEU싃Q4,tQ4$Q4U@@@MԺDUԍEEUU싆@Q4t3E@RH|=@EEM싆@U8W EUuEEEMu΋U@3ZYYdh_EEEEE_^[]dbPPdata&SELECT tBatch.id, tBatch.BatchStatusID FROM (tBatch;LEFT JOIN tBatchType ON tBatch.BatchTypeID = tBatchType.ID)MLEFT JOIN tDataSourceType ON tBatchType.DataSourceTypeID = tDataSourceType.ID!WHERE tBatch.BillingPeriod LIKE ''AND tBatch.BatchStatusID > AND tBatch.BatchStatusID < 1AND tDataSourceType.DataSource LIKE '%Automatic%'ORDER BY tBatch.ID DESCidUjjIuQSVډE3Uhod0d EEEQ4EQ4EQ4UME UEQ4EEtEeE EEUEME(EMME4EK|!C3E@$@(UtFKuEH;E@MԋUEEu*UEUQXEUEuE03YE0MԋUEUԍEEPE0@ZQ E}EE3ZYYdhvEEE^[]dbPPdataSELECT tBatchType.* FROM tBatch;INNER JOIN tBatchType ON tBatch.BatchTypeID = tBatchType.IDWHERE tBatch.ID = 0Var DescriptionU3QQQQQQQSV3Uhd0d l:M캨4EU}jf fuOU,tW,,.llllDtbU苃@EPUUXu;DD t  3ZYYdhEEE^[]BatchID;All Critical errors resolved. Process these transactions?UQjjIuMSVWً3Uh d0d UR@E , Q4@ Q4 Q4Q4\Q4tQ4Q4hUuh0EUQ4DQ4 Eh|Q4Q44Q4pQ4Q4 Q4PQ4hUuhEUQ4Q4Q4( E(Q4<Q4Q4Q4,Q4|Q4Q4Q4DQ4\Q4Q4Q4 Q4LQ4Q4hUuhEUQ4Q4 E Q44Q4Q4Q4DQ4Q4@Q4Q4(Q4Q4Q4Q4Q4 Q4`Q4Q4 ,RTUME0UQ4hXU0 uhU싆@ uhEUQ4Q4Q4Q4xQ4Q4HQ4Q4Q4(Q4[EDUXQ4Q4 Q4t Q4 Q44!Q4!Q4("Q4"Q4(#Q4#Q4#Q4$Q4($Q4$Q4$Q4%Q4`%Q4%Q4%Q4,&Q4x&Q4&Q4'Q4<'Q4|'Q4'Q4(Q4E (N<(Q4(Q4(Q44)Q4)Q4*Q4x*Q4*Q4\+Q4+Q4Q4,Q4`Q4Q4Mܺ ,EUME0UQ4U0 ME@,UQ4Q4d,Q4,Q4Q4,Q4E--Q4`-Q4-Q4-Q4l.Q4.Q4PQ4hUuhEUQ4.Q4/Q4E0/H/Q4`/Q4/Q4 0Q4(0Q4|0Q40Q4L1Q41Q4 2Q4p2Q42Q42Q43Q4t3Q4Q43Q44Q4h4Q4h4U@uh4h4EUQ45Q4L5Q4Q45Q45Q4<6Q4`%Q4%Q4x&Q46Q46Q4 7Q4E@7\7Q4p7Q47Q4 8Q4p8Q48Q49Q4`9Q49Q49Q49Q43Q44Q4h4Q4h4U@uh<:EUQ4(Q4EP:h:Q4:Q4 ;Q4;Q4;Q4`<Q4<Q4*Q4x*Q4*Q4\+Q4<Q4Q4,Q4`Q4Q4,tW,t u?Mܺ ,EUME<UQ42h=UuhEUQ4U$ ME,=UQ4U4 MEP=UQ4Q4t=Q4=Q40>Q4p>Q4>Q4>Q4|?Q43ZYYdh EEEE_^[] batchsummary SELECT BH.*aFROM (SELECT tBatch.ID AS BatchID, tBatchStatus.Description AS BatchStatus, tBatch.BatchStatusID,^ tBatchType.Description AS BatchType, (tBatch.TotalPayable - tBatch.GSTAmount) AS AmountExGST,? tBatch.GSTAmount, tBatch.TotalPayable, tBatch.TotalAdjustments FROM (tBatch;LEFT JOIN tBatchType ON tBatch.BatchTypeID = tBatchType.ID)@LEFT JOIN tBatchStatus ON tBatch.BatchStatusID = tBatchStatus.ID!WHERE tBatch.BillingPeriod LIKE '') AS BHORDER BY BH.BatchID DESC cesummaryDSELECT tDataCollection.BatchID, tBatchType.Description AS BatchType,\ Sum(tDataCollection.AmountExGST) AS TotalExGST, Sum(tDataCollection.GSTAmount) AS TotalGST,2 Sum(tDataCollection.AmountIncGST) AS TotalIncGST,q Sum(CASE WHEN tDataCollection.StatusID IS NOT NULL THEN tDataCollection.AmountExGST ELSE 0 END) AS CriticalValueFROM (tDataCollection8LEFT JOIN tBatch ON tDataCollection.BatchID = tBatch.ID):LEFT JOIN tBatchType ON tBatch.BatchTypeID = tBatchType.ID'8GROUP BY tDataCollection.BatchID, tBatchType.Description%ORDER BY tDataCollection.BatchID DESC completed SELECT C.*ZFROM (SELECT P.BatchID, P.PayableDate, LEFT(P.PlatinumFileName, 20) AS "PlatinumFileName",C (CASE P.ReleasedFlag WHEN 1 THEN 'Yes' ELSE '' END) AS "Released",7 tSupplier.SupplierName, tCentre.Description AS Centre,D tActivity.Description AS Activity, tElement.ElementCode AS Element,A tSubledger.Description AS Subledger, PD.ID AS "PayableDetailID",7 PD.PayableID, PD.Period, PD.AmountExGST, PD.GSTAmount,2 (PD.AmountExGST + PD.GSTAmount) AS "AmountIncGST"FROM tPayable P3INNER JOIN tPayableDetail PD ON P.ID = PD.PayableID3INNER JOIN tSupplier ON P.SupplierID = tSupplier.ID.INNER JOIN tCentre ON PD.CentreID = tCentre.ID4INNER JOIN tActivity ON PD.ActivityID = tActivity.ID1INNER JOIN tElement ON PD.ElementID = tElement.ID=INNER JOIN tSubledger ON PD.SubledgerID = tSubledger.ID) AS CWHERE C.Period LIKE 'ORDER BY C.BatchID DESCdubious SELECT DR.*kFROM (SELECT TN.*, tDubiousResult.DubiousTypeID, tDubiousResult.ID AS DID, tServiceID.ServiceID AS Service,3 tServiceID.PreviousRent, tServiceID.PreviousCalls,W tDubiousType.Description AS DubiousError, tDubiousResolution.Description AS ResolutionFROM ((((SELECT tTransaction.BatchID, tTransaction.ServiceID, tBatch.BatchTypeID, COUNT(tTransaction.ServiceID) AS RecordCount,h Sum(CASE tTransactionGroup.Description WHEN 'RENT' THEN tTransaction.AmountExGST ELSE 0 END) AS "Rent",i Sum(CASE tTransactionGroup.Description WHEN 'CALL' THEN tTransaction.AmountExGST ELSE 0 END) AS "Calls",j Sum(CASE tTransactionGroup.Description WHEN 'OTHER' THEN tTransaction.AmountExGST ELSE 0 END) AS "Other",o Sum(CASE tTransactionGroup.Description WHEN 'ADMIN' THEN 0 ELSE tTransaction.AmountExGST END) AS "TotalExGST",k Sum(CASE tTransactionGroup.Description WHEN 'ADMIN' THEN 0 ELSE tTransaction.GSTAmount END) AS "TotalGST",q Sum(CASE tTransactionGroup.Description WHEN 'ADMIN' THEN 0 ELSE tTransaction.AmountIncGST END) AS "TotalIncGST",i Sum(CASE tTransactionGroup.Description WHEN 'ADMIN' THEN tTransaction.AmountExGST ELSE 0 END) AS "Admin"FROM ((tTransaction5LEFT JOIN tBatch ON tTransaction.BatchID = tBatch.ID)SLEFT JOIN tTransactionType ON tTransaction.TransactionTypeID = tTransactionType.ID)YLEFT JOIN tTransactionGroup ON tTransactionType.TransactionGroupID = tTransactionGroup.IDBatchIDWHERE tTransaction.BatchID = AND (tBatch.BatchStatusID >  AND tBatch.BatchStatusID < )2AND tTransactionType.Description NOT LIKE '%Lost%'!AND tTransaction.StatusID IS NULLPGROUP BY tTransaction.BatchID, tBatch.BatchTypeID, tTransaction.ServiceID) AS TNsINNER JOIN tDubiousResult ON ((TN.BatchID = tDubiousResult.BatchID) AND (TN.ServiceID = tDubiousResult.ServiceID)))ILEFT JOIN tDubiousType ON tDubiousResult.DubiousTypeID = tDubiousType.ID)TLEFT JOIN tDubiousResolution ON tDubiousResult.ResolutionID = tDubiousResolution.ID)4LEFT JOIN tServiceID ON TN.ServiceID = tServiceID.ID5WHERE tDubiousResult.DubiousTypeID IS NOT NULL) AS DRORDER BY ServiceID rdserviceidRSELECT SID2.ServiceID, SID2.Code, SID2.ServiceType, SID2.Description, SID2.ShipTo,Q SID2.Customer, SID2.CustomerCentre, SID2.CustomerActivity, SID2.CustomerElement,Z SID2.CustomerSubledger, tCentre.Description AS Centre, tActivity.Description AS Activity,X tElement.ElementCode AS Element, tSubledger.Description AS Subledger, SID2.CurrentRent,Q SID2.CurrentCalls, SID2.PreviousRent, SID2.PreviousCalls, SID2.InstallationDate,c SID2.TerminationDate, SID2.UpEnd, SID2.UpMDF, SID2.DownEnd, SID2.DownMDF, SID2.Length, SID2.Person}FROM ((((SELECT SID.ServiceID, tServiceType.Code, tServiceType.Description AS ServiceType, SID.Description, tCustomer.ShipTo,r tCustomer.FullName AS Customer, tCentre.Description AS CustomerCentre, tActivity.Description AS CustomerActivity,y tElement.ElementCode AS CustomerElement, tSubledger.Description AS CustomerSubledger, SID.CurrentRent, SID.CurrentCalls,[ SID.PreviousRent, SID.PreviousCalls, SID.InstallationDate, SID.TerminationDate, SID.UpEnd,1 SID.UpMDF, SID.DownEnd, SID.DownMDF, SID.Length,> SID.CentreID, SID.ActivityID, SID.ElementID, SID.SubledgerID, tPerson.Person^FROM (((((((((tServiceID AS SID LEFT JOIN tServiceType ON SID.ServiceTypeID = tServiceType.ID)8 LEFT JOIN tCentre ON SID.CustomerCentreID = tCentre.ID)> LEFT JOIN tActivity ON SID.CustomerActivityID = tActivity.ID); LEFT JOIN tElement ON SID.CustomerElementID = tElement.ID)@ LEFT JOIN tDepartment ON tCentre.DepartmentID = tDepartment.ID)5 LEFT JOIN tGroup ON tDepartment.GroupID = tGroup.ID)6 LEFT JOIN tLocation ON SID.LocationID = tLocation.ID)A LEFT JOIN tSubledger ON SID.CustomerSubledgerID = tSubledger.ID)9 LEFT JOIN tCustomer ON tGroup.CustomerID = tCustomer.ID)8 LEFT JOIN tPerson ON SID.PersonID = tPerson.ID) AS SID21 LEFT JOIN tCentre ON SID2.CentreID = tCentre.ID)7 LEFT JOIN tActivity ON SID2.ActivityID = tActivity.ID)4 LEFT JOIN tElement ON SID2.ElementID = tElement.ID)9 LEFT JOIN tSubledger ON SID2.SubledgerID = tSubledger.IDORDER BY SID2.ServiceIDreleasetransactnsqSELECT TN.BatchID, tServiceID.ServiceID, TN.DateFrom, TN.DateTo, TN.Rent, TN.Calls, TN.Other, TN.Admin, TN.Total,-(TN.Rent + TN.Calls + TN.Other) AS "SubTotal":FROM (SELECT tTransaction.BatchID, tTransaction.ServiceID,` Min(CASE tTransactionGroup.Description WHEN 'RENT' THEN tTransaction.FromDate END) AS DateFrom,\ Max(CASE tTransactionGroup.Description WHEN 'RENT' THEN tTransaction.ToDate END) AS DateTo,f Sum(CASE tTransactionGroup.Description WHEN 'RENT' THEN tTransaction.AmountExGST ELSE 0 END) AS Rent,g Sum(CASE tTransactionGroup.Description WHEN 'CALL' THEN tTransaction.AmountExGST ELSE 0 END) AS Calls,h Sum(CASE tTransactionGroup.Description WHEN 'OTHER' THEN tTransaction.AmountExGST ELSE 0 END) AS Other,h Sum(CASE tTransactionGroup.Description WHEN 'ADMIN' THEN tTransaction.AmountExGST ELSE 0 END) AS Admin,' Sum(tTransaction.AmountExGST) AS Total5LEFT JOIN tBatch ON tTransaction.Batchid = tBatch.ID)AND tBatch.BatchStatusID = AND tTransaction.RevenueFlag = 0<GROUP BY tTransaction.BatchID, tTransaction.ServiceID) AS TNORDER BY tServiceID.ServiceID adjustment@SELECT tAdjustment.BatchID, tBatchType.Description AS BatchType,T Sum(tAdjustment.AmountExGST) AS TotalExGST, Sum(tAdjustment.GSTAmount) AS TotalGST,. Sum(tAdjustment.AmountIncGST) AS TotalIncGST,i Sum(CASE WHEN tAdjustment.StatusID IS NOT NULL THEN tAdjustment.AmountExGST ELSE 0 END) AS CriticalValueFROM (tAdjustment4LEFT JOIN tBatch ON tAdjustment.BatchID = tBatch.ID)4GROUP BY tAdjustment.BatchID, tBatchType.DescriptionORDER BY tAdjustment.BatchIDdctransactions SELECT DC3.*9FROM (SELECT DC2.*, tCriticalType.Description AS "Reason"]FROM (SELECT DC1.*, (DC1.RENT + DC1.CALL + DC1.OTHER) AS "TotalExGST", tServiceType.AdminFee, tCustomer.ShipToKFROM ((((((SELECT DC0.ServiceID, DC0.StatusID, DC0.ServiceTypeID, DC0.Code,_ Sum(CASE tTransactionGroup.Description WHEN 'RENT' THEN DC0.AmountExGST ELSE 0 END) AS "Rent",_ Sum(CASE tTransactionGroup.Description WHEN 'CALL' THEN DC0.AmountExGST ELSE 0 END) AS "Call",a Sum(CASE tTransactionGroup.Description WHEN 'OTHER' THEN DC0.AmountExGST ELSE 0 END) AS "Other",J Sum(CASE DC0.GSTAmount WHEN NULL THEN 0 ELSE DC0.GSTAmount END) AS "GST",X Sum(CASE DC0.AmountIncGST WHEN NULL THEN 0 ELSE DC0.AmountIncGST END) AS "TotalIncGST",! Min(DC0.FromDate) AS "FromDate", Max(DC0.ToDate) AS "ToDate"4FROM ((SELECT DC.*, tServiceType.ID AS ServiceTypeIDeFROM (SELECT tDataCollection.*, (CASE WHEN tDataCollection.ServiceType IS NULL THEN tServiceType.CodeF ELSE RTRIM(SUBSTRING(tDataCollection.ServiceType,1,5)) END) AS "Code"ILEFT JOIN tServiceID ON tDataCollection.ServiceID = tServiceID.ServiceID)DLEFT JOIN tServiceType ON tServiceID.ServiceTypeID = tServiceType.IDNWHERE (tDataCollection.RevenueFlag IS NULL OR tDataCollection.RevenueFlag = 0)AND tDataCollection.BatchID = ) AS DC=LEFT JOIN tServiceType ON DC.Code = tServiceType.Code) AS DC0JLEFT JOIN tTransactionType ON DC0.TransactionTypeID = tTransactionType.ID)IGROUP BY DC0.ServiceID, DC0.StatusID, DC0.ServiceTypeID, DC0.Code) AS DC1> LEFT JOIN tServiceID ON DC1.ServiceID = tServiceID.ServiceID)? LEFT JOIN tCentre ON tServiceID.CustomerCentreID = tCentre.ID)F LEFT JOIN tServiceType ON DC1.ServiceTypeID = tServiceType.ID) AS DC2C LEFT JOIN tCriticalType ON DC2.StatusID = tCriticalType.ID) AS DC3ORDER BY DC3.ServiceIDdctransactionsautoSELECT *SFROM (SELECT tDataCollection.BatchID, tDataCollection.ServiceID, tServiceType.Code,K tDataCollection.AmountExGST, tDataCollection.Var01, tDataCollection.Var02,E tDataCollection.Var03, tDataCollection.Var04, tDataCollection.Var05,E tDataCollection.Var06, tDataCollection.Var07, tDataCollection.Var08,E tDataCollection.Var09, tDataCollection.Var10, tDataCollection.Var11,E tDataCollection.Var12, tDataCollection.Var13, tDataCollection.Var14,> tDataCollection.Var15, tCriticalType.Description AS "Reason", tDataCollection.StatusIDFROM ((tDataCollectionGLEFT JOIN tCriticalType ON tDataCollection.StatusID = tCriticalType.ID)) AS DCA adminsummary SELECT TN1.*FROM (SELECT TN.BatchID, tServiceID.ServiceID, tServiceType.Code, TN.DateFrom, TN.DateTo, TN.Rent, TN.Calls, TN.Other, TN.Admin,tDiscount.DiscountRate, tDiscount.NonStdRevAdminFee, tDiscount.NonStdExpAdminFee, (TN.Rent + TN.Calls + TN.Other) AS "SubTotal",G(TN.Rent + TN.Calls + TN.Other + TN.Admin) AS "Total", tCustomer.ShipTooFROM ((((SELECT tBatch.BillingPeriod, tTransaction.BatchID, tTransaction.ServiceID, tTransaction.ServiceTypeID,( Min(tTransaction.FromDate) AS DateFrom,$ Max(tTransaction.ToDate) AS DateTo, tTransaction.CustomerIDWHERE tBatch.ID = WHERE tBatch.BillingPeriod = 'AND tBatch.BatchStatusID > AND tBatch.BatchStatusID < AND tTransaction.RevenueFlag = 1GROUP BY tBatch.BillingPeriod, tTransaction.BatchID, tTransaction.ServiceID, tTransaction.CustomerID, tTransaction.ServiceTypeID) AS TN5LEFT JOIN tServiceID ON TN.ServiceID = tServiceID.ID)=LEFT JOIN tServiceType ON TN.ServiceTypeID = tServiceType.ID)4LEFT JOIN tCustomer ON TN.CustomerID = tCustomer.ID)xLEFT JOIN tDiscount ON ((TN.CustomerID = tDiscount.CustomerID) AND (TN.ServiceTypeID = tDiscount.ServiceTypeID))) AS TN1ORDER BY TN1.ServiceIDUjjjjS3Uhd0d }uj@$MEtE4@$MEu E3ZYYdhE[] InstallationDateTerminationDateUļSV3ɉMĉMMMȉM̉MЉMԋ3Uhmd0d llt MȺlEEEN|zFEUlUQXuhMȺlEUuEĺUċEQ4ENuEPEPEPMUE}jf 3Ҹ˲Q4XQ4UEMEĺlUċQ4R@Q4hRH<$m <$<$EuhEĺUċQ4hRH<$m <$<$EuhEĺUċQ4h0RH<$m <$<$EuhEĺUċQ4DRH<$m <$<$EMEĺ\UċQ4UEMEĺlUċQ4R@,t,,MUEll3ZYYdhtEE^[]BatchID ServiceID||StatusID$Update the details for this Invoice?dbPPdata?SELECT TotalAdjustments, GSTAdjustment, GSTAmount, TotalPayable FROM tBatch WHERE ID = UPDATE tBatchSET TotalAdjustments = TotalAdjustments,GSTAdjustment = GSTAdjustment GSTAmount = GSTAmount TotalPayableTotalPayable = SVW؋ll֋֋ll_^[SVW؋44֋֋44_^[SVW؋,,֋֋,,_^[SVW؋  ֋֋  _^[SVW؋֋֋_^[SVW؋֋֋_^[SVW؋֋֋_^[SVW؋֋֋_^[SVW؋DD֋֋DD_^[SVW؋  ֋֋  _^[SVW؋hh֋֋hh_^[SVW؋֋֋_^[SVW؋֋֋_^[UjjSV3Uhd0d UQXغËQ4tËQ4ËQ4ËQ44ËQ4ËQ4ËQ4xËQ4ËQ4TËQ4ËQ4ËQ4HËQ4ËQ4ËQ4 ËQ4`ËQ4ËQ4huh EUËQ4( ËQ4p ËQ4 ËQ4Ӌ3ZYYdhE^[YY] ServiceIDSELECT SID2.ServiceID, SID2.Code, SID2.ServiceType, SID2.Description, SID2.RevElement, tElement.ElementCode AS ExpElement, SID2.Supplier, SID2.ShipTo, SID2.CustomerCentre, SID2.CustomerActivity, SID2.CustomerElement, SID2.CustomerSubledger, SID2.SplitService, SID2.VRTServiceFROM (SELECT SID1.ServiceID, SID1.Code, SID1.ServiceType, SID1.Description, tElement.ElementCode AS RevElement, ExpElementID, SID1.Supplier, SID1.ShipTo, SID1.CustomerCentre, SID1.CustomerActivity, SID1.CustomerElement, SID1.CustomerSubledger, SID1.SplitService, SID1.VRTServicehFROM (SELECT SID.ServiceID, tServiceType.Code, tServiceType.Description AS ServiceType, SID.Description,^ tServiceType.RevenueElementID AS RevElementID, tServiceType.ExpenseElementID as ExpElementID,] tSupplier.SupplierName AS Supplier, tCustomer.ShipTo, tCentre.Description AS CustomerCentre,T tActivity.Description AS CustomerActivity, tElement.ElementCode AS CustomerElement,r tSubledger.Description AS CustomerSubledger, tServiceType.SplitService, tServiceType.VRTServiceType as VRTService]FROM ((((((((tServiceID AS SID LEFT JOIN tServiceType ON SID.ServiceTypeID = tServiceType.ID)? LEFT JOIN tSupplier ON tServiceType.SupplierID = tSupplier.ID)8 LEFT JOIN tCentre ON SID.CustomerCentreID = tCentre.ID)> LEFT JOIN tActivity ON SID.CustomerActivityID = tActivity.ID); LEFT JOIN tElement ON SID.CustomerElementID = tElement.ID)@ LEFT JOIN tDepartment ON tCentre.DepartmentID = tDepartment.ID)5 LEFT JOIN tGroup ON tDepartment.GroupID = tGroup.ID)A LEFT JOIN tSubledger ON SID.CustomerSubledgerID = tSubledger.ID)8 LEFT JOIN tCustomer ON tGroup.CustomerID = tCustomer.IDWHERE SID.ServiceID LIKE ' ') AS SID1? LEFT JOIN tElement ON SID1.RevElementID = tElement.ID) AS SID26 LEFT JOIN tElement ON SID2.ExpElementID = tElement.IDORDER BY SID2.ServiceIDUjjjSV3Uhd0d t uRTURTUغËQ4hËQ4ËQ40ËQ4lËQ4ËQ4ËQ4$ËQ4lËQ4EMUËQ4EMUËQ4ËQ4<ËQ4hËQ4ËQ4ËQ4Ӌ3ZYYdhE^[]BatchID ServiceID\SELECT tTransaction.BatchID, tServiceID.ServiceID, Min(tTransaction.FromDate) AS "DateFrom",Y Max(tTransaction.ToDate) AS "DateTo", tTransactionType.Description AS "TransactionType",Z Sum(tTransaction.AmountExGST) AS "TotalExGST", Sum(tTransaction.GSTAmount) AS "TotalGST",0 Sum(tTransaction.AmountIncGST) AS "TotalIncGST"FROM ((tTransactionLLEFT JOIN tDubiousResult ON ((tTransaction.BatchID = tDubiousResult.BatchID): AND (tTransaction.ServiceID = tDubiousResult.ServiceID)))?LEFT JOIN tServiceID ON tTransaction.ServiceID = tServiceID.ID)RLEFT JOIN tTransactionType ON tTransaction.TransactionTypeID = tTransactionType.IDWHERE tTransaction.BatchID = AND tServiceID.ID = !AND tDubiousResult.ID IS NOT NULL!AND tTransaction.RevenueFlag <> 02AND tTransactionType.Description NOT LIKE '%Lost%'QGROUP BY tTransaction.BatchID, tServiceID.ServiceID, tTransactionType.DescriptionORDER BY tServiceID.ServiceIDUjjSV3Uh^d0d t4RTUغËQ4ËQ4,ËQ4lËQ4ËQ4HËQ4hËQ4ËQ4EM,UËQ4XËQ4ËQ4ËQ4TËQ4lӋll3ZYYdheE^[YY]BatchID8SELECT DC.*, tCriticalType.Description AS "CriticalType"ZFROM (SELECT tDataCollection.BatchID, tDataCollection.ServiceID, tDataCollection.StatusID,5 tTransactionGroup.Description AS "TransactionType", ` Sum(tDataCollection.AmountExGST) AS "TotalExGST", Sum(tDataCollection.GSTAmount) AS "TotalGST",e Sum(tDataCollection.AmountIncGST) AS "TotalIncGST", COUNT(tDataCollection.StatusID) AS "RecordCount"FROM (tDataCollectionVLEFT JOIN tTransactionType ON tDataCollection.TransactionTypeID = tTransactionType.ID)YLEFT JOIN tTransactionGroup ON tTransactionType.TransactionGroupID = tTransactionGroup.ID WHERE tDataCollection.BatchID = (AND tDataCollection.StatusID IS NOT NULL{GROUP BY tDataCollection.BatchID, tDataCollection.ServiceID, tTransactionGroup.Description, tDataCollection.StatusID) AS DC9LEFT JOIN tCriticalType ON DC.StatusID = tCriticalType.IDORDER BY DC.ServiceIDUQjjIuQMSVWMU3Uh[d0d EEԃ}%l]؛EEEEx=tEຄ Eຘ=/E亴uhUċuhEEu5hEMEuHEuMEUuhEtGXUċEčUE3M0EUċtEčUEPM0UEEUUXuEkE̠@PUċtEčUUEVu}^EM3MLE̋8EE}tHEduM0EUuhEpGE亀t EດUċEčUE~8uhUċpEčUuhE EຨtLxGE亸t EUċLEčUE~8uhUċLEčUuhE EຨGtEt EUEUE~3uUEUuhE Eຨ GtEt E(UEUE~3uU EUuhE EຨGtE@t EXUEUE~3uUEUuhE EຨGtEpt EຈUEUE~3uUEUuhE EຨGtE交t EUċEčUE~3uUċEčUuhE EຨGtEt EUEUE~3uUEUuhE EຨGtEt E,UEUE~3uUEUuhE EຨGtEDt EXUEUE~3uUEUuhE Eຨ=t>Eluh55EuhEUEQ4UEQ4EEGtd]vUE亄t Eຜuh$EuhEGtd]vUE亴t Euh$EuhExGEt EUEUE~3uUEUuhE Eຨ]vUEt Euh$EuhE]vUE4t ELuh$EuhE]vUEdt E|uh$EuhE]vUE亘t Eະuh$EuhEGtd]vUEt Euh$EuhExGEt EUċEčUE~8uhUċEčUuhE EຨxGE t E<UċEčUE~8uhUċEčUuhE Eຨ=R@XQ4|Q4RTUEUUE亠uh5EERHM3ҋE8W EMEEu8EPEIEEPEIEE=t EUEQ4UEQ4=tHEQ4ERH|;@EEMUE8W UEQ4EMu EQ4ERH|,@EEMUE8W UEQ4EMu߄t&UEMEUEQ4U=ER@ EQ4E @UEQ4h`55EuhEUEQ4EQ4URTEԋEUԉUEUER@EQ4EQ4h UEEUuh 5h,55Euh85hE UEQ4UR@DQ4UEMEpUQ4t E3҉RTUEEE3ZYYdhbEEEEE_^[]zD(VALUES (SET 0BillingPeriod,'', BatchTypeID,, SupplierID SupplierID,ValidAccountIDValidAccountNoSupplierAccountID, InvoiceNo, InvoiceNo =NULL, TenderNo, TenderNo = TotalRevenue,TotalRevenue = TotalPayable,TotalPayable = TotalCredits,TotalCredits =OpeningBalance,OpeningBalance =PaymentsReceived,PaymentsReceived =TotalAdjustments,TotalAdjustments =GSTAdjustment,GSTAdjustment = GSTAmount, GSTAmount =BatchStartDate, PaymentDate, PaymentDate = IssueDate, IssueDate = Rounding, Rounding =RentStartDate,RentStartDate = RentEndDate, RentEndDate =CallsStartDate,CallsStartDate = CallsEndDate,CallsEndDate = PayByDate, PayByDate = OrderNumber, OrderNumber =RequisitionNumber,RequisitionNumber =SELECT id FROM tBatchStatusORDER BY id ASCid BatchStatusID )INSERT INTO tBatch UPDATE tBatchWHERE tBatch.ID = SELECT ID FROM tBatchWHERE BatchTypeID = AND (BatchStartDate = '')ORDER BY ID DESCINSERT INTO tBatchStatusHistory1(BatchID, BatchStatusID, StatusChangeDate,UserID)Values (, , '', SELECT BatchStatusID FROM tBatch WHERE id = BatchStatusIDUSVW3҉UU3Uhd0d ݆L <$EUjhjEPE3ɸE NjQ4PNjQ4hNjQ4X NjQ4׋R@tR@u3NjR@NjQ4NjQ4M4NjQ4PNjQ4NjQ4NjQ4NjQ4׋NjR@NjQ4@NjQ4lNjQ4NjQ4NjQ40NjQ4hNjQ4NjQ4NjQ4NjQ4 NjQ4` NjQ4 NjQ4 NjQ4h uh< NjQ4l NjQ4 NjQ4 NjQ4 NjQ4, NjQ4T NjQ4 NjQ4 NjQ4\ NjQ4 NjQ4 NjQ4 NjQ4$ NjQ4< NjQ4d NjQ4 NjQ4 NjQ4 NjQ4M8NjQ4TNjQ4|NjQ4NjQ40NjQ4xNjQ4NjQ4NjQ4׋EE 3ZYYdhEE_^[]=tDataCollection;SELECT tBatchType.MultiManualEntry, tBatchType.EarlyRevenueFROM tBatchType7INNER JOIN tBatch ON tBatchType.ID = tBatch.BatchTypeIDWHERE tBatch.ID = MultiManualEntry EarlyRevenueUPDATE tDataCollectionSET RevenueFlag = 0WHERE BatchID = &AND TransactionTypeID IN (SELECT TT.IDFROM tTransactionType TT?LEFT JOIN tTransactionGroup TG ON TT.TransactionGroupID = TG.ID&WHERE TG.Description NOT LIKE 'OTHER')INSERT INTO tDataCollection (SequenceNo, ServiceID, BatchID,6 RateDescription, FromDate, ToDate, TransactionTypeID,< RevenueFlag, GSTFlag, AmountExGST, GSTAmount, AmountIncGST)2SELECT DC3.SequenceNo, DC3.ServiceID, DC3.BatchID,/ DC3.RateDescription, DC3.FromDate, DC3.ToDate,5 DC3.TransactionTypeID, DC3.RevenueFlag, DC3.GSTFlag, DC3.AmountExGST, DC3.GSTAmount,4 (DC3.AmountExGST + DC3.GSTAmount) AS "AmountIncGST"8FROM (SELECT DC2.SequenceNo, DC2.ServiceID, DC2.BatchID,/ DC2.RateDescription, DC2.FromDate, DC2.ToDate,: DC2.TransactionTypeID, (1) AS "RevenueFlag", DC2.GSTFlag, DC1.AmountExGST,; CAST((CASE WHEN DC2.GSTFlag = 'Y' THEN (DC1.AmountExGST * &) ELSE 0 END) AS money) AS "GSTAmount"7FROM (SELECT DC00.DataCollectionID, DC00.ServicetypeID, (CASE TG.Description WHEN 'RENT' THEN9 (CASE WHEN DC00.RentExGST IS NULL THEN DCX.AmountExGST ELSE DC00.RentExGST END)s WHEN 'CALL' THEN ((CASE WHEN DC00.CallExGSTRate IS NULL THEN 1.0 ELSE DC00.CallExGSTRate END) * DCX.AmountExGST)- ELSE DCX.AmountExGST END) AS "AmountExGST"JFROM (SELECT DC0.*, (Min(tRate.Cost) / 12 * DC0.Frequency) AS "RentExGST",/ (Min(tRate.PartCost) / 100) AS "CallExGSTRate"CFROM (SELECT DC.ID AS "DataCollectionID", tServiceID.ServiceTypeID, (CASE tServiceType.Frequency WHEN NULL THEN 1 WHEN 0 THEN 1 ELSE tServiceType.Frequency END) AS "Frequency"FROM tDataCollection DC;LEFT JOIN tServiceID ON DC.ServiceID = tServiceID.ServiceIDDLEFT JOIN tServiceType ON tServiceID.ServiceTypeID = tServiceType.IDWHERE DC.BatchID = AND DC.RevenueFlag = 0) AS DC0ULEFT JOIN tRate ON ((DC0.ServiceTypeID = tRate.ServiceTypeID) AND (tRate.Active = 1))HGROUP BY DC0.DataCollectionID, DC0.ServiceTypeID, DC0.Frequency) AS DC00?LEFT JOIN tDataCollection DCX ON DC00.DataCollectionID = DCX.ID>LEFT JOIN tTransactionType TT ON DCX.TransactionTypeID = TT.IDGLEFT JOIN tTransactionGroup TG ON TT.TransactionGroupID = TG.ID) AS DC1FLEFT JOIN tDataCollection DC2 ON DC1.DataCollectionID = DC2.ID) AS DC3UļSVW3ɉMȉM̉MMĉMMM3Uhn d0d <; xGt UȋEȍUEEtI3Ejh Uȋuh E̺Ef EUȋEE}<MUŰEU̍X u3E; t(E;( =u` PEPMUŰEU̍E=$]$]؛h EPUċEĹuh EPUEučE̺E]ЛE]rIuu$]r*E]ruu$]sjf 3Ҹ E]sjf 3Ҹ ` =uuuuu؋UE=uuuuu؋UEt=uuuuu؋UEQ=a uuuuu؋UE.=tW=u1uuuu؋EPUȋUȋMEuuuu؋MUE=b uuuuu؋MUE=uuuuu؋UE=uuuuu؋UEb=6R@H Q4l Q4 Q4t E UQXuuuu؋MUE=5R@H Q4l Q4 Q4t E UQXuuuu؋MUE=R@H Q4l Q4 Q4t E UQX` =Mt=Yu$` UE.=XuUE ` =Qt=Wu$` UE=VuUE=RuUE=Pu#EPM3]=Uu#EPM33=Nu#EPM33 =Su#EPM33=Ou#EPM3Ұ=Tu#EPM3Ұ=uUEi` =t=u!MU` 4=uUE=uUEte=t7ph UEuE̺U̡%UȋUȋ4 u=u =tE; | E;( |3Q`3ZYYdhu EEEE_^[]About to add to Period: Continue?01//(Dates must be within the Billing Period..Start and End Dates are transposed. Try again.SELECT tParameter.ParmTextFROM tParameter0WHERE tParameter.Parm LIKE 'InDataRootDirectory'ParmText,WHERE tParameter.Parm LIKE 'ImportDirectory' UjjjSVWU3Uh d0d غ$ËQ4LËQ4`ËQ4UEMEUËQ4Ӌt -UQXEUU3ZYYdhE_^[]SELECT tSupplier.SupplierName FROM tBatch7LEFT JOIN tSupplier ON tBatch.SupplierID = tSupplier.IDWHERE tBatch.ID = SupplierNameUjjjSVWU3Uh.d0d HƋQ4ƋQ4ƋQ4UEMEUƋQ4֋tE3҉GRTU UQXEUU3ZYYdh5E_^[]1SELECT tBatch.BatchTypeID, tBatchType.Description FROM tBatch:LEFT JOIN tBatchType ON tBatch.BatchTypeID = tBatchType.IDWHERE tBatch.ID = BatchTypeID DescriptionS؋<;uK xGt+3ҋ3ҋ[UjjIuSVW3Uhd0d t -@$MغEE; E}t Mغ(EUƋQ4HƋQ4pƋQ4EԋMUԋƋQ4@$RTUMЍEԺUԋƋQ4˲E0E֋EEE􀸐tE􀸑H@EEU}t+@$MغDE=@$MغEPEUUXERT@$RT;ƋR@XƋQ4MغEEUMЍEԺxUԋƋQ4@$MغEUMЍEԺUԋƋQ4֋R@EMxEE3ZYYdhEEкEE_^[]BatchIDDubiousResolutionIDYSELECT tDubiousValidResolution.DubiousResolutionID, tDubiousValidResolution.DubiousTypeIDFROM tDubiousValidResolution(WHERE tDubiousValidResolution.Active = 12AND tDubiousValidResolution.DubiousResolutionID = DubiousTypeID,AND tDubiousValidResolution.DubiousTypeID = dbPPdata ResolutionUPDATE tDubiousResultSET ResolutionID = DIDWHERE tDubiousResult.id = U3QQQQQQSV3Uh:d0d PƋQ4ƋQ4ƋQ4pƋQ4ƋQ4tFu7RTUME(UƋQ4(֋((`(UQXUEU苃$3ZYYdhAEE^[]SELECT tDubiousValidResolution.DubiousResolutionID, tDubiousType.Description AS DubiousType, tDubiousResolution.Description AS DubiousResolutionFROM tDubiousValidResolutionQLEFT JOIN tDubiousType ON tDubiousValidResolution.DubiousTypeID = tDubiousType.IDcLEFT JOIN tDubiousResolution ON tDubiousValidResolution.DubiousResolutionID = tDubiousResolution.ID(WHERE tDubiousValidResolution.Active = 1 DubiousTypeID,AND tDubiousValidResolution.DubiousTypeID = DubiousResolutionU3QQQQQSVWU3Uhd0d t5t,,t8,RT38RTujf @3ҸLgƋQ4ƋQ4UMEUƋQ4֋RT;< ERT;8 E}ƋR@ƋQ4ƋQ4UMEUƋQ40ƋQ4֋tt< E}jf LXfЋtt|*tU|,t',,U싃Ujf @3Ҹ3ZYYdh&EE_^[]BatchID)Unable to determine the Batch to process.SELECT BatchStatusID FROM tBatch WHERE ID = BatchStatusIDSELECT TOP 1 IDFROM tDubiousResultWHERE BatchID = AND ResolutionID IS NULL4All results resolved. Release revenue for invoicing?ZRevenue cannot be released until you test for Dubious Errors and all errors are resolved.USVW3ɉMU3Uhd0d EEERN|6F3ۍMӋE8W U~ӋES CNu͋EU3ZYYdhE_^[] .RevenueFlagRWHERE ((tDataCollection.RevenueFlag IS NULL) OR (tDataCollection.RevenueFlag = 0))USVW3ɉMU3Uhd0d EEERN|6F3ۍMӋE8W U~ӋES CNu͋EU3ZYYdhE_^[] .RevenueFlagWWHERE ((tDataCollection.RevenueFlag IS NOT NULL) AND (tDataCollection.RevenueFlag = 1))US3ɉM3UhNd0d EU@EЋЋ0Md0xGt8t UUDDER@,toM|0xGt8t UU  U@EЋE3ZYYdhUE[YY]DCTransactionsDCTransactionsAutoUjjSVW3UhVd0d lQ4Q4Q4hUuhEUQ4Q4,Q4HQ4/TUQXUQ4tȋ3ҋM3ҋ8W U3ZYYdh]EE_^[YY]SELECT DISTINCT CB.BatchIDFROM (SELECT DISTINCT BatchIDFROM tPayableDetailWHERE Period LIKE '') AS CBWHERE CB.BatchID IS NOT NULLORDER BY CB.BatchIDAllBatchIDUSVW3ɉMMMUE3Uhd0d ؍UEEUEUEEUEQUËQ,ËRN|.M֋Ë8W EUUNuҋËRH|5EMUË8W EUU M}u΋ËR@|(FEMEU8W UËQ4ENu}t+UEME,UËQ4EPERNX+|$FEMEU8W UËQ4ENuUËQUEQ,3ZYYdhEE_^[]allWHERE ORDER BY AND BatchID = US3ɉM3Uhd0d EUQUEQ,UUE3ZYYdhE[YY]US؀}u.8@$HRT~ E[] StatusIDUS؀}u.0@$HRT~ E[] StatusIDUS؀}u.\@$HRT~ E[] StatusIDUjjSVW3Uhd0d t5t,,t0,RT#3@$0RTujf 83ҸDcR@xQ4Q4UMEUQ4t3RT, ;uj0 t Ћ,tf,,=;~jf 83Ҹ"jf 83Ҹ3ZYYdh E_^[YY]BatchID)Unable to determine the Batch to process.SELECT tBatch.BatchStatusID FROM tBatchWHERE tBatch.ID = BatchStatusID"You must calculate the fees first.)Improper access to fee approval. Aborted.SVQ؋t3t*,t,RT3RTujf 3Ҹ#<$tZ^[BatchID)Unable to determine the Batch to process.UjjjSVW3Uhd0d t5t,,t,RT#3@$RTujf 3Ҹ(ER@\Q4Q4UMEUQ4t3RT;0 tt4 ERTU,t',,3ZYYdhE_^[]BatchID)Unable to determine the Batch to process.SELECT tBatch.BatchStatusID FROM tBatchWHERE tBatch.ID = BatchStatusIDUjjIuQSVW3Uhd0d ,t h= u = R,RT;@ 1 ,RT; M,EPE܋$ UX}J4t44 M,EPE܋( UXjf  fugM ,EUt Ћ,,f4t44 M,EPE܋0 UX}Jt M,EPE܋4 UX}`t. M,EPE܋8 UXtO((Mp(U싃$.E ,RTU||M,EPE܋@ UX}|tO((Mp(U싃$ ||3ZYYdhE܋_^[] BatchStatusIDBatchID)DAll errors resolved. Process these transactions or Retry for Errors?DubiousResolutionUjjIuSV3Uh#d0d t 8RTUHUQX\ƋQ4pƋQ4ƋQ4ƋQ4HƋQ4ƋQ4ƋQ4ƋQ4(ƋQ4DƋQ4ƋQ4ƋQ4EMLUƋQ4htuhEUƋQ4ƋQ4ƋQ4@ƋQ4ƋQ4ƋQ4֋(P0P8 TMEt#E UTlEdEPMԺUXE<$EPE UT(P0P8 XM Et, XlEdEPMԺ UXE<$EPE UX0P0P8 \M< EtL \HM< E<$EMЍE\ U\3ZYYdh*EEԋE^[]BatchID ServiceIDSELECT *8FROM (SELECT tTransaction.BatchID, tServiceID.ServiceID,( Min(tTransaction.FromDate) AS DateFrom,W Max(tTransaction.ToDate) AS DateTo, tTransactionType.Description AS "TransactionType",- Sum(tTransaction.AmountExGST) AS TotalExGST,) Sum(tTransaction.GSTAmount) AS TotalGST,/ Sum(tTransaction.AmountIncGST) AS TotalIncGST,2 tTransactionGroup.Description AS TransactionGroupFROM ((tTransaction?LEFT JOIN tServiceID ON tTransaction.ServiceID = tServiceID.ID)SLEFT JOIN tTransactionType ON tTransaction.TransactionTypeID = tTransactionType.ID)YLEFT JOIN tTransactionGroup ON tTransactionType.TransactionGroupID = tTransactionGroup.IDWHERE tTransaction.BatchID = AND tServiceID.ServiceID LIKE ''PAND (tTransaction.RevenueFlag = 1 OR tTransactionGroup.Description LIKE 'ADMIN')2AND tTransactionType.Description NOT LIKE '%Lost%'RGROUP BY tTransaction.BatchID, tServiceID.ServiceID, tTransactionType.Description,* tTransactionGroup.Description) AS ADetailORDER BY ServiceIDNonStdRevAdminFee% DiscountRate0.00%Admin$0.00$US؋3Ћ[]U3QQQQQSV3Uhd0d Etytp,t7,t uM,EOE3jf 3Ҹ|%@$ME}t U3ZYYdhE^[]BatchID`Test failed. Unable to identify a Batch to process. Select a Batch in the Batch Status Summary.Ujj3Uhd2d"T tEEjEE3ɋU } 3ZYYdhEYY] 1 0 PPSystem.exeIError running PPSystem.EXE It MUST be in the same directory as NewPP.exeRsu ׋_^[]S؋xGt)<u 3ҋ[UjjIuQSVW3Uhd0d EUEÄtshEPU؋EعuhEPUԋEԹu؍EܺE] ]움=Euu$Euu$EEQ4huhEܺU܋EQ4huhEܺU܋EQ4\ Eܺ(U܋EQ4UER@HEQ4\EQ4\ Eܺ(U܋EQ4|EQ4ULQ42f@8fEf3UhKd0d EQ4EQ44EQ4|EQ4EQ4\ EܺU܋EQ4βMU}JUEUEСGt$:Gt$tuuGt$FGt$ tuu$fUHu1X UE 3ZYYdhRfUE3ZYYdhEԺEEE_^[]01//UPDATE tMultiManualDataSET FromDate = '', ToDate = ''WHERE BatchTypeID = SELECT *FROM tMultiManualDataORDER BY ServiceIDuSELECT DISTINCT tServiceType.Code + ' - ' + tServiceType.Description AS ServiceType, tServiceType.ID AS ServiceTypeIDFROM ((tBatchType= LEFT JOIN tSupplier ON tBatchType.SupplierID = tSupplier.ID): LEFT JOIN tSystem ON tBatchType.ID = tSystem.BatchTypeID)= LEFT JOIN tServiceType ON tSystem.ID = tServiceType.SystemIDWHERE tBatchType.ID = U3QQQQSV3Uhd0d Dt `U@DUQXغËQ4ËQ4@ËQ4ËQ4ËQ4ËQ4TËQ4ËQ4ËQ4,ËQ4dËQ4ËQ4ËQ4 ËQ4DËQ4|ËQ4ËQ4ËQ4ËQ4ËQ4ËQ4dËQ4EMUËQ40xGtF8tËQ4EH \ ËQ4E h uh h EUËQ4 ËQ4TTuh< uhP uEUXhӋhhT3ZYYdhE^[] ServiceID SELECT DCDA.*CFROM (SELECT DCD.BatchID, DCD.ServiceID, DCD.Code, DCD.AmountExGST,K DCD.CallCode, DCD.DialledNumber, DCD.RateDescription, DCD.TransactionType,7 DCD.Var01, DCD.Var02, DCD.Var03, DCD.Var04, DCD.Var05,7 DCD.Var06, DCD.Var07, DCD.Var08, DCD.Var09, DCD.Var10,6 DCD.Var11, DCD.Var12, DCD.Var13, DCD.Var14, DCD.Var15@FROM (SELECT tDataCollection.BatchID, tDataCollection.ServiceID,7 tDataCollection.AmountExGST, tDataCollection.CallCode,@ tDataCollection.RateDescription, tDataCollection.DialledNumber,. tDataCollection.Var01, tDataCollection.Var02,. tDataCollection.Var03, tDataCollection.Var04,. tDataCollection.Var05, tDataCollection.Var06,. tDataCollection.Var07, tDataCollection.Var08,. tDataCollection.Var09, tDataCollection.Var10,. tDataCollection.Var11, tDataCollection.Var12,. tDataCollection.Var13, tDataCollection.Var14,H tDataCollection.Var15, tTransactionType.Description AS TransactionType, (CASE WHEN tDataCollection.ServiceType IS NULL THEN tServiceType.Code ELSE RTRIM(SUBSTRING(tDataCollection.ServiceType,1,5)) END) AS "Code"FROM ((tDataCollectionILEFT JOIN tServiceID ON tDataCollection.ServiceID = tServiceID.ServiceID)ELEFT JOIN tServiceType ON tServiceID.ServiceTypeID = tServiceType.ID)ULEFT JOIN tTransactionType ON tDataCollection.TransactionTypeID = tTransactionType.ID WHERE tDataCollection.BatchID = OAND tDataCollection.RevenueFlag IS NOT NULL AND tDataCollection.RevenueFlag = 1 Revenue: LAND (tDataCollection.RevenueFlag IS NULL OR tDataCollection.RevenueFlag = 0) Expense: $AND tDataCollection.ServiceID LIKE '') AS DCD) AS DCDAORDER BY DCDA.ServiceIDBatchID= ServiceID=UjjIuQSV3Uhd0d xG˲<;0uDb8zGtD0zGt 3'U@˲3EСUQXUHEPMԺUԍEEUEDD t  $PMƋ03ZYYdh EEEE^[] ServiceIDUjSV3Uhd0d (t3 u<tTUQUƋQ,֋RUQUƋQ,֋ЋЋ3ZYYdhE^[Y]ËzGt1<;u#lt u S؋(tHdH u(@R~<$d(Ћ8,Ћ0[US3ɉM3Uhd0d E(tOUDQUEQ,UDUDDMU QUEQ,U U  3ZYYdhE[YY]US3ɉM3Uhd0d E(tOUDQUEQ,UDUDDMU QUEQ,U U  E3ZYYdhE[YY]U3QQQQQQSVڋ3Uh5d0d R@LQ4tQ4Q4UMEUQ4MEt3ME؋R@3ZYYdh<EE^[]SELECT tBatchType.EarlyRevenueFROM tBatchType7RIGHT JOIN tBatch ON tBatchType.ID = tBatch.BatchTypeIDWHERE tBatch.ID = EarlyRevenueUSV3ۉ]M3Uhd0d ؀}utËQ4ËQ4|ËQ4h\ hhEUËQ4UËQEPLZQ,ULQ8E3ZYYdhE^[YY]INSERT INTO tMultiManualDataX (BatchTypeID, ServiceID, Rent, Call, Other, GSTAmt, FromDate, ToDate, RateDescription)VALUES (-, :ServiceID, :Rent, :Call, :Other, :GSTAmt, & :FromDate, :ToDate, :RateDescription)SȲ؋Ë[áSV3؈T Ӌ^[SV؈T Ӌ^[UjS3UhDd0d UU3ZYYdhKE[Y]UjjS3Uhd0d ,tn,u_,RTjhUuhEEf 3u Ӹ(3ZYYdhE[YY]BatchIDPrevious Web data for Batch  will be overwritten. Continue?tProcessedTransactionUjSVW3Uhd0d xGβ<;0uF8xGtDED0xGt E #3;TuhE43ۄt U3ZYYdhE_^[Y]tDataCollection SummarytDataCollection Auto SummarytDataCollection DetailU3Uhwd0d uP3ZYYdh~]Ã-m>%i eqmu 9y})=!-15e}"  $= ,Q . .9 H ,8 .! ,9 *Q *e 4 & y 0   * 8%  0U . < D H B F N DU Ji Ju * LMPiXD@ @B J R B% BH5 LF > :@=:i *:>:%8I2U8i>i"u.DD$*:9.(-29>0*E RTTE.U.u><*0666uF!%<dfhjl)0n>>B>FBi 6HLJ J N! P- N9 LE LQ P] P u D < 6iA uEI }2}-15e   m  9)EA q9 =Y< @}B } } }$p}r6tZv } } }$p. } }r8I v } } }$p. } }r8I v2u E 9a y*)"" 15 } 5%% M %   } D    ~8A  (U &            &     &     &     &      &  ! !   &!  - -   &-  9 9   &9  E E   &E  Q Q   &Q  ] ]   &]  i i "  >i  u 8vFp"- @ $ @ $ 0    "  $ &  (&!."  $ &  (&! &  (&!(    Q 6 ! %       5   0vFp -*1,569P r)  r 1) r 1) r 1) x&9 AE  x*I x  r)  xA 5M r)  r=XAE@t* AE) IAE )) MAE  MAE  MAE  MAE  MAE )) IAE ) MAE ) MAE  IAE) 4(Q 14-   9 < -2z! %       5 $vFp 9zvp "- 9zvp "- 9zvp "- 9zvp "- 9zvp "- 9"zvpz&vp U >    & 6- 9U 9zvp "- 9"zvpY   %%  "- EI 9U 99  E V E D r) x   r=A 59&t< x&9 ! .  ! .! (! E! 0! r)! ! r=A 5]!  |9 "9 9 xA9 r) aa9 xA Q =e 9  A "A A  )E( ) =&E$a$ IQ UM *) =*y " A x$ A x,( A x$ A x,( A I A x$( A x$"( A x$"( A x$"( A x$"( A x$ A ( A x$"( A x$"( A x$"( A x$( A x$( A x$( A x$"( A x$((( A x$((( =2$M9&$M9Y$ae$ae$ae$a A x$( A x$(A  I ( =()(((((((6(Q (Q  U]] = Y>A>I IQ 1QU@MQ 1QQ 1U MQUM! %AQ Q Y Q *vFpQ r)EQ xEv2EQ Q Q Q Y Q 5*vFpA Q  e &e (! %e e e e $e *vFp e xIQUMpe r)e x,(e r)e x,(e r)e r(e r)e r$(e r)e xe $(e r)e r$(e r)e r$(e r)e r(e r)e r$(e r)e r$(e r)e r$(e r)e r$a(e r)e r$a(e r)e r$a(e r)e r$0e r)e r$ae r)e r$a0e r)e r$ae r)e r$a(e r)e r(e r)e re   y "y (U! %y y y y *Uy $ 9y y $vFp&y   0 , a e   6 * ! %(i",i % vFp,i % vFp,i % vFp,i ) ) % vFp,i % vFp4i ) ) ) ) ) ) % vFpp r2 ,i ) ) % vFp4i ) % vFpp&U PiF % 9eP vFp$ % 9eP vFp9 &i % vFp- EI   (i"v4i"v&%% Mi"vv0i"v0i"vi"v0i"v0i"v0i"vvi"v0i"v0i"vi"v0i"v0i"vv0i"vvi"v.i.v.i.v EI  m.q   EI 2 < @ B       58A 8A J  $p rU6t9<v   6 < @ B & & A 2ptA  q .9" Yr)x&U 40r4<v  q ( "z  r=&    zvp"-vpvpz$A9vpzvp  % @% i% 9% % % % % % % % % 5"% $% 9% % % % % % % % % 5"% % $% 9% % % % % % % % % % % % % % % % % 5"% $% 9% % % % % % % % % % % % % % % % % xA% % A% A% 5"% % % % % % % % % $% 9% % % % % % % % % % % % % % % % % % % % % % % % % % % % $% 9% % % % % % % % % % % % % % % r=A% 0A% "% % % % % $% 9% % % % % % % % % 5"% % $% 9% % % % % % % % % % % % % % % % % % % % % % 5"% % % % % % % % % % % % $% 9% % % % % % % % % % % % % % % % 5"% $% 9% % % % % % % % % % % % % % % % zH% r=A% "% % 50A% 0A% "% % % % % % % % $%  a9 $9 .9 r)"9 r)"9  U JU "zXU r=! %J U x U U r=A 5V&U U $< @U BU U AU *pvDU U U x*U U 52U U x*U U 52U U x*U U 52U x*U U >AU 6vHv8zvpvpU   v*Fp v*Fp v*Fp v*Fp v*Fp v*Fp v*Fp v*Fp v*Fp v*Fp% v*Fp5 v*FpE v*FpU U U x! %U U U U U U U U U U U U U U U U U U U U 5U U U $vFp"-U  I i "i Ni xA i xA! %i i i i i i i i i $i *i i i i i i (ivFp"-i  a   xA! %        $     (ivFp"-  5 F 2= =9  ! %! %! %  =   ]   = Y  5 YY  5 r) Y r=A 54U   r),U rU9, UE8] D Y r=A 50 Y YU  U 5 Y8 Y YU  U 5 Y( Y YU *U 5 Y( Y YU *U 5 Y( Y YU *U 5 Y( Y YU *U 5 Y( Y YU *U 5 Y( Y YU *U 5 Y( Y YU *U 5 Y( Y YU *U 5 Y = Y 9 9 5<&e  Y Y e 5&e  Y Y e 50 Y YU *U 5 Ye  Y Y e 5e  Y Y e 5e  Y Y e 5e  Y Y e 5&e  Y Y e 50 Y YU  U 5 Y0 Y YU  U 5 Y =(v,  p  xAU] v Y ]5@ 2q 9  M  M Y = Y8=  A 0vFH =( "Y    9 9 5  *vFp  xv&A   AU ]  9 9   50vFH8 A *p. x"v   L PeiJv 9 9 1! %   0 0vFp  x x4v(  * $    (FH                5$                  * $       $vFHv9 9 "   . L b &U 2  5 .94 AHIHQ ] I$ee $$M $$M 54<"  2  R F FFMP>LFF:v,   p" xv4:v,   p" xv4A$vD , , p. x&v45$ 5&5 5@5$ 5&5 5&5 5&5" 5&5" 5&5" 5&5" 5&5" 5&5" 5&5 5:5$) 5*! 5* 5A A 5 ]  IQUMn  = .= ! %= = = $A= *vFp,= x&Uv=  Q .Q ! %Q Q Q $AQ *vFp:Q xQ x&UvQ  i LA v Uui u 4u Zu r=< u r=A! %u u u $u *u xAu &< @u BFpND"u r)&u ru x$u x<u u r=Au *u r=Au *vFHHvvpu  m & ! %     $z0 xA *vFp  x&E2     , Rz x$ x(  ! %  "A *vFp  x( x4v,  "A  $vFp:.  *vpJ 6i "-zvp"-     Q * j 1 J   * j 1 J  $! %"9e% P FpD% P Fp9   &v    5& $p"xFt v@ <! %&Ui 9] 1d] 1  =$=! %XFp= M&M x,<i&i x,<& x,< Rzx0 x(  vD,A >p0x$v.0  zvp"-    Hzx x$ "vp$Rzx0 x(  vD,A >p0x$vbx zvp"-  2! %H))x,x2r$zvp "-r$ r=0 vp"-4zvp "-r$zvp "-r$zvpvp "-r$"zvvppr2x "-r$zvvppr2 "-mq .NxA x! %$ 5(ivFp4r)  r8I Y4r)r8I Y4r)rum "-mq *U %$%ZzH%r=&%%  % r=$% 199.9  9  9 e 9 9 EIU UdU a6U a6U a$Ua6U a6U a6U a6U e6U e6U anU U U 4UU 5aUU 5anU U U UU 5a0U aU i9 ua 9   (0 m" 2! %" $$M$$M 5EE$ 5 52 2FH,  ,FpI 6QQU,  ! =   !! A0U9! E&e! I*e! I"! I&e! M*e! M"! M QU !,9 9 QU  5 "` x! %$ Z    5(i 5vFp"- 0>< @    9 x  EI :r$MEvpzvp " J! %Jz. "vvFp"VvFp"66 -r 9  FzX "66 E$E! %| vFpV vFpE U$U! %| vFpV vFpU e*e"vDe,e,eAe >per) eryv<e  u,u! %uuuuu u5PLBu y   & % Y   y*  y*(  "z0xA5  =>< @d 8 8 $ e  ]  Y               ( E  FD$  2    \H0   $"   $"( $""  2lr.h 0Lz 44F 44P 44P 44P 44P 44P 44P 44P 44P 44P 44P 44P .6h  "0606D"" & *" &" & (&P"9JF(0($ B((6b 6.   R",$$$$$,"$$"(4("t!P&d"$"$"$"$"$&&J$.* "$L"$&&6""L L  L 6& 6 B JFvpp6VFVj~6F"(8>"("DL(DL(4D(D"(D"(D"(D"(D (D"(D"(D"(D(D(D(D"(D(((D(((R::D(D(66600000(("(((((((<* ( > >"B,,:>4&Nb:4*VLVLVXVZVZVZVZVXVZVZVZVZVZVZVZ >Z>Z >Z>ZVXVX66600000 6P04RD   *J *>,$  ""  """"""B"" "8&,X< X<Bb m" " &" " "" " " "" " "" " " ""..  *.F(    lXX$  r BH J*&&&V8v$6">:x&tY<&:* &lp T&d"&d"&d@"&n"&"&zP"&d"&n"&d"& N~dPPI8 NNTv^^< 4<   R",^"j             20H"R1 682:44"R I2:4"RZ JV6>vjF  v "Bp("Jp"Bf"Bf"Bf"Bf"Bf"Bf"Bf"Bfb6"n6"n "Jf&"n&"n&"n&"n6"n "Jp "Jp   b6R>880808 L <r (2    R$,``FFp @0T@&.`0L 22n",66448888b>>88    (>    ( >",,,2(("("      ("n0  mBJZR BJ4ZR("H8L"&F4~"8>lt"0 U:<nbb @02& 4H>>H0$*0""4 *b 9>$<J >$<J 8X<$<>Jv4    l  0PPp.P  R Xbt.b 8>J   B4  B4  B4402>4",,\&&0&.*^ q 0.". 802> 4",,\&&02fFB`,h* F0,,`,`,hF:,`F"^B8204H4>F4>$4>$" 8 80N>*JZ *<&Db- 4  bbb*bbbvvb$$$  28F844JJ<<, <& Z44 448   \0 6804$R\"RD  >((,,F,v0 >.$&D"$<&<"66H d$&H&"66 8$>>P 8$>>J >",,,\>:z@ XH H a ,j 0<.x\y%0     NiP(&9 R  R     5 9 M" , M/ / 0 Q0 u0 5 4 9 4f };f ; q<* =H} = Q  9   ! 9 Q e   y      %   U    ! % ) - 1U 5i 9u = AMEiMUY ]a i m q% uy5   =i %IUiiu9-9E EU u !%)A I   e  ! - 9 E Q ] i  u    u i@mm u }XpF9 Uq `  `0  &&`022`0..F@0@ 4@ 4@ 4@  4 @  4  @  4 ! @ ) 4) - @ 5 45 9 @ A 4A E @ M 4M Q @ Y 4Y ] @ e 4e i u `0y } } Zy @  l @  l (pR `p J a  M  % 9 y       e Q  a   X0 P  1       ! 80% B5 j1 5 1 % 9 @(= 6= A @0E 6E 9#I @M M  Q `80U <Y Y 9 U e 00i :m rm u Au Qi $y `0} 6 n}   p Z d v 00 > > p p ! !     r  A i  9   U } % M   1  i  M m ) `p  4 h `Xp F n Q } `X0 J    80 < ! !   a% AHp1 T) T- T - h) Q) ) ) m) Q ) ) ) ) ) A) ) ) )) ) U$) &) ]*) *) 11 49 ` = 8= = = U 0Y ^i Yi   iY  p   < N h ~ p   < N h ~ p   < N h ~ p   < N h ~ p   < N h ~ p   < N h ~ p   < N h ~ p    < N h ~ p    < N h ~ p   ! < N! h ~% p) -  1 <- N1 h) ~5 p9 =  A <= NA h9 ~E pI M  Q <M NQ hI ~U `0Y 2a ~Y Ma i `0m 6u m u 9 `0 2    p Z  6 8 > y? ? B B E F %F %F H Qp `     ] p ` 5  5 9 m 9 I %" %= pA BI B M ^I A M QQ pU B] B e ^] U 1e i @m m u py H} H}  m y  `00 : V A  @ (p @ U U  Q y    `p r  `p r  @8`p4@-u`@p-l1Q1-=@A8AM@Q QZi@m mZ@ Zp4mm  ] q0 Yp8  uu m HpFbU}``0B@ D%(0)811)51519`=*=fAAeI@MMU Y4a`apaaaaamaaaaaaaaaaaaaa a a a a!aAYi@mm u@yy@@p JJJ@pXpRFm Y` 06A  X02D  ]e!%`0!.)J!)=-@11z9@==E@I8IU@Y8Yee00i>m>mqiqu`0y@\y`""D @0X@0X@,`0Ap0p t  AQQQqq y    a