Too many distributions on this invoice" in Sage 50
Sage 50 is telling you the invoice has more distribution lines than the program can store, so it refuses to save or post it.
If Sage 50 shows you “There are too many distributions on this invoice.”, it means the invoice has hit an internal limit on how many distribution lines a single transaction can hold. A distribution is each line that touches the general ledger: an expense line, a sales line, a tax line, a discount, a freight charge. Sage 50 caps how many of those one invoice may contain. It is not a comment on your data being wrong, and it is not corruption. It is a hard ceiling, and the program will not save past it.
Why it happens
The usual cause is a very large invoice. Consolidated customer bills, a month of service lines on one sales invoice, or an imported invoice with hundreds of detail rows will all push the count up. Each line plus its tax split counts toward the total, so the real number is often higher than the lines you can see on screen.
It also shows up during data conversion. When invoices are brought into Sage 50 from another product, or from a third-party import tool, a single source document can carry more rows than Sage 50 was built to accept. The import fails on that one invoice and reports this message.
Split the invoice
The safest fix is to split the invoice into two or more smaller ones. Post the first batch of lines as one invoice and the rest as a second, keeping the same customer and dates. The accounting result is identical. The only real cost is that the customer sees two documents instead of one, and your receivables aging will show two open items until payment arrives.
If the invoice is a recurring consolidated bill, consider whether the detail belongs on a statement instead. A summary invoice with the detail attached outside the books often works better for very large bills.
Reduce the number of lines
Before splitting, look for lines you can collapse. Repeated small charges for the same item can often be merged into one line with a quantity. Tax and freight lines that were entered as separate items may be better handled by the built-in tax and shipping fields, which count differently than manual lines. Fewer, larger lines mean fewer distributions.
When it appears during a conversion
If the message appears while converting data into Sage 50, or while importing invoices, the source document simply exceeds what a single Sage 50 transaction can hold. Splitting it by hand after import is one option. Where there are many such invoices, our engineers can split them automatically during the conversion so each lands under the limit. That is routine work in a Sage 50 to QuickBooks conversion or a Sage-to-Sage migration, and the same applies to the Canadian edition.
When the count looks wrong
Sometimes the invoice does not look that big, yet the message still appears. That can mean hidden distribution rows, such as per-line tax splits or rounding entries, are inflating the count. It can also mean the file itself is damaged and the count is being read incorrectly. If the invoice is small and the message persists, the file needs professional attention rather than more editing. Our engineers can inspect it and tell you which case you are in; a free evaluation of your Sage 50 file settles the question quickly.
A useful next step
Count the lines on the offending invoice, tax included. If the count is genuinely large, split it. If it is small, stop editing and send the file for evaluation before the problem spreads to other transactions.