Hello, for most of our company expense reports, employees are using their corporate credit cards. However, our accounting department still has to manually create credit card transaction records that correspond to each expense report, since expense reports have no GL impact. They're asking if this can be automated. Unfortunately, it doesn't seem like you can transform an expense report into a credit card statement using SuiteScript. Is there a way of doing this natively in NetSuite or else using SuiteScript without copying each transaction line item from one record to the other one at a time? I'm not adverse to doing the latter, I was just wondering if there was an easier way.

Hi @rmhollands. The workaround that I came up with was to create additional employees records to be used as each employee's "credit card employee record". These are dummy records that dont need access. Then had a check box on the expense report to mark that it was a credit card expense report. When this was ticked it kicked off a workflow on save that swapped out the employee with their credit card employee. This means that the total credit card expense sits against that CC employee and the direct debit or payment can be put to that record when paid. Means aswell that it has been posted to the P&L. Dont need to use the credit card transaction then at all.