Item Ledger missing Sales Transactions

Dear List,

B733.2 SP 10.1
Oracle 8.1.5
RS 6000
Citrix 1.8


I have seen some transactions where there are items on the Sales Order
that are ship confirmed but these do not get written to the Item
Ledger.

The Sales Update writes them off the G/L, but the quantities do not
get relieved from inventory. You can imagine that makes reconciling
inventory back to the G/L a fun experience !

I have not been able to determine any pattern to the transactions, it
has generally been on about 1-2 orders per day. I have designed a
report to check F0911 transactions back to the F4111 to highlight any
potential problems, but would obviously like to eradicate the problem.

The only discernable pattern is that it is only the last lines on the
sales order that go missing. e.g. if an order has 10 lines on it, the
first 6 may be relieved from inventory, but not the last 4.

Has anyone experienced this before ??

Thanks and regards,

Adrian Skuodas
Deloitte Growth Solutions - Sydney


***********Confidentiality/Limited Liability Statement***************

Have the latest business news and in depth analysis delivered to your
desktop. Subscribe to "Insights", Deloitte's fortnightly email
business bulletin . . .

http://www.deloitte.com.au/preferences/preference.asp

This message contains privileged and confidential information intended
only for the use of the addressee named above. If you are not the
intended recipient of this message, you must not disseminate, copy or
take any action in reliance on it. If you have received this message
in error, please notify Deloitte Touche Tohmatsu immediately. Any
views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
Deloitte.

The liability of Deloitte Touche Tohmatsu, is limited by, and to the
extent of, the Accountants' Scheme under the Professional Standards
Act 1994 (NSW).

We had a similar problem at one of our clients (B7332/Oracle/HP 9000).
P42800 has a bug, you will need a tools person to assist you in fixing the
problem. We found that the business function B4200560 aborts under certain
conditions resulting in the F4111/F41021 transaction not been written or
updated. It seems that one of the key fields is defined with as a 10
character field instead of a 11 character field.

Please feel free to contact us should you need any additional assistance. We
are contactable on the D&T international e-mail system.

Call JDE to get the SAR / ESU to fix this problem. Most likely it's the
problem that a group of us have bumped into. Our machines were too fast and
when we wrote records to the ledger, there were a few isolated incidents
that we were writing two records within the same second for the same detail
line. If you look closely the key includes date and time, but the time is
only 6 digits; thus if you write too quickly, the second write will be a
duplicate key and will be skipped.

JDE fixed this, and I'm sorry I don't know the exact SAR / ESU for the fix,
by slowing the program down around the second write. If the key already
exists, they try again until successful. Although not pretty, it is
functional.

Good luck.

Free advice from a free consultant


On Mon, 6 Nov 2000 22:58:55 -0800 (PST), [email protected] wrote:

> Dear List,
>
> B733.2 SP 10.1
> Oracle 8.1.5
> RS 6000
> Citrix 1.8
>
>
> I have seen some transactions where there are items on the Sales
Order
> that are ship confirmed but these do not get written to the Item
> Ledger.
>
> The Sales Update writes them off the G/L, but the quantities do not
> get relieved from inventory. You can imagine that makes reconciling
> inventory back to the G/L a fun experience !
>
> I have not been able to determine any pattern to the transactions,
it
> has generally been on about 1-2 orders per day. I have designed a
> report to check F0911 transactions back to the F4111 to highlight
any
> potential problems, but would obviously like to eradicate the
problem.
>
> The only discernable pattern is that it is only the last lines on
the
> sales order that go missing. e.g. if an order has 10 lines on it,
the
> first 6 may be relieved from inventory, but not the last 4.
>
> Has anyone experienced this before ??
>
> Thanks and regards,
>
> Adrian Skuodas
> Deloitte Growth Solutions - Sydney
>
>
> ***********Confidentiality/Limited Liability Statement***************
>
> Have the latest business news and in depth analysis delivered to your
> desktop. Subscribe to "Insights", Deloitte's fortnightly email
> business bulletin . . .
>
> http://www.deloitte.com.au/preferences/preference.asp
>
> This message contains privileged and confidential information intended
> only for the use of the addressee named above. If you are not the
> intended recipient of this message, you must not disseminate, copy or
> take any action in reliance on it. If you have received this message
> in error, please notify Deloitte Touche Tohmatsu immediately. Any
> views expressed in this message are those of the individual sender,
> except where the sender specifically states them to be the views of
> Deloitte.
>
> The liability of Deloitte Touche Tohmatsu, is limited by, and to the
> extent of, the Accountants' Scheme under the Professional Standards
> Act 1994 (NSW).
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=567
> *************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html