Microsoft Dynamics GP: Common Issues on Sales Transaction Entry

This page is a running reference for the errors that come up most often in Microsoft Dynamics GP → Sales Transaction Entry (Transactions >> Sales >> Sales Transaction Entry). Each section lists the exact message you will see on screen, why GP raises it, and the steps to clear it. Find your message in the list below and jump straight to it.

Jump to an issue

1. One or more line items contain warnings or errors. / Distribution account(s) are missing or invalid
2. The accounts receivable distribution(s) does not equal the actual amount
3. Account is empty. Do you want to save changes with errors?
4. Tax codes are not showing

Issue 1 — One or more line items contain warnings or errors

What you see

One or more line items contain warnings or errors.

On the edit list or when you click the warning icon beside the line, the detail reads:

Distribution account(s) are missing or invalid.
ERROR: Line accounts are missing or invalid.

A small warning symbol appears against one or more lines in the scrolling window, and the document will not post.

Why it happens

GP builds the General Ledger distributions for every sales line from a set of default posting accounts. If any account it needs is blank, inactive or has been deleted, GP flags the line rather than guessing. The account can be missing from the item card, the customer card, or the company-wide posting defaults.

How to fix it

1. Find out which account is missing. With the document open, print the edit list (the printer icon in Sales Transaction Entry, or Transactions >> Sales >> Sales Batches for the whole batch). The edit list names the exact line and the exact account type that is blank — do this first, it saves a lot of guesswork.
2. Check where GP is pulling accounts from. Open the Sales Order Processing Setup window (Microsoft Dynamics GP >> Tools >> Setup >> Sales >> Sales Order Processing) and look at Posting Accounts From. It is set to either Item or Customer, and that tells you which master record to correct.
3. If it is set to Item — open Item Account Maintenance (Cards >> Inventory >> Account), select the item on the failing line, and fill in every blank account: Inventory, Inventory Offset, Cost of Goods Sold, Sales, Markdown, Sales Returns, In Use, In Service, Damaged and Drop Ship Items.
4. If it is set to Customer — open Customer Maintenance (Cards >> Sales >> Customer), select the customer and click the Accounts button. Fill in Accounts Receivable, Sales, Cost of Sales, Inventory, Terms Discount Taken, Terms Discount Available, Finance Charges and Writeoffs.
5. If the line is a non-inventoried item — there is no item card to read, so GP falls back to the company defaults. Open Posting Accounts Setup (Microsoft Dynamics GP >> Tools >> Setup >> Posting >> Posting Accounts), set Display to Sales, and fill in Non-Inventoried Items along with any other blank rows in the list. This is by far the most common cause of this error.
6. Confirm the account is valid, not just present. Open Account Maintenance (Cards >> Financial >> Account) and check the account exists and is marked Active. GP treats an inactive account the same as a missing one.
7. Refresh the document. Correcting the setup does not repair a document you have already keyed. Either delete the failing line and re-enter it, or open the distributions from the document (Sales Transaction Entry → GoTo button → Distributions) and click Default to rebuild every distribution row from the corrected master records.
8. Save and reprint the edit list. The warning icon should be gone and the document ready to post.

Remember: GP never goes back and updates transactions that are already saved. If you fix the item or customer accounts today, yesterday's unposted invoices still carry the blank accounts until you re-key the line or click Default in the distributions window.

For your GP administrator: if the warning survives all of the above, the error flag is stored on the line itself. A read-only check of SELECT SOPLNERR, * FROM SOP10200 WHERE SOPNUMBE = '<document number>' will pinpoint it — a value of 8 confirms “line accounts are missing or invalid”, while other values point elsewhere (2 = site record missing, 12 = line quantity is zero, 14 = line quantity not distributed, and so on).

↑ Back to the issue list

Issue 2 — The accounts receivable distribution(s) does not equal the actual amount

What you see

The accounts receivable distribution(s) does not equal the actual amount.

The message appears when you try to save or post the document, and GP will not let it through.

Why it happens

The amount sitting on the RECV (Accounts Receivable) distribution row no longer matches what the document is actually worth. GP works out the document total from the line items plus freight, miscellaneous and tax, less any trade discount and any payment or deposit taken on the document. If someone typed over the distribution amounts, or if the document changed after the distributions were created, the RECV row is left holding the old figure.

How to fix it

1. Note the correct figure first. In Sales Transaction Entry, look at the Total at the bottom right of the window, and at the Amount Received field if a payment or deposit has been entered. The RECV distribution should equal the document total less any payment already applied on the document.
2. Open the distributions. Click the GoTo button and choose Distributions (or click the Distributions button) to open Sales Distribution Entry.
3. Click the Default button. This clears every manual amount and rebuilds all distribution rows from the current state of the document. In most cases this single step clears the error. Only skip it if you have a deliberate manual split you cannot afford to lose.
4. Check the Type column. A standard invoice should have exactly one RECV row. If there are two, or if a row was left behind from an earlier edit, select the unwanted row and use Edit >> Delete Row.
5. Confirm the totals balance. At the bottom of Sales Distribution Entry the Debit total and the Credit total must be identical, and the RECV amount must match the figure you noted in step 1.
6. If you split revenue on purpose — keep the split on the SALES rows only and leave the RECV row alone. You can distribute revenue across as many departments as you like, as long as debits still equal credits and RECV still equals the document total.
7. Check the document type. If the document total is negative because you are reversing an invoice, GP expects a Return or credit document, not an invoice. Entering a negative invoice produces exactly this error. Delete the document and re-enter it choosing the correct Type / Type ID at the top of Sales Transaction Entry.
8. Multicurrency documents — if the document is in a foreign currency, check the Currency ID and the exchange rate on the document. A rate that changed after the distributions were created leaves the functional-currency RECV amount stale. Correct the rate, then click Default again.
9. Click OK, save the document, and reprint the edit list to confirm it is clean before posting.

