• Unable to edit the zero record
• 'xxx.xxx' is not a valid timestamp

High. User is not down.

If the error occurs when viewing a customer record, the TaxIDExpDate field is the wrong field type.

1. Rename the Customer Database files (.DB, .MB, .PX, .XGx, etc.) to oldCustomer Database.
2. Copy a fresh blank Customer Database table.
   1. Open the DBBrowser and change the Version to 8.0 in the Store Information table
   2. Close the DBBrowser
   3. Open the SSLIP
   4. Open SMS - this should update the Customer table to the correct fields
   5. Close Cyrious and the SSLIP
3. Run the query below to copy the data into the new table. *Note: Some fields may need to added or removed from the query depending on the version of SMS currently running.

INSERT INTO 'customer database'
SELECT
CAST(CustomerID AS INTEGER) AS CustomerID,
CAST(StoreID AS INTEGER) AS StoreID,
CAST(CompanyName AS CHAR(50)) AS CompanyName,
CAST(Department AS CHAR(30)) AS Department,
CAST(PrimaryContactID AS INTEGER) AS PrimaryContactID,
CAST(APContactID AS INTEGER) AS APContactID,
CAST(APSameAsPrimary AS BOOLEAN) AS APSameAsPrimary,
CAST(SalesPersonID AS INTEGER) AS SalesPersonID,
CAST(PricingRatio AS NUMERIC) AS PricingRatio,
CAST(BillingAddress1 AS CHAR(30)) AS BillingAddress1,
CAST(BillingAddress2 AS CHAR(30)) AS BillingAddress2,
CAST(City AS CHAR(20)) AS City,
CAST(State AS CHAR(25)) AS State,
CAST(Zip AS CHAR(25)) AS Zip,
CAST(County AS CHAR(20)) AS County,
CAST(Country AS CHAR(10)) AS Country,
CAST(CustomerTypeID AS INTEGER) AS CustomerTypeID,
CAST(IndustryTypeID AS INTEGER) AS IndustryTypeID,
CAST(OutstandingBalance AS Money) AS OutstandingBalance,
CAST(ChargeAccount AS BOOLEAN) AS ChargeAccount,
CAST(CreditLimit AS Money) AS CreditLimit,
CAST(CreditLimitUsed AS Money) AS CreditLimitUsed,
CAST(CreditBalance AS Money) AS CreditBalance,
CAST(TaxExempt AS BOOLEAN) AS TaxExempt,
CAST(TaxExemptNumber AS CHAR(20)) AS TaxExemptNumber,
CAST(AlternateStateTax AS NUMERIC) AS AlternateStateTax,
CAST(AlternateCountyTax AS NUMERIC) AS AlternateCountyTax,
CAST(CreditCardNumber AS CHAR(30)) AS CreditCardNumber,
CAST(CreditCardType AS INTEGER) AS CreditCardType,
CAST(CreditCardExp AS DATE) AS CreditCardExp,
Notes,
CAST(Prospect AS BOOLEAN) AS Prospect,
CAST(CreateDate AS DATE) AS CreateDate,
CAST(ImportBatch AS CHAR(12)) AS ImportBatch,
CAST(FirstOrderDate AS DATE) AS FirstOrderDate,
CAST(LastOrderDate AS DATE) AS LastOrderDate,
CAST(LastPickedUpDate AS DATE) AS LastPickedUpDate,
CAST(LastEstimateDate AS DATE) AS LastEstimateDate,
CAST(LastStatementDate AS DATE) AS LastStatementDate,
CAST(LastContact1 AS TIMESTAMP) AS LastContact1,
CAST(LastContact2 AS TIMESTAMP) AS LastContact2,
CAST(LastContact3 AS TIMESTAMP) AS LastContact3,
CAST(LastContact4 AS TIMESTAMP) AS LastContact4,
CAST(LastContact5 AS TIMESTAMP) AS LastContact5,
CAST(TaxRegion AS INTEGER) AS TaxRegion,
CAST(ImportDate AS TIMESTAMP) AS ImportDate,
Flags,
CAST(ActiveCustomer AS BOOLEAN) AS ActiveCustomer,
CAST(PaymentTerms AS INTEGER) AS PaymentTerms,
CAST(UserField1 AS CHAR(30)) AS UserField1,
CAST(UserField2 AS CHAR(30)) AS UserField2,
CAST(LastContactDate AS TIMESTAMP) AS LastContactDate,
CAST(MarketingFlag6 AS TIMESTAMP) AS MarketingFlag6,
CAST(MarketingFlag7 AS TIMESTAMP) AS MarketingFlag7,
CAST(MarketingFlag8 AS TIMESTAMP) AS MarketingFlag8,
CAST(MarketingFlag9 AS TIMESTAMP) AS MarketingFlag9,
CAST(MarketingFlag10 AS TIMESTAMP) AS MarketingFlag10,
CAST(MarketingFlag11 AS TIMESTAMP) AS MarketingFlag11,
CAST(MarketingFlag12 AS TIMESTAMP) AS MarketingFlag12,
CAST(MarketingFlag13 AS TIMESTAMP) AS MarketingFlag13,
CAST(MarketingFlag14 AS TIMESTAMP) AS MarketingFlag14,
CAST(MarketingFlag15 AS TIMESTAMP) AS MarketingFlag15,
MktgList1,
MktgList2,
CAST(ChargeStatusDate AS TIMESTAMP) AS ChargeStatusDate,
CAST(PORequired AS BOOLEAN) AS PORequired,
CAST(MarketingFlag16 AS TIMESTAMP) AS MarketingFlag16,
CAST(MarketingFlag17 AS TIMESTAMP) AS MarketingFlag17,
CAST(MarketingFlag18 AS TIMESTAMP) AS MarketingFlag18,
CAST(MarketingFlag19 AS TIMESTAMP) AS MarketingFlag19,
CAST(MarketingFlag20 AS TIMESTAMP) AS MarketingFlag20,
CAST(MarketingFlag21 AS TIMESTAMP) AS MarketingFlag21,
CAST(MarketingFlag22 AS TIMESTAMP) AS MarketingFlag22,
CAST(MarketingFlag23 AS TIMESTAMP) AS MarketingFlag23,
CAST(MarketingFlag24 AS TIMESTAMP) AS MarketingFlag24,
CAST(MarketingFlag25 AS TIMESTAMP) AS MarketingFlag25,
URL,
CAST(TaxIDExpDate AS DATE) AS TaxIDExpDate,
IsCCEncrypted,
CCNumber,
Vcode,
ccnameoncard,
sendbillingaddress,
sendcompanyaddress,
altbillingaddress1,
altbillingaddress2,
altbillingcity,
altbillingstate,
altbillingzip,
altbillingcounty,
modifiedbycomputer,
modifieddate,
cccscustomerguid
FROM "oldCustomer Database"

• Reported : 02/10/2010
• Version(s): 08.90.xxxx.xxxx
• Fixed in : n/a