Payable Invoice Line Volumes

You can process payable invoices with up to 9,980 lines using Lightning Experience.

Warning:
The maximum supported number of payable invoice lines depends on the other Accounting features enabled in your org and on their complexity. For example:
  • Intercompany Accounts or Intercompany Accounts Receivable (A/R).
  • A local chart of accounts structure.
  • Avalara AvaTax external tax calculation.
  • The Primary (Live) Update balance type. To achieve higher document line volumes, use the Primary (On Demand) Update Balance type. For more information, see About Balance Update.
  • Any custom processes or integrations related to the payable invoices in the org.
  • Note that Salesforce limits the number of lines processed in a single operation to 10,000.

Additionally, you can use Datastream to bulk-load payable invoices with up to 9,980 lines from a spreadsheet. For more information about Datastream, see Datastream Overview.

This table shows the achievable number of payable invoice lines, depending on their type and the additional features enabled.

Note:
The achievable number of lines may vary depending on your org's configuration and the factors mentioned above.
Number of Lines on Payable Invoices for Common Tax and GLA Scenarios
  With Accounting Tax
and On Demand Reporting Balance Update
With Accounting Tax and Live Reporting Balance Update With Local General Ledger Account (GLA) With Avalara AvaTax Tax Calculation
Record Full
Tax Details
is Disabled
Record Full Tax Details
is Enabled (Two Tax Codes Returned)

Create/Save

  • Using Lightning Experience
  • Using API
  • Using Datastream
9980

(Controlled by
Payable Invoice Batch Line Limit)
9980 4990 9980 9980
Post Synchronous
  • Using Lightning Experience
  • Using API
1800

(Controlled by
Payable Invoice Lines Threshold)
1500 1000 100 100
Asynchronous
  • Using Background Posting Scheduler
  • Using API
9980 9940 4990 4900 2400
Discard Synchronous
  • Using Lightning Experience
  • Using API
9980 9980 4990 9980 9980
Amend Synchronous
  • Using Lightning Experience
  • Using API
1300 1300 1300 See the number of lines for posting See the number of lines for posting
Asynchronous Using API 4999 4999 4990 See the number of lines for posting See the number of lines for posting

Convert To Credit Note

Synchronous Using Lightning Experience 750 750 750 See the number of lines for posting See the number of lines for posting
Asynchronous Using Background Posting Scheduler 5200 5200 4990 See the number of lines for posting See the number of lines for posting
Number of Lines on Payable Invoices for Common Intercompany A/R Scenarios
  For Intercompany Account with AutoProcess and AutoPost Enabled For Intercompany Accounts Receivable (A/R) with AutoProcess and AutoPost Enabled
With Intercompany Tax Without Intercompany Tax With Accounting Tax Without Accounting Tax

Create/Save

  • Using Lightning Experience
  • Using API
  • Using Datastream
9980

(Controlled by
Intercompany PIN Batch Line Limit
)
9980

(Controlled by
Intercompany PIN Batch Line Limit
)
2400

(Controlled by
Intercompany A/R PIN Batch Line Limit
)
2400

(Controlled by
Intercompany A/R PIN Batch Line Limit
)
Post Synchronous
  • Using Lightning Experience
  • Using API
1500

(Controlled by
Intercompany PIN Lines Threshold
)
1500

(Controlled by
Intercompany PIN Lines Threshold
)
600

(Controlled by
Intercompany A/R PIN Lines Threshold
)
600

(Controlled by
Intercompany A/R PIN Lines Threshold
)
Asynchronous
  • Using Background Posting Scheduler
  • Using API
9980 9980 2400 2400
Discard Synchronous
  • Using Lightning Experience
  • Using API
9980 9980 2400 2400
Amend Synchronous
  • Using Lightning Experience
  • Using API
1300 1300 1300 1300
Asynchronous Using API 4999 4999 2400 2400

Convert To Credit Note

Synchronous Using Lightning Experience 750 750 750 750
Asynchronous Using Background Posting Scheduler 5200 5200 2400 2400

The following table details limits when posting expenses lines with allocation rules assigned. Create, discard, amend, and other process limits are not changed when applying allocation rules.

This table assumes each expense line creates 10 transaction line items when posting. For example, 150 expense lines creating 1500 transaction line items is supported in synchronous posting.

Number of Lines on Payable Invoices for Allocation Rules on Expense Lines
  With Accounting Tax
and On Demand Reporting Balance Update
With Accounting Tax and Live Reporting Balance Update With Local General Ledger Account (GLA) With Avalara AvaTax Tax Calculation
Record Full
Tax Details
is Disabled
Record Full Tax Details
is Enabled (Two Tax Codes Returned)
Post

Fixed Allocation Rule

(10 split lines)

Synchronous

150

Expense lines

120

Expense lines

100

Expense lines

N/A N/A
Asynchronous

980

Expense lines

900

Expense lines

750

Expense lines

850

Expense lines

800

Expense lines

Statistical Allocation Rule (10 split lines) Synchronous

150

Expense lines

130

Expense lines

N/A N/A N/A
Asynchronous

980

Expense lines

900

Expense lines

N/A

900

Expense lines

800

Expense lines

Notes:
  • Synchronous posting occurs when you post an "In Progress" payable invoice immediately using the Post button. For more information about synchronous posting, see the PIN lines threshold field descriptions in Accounting Settings.
  • Asynchronous posting occurs when you use the Background Posting Scheduler to post payable invoices with the following statuses:
    • Ready to Post
    • Ready to Post and Match
  • For more information about the Background Posting Scheduler, see About the Background Posting Scheduler.