Watch out for this sequence: entering distributions manually and then adding a line, changing the freight or misc amount, applying a deposit, or changing the customer. Any of these changes the document total but leaves your typed RECV amount behind. If you must edit distributions, do it last.

↑ Back to the issue list

Issue 3 — Account is empty. Do you want to save changes with errors?

What you see

Account is empty. Do you want to save changes with errors?

The prompt appears when you leave Sales Distribution Entry or save the document.

Why it happens

At least one distribution row has a blank Account. The root cause is the same family of missing posting defaults as Issue 1, but this message often shows up on returns and credit documents that use accounts an invoice never touches — Sales Returns and Markdown in particular. That is why the same item can invoice perfectly and still fail on a return.

How to fix it

1. Answer No. This keeps you in the window and stops a broken document being saved into the batch.
2. Find the blank row. In Sales Distribution Entry, scroll down the Account column until you find the empty one, and note its Type — SALES, RECV, COGS, INV, TAXES, FREIGHT, MISC, TRADE, RETSALES or MARKDOWN. The type tells you exactly which setup window is incomplete.
3. Fix the source so it does not come back.
   • RETSALES / MARKDOWN (returns and credits) — Item Account Maintenance, Cards >> Inventory >> Account. Fill in Sales Returns and Markdown.
   • SALES / COGS / INV on a non-inventoried line — Posting Accounts Setup, Microsoft Dynamics GP >> Tools >> Setup >> Posting >> Posting Accounts, with Display set to Sales.
   • RECV — Customer Maintenance → Accounts button, Cards >> Sales >> Customer. Fill in Accounts Receivable.
   • TAXES — Tax Detail Maintenance, Microsoft Dynamics GP >> Tools >> Setup >> Company >> Tax Details. Every tax detail must have its own GL account.
   • FREIGHT / MISC / TRADE — Customer Maintenance → Accounts button, or the same rows in Posting Accounts Setup with Display set to Sales.
4. Reload the distributions. Back in Sales Distribution Entry, click Default to pull in the accounts you just set up. If you have a manual split you want to keep, type the account straight into the blank row instead, or pick it with the lookup button beside the Account heading.
5. Delete any leftover empty row. A row with no account and a zero amount can simply be removed — select it and use Edit >> Delete Row.
6. Check that Debit total equals Credit total, click OK, then save the document.

Do not answer Yes to get past it. Saying Yes does not fill in the account — it only lets the document sit in the batch with the error still attached. It will be rejected again at posting time and the rest of the batch will not post either. Always fill in the account first.

↑ Back to the issue list

Issue 4 — Tax codes are not showing

What you see

The Tax field on the document stays at 0.00, or clicking the expansion arrow beside Tax opens an empty tax detail window, or the Tax Schedule ID lookup returns nothing at all. There is no error message — the tax simply never appears.

Why it happens

Tax on a sales line is not a single code read off the customer card. GP only produces tax when three things line up: tax calculation is switched on in setup, the item itself is flagged as taxable, and the customer is not exempt. If any one of them is off, the line comes out at zero and there is nothing to display. Work through the checks below in order — the first one that is wrong is usually the whole answer.

How to fix it — work through these in order

1. Is tax calculation switched on? Open Sales Order Processing Setup (Microsoft Dynamics GP >> Tools >> Setup >> Sales >> Sales Order Processing) and click the Options button. Check Calculate Taxes:
   • None — tax will never calculate. Change it to Advanced or Single Schedule.
   • Single Schedule — only the one schedule named here is used; item settings and shipping method are ignored entirely.
   • Advanced — the normal setting, and the comparison described in the steps below applies.
   While you are in this window, also check the Non-Inventoried Items and Freight / Miscellaneous tax schedule fields. Blank here means no tax on those lines.
2. Is the item taxable? Open Item Maintenance (Cards >> Inventory >> Item) and click Options. Look at Sales Tax Option:
   • Nontaxable — no tax, regardless of everything else.
   • Taxable — GP compares the item's own Tax Schedule ID with the customer or site schedule and uses only the details found in both. If the two schedules share no details, tax comes out as zero. This is the most common reason tax does not show.
   • Base on customers — the item schedule is ignored and every detail on the customer or site schedule is applied. If a customer should simply be taxed according to where they are, this is usually the setting you want.
   
   
3. Is the customer flagged as exempt? Open Customer Maintenance → Options button and check the Tax Exempt 1 and Tax Exempt 2 fields and the Tax Schedule ID. A tax registration number entered here can also change how the customer is treated.
4. If the Tax Schedule ID lookup itself is empty — either no tax schedules have been created yet in Tax Schedule Maintenance, or the user does not have security access to the tax setup windows. Ask your GP administrator to check the security task and role assigned to that user, then log out and back in.
5. Re-key the line after any setup change. GP applies tax when the line is entered, so a document that is already keyed will not pick up the new setup. Delete and re-enter the line (or the whole document), then click the expansion arrow beside Tax to confirm the details now appear.

Quick way to see what GP decided: click the expansion arrow next to the Tax field in Sales Transaction Entry to open the tax summary, then drill into the line. If the window is blank, GP found no tax detail to apply — work back through steps 1 to 3.

↑ Back to the issue list

---

This page is updated as new Sales Transaction Entry issues come up. If you hit an error that is not listed here, leave a comment with the exact message and the steps you took, and it will be added.