E1: FIN: Be Able To Set The A/R and A/P Offset Methods At Company Level Due To Tax Capture by Pay Item And G/L Account (P0000, forms W0000D and W0000E; P00218) (Doc ID 2202314.1)

Last updated on NOVEMBER 09, 2016

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version 9.1 and later
JD Edwards EnterpriseOne Accounts Payable - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

The Offset Method in the A/R Constants (P0000, form W0000D) and in the A/P Constants (P0000, form W0000E) specifies how the system generates the offset entry (document type AE) in the Account Ledger table (F0911) when A/R invoices, A/R receipts, A/R drafts, A/P vouchers, A/P payments, and A/P drafts are posted using the G/L Post (R09801) to the F0911.

When the Track Taxes by Pay Item and GL Account functionality is set up, you can activate this only for specific companies. This is done via the Invoice and Voucher Company Tax Constants program (P00218).

This constant does not have to be set system-wide but can be activated for certain companies only. For more information see Chapter 3.10.1 - Understanding Tax Capture Settings in the JDE1 Apps Tax Processing Implementation Guide for 9.1.

However this functionality requires that the Offset Method for A/R and A/P is set to S, which means that the system creates one offset for each pay item by account. This results in a lot of extra records if originally these constants were set to B (Offset by Batch) or Y (Offset by Document).

Clients are requesting to be able to set the Offset Method constants for A/R and A/P at the company level, so that they can activate it only for those companies for which they have activated Tax Capture by Pay Item and GL Account in P00218.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms