2021-07 Endeavor
General
Users can now enable functionality in the Quoter integration to have Quoter generate new products in TBS and assign charges to those products. For a new product to be generated, the Category field on the Quoter line item must match a TBS Product Type. There must be a Template Product for any product type that will be replicated. To identify the Template Product that should be used, the Additional Information field must have "Quoter" in it.
When a new product is created, the line item will be added as a charge on that product. If the Category and Product Type do not match or the Product Type does not have a corespondent Template Product, the line item will be added as a charge to the customer's Account Level Charges.
The Use Quoter Category To Replicate Products box on the Company setup page must be checked to enable this functionality.
LOCATION: Setup / Company Settings / Add or Edit Company / Integrations section / Use Quoter Category To Replicate Products
LOCATION: Orders / Inventory / Order Details / Milestones
A Milestones tab has been added to TBS Orders. The Milestones section lists 7 milestones, each with a customizable Status field and a date field. The Milestones tab is only available to Employees and requires edit permissions on Orders to modify.
TBS can now send payment confirmation emails for NACHA payments.
The Quoter integration will check the TBS Account Number field in Quoter to see if there is a corresponding customer account number in TBS. If a matching account number is found, the integration will not create a new customer. If the field is blank or there is no matching account number in TBS, then a new customer will be created.
When a customer that has the same name as an existing TBS customer is imported from Quoter, a number will be appended to the end of the name. This allows the customer from Quoter to be added to TBS and assigned the correct payment profile and funds.
Examples of formatting are:
-
John Doe
-
John Doe (1)
-
John Doe (2)
Tasks
The Contact Email and Notification Email fields on Tasks have been expanded from 255 characters to 500 characters.
Resolved Issues
-
General
- The accuracy of the TBS Quick Search has been improved. (343596)
-
Integrations
-
For the Quoter integration with TBS, add on quotes will no longer generate a new customer in the system. In previous releases, when a prefix or group was not assigned, a customer would still be created and assigned to the default group set in TBS. (333695)
-
Release Database Changes
These are the differences that will be made to your existing database when upgrading to version 77.00.
NOTE: Also see BillHistoryV2 changes below.
The following fields have been dropped:
-
None
The following fields have been altered:
- None
The following tables and views have been added:
-
PayaChargebacks
-
PayaSettlements
-
PayaSettlementsView
-
PayaStatements
-
PayaTransactions
-
PayaTransactionsView
-
PayaUngroupedSettlementsView
The following fields have been added:
-
Company.UseQuoterCategoryToReplicateProducts
-
PayaChargebacks.PayaChargebacksKey
-
PayaChargebacks.AccountSuffix
-
PayaChargebacks.Activity
-
PayaChargebacks.ActivityDate
-
PayaChargebacks.Affiliate
-
PayaChargebacks.ARN
-
PayaChargebacks.AssignedTo
-
PayaChargebacks.AssignedToUserType
-
PayaChargebacks.AuthAmt
-
PayaChargebacks.AuthCurrency
-
PayaChargebacks.AuthDate
-
PayaChargebacks.BatchID
-
PayaChargebacks.BillingDescriptor
-
PayaChargebacks.Bin
-
PayaChargebacks.Campaign
-
PayaChargebacks.CaseID
-
PayaChargebacks.ChargebackAmt
-
PayaChargebacks.ChargebackCurrency
-
PayaChargebacks.CreatedDate
-
PayaChargebacks.CustomerID
-
PayaChargebacks.Cycle
-
PayaChargebacks.DateIssued
-
PayaChargebacks.DateMethod
-
PayaChargebacks.DateReceived
-
PayaChargebacks.GravityFTPFileID
-
PayaChargebacks.IssuingBank
-
PayaChargebacks.IssuingBankCountryCode
-
PayaChargebacks.MerchantGroupingID
-
PayaChargebacks.MerchantID
-
PayaChargebacks.MerchantName
-
PayaChargebacks.MerchantOrderNumber
-
PayaChargebacks.MerchantTransactionID
-
PayaChargebacks.PaymentType
-
PayaChargebacks.Presenter
-
PayaChargebacks.ReasonCode
-
PayaChargebacks.ReasonDescription
-
PayaChargebacks.ReplyByDate
-
PayaChargebacks.ReportingGroup
-
PayaChargebacks.SessionID
-
PayaChargebacks.SettlementDate
-
PayaChargebacks.SourceFile
-
PayaChargebacks.SourceLine
-
PayaChargebacks.TransactionDate
-
PayaChargebacks.TransactionPurchaseAmt
-
PayaChargebacks.TransactionPurchaseCurrency
-
PayaChargebacks.TransactionSettlementAmt
-
PayaChargebacks.TransactionSettlementCurrency
-
PayaChargebacks.TxnSecondaryAmt
-
PayaChargebacks.TxnSecondarySettlementAmt
-
PayaChargebacks.TxnType
-
PayaChargebacks.PayaPaymentID
-
PayaSettlements.PayaSettlementsKey
-
PayaSettlements.CreatedDate
-
PayaSettlements.SourceFile
-
PayaSettlements.SourceLine
-
PayaSettlements.Total
-
PayaSettlements.Batch
-
PayaSettlements.VisaSaleAmount
-
PayaSettlements.VisaRefundAmount
-
PayaSettlements.VisaRefundCount
-
PayaSettlements.VisaTotal
-
PayaSettlements.VisaDepositCount
-
PayaSettlements.MastercardSaleAmount
-
PayaSettlements.MastercardRefundAmount
-
PayaSettlements.MastercardRefundCount
-
PayaSettlements.MastercardTotal
-
PayaSettlements.MastercardDepositCount
-
PayaSettlements.DiscoverSaleAmount
-
PayaSettlements.DiscoverRefundAmount
-
PayaSettlements.DiscoverRefundCount
-
PayaSettlements.DiscoverTotal
-
PayaSettlements.DiscoverDepositCount
-
PayaSettlements.AmexSaleAmount
-
PayaSettlements.AmexRefundAmount
-
PayaSettlements.AmexRefundCount
-
PayaSettlements.AmexTotal
-
PayaSettlements.AmexDepositCount
-
PayaSettlements.OtherSaleAmount
-
PayaSettlements.OtherRefundAmount
-
PayaSettlements.OtherTotal
-
PayaSettlements.LocationID
-
PayaSettlements.ActivityDate
-
PayaSettlements.ACHDepositAmount
-
PayaSettlements.ACHDepositCount
-
PayaSettlements.ACHRefundAmount
-
PayaSettlements.ACHRefundCount
-
PayaSettlements.AmexChargebackAmount
-
PayaSettlements.AmexChargebackCount
-
PayaSettlements.DiscoverChargebackAmount
-
PayaSettlements.DiscoverChargebackCount
-
PayaSettlements.MastercardChargebackAmount
-
PayaSettlements.MastercardChargebackCount
-
PayaSettlements.VisaChargebackAmount
-
PayaSettlements.VisaChargebackCount
-
PayaSettlements.ACHReturnAmount
-
PayaSettlements.ACHReturnCount
-
PayaSettlementsView.CreatedDate
-
PayaSettlementsView.Total
-
PayaSettlementsView.CardDepositAmount
-
PayaSettlementsView.CardDepositCount
-
PayaSettlementsView.CardRefundAmount
-
PayaSettlementsView.CardRefundCount
-
PayaSettlementsView.CardChargebackAmount
-
PayaSettlementsView.CardChargebackCount
-
PayaSettlementsView.LocationID
-
PayaSettlementsView.ActivityDate
-
PayaSettlementsView.Batch
-
PayaSettlementsView.ACHDepositAmount
-
PayaSettlementsView.ACHDepositCount
-
PayaSettlementsView.ACHRefundAmount
-
PayaSettlementsView.ACHRefundCount
-
PayaSettlementsView.ACHReturnAmount
-
PayaSettlementsView.ACHReturnCount
-
PayaStatements.PayaStatementsKey
-
PayaStatements.Filename
-
PayaStatements.AWSKey
-
PayaStatements.Description
-
PayaStatements.CreatedDate
-
PayaStatements.LocationID
-
PayaTransactions.PayaTransactionsKey
-
PayaTransactions.CreatedDate
-
PayaTransactions.SourceFile
-
PayaTransactions.SourceLine
-
PayaTransactions.GravityFTPFileID
-
PayaTransactions.TransactionID
-
PayaTransactions.PaymentMethod
-
PayaTransactions.AccountVaultID
-
PayaTransactions.RecurringID
-
PayaTransactions.FirstSix
-
PayaTransactions.LastFour
-
PayaTransactions.IssuingBank
-
PayaTransactions.AccountHolderName
-
PayaTransactions.TransactionAmount
-
PayaTransactions.Description
-
PayaTransactions.TransactionCode
-
PayaTransactions.AVS
-
PayaTransactions.Batch
-
PayaTransactions.OrderNum
-
PayaTransactions.Verbiage
-
PayaTransactions.TransactionSettlementStatus
-
PayaTransactions.EffectiveDate
-
PayaTransactions.Routing
-
PayaTransactions.ReturnDate
-
PayaTransactions.CreatedTS
-
PayaTransactions.ModifiedTS
-
PayaTransactions.TransactionAPIID
-
PayaTransactions.TermsAgree
-
PayaTransactions.NotificationEmailAddress
-
PayaTransactions.NotificationEmailSent
-
PayaTransactions.ResponseMessage
-
PayaTransactions.AuthAmount
-
PayaTransactions.AuthCode
-
PayaTransactions.StatusID
-
PayaTransactions.TypeID
-
PayaTransactions.LocationID
-
PayaTransactions.ReasonCodeID
-
PayaTransactions.ContactID
-
PayaTransactions.BillingZip
-
PayaTransactions.BillingStreet
-
PayaTransactions.ProductTransactionID
-
PayaTransactions.Tax
-
PayaTransactions.CustomerIP
-
PayaTransactions.CustomerID
-
PayaTransactions.PONumber
-
PayaTransactions.AVSEnhanced
-
PayaTransactions.CVVResponse
-
PayaTransactions.BillingPhone
-
PayaTransactions.BillingCity
-
PayaTransactions.BillingState
-
PayaTransactions.ClerkNumber
-
PayaTransactions.TipAmount
-
PayaTransactions.CreatedUserID
-
PayaTransactions.ModifiedUserID
-
PayaTransactions.ACHIdentifier
-
PayaTransactions.CheckNumber
-
PayaTransactions.SettleDate
-
PayaTransactions.ChargeBackDate
-
PayaTransactions.VoidDate
-
PayaTransactions.AccountType
-
PayaTransactions.IsRecurring
-
PayaTransactions.IsAccountvault
-
PayaTransactions.TransactionC1
-
PayaTransactions.TransactionC2
-
PayaTransactions.TransactionC3
-
PayaTransactions.TerminalSerialNumber
-
PayaTransactions.EntryModeID
-
PayaTransactions.TerminalID
-
PayaTransactions.QuickInvoiceID
-
PayaTransactions.ACHSecCode
-
PayaTransactions.CustomData
-
PayaTransactions.HostedPaymentPageID
-
PayaTransactions.TRXSourceID
-
PayaTransactions.TransactionBatchID
-
PayaTransactions.CheckinDate
-
PayaTransactions.CheckoutDate
-
PayaTransactions.RoomNum
-
PayaTransactions.RoomRate
-
PayaTransactions.AdvanceDeposit
-
PayaTransactions.NoShow
-
PayaTransactions.EMVReceiptData
-
PayaTransactions.StatusTitle
-
PayaTransactions.TypeTitle
-
PayaTransactions.AllTags
-
PayaTransactions.QuickInvoice
-
PayaTransactions.CreatedUserUsername
-
PayaTransactions.LocationName
-
PayaTransactions.ProductTransactionTitle
-
PayaTransactionsView.LocationID
-
PayaTransactionsView.ActivityDate
-
PayaTransactionsView.Type
-
PayaTransactionsView.Status
-
PayaTransactionsView.TransactionID
-
PayaTransactionsView.PaymentMethod
-
PayaTransactionsView.Batch
-
PayaTransactionsView.PaymentType
-
PayaTransactionsView.TransactionAmount
-
PayaTransactionsView.CustomersKey
-
PayaTransactionsView.AccountNumber
-
PayaTransactionsView.CustomerName
-
PayaUngroupedSettlementsView.PayaSettlementsKey
-
PayaUngroupedSettlementsView.CreatedDate
-
PayaUngroupedSettlementsView.Total
-
PayaUngroupedSettlementsView.CardDepositAmount
-
PayaUngroupedSettlementsView.CardDepositCount
-
PayaUngroupedSettlementsView.CardRefundAmount
-
PayaUngroupedSettlementsView.CardRefundCount
-
PayaUngroupedSettlementsView.CardChargebackAmount
-
PayaUngroupedSettlementsView.CardChargebackCount
-
PayaUngroupedSettlementsView.LocationID
-
PayaUngroupedSettlementsView.ActivityDate
-
PayaUngroupedSettlementsView.Batch
-
PayaUngroupedSettlementsView.ACHDepositAmount
-
PayaUngroupedSettlementsView.ACHDepositCount
-
PayaUngroupedSettlementsView.ACHRefundAmount
-
PayaUngroupedSettlementsView.ACHRefundCount
-
PayaUngroupedSettlementsView.ACHReturnAmount
-
PayaUngroupedSettlementsView.ACHReturnCount
-
T4CompanyMaster.RestServiceUserID
-
T4CompanyMaster.RestServiceUserPassword
-
TransactionsView.CreditRollupTopLevelKey
-
WebhookRequests.AdditionalInfo
The following fields have been dropped:
-
None
The following fields have been altered:
- None
The following tables and views have been added:
-
None
The following fields have been added:
-
None