Skip to main content
Avalara Help Center

Why am I getting Lines is expected to be between 1 and 1000 in SalesForce?

Overview

You are attempting to calculate tax but the error "Lines is expected to be between 1 and 1000" is occurring, and you cannot calculate tax.

Environment

Avalara AvaTax for Salesforce

Resolution

  • This indicates that there are no Products on the quote/opportunity/contract being sent to Avalara:
    • In SalesForce it is possible to see an amount listed in customized value fields but amounts for tax calculation are sent to Avalara only from the Products themselves. 
    • Add all Products needed for the sale and calculate again

 

Note: This error will also occur if there are more than 1,000 products included (separate lines, not quantity per line). If the number of products exceeds 1,000, split it into multiple quotes, opportunities, etc. for processing.