E1: FIN: R0018P Does Not Include Vertex Data From F0018 Table (Doc ID 2161208.1)

Last updated on APRIL 09, 2017

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.1 and later
JD Edwards EnterpriseOne Accounts Receivable - Version 9.1 and later
JD Edwards EnterpriseOne General Ledger - Version 9.1 and later
JD Edwards EnterpriseOne Sales Order Processing - Version 9.1 and later
JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When the Tax Detail/Summary report (R0018P) is run over the data in the Taxes table (F0018), it does not include transactions with a Vertex GeoCode in the Tax Rate/Area (TXA1) field.

This is even though the JD Edwards EnterpriseOne Applications Tax Processing Implementation Guide for release 9.1 states in Appendix B that R0018P "lists transaction details from the F0018 table and provides totals for each tax rate/area for each document type by company."

The guide does not state or note anywhere that Vertex information is excluded from this report.

The R0018P should list all transaction details from the F0018, including records with Vertex GeoCodes.

 

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