Hi Olivier, the link you provided is to the ACCOUNTS table, which are the GL and Statistical accounts, nothing in that table relates to the Record Types. Did you possibly paste the wrong link? Thanks

Thank you for responses.Usually, by morning I've figured things out but this is a bugger. FYI, I have been working with the full schema diagram of the Revenue Recognition process, and primarily sourcing the [TransactionLines] table. I've got the full model built and working perfectly. I'm finding all "Transaction Types"…

I got this working, the problem I believe is because I wrote the formulas in Word and pasted them into NetSuite. I noticed the single quotes looked different than the ones in NetSuite and believe that is was simply not recognizing the character. Has anyone else ever experienced issues pasting formulas from Word? Is there a…

Still haven't figured this out but ran into an unexpected issue with sourcing the contact from the Customer in that the Contact's Name is prefaced with the Customer's Name ie: "ABC Co : John Doe". which is not really what I wanted. With the Customer name and the Contact names concatenated like that NetSuite doesn't allow…

Nevermind, Just realized I didn't have the field set to be in-line, its working fine now. Thanks