106 A/P Reports Processing Options

This chapter contains these topics:

Section 106.1, "A/P Summary Reports (P04413)"
Section 106.2, "A/P Detail Reports (P04423)"
Section 106.3, "Currency Detail Report (P04427)"
Section 106.4, "A/P Payment Detail (P04424)"
Section 106.5, "Payment Register - Address & Payment Date (P09313)"
Section 106.6, "Suspected Duplicate Payments (P04601)"
Section 106.7, "A/P and A/R Netting (P03455)"
Section 106.8, "Supplier Analysis Report (P04602)"
Section 106.9, "Supplier Totals by G/L Account (P09450)"

106.1 A/P Summary Reports (P04413)

Processing Option	Processing Options Requiring Further Description
PRINT OPTIONS:
1. Specify one of the following print formats: ' ' = Standard 132 character format with aging. (Default) '1' = Long 198 character format with foreign currency aging. '2' = Short 132 character format with Offset and Remarks.
BYPASS SUPPLIERS:
2. Enter a '1' to bypass suppliers with a Hold Payment code of 'Y' or those that are Inactive. If left blank, all suppliers will print.
AGING:
3. Enter a '1' to retrieve the aging specifications from A/P Constants. If left blank, the processing options will be used for aging.
4. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
5. Specify one of the following dates to age accounts from: D = Due Date (Default) I = Invoice Date G = General Ledger Date
6. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
7. Enter the following aging category information: (for method "1" only) Aging Days: Beginning thru thru thru thru
8. Specify one of the following for aging credits: ' ' = Apply Credits to Current Column (Default) '1' = Age Credits
"AS OF" DATE PROCESSING:
9. Enter a '1' to use the "As Of" date process. Note: DREAM Writer Based On File must be F0411AJC.
SUMMARY PAGE:
10. Enter a '1' to print the company summary page at the end of the report. If left blank, no summary page will be printed.
ROUNDING FACTOR:
11. Enter rounding factor for Non-Aging: ' ' = no rounding (Default) '0' = round decimals only '1' = divide by 10 '2' = divide by 100 '3' = divide by 1000 '4' = divide by 10000 '5' = divide by 100000 '6' = divide by 1000000 Any value of 0 through 6 will round decimals to whole numbers. Amounts are rounded using 4/5 rounding. Actual amounts are used to accumulate the total fields. This is for NON-AGING amounts.
ROUNDING FACTOR:
12. Enter Rounding factor for Aging: ' ' = no scaling '0' = round decimals only '1' = divide by 10 '2' = divide by 100 '3' = divide by 1000 '4' = divide by 10000 '5' = divide by 100000 '6' = divide by 1000000 Any value of 0 through 6 will round decimals to whole numbers. Amounts are divided using 4/5 rounding. Actual amounts are used to accumulate the total fields. This is for AGING amounts.

106.2 A/P Detail Reports (P04423)

Processing Option	Processing Options Requiring Further Description
PRINT FORMATS:
1. Specify one of the following print formats: ' ' = Standard 132 characters with remarks. (Default) '1' = Standard 132 characters with net amounts. '2' = Long 198 characters with aging. '3' = Long 198 characters with foreign currency aging.
BYPASS HELD SUPPLIERS:
2. Enter a '1' to bypass suppliers with a Hold Payment Code of "Y" or those that are Inactive. If left blank, all suppliers will print.
AGING: (if Aging format is selected)
3. Enter a '1' to retrieve the aging specifications from A/P Constants. If left blank, the processing options will be used for aging. Note: If selected, all other aging processing options will be ignored.
4. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
5. Specify one of the following dates to age accounts from: D = Due Date I = Invoice Date G = General Ledger Date (If left blank, "D" is the default.)
6. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
7. Enter the following aging category information: (for method "1" only) Aging Days: Beginning thru thru thru
8. Enter a '1' to age credits. If left blank, credits will be applied to the "Current" aging column.
"AS OF" PROCESSING:
9. Enter a '1' to use "As Of" date processing. Note: The DREAM Writer Based on File must be F0411AJC.
PAYMENT PROCESSING:
10. Enter a '1' to print payment information. If left blank only original voucher information will be printed.
11. Enter a '1' to include payment amounts in the Original amount column total on the report. If left blank, only original document amounts will be totaled in this column. This option is only valid if payment information is being printed (option 10).
ROUNDING FACTOR:
12. Enter the desired rounding factor: ' ' = no rounding (Default) '0' = round decimals only '1' = divide by 10 '2' = divide by 100 '3' = divide by 1000 '4' = divide by 10000 '5' = divide by 100000 '6' = divide by 1000000 Actual amounts are used to accumulate totals.
RECURRING FREQUENCY:
13. Enter a '1' to print the recurring voucher information on the report. If left blank, no recurring information will be printed. (This applies to all formats except the foreign aging.)
14. Enter the number of remaining payments to highlight on the report. Any vouchers with this number of remaining payments or less will be flagged on the report.
GENERIC TEXT:
15. Enter a '1' to print the generic text for pay items in a 40 character width Enter a '2' to print text in an 80 character width. If left blank, generic text will not be printed.
16. Enter a '1' to print only the summarized generic text. Enter a '2' to print both the pay item generic text and the summarized generic text. If left blank, only pay item generic text will print.

106.3 Currency Detail Report (P04427)

Processing Option	Processing Options Requiring Further Description
PRINT FORMAT:
1. Enter a '0' to print aging information, or a '1' to print foreign and domestic information.
HOLD PAYMENT CODE:
2. Enter a '1' to bypass suppliers with a Hold Payment code of "Y" or those that are Inactive. If left blank, all suppliers will be shown. AGING: (if Aging format is selected)
3. Enter a '1' to retrieve the aging specifications from A/P Constants. If left blank, the processing options will be used for aging.
4. Enter the "As Of" date to age open balances. If left blank, the current date is used as the default.
5. Specify one of the following dates to age accounts from: D = Due Date I = Invoice Date G = General Ledger Date (If blank, "D" is the default)
6. Specify one of the following methods for aging calculations: 1 = Aging Days (Default) 2 = Fiscal Periods 3 = Calendar
7. Enter the following aging category information: (for method "1" only) Aging Days: Beginning thru thru thru
8. Enter a '1' to age credits or leave blank to apply credits to the current column.
"AS OF" PROCESSING:
9. Enter a '1' to use 'As Of' date process. Note: DREAM Writer Based on File must be F0411AJC.

106.4 A/P Payment Detail (P04424)

Processing Option	Processing Options Requiring Further Description
PRINT FORMATS:
1. Enter a '1' to print the report with foreign and domestic amounts of the payment. If left blank, only the payment amount will display.
2. Enter a '1' to begin a new page with each payment number. If left blank, a new page will begin with each payee.
3. Enter '1' to print generic text for payments in a 40 character width, a '2' to print text in an 80 character width. If blank, no text will print.

106.5 Payment Register - Address & Payment Date (P09313)

Processing Option	Processing Options Requiring Further Description
SUPPLIER NAME:
1. Enter a '1' to print the Mailing Name of the Supplier. If left blank, the Alpha Name in the G/L Alpha Explanation field will print.

106.6 Suspected Duplicate Payments (P04601)

Processing Option	Processing Options Requiring Further Description
SELECTION DATE:
1. Enter a selection date. Only vouchers with an invoice date greater than or equal to this date will be selected for printing. If left blank, all vouchers will be selected.

106.7 A/P and A/R Netting (P03455)

