G/L accounts - Not able to add nor work in G/L Transactions Journals.

SOLVED

The problem is generating this message :

When attempting to add a new GL account, and the following screen on the General Ledger Journal Transactions screen:

Cashbook batches and invoicing all works. 

I can see the properties of this Table don't carry enough allow NULL values say compared to the same file table in another set of data on the Same Version V910.2 also in SAGE 100.

But we did not have this problem in the V9.10.1 version.  I am not sure how to Drop and create a new file.

All these datasets (for one site/customer) were converted from Partner V18 Data.  Also from the beginning I get the message that I can not upgrade these Datasets whilst attached to a SAGE 100 Common License - I have to attach them to a SAGE 200 Common, perform the upgrade, then re-attach to the Customers SAGE100 COMMON.  I think this latter is a licensing problem.