Wednesday, October 31, 2018

Purchase and Sales By Tax Code Reports throw "Report Execution Error" if VAT/GST Amount Reaches Ten Billion (10,000,000,000.00)

Error is happening to the following saved reports included in the International Tax Reports bundle (ID=14864) :

  •   Purchase By Tax Code (Summary) 
  •   Sales by Tax Code (Detail) 
  •   Sales By Tax Code (Summary) 
  •   Purchase By Tax Code (Detail)

The reports above are saved reports included in the International Tax Reports bundle (ID=14864) 

This occurs if the VAT/GST amount reaches 10,000,000,000.00 the report errors with "Report Execution Error: NetSuite has encountered an error while generating your report. Please click here to notify support." The error log shows "value larger than specified precision allowed for this column". This kind of transaction is most probably entered by mistake. It is very unlikely that a transaction tax will amount to more than ten billion.

To resolve, user needs to search for all transactions where tax amount reaches 10,000,000,000.00 and correct the amount

To create the Saved Search:

1. Navigate to Lists > Search > Saved Searches > New > Transaction   
2. Include these filters under the Criteria tab > Standard subtab:
Posting is true  
Account is any of VAT on Purchases, VAT on Sales, xVAT on Purchases  
Amount is greater than or equal to 10000000000.00
3. Include these fields under the Results tab > Columns subtab:
  • Date
  • Number
  • Name 
  • Amount

4. Preview

Once user has identified all the affected transactions, he can then correct the tax amounts.

Note: This is addressed by enhancement 214243