Supplier Mailing Labels
Use this report to create mailing labels for supplier sites. You can order your labels by supplier or by postal code. You can print mailing labels for any of your supplier's active sites.
Payables prints "Attn: Accounts Receivable" on the label if you have enabled the Attention AR option for the supplier site.
When you submit the report you choose either Formatted or Unformatted for the output style parameter. If you choose Formatted, Payables creates output for Avery brand 1 1/3" x 4" labels. If you choose Unformatted, Payables creates a flat file with the report output. You can then use a custom program to format the file and print it on labels of another size.
Unformatted
If you use the Unformatted output style, the flat file lists the following information for each supplier site that matches the parameters you enter.
| Attention
| :
| Attn: Accounts Receivable
|
| Supplier:
| :
| supplier name
|
| Address 1
| :
| address line 1
|
| Address 2
| :
| address line 2
|
| Address 3
| :
| address line 3
|
| City
| :
| city
|
| State/Province
| :
| state. Payables prints the province if state is null
|
| Zip
| :
| zip code
|
| Country
| :
| country name
|
Each address segment is preceded by a descriptive tag. There is no top or left margin. Each descriptive tag has a length of 17 (including spaces before and after a colon mark) followed by the corresponding address segment value with a length of 63. There is one blank line between supplier sites.
Formatted
If you choose Formatted, Payables prints a label for each supplier site that matches the parameters you enter. The report generates output specifically for Avery 1 1/3" x 4" laser labels, part number 5162. On each page, Payables prints 2 labels across and 7 labels down. Payables can print 6 lines on each label, and Payables can print 34 characters on each line.
Payables uses the same 9 address segments listed above, and formats each address to fit as much information on the label as possible. Payables uses the same address order for all countries except Japan. If you select the Japanese address style in the Countries and Territories window, Payables prints labels in the Japanese address style.
Report Submission
You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Selected Report Parameters
Supplier Type. If you want to print labels for one type of supplier, enter the supplier type. Leave blank to print labels for all suppliers.
Order Labels By. Enter the order in which you want Payables to sort the labels.
Which Sites? Indicate for which sites you want to create labels:
- Pay. Create labels for pay sites only.
- Non-pay. Create labels only for supplier sites that are not pay sites.
- All/Null. Create labels for supplier sites regardless of the site type.
Print Home Country? If you want Payables to suppress the country name in the address for suppliers that are in your home country, enter No. You define your home country when you enter the Default Country profile option. If you do not enter a Default Country profile option, your default home country is the United States.
Output Style. Choose the format in which you want Payables to create the output.
- Formatted. Create output for 1 1/3" x 4" labels, 2 labels across and 7 labels down per page.
- Unformatted. Create a flat file that you will process with a custom program.
Troubleshooting this report
If you are having problems running the Supplier Mailing Labels report, and you are using Oracle Payables Production 16 or later, your system administrator may not have performed the required installation steps. See: Setting Up Print Styles and Drivers for the Supplier Mailing Labels Report
See Also
Common Report Parameters
Countries and Territories
