Oh the woes of importing old databases (-: Turns out everything was importing great, but since the old sales slip table was flat with repeating fields and allowed the client to type in address info in the table without creating a client.... well I'm sure you get the picture. There were about a 100 records without clients because they had been hand entered and the same thing was happening in the repeating fields themselves where the product info should have been pulled from the products database, however sometimes the client typed in their own products and pricing... screws imports totally up. Suffice it to say that the new version does not allow anything of this (-: Wasn't going to anyway.
Still good to know that it doesn't require a lot of complicated stuff. Just pull the repeating fields into the line items databse without automatically adding sn numbers etc. and after you've done that you can import the rest of the sales slip into the new sales slip table and everything shows up in the portal automatically! Too cool