The 1099 Detail report may be blank when you make a journal entry to a 1099 vendor in Small Business Accounting 2006 (906098)


The information in this article applies to:

  • Microsoft Office Small Business Accounting 2006
  • Microsoft Office Small Business Management Edition 2006

SYMPTOMS

When you make a journal entry to a 1099 vendor in Microsoft Office Small Business Accounting 2006, you may experience one of the following symptoms:
  • The 1099 Detail report is blank.
  • The amount in the Payment Amount column in the 1099 Detail report does not match the amount that you paid to the vendor.

CAUSE

This problem occurs if one of the following conditions is true:
  • You make a journal entry to increase the balance on a vendor's account. Then, you apply a payment to cover the amount of the journal entry.
  • You make a journal entry to create a credit on a vendor's account. Then, you apply the credit to an outstanding balance.

WORKAROUND

To work around this issue, use the Vendor Transaction History report to view all the payments to the vendors. To do this, follow these steps:
  1. On the Reports menu, point to Vendors and Payables, and then click Vendor Transaction History.
  2. In the Date Range list, click the date range that you want to use.
  3. On the toolbar, click Filter Options.
  4. In the Select filter option area, click Vendor name.
  5. In the Options list in the Filter Options section, click Selected Names.
  6. In the Available Options section, click the 1099 vendor, and then click Add. Repeat this step for each 1099 vendor that you want to add, and then click OK.
  7. Click Apply, and then click OK.
  8. On the toolbar, click Export to Excel.
  9. In Microsoft Excel, remove any amounts that you do not want to include in the calculations. For example, remove vendor bills or credit memos.
  10. Total the vendor payment amounts, and then use this amount on the 1099-MISC form.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the problem

Note The following steps refer to the Fabrikam company. Fabrikam is a fictitious company name that is used for demonstration purposes in Small Business Accounting.

Example 1

  1. Create a 1099 vendor. To do this, follow these steps:
    1. On the Vendors menu, point to New, and then click New Vendor.
    2. In the Vendor name box, type a name for the vendor.
    3. On the Details tab, click to select the Vendor 1099 check box.
    4. Click Save and Close.
  2. Create a new expense account. To do this, follow these steps:
    1. On the Company menu, click New Account.
    2. Click Expense, and then click OK.
    3. In the Account Name box, type a name for the new account.
    4. In the 1099 Category list, click Box 3. Other Income.
    5. Click Save and Close.
  3. Define vendor preferences. To do this, follow these steps:
    1. On the Company menu, click Preferences.
    2. On the Vendors tab, click 1099 Categories.
    3. In the 1099 Categories list, click Box 3. Other Income, and then click Edit.
    4. In the Threshold box, type $100, and then click OK.
    5. Click Close to close the Modify 1099 Categories dialog box.
    6. Click OK.
  4. Create a new journal entry. To do this, follow these steps:
    1. On the Company menu, click New Journal Entry.
    2. In the first row, supply the following information:
      1. In the Type list, click Financial Account.
      2. In the Account list, click the account that you created in steps 2a through 2e.
      3. In the Debit box, type $150.
    3. In the second row, supply the following information:
      1. In the Type list, click Vendor.
      2. In the Account list, click the vendor that you created in steps 1a through 1d.
      3. In the Credit box, type $150.
    4. Click Save and Close.
  5. Pay the vendor bill. To do this, follow these steps:
    1. On the Vendors menu, click Pay Bills.
    2. In the Pay From list, click an account.
    3. In the Payment method list, click a payment method.
    4. In the Pay column, click to select the check box for the journal entry that you created in steps 4a through 4d. The vendor that you created in steps 1a through 1d appears in the Vendor column. The amount in the Payment column is $150.00.
    5. Click Save and Close.
  6. On the Vendors menu, click Print 1099 Report.
The report is empty.

Example 2

  1. Create a 1099 vendor. To do this, follow these steps:
    1. On the Vendors menu, point to New, and then click New Vendor.
    2. In the Vendor name box, type a name for the vendor.
    3. On the Details tab, click to select the Vendor 1099 check box.
    4. Click Save and Close.
  2. Create a new expense account. To do this, follow these steps:
    1. On the Company menu, click New Account.
    2. Click Expense, and then click OK.
    3. In the Account Name box, type a name for the new account.
    4. In the 1099 Category list, click Box 3. Other Income.
    5. Click Save and Close.
  3. Define vendor preferences. To do this, follow these steps:
    1. On the Company menu, click Preferences.
    2. On the Vendors tab, click 1099 Categories.
    3. In the 1099 Categories list, click Box 3. Other Income, and then click Edit.
    4. In the Threshold box, type $100, and then click OK.
    5. Click Close to close the Modify 1099 Categories dialog box.
    6. Click OK.
  4. Create a service item. To do this, follow these steps:
    1. On the Vendors menu, point to New, and then click New Item.
    2. Click Service, and then click OK.
    3. In the Item Name box, type the name that you want to use.
    4. Click to clear the I sell this item check box.
    5. Click to select the I buy this item check box.
    6. In the Purchase price box, type $50.00.
    7. In the Expense account list, click the account that you created in step 2.
    8. Click Save and Close.
  5. Create a vendor bill. To do this, follow these steps:
    1. On the Vendors menu, click Enter Bills.
    2. In the Vendor name list, click the vendor that you created in step 1.
    3. In the Name list, click the service item that you created in step 4.
    4. In the QTY box, type 10.
    5. Click Save and Close.
  6. Create a new journal entry. To do this, follow these steps:
    1. On the Company menu, click New Journal Entry.
    2. In row 1, supply the following information:
      1. In the Type list, click Vendor.
      2. In the Account list, click the vendor that you created in step 1.
      3. In the Debit box, type $350.
    3. In row 2, supply the following information:
      1. In the Type list, click Financial Account.
      2. In the Account list, click the account that you created in step 2.
      3. In the Credit box, type $350.
    4. Click Save and Close.
  7. Pay the bill. To do this, follow these steps:
    1. On the Vendors menu, click Pay Bills.
    2. In the Pay From list, click an account.
    3. In the Payment method list, click a payment method.
    4. Click to select the Pay check box that corresponds to the bill that you created in step 5, and then click Credits in the Apply column.
    5. In the Apply Credits and Payment dialog box, click to select the check box that corresponds to the journal entry that you created in step 6, and then click Adjust. When the credit is applied, the amount in the Payment column on the Pay Bills form changes to $150.00.
    6. Click Save and Close.
  8. On the Vendors menu, click Print 1099 Report.
Two payments are shown in the Box 3: Other Income section. One payment is for $150.00, and the other payment is for $350.00. The total payment is $500.00.
Modification Type:MajorLast Reviewed:3/27/2006
Keywords:kbBug kbMBSMigrate kbprb KB906098 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.