Problem in recovering the sequence number when posting an invoice

SOLVED

I have upgraded a new site from v6.5 to v11 and on testing invoice process cycle there are issues with posting transactions as shown below

Table : ACODNUM [ANM]
Key:
No current records
INV0001 Problem in recovering the sequence number () : Nonexistent Sequence Number : Non existant automatic
Problem in recovering the sequence number () : Nonexistent Sequence Number
INV0001 Rollback Following Error in Transaction