Integrity Issues in Account Receivable

mattw

mattw

Member
I would be very grateful if someone could provide me with details of common integrity issues that occur in World, the integrity reports that are run to identify them and how they are resolved. Many thanks
 
mattw,
Go to menu G0922 and you can see all reports used for Integrity issue.

Run to check if there is any unposted batches then for transaction and for company. This reports will show you where the problem is.

Thanks,
 
This isn't any direct help, but here goes. For A/R, you can read help text for P03701 & P037001. For me that would be on G0321--HELP 14 and HELP 15, respectively. You could also log on to the Oracle/PS Customer Connection site & search for knowledge documents or call the Support Line & request that the documents be emailed to you. There was a document that gave the preferred order of running integrities but I don't have it now. I believe that the General Accounting II manual covers integrities. If you don't have it, you can download from Customer Connection.
 
Chan,



Oh wow - has JDE put A/R A/P integrity reports on the G/L integrity menu
G0922?

I haven't seen this yet, it must have come with one of the more recent
cumes.

I look forward to seeing it - beats having to create tailored "All
Systems Integrity" menus at every client.
 
Matt,



I have forwarded to you (via "off list" email) an old document I wrote
covering the essential AP AR and GL integrity reports. It may be of
help/



Some of the "common" and less common causes of integrity problems
between AR and GL might include:-



* Manual (or other) journal entries to the AR control account(s)
in GL - always use a separate GL account (OBJ or OBJ.sub) to hold
accrual journals or temporary (from an idealist view there should be no
such things) "adjustments"
* Unposted F0311 records - either, or both, original and matching
records
* Batches that have not completely posted - there has been a
"crash" in the middle of the post process
* Unposted batches that have "lost" their batch header
* Cash receipts batch that has been posted but the related invoice
batch(es) still unposted.
* Cash receipts that have been applied to a date earlier than the
related invoice - a nasty one especially around month end



For my money, if the integrity report (AR to GL by control account)
shows no difference then the problem lies with the A/R trial balance you
are using to reconcile manually to G/L with - check selection criteria
etc. If you are using the "as of" file for the t/balance make sure it
has been refreshed and the date selection criteria etc are correct. If
nothing is apparent then look for evidence of the last mentioned cause
above.



I am sure that there plenty of others on this list who can provide you
will many more causes.



If you have a couple of specific cases, then if you email me the details
I will try and help.
 
Re: RE: Integrity Issues in Account Receivable

hi collin, can i get a copy of your documentation on the AR/AP/GL intergrity. regards
 
RE: RE: Integrity Issues in Account Receivable

My name is Colin - with one "l". Integrity is the correct spelling, not
"intergrity"



What I said and did in February (long before you joined the List) was
for one specific JDELister in response to one specific post. I did not
offer the documentation openly and freely to everyone.
 
Try searching for WFN-01-0009 and one of the results will be the document you referred to: Integrities - Preferred Order and Functionality Overview.
 
Ahh George,



The apparent "lister" asked specifically for my documentation - not
WFN-01-0009. I really don't like "list trawlers" who are new to JDEList
and have posted or replied diddly squat, coming along months and months
after a post (and its replies) and seeking freebies in exchange for
nothing. Use the JDEList functions and see just when this lister joined
and what he/she has posted since joining. If they were to post
something sensible outlining their need or problem then I am more than
willing to help.
 
Re: RE: Integrity Issues in Account Receivable

Colin,

My post was not in reply to your issue with the post for your documentation. Mine was an assist to dhashimura about the document on the Customer Connection with the perferred order of running the integrity reports. I happened to have a copy the the document mentioned in my files, so I double-checked if was still available, it was, so I sent a post.

I usually appreciate your posts and comments as it is sometimes amusing and interesting to read your point of view. I also reserve my comments to when I really feel I have something to share, mainly because I don't appreciate all of the "Out of Office" auto-replies. However I also don't like being jumped about a reply that did not involve you as I took specific action to log on to the forum and reply to the specific portion of the thread that I was participating in. I to don't particularly appreciate seeing the same question over and over or having to read about Citrix Server and why the server crashed, but I feel it is necessary to stay involved and contribute when I think I have something of value.

Besides the person that originally listed this question had only 1 post and you provided them with your documents offline and there wasn't a need to let the rest of us know about it, especially if you weren't willing to share.
 
Back
Top