Incomplete Receipts

Diane_Krell-Bat

Member
When we receive PO lines interactively using P4312, some of the lines
(F4312) in the PO are not updated and the associated receiving detail
(F43121) records are not created, even though item ledger and general
ledger records are created for the lines that weren't updated. Usually, at
least one line in the order is received correctly and the rest aren't.
This has been very hard to track down because it happens to one order every
few weeks. I can't find any pattern. Has anyone else experienced or been
able to resolve this?


Diane Krell-Bates
Edwards Lifesciences, Inc.
Email: [email protected]

OW: B733.2 SP15_006 4116422, 4605023
AS400 V4R3/WNT 4.0/SQL7.0 Central Objects
Citrix Metaframe 1.8
 
We experienced similar, not all files were updated we changed our ini
settings (personal and server) to 200 (they were 4) this seems to have
helped tremendously, we had found that it was somewhat workstation related
i.e. the "receivers" usually had slower computers therefore the timeouts
were more frequent on theirs. Its too early for us to say the problem is
totally solved but we haven't seen reoccurrence since.
 
We have seen similar stuff, in several flavors. Ours were eventually blamed
partly on an Oracle version incompatibility. Still get a few. Also have seen
inventory issues update F41021 and nothing else. I suggest looking for
dropped issue records also. The best defense is to write your own integrity
reports that look at all inventory transactions for:

1. Matching records among: F4111 and F0911 and F43121 (receipts only) and
F4311 (receipts only). (For F4312 I think you mean F4311)
2. Change in F41021 on-hand balance.

Reversal of a receipt will look strange on your report, because the reversal
does not add a record and leave the original record. It changes the original
record.

Dave Mallory Denver Water 7332 SP15.1 Oracle 81634 NT 4.0
 
I agree. We have about 60 such integrity scripts which run daily. Check
everything from sales orders to inventory to invoicing to the GL. Stuff
falls out for all sorts of reasons. I don't really see how anyone could even
operate without these types of checks going on on a regular basis. If you
are not then I bet you have some hidden troubles you are unaware of.
However, I would be very interested in hearing the details in regards to the
Oracle version incompatibility. In most of the cases I'm aware of it is
simply poor code on JDE's part.

- Ethan
- San Diego, CA
- www.FreeOCP.com
 
The only information I have is that, with OW 7332 and SP15.1, JDE
recommended we "upgrade to Oracle 81634."
 
Re: RE: Incomplete Receipts

hi deraa,
what ini setting is that? from what 4 to 200?
kindly explain and thanks.

pander
 
Re: RE: Incomplete Receipts

Yeah, which settings? We are having the exact same issues lately and are trying to determine if our settings reverted to the original settings after our latest full client package install.

Which timeout settings did you change from 4 to 200?

Justin Revoredo
Amersham Pharmacia Biotech
OW B733.2 SP11.1 AS/700 Oracle/DB2
 
Does anyone know if these Oracle compatibility issues only apply if the Business Data is on Oracle? Oracle houses our central objects, but the Business data is on DB2.

This problem with PO's not closing is increasing in frequency and we are having trouble finding out why...

Thanks,

Justin Revoredo
 
There could be many reasons for this, have there been any modifications to
the application? Did you try to debug the application to make sure the
business function to the close the receipt is being called correctly. Check
the processing options? Try the vanilla versuion to make sureit is not
working as well, if it is working your version could be hosed.


----Original Message Follows----
From: JRev <[email protected]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: Incomplete Receipts
Date: Tue, 22 May 2001 08:53:42 -0700 (PDT)

Does anyone know if these Oracle compatibility issues only apply if the
Business Data is on Oracle? Oracle houses our central objects, but the
Business data is on DB2.

This problem with PO's not closing is increasing in frequency and we are
having trouble finding out why...

Thanks,

Justin Revoredo



--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=11352
 
RE: RE: Incomplete Receipts

Pander,

We applied these settings to the client jde.ini:

[JDENET]
connectTimeout=200

[NETWORK QUEUE SETTINGS]
JDENETTimeout=200

Viorel

OW XU1, SP13, NT, SQL 7
 
We were experiencing this problem aswell. It seemed to happen only on large receipts (ie many lines).

The solution I was given was to change a processing option on the receipts program.

P4312 on the process tab choose '1' to print 'Receipt Traveler Documents'

This will force all updates to take place before the document prints maintaining the data integrity. We can now receive receipts of 400+ lines with no data integrity issues.

Sean

XE SP15, Solaris, Oracle8.0.6, JAS NT, WebSphere3.5
 
RE: RE: Incomplete Receipts

Viorel,

Do you have remote sites where receipts are being processed?

Gary Waer, North County Transit.
 
Back
Top