101 Receivables and Payables Netting Processing Options

This chapter contains these topics:

101.1 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.

 

101.2 Build A/P and A/R Netting File (P03465)

Processing Option Processing Options Requiring Further Description
A/R BUILD OPTION:  
1. Enter the DREAM Writer version for the Netting Workfile build for Accounts Receivable (DREAM Writer form P034651).

If left blank, a default of ZJDE0001 will be used.

 
A/P BUILD OPTION:  
2. Enter the DREAM Writer version for the Netting Workfile build for Accounts Payable (DREAM Writer form P034652).

If left blank, a default of ZJDE0001 will be used.

 

101.3 A/P and A/R Netting Report (P03466)

Processing Option Processing Options Requiring Further Description
FORMAT CONTROL OPTIONS:  
1. Enter one of the following format options:

' ' = Domestic Only aging

'1' = Foreign Currency aging

(198 Characters)

 
2. Enter a '1' to print the Supplier's Invoice Number beneath the document information on the report.

If left blank, the invoice number will not be printed.

 
COMPANY CONSTANTS AGING:  
3. Enter a '1' to retrieve the aging specifications from A/R Constants.

If left blank, the processing options for aging will be used.

Note: Report MUST be sequenced and set to page break by company if company defaults are requested.

 
AGING "AS OF" DATE:  
4. Enter the "As of" date to age open balances.

If left blank the current date is used as the default.

 
AGING DATE METHOD:  
5. Specify one of the following dates to age accounts from:

D = Due Date (Default)

I = Invoice Date

G = G/L Date

Note: The Statement Date Aging Method of "S" is invalid in Accounts Payable and is also invalid for this report.

If "S" is specified, the Due Date method "D" will default.

 
AGING CALCULATION METHOD:  
6. Specify one of the following methods for aging calculations:

1 = Aging Days (Default)

2 = Fiscal Periods

3 = Calendar

 
AGING CATEGORY INFORMATION:  
7. Enter the following aging category information: (for method "1" only)

(Aging Days)

Beginning

Thru

Thru

Thru

Thru

 
AGING CREDITS:  
8. Enter a '1' to age credits. If left blank, all credits will apply only to the current aging column.  
AGING DAYS MAXIMUM:  
9. Enter the maximum amount of aging days for a transaction to be included on the report.

If left blank, all transactions will be included regardless of aging days.

 
FILE BUILD OPTIONS:  
10. Enter one of the following values to control the workfile build:

Blank = No file build (Default)

'1' = Build permanent file

'2' = Build temporary Workfile

Note: Temporary file will be cleared at the completion of the report.

 
A/R BUILD OPTION:  
11. Enter the DREAM Writer Version for the Accounts Receivable workfile build (DREAM Writer Form P034651).

If left blank, a default of ZJDE0001 will be used.

 
A/P BUILD OPTION:  
12. Enter the DREAM Writer Version for the Accounts Payable workfile build (DREAM Writer Form P034652).

If left blank, a default of ZJDE0001 will be used.

 
ROUNDING FACTOR:  
13. Enter desired rounding factor:

' ' = No rounding (Default)

'0' = Round to decimals only

'1' = Divide by: 10

'2' = Divide by: 100

'3' = Divide by: 1000

'4' = Divide by: 10000

'5' = Divide by: 100000

Note: Values '0' through '5' will also round amounts to whole numbers without decimals. Amounts are divided with 4/5 rounding. Actual recorded amounts (unrounded) are used to accumulate the report totals.