My Oracle Support Banner

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 FEBRUARY 06, 2019

Applies to:

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


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.





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.