Articles
App Support General Information - Find & Remove SedonaWeb Contact Script
-- This will remove the contact and SedonaWeb user created during the user creation process. This will allow them to recreate the user in order to test the email server setup in their SedonaWeb.
-- First find his Customer Contact ID
-- Rep...
Changing Email Text in SedonaWeb Legacy
While using Sedona Web Legacy, the text of the emails that are sent automatically for account registration like the one above can’t be accessed through Sedona Office. These settings are found in the IIS Server configuration. This should...
SedonaOffice - SQL Script - WS_AP_Setup_GET - Error Fix on SedonaWeb1.0
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WS_AP_Setup_GET]
/* WITH ENCRYPTION */ AS
SELECT * FROM AP_Setup
GO
...
SedonaOffice - SQL Script - WS_Account Error Fix - New Customer Registration - Web 1.0 (2.7.80)
IF EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID(N'[dbo].[WS_Account_Register]') > 0 AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WS_Account_Register]
GO
CREATE PROCEDURE [dbo].[WS_Account_Register]
@customer_number varchar(15),
@in...
Error Adding Payment Methods through SedonaWeb
When a customer tries to add a New Payment Method through their Online Account in SedonaWeb and receives this Error Message
This is most likely due to the Setup of the Payment Methods in Sedona Office.
Sedona Office
Go to Sedona Se...
How to use Octopus for SedonaWeb Endpoint
This would be used in the case that IT does not provide the endpoint or if this is an old project being reactivated
http://alarmbillerdeployment.perennialsoftware.com:8080/octopus/app#/users/sign-in
Step 1: Find Company
1. Sea...
SedonaOffice - SQL Script - Customer_ID reveal for SedonaWeb Duplicate Accounts Error
select c.Customer_Number,c.Customer_Name,ws.* from WS_Account ws
inner join AR_Customer c on c.Customer_Id =ws.Customer_Id
where Account_Name ='the_email.com'
That's what identifies the Customer Number, got that one removed from the cancell...
SedonaCloud - Troubleshooting - Customer unable to register in SedonaWeb 2.0
All information for registration must match what is in the SedonaOffice database in order for a customer to register and make a payment on SedonaWeb2.0.
NOTE: The customer name entered during registration must match the Business_Name OR the...
SedonaWeb 1.0 - Stored Procedure fix for 6.2.09 / 6.2.0.10 Customers
/****** Object: StoredProcedure [dbo].[WS_Account_Register] Script Date: 2/22/2023 3:46:15 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WS_Account_Register]
@customer_number varchar(15),...
SedonaWeb Implementation Process
Contents
Purpose
Process Overview
Locating the Website URL
API vs SedonaWeb Sites
Purpose
SedonaWeb provides a web portal for Bold Product users' customers to conveniently manage their accounts. It provides visib...
SedonaWeb Legacy Users 1st Login to SedonaWeb 2.0
How to Log into Sedona Web 2.0 for the first time:
If you have a Sedona Web Legacy account already, you will need to follow the below steps to log into the new portal using your old account.
Step 1:
Use the ‘Forgot your password?’ lin...
SedonaWeb 2.0 - Linking Customer Accounts
Users may need to view more than one SedonaOffice customer account when logging into SedonaWeb. They can do this by linking multiple customer accounts to the same SedonaWeb 2.0 login. Here are the steps.
Log in to your online account.
...
*OLD* WS_Account Error Fix - New Customer Registration - Web1.0 (2.7.80) Invoice#
IF EXISTS (SELECT * FROM sys.objects WHERE OBJECT_ID(N'[dbo].[WS_Account_Register]') > 0 AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WS_Account_Register]
GO
CREATE PROCEDURE [dbo].[WS_Account_Register]
@customer_number varchar(15),
...
Removing a Users SedonaWeb Legacy Access
Step#1 Open account you want to deactivated from Sedona Web 1.0.
You will de-activate the user, by right clicking on the contact and click Edit.
Step#2 You will put a check mark next to Inactivate Web Login
Step#3 ...
SedonaOffice - SQL Script - Web 2.0 NULL Error - WS_Account Maximum Length
SELECT TABLE_NAME, COLUMN_NAME,DATA_TYPE , CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'dbo' AND
TABLE_NAME = 'WS_Account' AND
COLUMN_NAME = 'Account_Name'
***Should be set to 256...