My Oracle Support Banner

E1: 74: R42565 Not Working when Tax is Set up only for Item in Portugal Environment (Doc ID 2406531.1)

Last updated on JUNE 01, 2018

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.

Symptoms

When the tax is setup only for the Item Number (3, 4, 5, 6 values) in P4008 and R42565 is ran on a sales order with taxable = 3, 4, etc, in a Portugal enable environment, the system doesn't call R74L3030 and doesn't generate an invoice.

Note: if tax exists for no Item Number (generic), the invoice is printed correctly.

Steps:

1. Define an item - 8221133PT - taxable sales = 3 in P41026
2. P4008 define a tax - PORT_VAT set only for Item number (taxable) = 3, not for general
3. P4210 enter sales order and make sure the tax gets applied and the detail line has a taxable = 3 value
4. Run R42565 - it does not call the R74L3030 report and no invoice is generated

WC error -
"
CAUSE . . . . The record to be fetched from table F4008 does not exist or you do not have authority to fetch records from this table.
RESOLUTION. . Verify that the record being fetched exists and that you have proper authority. Check the JDE.LOG and JDEDEBUG.LOG for additional information.
"
The system is trying to fetch the tax from F4008 for item = 0 even if the line was set up only for taxable = 3

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.