I have inserted a record into SLX Account Table but it is not visible in SLX.  I did make it to the table as I can query it.  

Are there minimum requirements for a new record.  

A am doing the following.  

1.  Generating any new IDs correctly with the NewID function

2.  I have only put in the Account Record, and just wanted to test to see if things are working.  so there is no Contact or other record.  

Are there requirements for a SLX record to appear.

Thanks

Tim 

Here is what went in. 

Ooops, sorry about the table

Here's the data

ACCOUNTID A6UJ9A0000QG

TYPE Customer

ACCOUNT anyanwu margret

DIVISION NULL

SICCODE NULL

PARENTID NULL

DESCRIPTION NULL

ADDRESSID a6UJ9A0001HY

SHIPPINGID a6UJ9A0001HY

REGION NULL

MAINPHONE 8565136227

ALTERNATEPHONE NULL

FAX NULL

TOLLFREE NULL

TOLLFREE2 NULL

OTHERPHONE1 NULL

OTHERPHONE2 NULL

OTHERPHONE3 NULL

EMAIL NULL

EMAILTYPE NULL

WEBADDRESS NULL

SECCODEID SYST00000001

REVENUE NULL

EMPLOYEES NULL

INDUSTRY NULL

CREDITRATING NULL

NOTES NULL

STATUS Active

ACCOUNTMANAGERID            

REGIONALMANAGERID NULL

DIVISIONALMANAGERID NULL

NATIONALACCOUNT NULL

TARGETACCOUNT NULL

TERRITORY NULL

CREATEUSER ADMIN       

MODIFYUSER ADMIN       

CREATEDATE 16:36.0

MODIFYDATE 16:36.0

ACCOUNT_UC ANYANWU MARGRET

AKA NULL

CURRENCYCODE NULL

INTERNALACCOUNTNO NULL

EXTERNALACCOUNTNO NULL

PARENTACCOUNTNO NULL

ALTERNATEKEYPREFIX NULL

ALTERNATEKEYSUFFIX NULL

DEFAULTTICKETSECCODEID NULL

NOTIFYDEFECTS NULL

NOTIFYONCLOSE NULL

NOTIFYONSTATUS NULL

SHORTNOTES NULL

USERFIELD1 NULL

USERFIELD2 NULL

USERFIELD3 NULL

USERFIELD4 NULL

USERFIELD5 NULL

USERFIELD6 NULL

USERFIELD7 NULL

USERFIELD8 NULL

USERFIELD9 NULL

USERFIELD10 NULL

CAMPAIGNID NULL

DONOTSOLICIT NULL

SCORE NULL

TICKER NULL

SUBTYPE NULL

LEADSOURCEID LQF8AA000000

IMPORTSOURCE NULL

ENGINEERID NULL

SALESENGINEERID NULL

RELATIONSHIP NULL

LASTHISTORYBY NULL

LASTHISTORYDATE NULL

BUSINESSDESCRIPTION NULL

WEBADDRESS2 NULL

WEBADDRESS3 NULL

WEBADDRESS4 NULL

Tim, you are missing an address record (must be populated). Link to a new address row (a6UJ9A0001HY). Also, you should populate ACCOUNTSUMMARY as well (just name, same seccodeid). You should not populate any cols that you want to be Null (not sure if this is the column, or what you populated?). Ideally, populate AccountManagerID - not strictly necessary, but best if you do.

Excellent, that's what I needed to know.  Thanks so much for pointing me in the right direction. 

Tim 

Actually on the WEB the AccountMAnagerId must be populated due to the join to the UserInfo table to display the Account Manager's Name in the Account Detail Screen......if it's NULL then you will get an error message and never be able to get to the Account Detail View.