An Item has a blank sales account number (for Invoices)

Error

An item has a blank sales account number.
- Refer to Item: '<item code>'.

Applies to: ConnectWise, Xero, QuickBooks Online

How can this happen?

This error can occur when the GL mapping is missing from the Setup Tables in ConnectWise and relates to the Income category of the product used in the Invoice.

Solution

  1. In ConnectWise Manage, find the item that's causing the error and take note of the item category and subcategory 
  2. Go to Setup Tables > GL Accounts and create a new account based on the item and Invoice type (Revenue, Revenue-Agreements, Revenue-Product and Revenue-Agreements Products). You may also refer to the related articles below.
  3. Once created, go to Finance > Accounting Interface > Unposted Invoices
  4. Select the invoice and update the GL Entries by click on Actions then Update GL Entries or set the invoice status to GL Reload then set back to Closed
  5. Re-sync

Related Articles:

GL Mapping (Non-Product Revenue & COGS Accounts) - Xero
GL Mapping (Product Revenue & COGS Accounts) - Xero
GL Mapping (Non-Product Revenue & COGS Accounts) - QBO
GL Mapping (Product Revenue & COGS Accounts) - QBO

P
Paul is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.