Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Vendor invoice CSV import with custom tax
Hello Guru's,
I have created a CSV import for our employee credit card statements. The import works great and is very quick and easy for everyone. The one issue I have run into is with the tax.....
In Canada, we have a GST of 5% on everything except for essential groceries and other random things. When it comes to the accounting side, we can only claim 50% of the GST on entertainment or dining. I can't simply have a tax code in NetSuite that takes everything into account.
The easiest thing I have been able to come up with is for the cardholder that is doing the expenses, to enter the GST from the receipt into a field on a data entry page. They also select the Expense Category, and if it is entertainment, the GST will be reduced by 50% and the difference added back to the subtotal.