The Quick Price screen shows up with a blank window as shown in the image below. You can still use the Quick Price screen by clicking on the Products tab, however this tab should be the default window shown when entering Quick Price.

sms-quickprice.jpg

The problem only seems to more often occur when the User Option Company Entry First in Order Entry is enabled, this issue can be caused by several potential causes including:

The CustomerID = 0 record may be missing from the Customer Database Table.

The ContactID = 0 record may be missing from the Contact Database Table.

There may be a customer record with a space as the first character of the Company Name you specify when creating a new customer.

Low.

1. To resolve the problem you'll need to insert the needed records and remove any spaces,
2. Cyrious Technical support is the only personnel that have the tools available to manually edit the database records
3. Contact technical support staff and reference this WIKI article for resolution.

// This query will INSERT TO CustomerID = 0 record.
DELETE FROM "Customer Database"
WHERE CustomerID = 0
;
INSERT INTO "Customer Database"
(CustomerID, StoreID, CompanyName, PrimaryContactID, APContactID, APSameAsPrimary, PricingRatio, Prospect, TaxRegion, ActiveCustomer, PaymentTerms)
VALUES (0,1,'(none)',0,0,'TRUE',1,'TRUE',0,'TRUE',0)
;
// This query will INSERT the ContactID = 0 record.
DELETE FROM "Contact Database"
WHERE ContactID = 0
;
INSERT INTO "Contact Database"
(ContactID, StoreID, CustomerID, LastName, PrimaryContact, ShippingContact, APContact, InvoicingContact, IsActive)
VALUES(0,1,0,'(none)','FALSE','FALSE','FALSE','FALSE','TRUE')
;
// This query will SELECT ALL companies showing
// you the original company name AND the NEW company name which will be SET.
SELECT CompanyName, TRIM(LEADING " " FROM CompanyName) AS NewCompanyName FROM "Customer Database"
WHERE SUBSTRING(CompanyName FROM 1 FOR 1) = ' '
;
// This query will remove ALL LEADING spaces FROM the Company Name.
UPDATE "Customer Database"
SET CompanyName = TRIM(LEADING " " FROM CompanyName)
WHERE SUBSTRING(CompanyName FROM 1 FOR 1) = ' '
;

• Reported : 6/9/2010