Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Tax per transaction line
I have an issue with VAT reporting. I’ve been trying to use PowerBI to do the tax reporting as we cant get all the fields from saved search.
The reporting works apart from that the VAT is group for each transaction and put onto 1 line
By this I mean if the vendor bill is posted to multiple accounts/cost centres etc and there are 5 lines each with £20 VAT, then you just get one line on the transactions/transactionline/transactionaccountingline table with £100 VAT against the VAT account code eg its not split between each cost centre etc.
I suspect if we had Suite tax then the tax tables would be available and I’d be able to get this information., but we dont. Are my assumptions correct?
Tagged:
0