Integrity Reports : S&D

[sandeep]

HI List,

Am Working for a client on Oneworld XE B73.3.

Am stuck in Both the Integrity Reports for Inventory Module.

A : Item Ledger v/s Item Availability Integrity.
Have carried out the As of processing and Updating. Still on running the report, the output does not match with what the Item Ledger contains. The report is throwing out Incorrect Figures. is there any set up related issue that I'm missing out. Any SAR's ( Update 6 has been carried out).
Prior to running the As OF Processing, a host of integrity corrections related to Multiple updates in cardex etc have been carried out on a very large scale

B : Item Ledger v/s General Ledger Integrity.
This report is throwing out all the ST/ OT related TS and TO docs and many other variances as well
Have set up udc 41/IN for the following exceptions
a: All Sales invoice Doc Type : 1
b : All PV and like DoC types : 2
c : All OV/IT and like Doc Types : 3
Is this correct. the doc types for Orders dont appear in this udc. what happens if 0 is put as the first digit in Description 1 field of this udc.
Is there any SAR related to this report.

Also, while activating the udc 00/AT for manual Rollback of F41021, is there any other set up that needs to be done. F41021WF table exists but transactions are not being trapped

Any / All input and assistance is most welcome

Thanking you

Sandeep

 

[Craig_Potter]

A : Item Ledger v/s Item Availability Integrity.
I believe that this program will only read F4111 records with a G/L Date
from the start of the current fiscal month to today. All prior transactions
are sourced from the As-Of file (F41112). Is this consistent with your own
reconciliations of the 'Item Ledger' figures on this report? If the answer
is yes, it sounds like your F41112 is out of sync with your F4111 (if I read
your post correctly that the Item Ledger is OK). The program will only read
1 F41112 record for each Item Branch record and expects that this record
will have the Opening balance for the Fiscal Year and all Item Ledger
transactions for this fiscal year (prior to the current period) in the
period buckets.
So, spot check a couple of your records on your report and see if you can
make sense of the figures. Does the opening figure look OK? Does each month
bucket add up with the Item Ledger?
If you do not have a current year record in the As-of, use the R41548
program to create current year records. This program should be part of your
End of year Inventory close-off process as it creates opening As-of records
for the year. (Note the As-of generation will only create these records if
you have had transactions in the current year).

Watch out for users changing UOM conversions between a non-primary
transaction and the As-of generation - the Item Ledger does not hold the
primary qty on a non-primary transaction and will therefore use the current
conversion rate to calculate the primary qty.


B : Item Ledger v/s General Ledger Integrity.
What's behinfd the use of UDC Table 41/IN?.
This UDC is set-up for each document type and using the 1st Position of
Description 1 the program decides the Object accounts which are valid for
each document type. The codes in this UDC represent the AAI's which will be
interrogated to find the valid Object Account codes as follows...

1 - 4240 & 4241
2 - 4310 & 4385
3 - 4122, 3110, 3910, 4134, 4152, 4162, 4172, 4240, 4241, 4310, 4385, 4330
(Note: 4330 added recently due to a SAR in May 2001)

So, the program goes out to the AAI tables and builds a list of Object
Accounts using the Company (and Company 00000) and the G/L Class (and G/L
Class '****') from the F4111 record. IT DOES NOT USE THE DOCUMENT TYPE!!! It
then reads all F0911 records and looks up the valid Object Account list that
it has built to determine whether this F0911 should be included in the
Account Ledger figure.

Therefore, if you have multiple object accounts listed in one of the above
AAI groups (irrespective of document type) and it just so happens that both
the object accounts found in the DR & CR on one of your Document types
exists - you've got a problem (i.e. Account Ledger column = 0).
One option is write your own Integrity program (many do), alternatively you
could modify this program to look to your own AAI entries (i.e Create AAI
entry 5501 and modify B4100910 to use this AAI table if UDC 41/IN = 4?).

Hope this helps.

Craig



Craig Potte

 

[sandeep]

Re: RE: Integrity Reports : S&D

HI Craig,
Thanks for the reply. It was surely quite helpful.
Have managed to get both the reports up and running.
Just a few minor issues in R41543:
All ST/OT are being reported. The JD white paper mentions that Interbranch Transactions should have a batch type (GLICUT) ST which this report is supposed to bypass. but out here the batch type (GLICUT in F4111) is G.
Thanks again.
Sandeep

 

[pjoh]

Re: RE: Integrity Reports : S&D

I would be interested to know if the reports you are running are useful to keep the F4111 / F0911 in balance. Due to the construct of the 41 IN only pointing to Object accounts and not Object.Sub, we gave up on this and are working on exports to a database and then do our Integrity checking in it. My view of prior messages on this topic is that many others are in a similar state of despair. But if you are successful, then perhaps we need to reconsider. I will be interested in your reply.

 

[grrezek]

Re: RE: Integrity Reports : S&D

Did you write your own item ledger/Account integrity?
If so would you tell how you did it?

 

[marsyang]

Need help

I see the document of JDE ,But it doesn't mention the Rule 3 but there is a Rule 0.Also it calls the "exception rull".I need your help.

 

[pjoh]

RE Gl and Item Ledger F4111 Integrity

We gave up using standard JDE Integrity testing on this one. The Integrity Report looks at the Objects only in the DMAAI table to determine what general ledger accounts it will use to reconcile against. Due to the way we have constructed our DMAAI's, many errors are reported that are not errors at all. If the Integrity report would look at Object and Sub, it would work fine for us. We do not understand why Object AND Sub are not called by the Integrity report.