Amount Paid on the Invoice did not coincide on the Total Revenue field value of the Custom Sales by Customer Detail - Cash Basis.

Scenario:

 

·        Customer's invoice has an item line amouting to $14,000 with sales tax amount (Tax Code: NY_NASSAU CO_BGGY = 8.625%) of $1,207.50. 

 

·        The said invoice was partially paid for $14,000 via check. 

 

·         However, when the user ran the Custom Sales by Customer Detail - Cash Basis report, the Total Revenue only showed $12,888.38 and not $14,000.

 

 

Steps to create the Custom Sales by Customer Detail - Cash Basis report:

 

·         Navigate to Reports > Sales > Sales by Customer > Customize Detail. 

 

·         Go to the Filters page and set the appropriate period. 

 

·         Then, in the More Options page, mark the Cash Basis box.

 

·         Click Preview or Save.

  

 

 

Solution/Workaround/Gotcha/Recommendation Details:

 

 

     

·         The Sales by Customer report does not include sales tax. 

 

·         When the report was set to Cash Basis = True, the Total Revenue field value will show the amount paid on the invoice except when the invoice includes a sales tax amount greater than 0.00.

 

·         If the invoice includes a sales tax amount greater than 0.00, NetSuite will allocate the partially paid invoice.  See calculation below:

 

       Item                  $14,000.00 (92.05983889%)*
Tax (8.625%)      1,207.50 (7.940161104%)**
Total                   $15,207.50 (100%)

  *14000 / 15207.50 = 92.05983889%
**1207.5/15207.50 = 7.940161104%

Amount Paid $14,000 x 92.05983889% = $12,888.38