Processing Option	Processing Options Requiring Further Description
NETTING PROCESS OPTIONS:
1. Enter a '1' to perform A/R Netting when called from a stand-alone menu. If left blank, A/P Netting will be called from a stand alone menu.	The net total for A/P payments is a positive number and a negative number for A/R. You must ensure you set this processing option to launch the type of netting program from the menu that you intend to use. If you do not set this processing option properly and attempt perform the netting process, the system displays the Invalid Netting Amount error message, and does not calculate the net amounts. You must also set the A/P & A/R Netting processing option in Receipts Entry (P03103) and Payment with Voucher Match (P04102) programs. If you encounter the error, you can access the correct version of the netting program by choosing A/R & A/P Netting Toggle (F10). For example, if you are in the A/P netting program, but your liabilities are actually in A/R, you can choose A/R & A/P Netting Toggle (F10) to toggle to the AR version of the netting program.
2. Enter a '1' for Inquiry mode only. If left blank, the program will be called in update mode.
3. Enter a '1' to override the address book authority and allow Netting. If left blank, the address book value will be used.	1 - Allow netting regardless of the setting of the AR/AP Netting field in the address book master record. Blank - Do not allow netting unless the value of the AR/AP Netting field in the address book master record is set to Y. If you leave this processing option to blank, you must be set the AR/AP Netting field in the address book master record to Y prior to entering invoices in the system. If invoices exist before you set the AR/AP Netting field to Y, the system does not display them in the netting application unless the value in this processing option is 1.
4. Enter a valid Pay Status code to override all A/P netted transaction records. This override is ignored when netting Manual Checks.
5. Enter a valid Payment Instrument code to override all netted transaction records. (A/P use only).
6. Enter a value to default into the Alternate Payee in A/P ledger for Payments: " " = Vendor Number "1" = Fifth Address from Address Book
AUTOMATIC POSTING :
7. Enter a '1' to enable the automatic posting of netted batches on exit of program. If left blank, the user will be responsible for the postings.	1 - Post automatically. The system posts the transactions it generates as a result of the netting program, when you exit this program. Blank - Do not post automatically. This processing option applies only to the A/P Standalone Netting program (P03455) that you access from one the A/R or A/P menu. Note: You can not reverse posted net transactions. If net transactions are posted, you must complete the payment process, and then void the payment and reverse the net transaction. JD Edwards World recommends that you leave this processing option blank. If you create net transactions using the Receipts Entry (P03103) or Payment Match with Voucher (P04102) programs, the system posts the net transactions regardless of the setting of this processing option.
VOUCHER ENTRY MODE:
8. Enter '1' to allow changes in Voucher Entry. If left blank, Voucher Entry will be restricted to Inquiry mode.
INVOICE ENTRY MODE:
9. Enter '1' to allow changes in Invoice Entry. If left blank, Invoice Entry will be restricted to Inquiry mode.
PROTECT INPUT FIELDS:
10. Enter a '1' to protect the following fields from updates. Pay Status Payment Instrument Due Date G/L Bank Account Header G/L Date (Today's Date will default)
GENERAL LEDGER OFFSET:
11. Enter an override G/L offset for the Trade A/P account. If left blank, the G/L Class from the Vendor Master File will be used.
12. Enter an override G/L offset for the A/R account. If left blank, the G/L Class from the Customer Master File will be used.
REMARK IN A/P & A/R LEDGER:
13. Enter remark for A/P & A/R ledger. (RPRMK).
VALIDATION OF TRANSACTIONS:
14. Enter a '1' to limit A/P to Vouchers that have been Redistributed ONLY.
15. Enter a '1' to restrict A/P & A/R Netting to Posted transactions ONLY.
DEFAULT POSTING VERSIONS FOR AUTO POST:
16. Enter a Version of the post program for the Receipts Entry Batch. If left blank ZJDE0005 will default.
17. Enter a Version of the post program for the Voucher Entry Batch. If left blank ZJDE0003 will default.
18. Enter a Version of the post program for the Manual Payments Batch. If left blank ZJDE0004 will default.
19. Enter a Version of the post program for the Invoice Entry Batch. If left blank ZJDE0002 will default.
DEFAULT VERSION A/P NETTING VOID:
20. Enter a Version of the A/P Netting Void Payment program (P04456). If left blank, version ZJDE0001 will be used.

106.8 Supplier Analysis Report (P04602)

Processing Option	Processing Options Requiring Further Description
REPORT CURRENCY: Enter the currency that the report is to be stated in. If left blank the report will be stated in U.S. Dollars (USD). This is only used if multi- currency is on.

Processing Option

Processing Options Requiring Further Description

REPORT CURRENCY:

Enter the currency that the report is to be stated in.

If left blank the report will be stated in U.S. Dollars (USD). This is only used if multi- currency is on.

106.9 Supplier Totals by G/L Account (P09450)

Processing Option	Processing Options Requiring Further Description
ACCOUNT DISPLAY MODE:
1. Enter the type of account number to print on the Report. ' ' = Number entered during input. '1' = Structured Account. '2' = Short Account ID. '3' = Unstructured Account Number
DISPLAY ADDRESS:
2. Enter a '1' to print the supplier/ customer address. If left blank, no address will print.