Setting Up Print Styles and Drivers for the Supplier Mailing Labels Report

When you submit the Supplier Mailing Labels report, you choose an output style parameter of either Formatted or Unformatted. If you choose Formatted, Payables prints the supplier label information on Avery brand laser labels. If you choose Unformatted, Payables creates a flat file with the supplier label information. You can then use a custom program to format the flat file and print your custom labels.

Before you can run the Supplier Mailing Label report, you must set up a print style and printer driver and assign them to the report. You set up the print style based on whether you want to run the report in the Formatted or Unformatted output style, and if you use a printer in PostScript mode or not.

If you want to use the Formatted output style, and you use a printer in non-PostScript mode, and an SRW driver is not defined for this printer, you must first define a new Portrait type (66 height x 80 width) SRW driver for your printer and it must be in your $FND_TOP/$APPLREP directory. 

Tip: If you want to be able to choose both Formatted and Unformatted output styles when you submit the report, assign in the Print Style window an SRW driver that can print in the Unformatted output style, and assign in the Printer Drivers window an SRW driver that can print in the Formatted output style. 

The system uses the SRW driver in the Print Styles window when, in the Submit Request window, you enter zero in the Copies field. The system uses the SRW driver in the Printer Drivers window if, in the Submit Request window, you enter a value greater than zero in the Copies field, and you enter a printer value in the Printers field. 

If the Print Style SRW driver is different from the Print Drivers SRW driver, each time you submit the Supplier Mailing Labels program, you must remember to properly set the Copies and Printer fields in the Submit Request window.


Defining 'Portrait - Mailing Labels' Print Style

  • Log in to Oracle Applications and choose the System Administrator responsibility.
  • Navigate to the Print Styles window.
  • Define the Portrait - Mailing Labels print style by entering and saving the following values and options.

Field

Value or Option

Style Name

PORTRAITMAILLABELS

Sequence

Unique number that specifies order in which the printer’s name appears on your printer list of values. See: Print Styles Window documentation for more details.

User Style

Portrait - Mailing Labels

SRW Driver

Select a driver depending on whether an SRW driver for your printer is predefined in Oracle Applications, whether you use your printer in PostScript mode, and whether you use the Formatted (Avery labels) or Unformatted (custom labels) Output Style parameter for the Supplier Mailing Labels Report:
- APFMLB (predefined PostScript SRW driver, Formatted output style, with page breaks)
- APUMLB (predefined non-PostScript SRW driver, Unformatted output style, without page breaks)
- existing Portrait type (66 height x 80 width) SRW driver, e.g. P (predefined non-PostScript SRW driver for Formatted/Unformatted output styles with page breaks)
- user-defined

Description

Style for Supplier Mailing Labels

Columns

80

Rows

66

Suppress Header

Disabled

Orientation

Portrait



Defining the Printer Driver

  • Log in to Oracle Applications and choose the System Administrator responsibility.
  • Navigate to the Printer Drivers window.
  • Define a printer driver by entering the following values. For more information, see: Printer Drivers Window, Oracle Applications System Administrator's Guide .
  • If you are using a printer in non-PostScript mode, you may want to remove the PostScript references in the values you enter for the Driver Name, User Driver, and Description.

Field

Value

 

Driver Name

PORTRAITPSMAILLABELS

 

User Driver

PostScript Portrait for Mailing Labels

 

Description

PostScript Portrait 80x66 (8.5"x11"), 0 margins

 

SRW Driver

Select a driver depending on whether an SRW driver for your printer is predefined in Oracle Applications, whether you use your printer in PostScript mode, and whether you use the Formatted (Avery labels) or Unformatted (custom labels) Output Style parameter for the Supplier Mailing Labels Report:
- APFMLB (predefined PostScript SRW driver, Formatted output style, with page breaks)
- APUMLB (predefined non-PostScript SRW driver, Unformatted output style, without page breaks)
- existing Portrait type (66 height x 80 width) SRW driver, e.g. P (predefined non-PostScript SRW Driver for Formatted or Unformatted output styles with page breaks)
- user-defined

 

