How to resolve alignment problems in 1099 reports in Payables Management in Microsoft Dynamics GP


INTRODUCTION


This article describes how to realign the fields in the 1099 reports so that the fields are put in the correct locations on preprinted forms in Payables Management in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains 8.0.

More Information


When you print the 1099 reports, the alignment of the fields is incorrect on the preprinted forms in Microsoft Dynamics GP. To resolve this issue, use one or more of the following methods.

Method 1


When you print the report to a printer, the Print window opens. Enter values in the Horizontal field and in the Vertical field, and then click OK to print the report to blank paper. Hold the alignment form and the preprinted form together to determine whether the alignment is correct. If the alignment is incorrect, repeat this step. Use different values in the alignment fields until the alignment is accurate.

Notes
  • The Horizontal field: A negative value moves the alignment to the right on the paper. A positive value moves the alignment to the left on the paper.
  • The Vertical field: A negative value moves the alignment up on the paper. A positive value moves the alignment down on the paper.

Method 2

Reinstall the printer driver. For more information about how to reinstall the printer driver, visit the printer manufacturer's Web site.

Method 3

Use a different workstation and printer to print the 1099 reports.

Method 4

Use Report Writer to change the 1099 report. To do this, follow these steps:

  1. Follow the appropriate step:
    • In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Customize, and then click Report Writer.
    • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions – Great Plains 8.0, point to Customize on the Tools menu, and then click Report Writer.
  2. Click Reports.
  3. In the Original Reports box, click the 1099 report that you want to change. The following 1099 reports are available:
    • 1099 Dividend
    • 1099 Interest
    • 1099 Miscellaneous
    • 1099 Laser Dividend
    • 1099 Laser Interest
    • 1099 Laser Miscellaneous
  4. Click Insert, click the same report in the Modified Reports box, and then click Open.
  5. In the Report Definition window, click Layout.
  6. In the Report Layout, move the appropriate fields so that they align with the preprinted 1099 form.
  7. On the File menu, click Microsoft Dynamics GP or Microsoft Business Solutions – Great Plains. When you are prompted to save changes, click Save.
  8. To assign security permissions to the modified report, use one of the following methods.

    Method A: Use security in Microsoft Dynamics GP 10.0


    1. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click Alternate/Modified Forms and Reports.
    2. In the ID box, type the ID of the user who will print this modified report.
    3. In the Product list, click Microsoft Dynamics GP.
    4. In the Type list, click Reports.
    5. Expand the Financials folder.
    6. Expand the folder for the report that you modified.
    7. Click to select Microsoft Dynamics GP (Modified).
    8. Click Save.
    9. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to System, and then click User Security.
    10. In the User list, click a user ID.
    11. In the Company list, click a company.
    12. In the Alternate/Modified Forms and Reports ID list, click the ID from step b.

    Method B: Use the Advanced Security tool in Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions – Great Plains 8.0

    1. On the Tools menu, point to Setup, point to System, and then click Advanced Security.
    2. If you are prompted, type the system password in the Please Enter Password box, and then click OK.
    3. In the Advanced Security window, click View, and then click By Alternate, Modified and Custom.
    4. Use one of the following steps, depending on which version is installed:
      • In Microsoft Dynamics GP 9.0, expand Microsoft Dynamics GP.
      • In Microsoft Business Solutions - Great Plains 8.0, expand Great Plains.
    5. Expand Reports, expand Financials, and then expand the report that you modified.
    6. Use one of the following steps, depending on which version is installed:
      • In Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP (Modified).
      • In Microsoft Business Solutions - Great Plains 8.0, click Great Plains (Modified).

    7. Click Apply, and then click OK.



      Note By default, when you start the Advanced Security tool, the current user and the current company are selected. Any changes that you make affect the current user and the current company. However, you can select additional users in the Users area of the Advanced Security window. You can select additional companies in the Company Name area of the Advanced Security window.

    Method C: Use the Standard Security tool in Microsoft Dynamics GP 9.0 or in Microsoft Business Solutions – Great Plains 8.0

    1. On the Tools menu, point to Setup, point to System, and then click Security.
    2. If you are prompted, type the system password in the Please Enter Password box, and then click OK.
    3. In the User ID list, click the ID of the user who you want to have access to the modified report.
    4. In the Type list, click Modified Reports.
    5. In the Series list, click Financials.
    6. In the Access List box, double-click the report that you modified, and then click OK.



      Note An asterisk (*) appears next to the report name.