An Item has a blank sales account number (for PO's)

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 Purchase Order.

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 Revenue-Product account. You may also refer to the related articles below.
  3. Once created, the GL Entries of the item has to be refreshed. Find and re-open the Purchase Order
  4. Under the Products tab, click on the item and unchecked the Closed tickbox then Save
  5. Checked the Closed tickbox again and Save 
  6. 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.