Platform

(blank)

 

Driver Method

Command. You can use other Driver Methods. Using an alternate Driver Method may require you to change the values for Spool File, Standard Input, Program Name, and Arguments.

 

Spool File

Enabled

Standard Input

Disabled

Program Name

(blank)

Arguments

lp -c -d$PROFILES$.PRINTER -n$PROFILES$.CONC_COPIES $PROFILES$.FILENAME
Note that for some operating systems you will need to alter the Arguments. Using alternate Arguments may require you to change the values for Spool File and Standard Input.

Initialization

If you use a printer in PostScript mode, leave the Initialization field blank. If you use a printer in non-postscript mode and want to use the Formatted output style, enter a string with the following escape sequences:

- printer coordinate origin in top left corner of physical page

- all page margins (top, bottom, left, right) are 0

- page dimensions are 80 characters wide and 66 characters high

Reset

If you entered an Initialization string, enter a string that will reset the printer's instructions for the next print job.


  • Save your work

To assign the printer style and printer driver to your printer:


  • Log in to Oracle Applications and choose the System Administrator responsibility.
  • Navigate to the Printer Types window. For more information, see: Printer Types Window, Oracle Applications System Administrator's Guide.
  • Query the printer you want to use to print the mailing labels.
  • Select PORTRAITMAILLABELS as the printer style and select the printer driver name you defined, e.g. PORTRAITPSMAILLABELS.
  • Save your work.

To assign the printer style to the Supplier Mailing Labels Report:

  • Log in to Oracle Applications and choose the System Administrator responsibility.
  • Navigate to the Concurrent Programs window. For more information, see: Concurrent Programs Window, Oracle Applications System Administrator's Guide.
  • Query the Supplier Mailing Labels Program (short name APXVDLBL).
  • In the Output region, overwrite the Style default value of 'Portrait' with 'Portrait - Mailing Labels'.
  • If you do not want to allow users to select other print styles when they submit the report, check the Style Required check box.
  • Save your work.

Setting the Query Driver Parameter for 1099 Reporting

Before you perform 1099 reporting, you need to ensure that the Query Driver hidden parameter is set properly and consistently for the 1099 reports that use this parameter. To help ensure that the parameter is consistent, the system administrator sets the parameter and the parameter does not appear during report submission.

The following 1099 reports use the Query Driver parameter :
  • 1099 Forms
  • 1099 Payments Report
  • 1099 Electronic Media
  • 1099 Supplier Exceptions
  • 1099 Invoice Exceptions
These reports provide 1099 payment or exception information by balancing segment. Each report uses the setting of the Query Driver parameter to determine which account to use to determine the balancing segment associated with the invoice. The parameter options are:
  • INV: charge account on the invoice distribution
  • PAY: bank cash account used for the invoice payment
When you submit each of these 1099 reports, you run the report for a specific reporting entity. By choosing a reporting entity, you are choosing to run the report for the balancing segments assigned to the specified reporting entity. For example, you run a report for reporting entity "Headquarters", which represents balancing segments 1, 2, and 3. The report includes all transactions that were charged to accounts with balancing segments 1, 2, and 3.

You need to set the Query Driver parameter so you will report using the transaction type that has the most specific information, either the payment or the invoice. Continuing from the previous example, if you use the same cash account to pay for transactions for balancing segments 1, 2, 3, and 4, and balancing segment 4 is assigned to reporting entity "West", then you should use INV as your Query Driver parameter. You can run the reports for both the Headquarters and West reporting entities because the system can then separate transactions by balancing segment.

The default parameter for the 1099 reports is PAY. If you want to use the PAY parameter, then do nothing.

If you want to change the parameter to INV, then perform the following steps for each of the reports.

Important: To ensure consistent reporting, each of the reports must use the same value for the Query Driver parameter.

To change the Query Driver parameter from PAY to INV:

  • Log in as the System Administrator.
  • Navigate to the Concurrent Programs window.
  • Search for the report and click Parameters.
  • Select the Query Driver parameter and update the Default Value field.

No comments:

Post a Comment