E1: 17: Journal Edit Register (R48300) Creates Single Line for Transactions with Different Tax Rate Areas (Doc ID 2225976.1)

Last updated on JULY 14, 2017

Applies to:

JD Edwards EnterpriseOne Service Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

For two (or more) items with different tax values on parts list of an equipment WO, R48300 Journal Edit Register creates a single line in F4822, F03B11, F0911. It combines the amounts and the different taxes into a tax value that does not exist on paper (as an arithmetic mean).
It should allow to have the different tax lines split, but not based on the line billing control id. This will end up with a number of lines in F4822, F03B11, F0911 as big as the initial number of items on the parts list. For the lines with the same tax value, customer would like to have them grouped together in one single record in F4822/F03B11/F0911. This will still work with the correct tax value.

Issue was reported to Oracle development in Bug 25077216 - R48300 JOURNAL EDIT REGISTER CREATES A SINGLE LINE IN F4822, F03B11, F0911:

The above is not a bug and working as designed. There is a little setup that needs to be done in summarization.

Follow these steps (please see attached document "Go to P4805 and add the below summarization key.docx"):

1. Go to P4805 and add the below summarization key
[level break] [summ code] [seq/summ] [Data descr]
1 I AN8 AddressNumber
2 P BCI BillingControlId

2. The new summarization seq is S005

3. Component items setup in item branch P41026:
item 1: Sales Taxable = Y
item 2: Sales Taxable = 3

4. Define two values for the tax in P4008 Work With Tax Rate/Areas for Short
item No:
value 10.00 for blank ( or Y)
value 3.00 for 3

5. Run R48121 over the two billing id's taken from F4812.
Set Processing option as below, process tab, summarization key as the newly created key S005.

 

Yet, this will create a one to one ratio between the lines in parts (F3111) and the financial tables F4822, F03B11, F0911. The business request is to group together only the items having the same tax value. This way there will not be any arithmetic mean value calculation involved for the "new" tax.

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