F4074 Missing Records

Cosmas

Cosmas

Member
Dear List,
After sales order entry the base price record is not written in F4074 file.
When there is Adjustements schedule are not written base price and
adjustements records as well.
According the adjustements we have setup them to be written to F4074 file.
We work on OneWorld Xe.

Have you got any idea ?

Cosmas Caraconstantis
 
The first thing to check is: Did the order pick up the Adjustment Schedule
Name? Take the row exit from order entry details to Additional Info. If it
is not there, then you didn't set it up in the Billing Instructions of the
sold to or you did not setup the Price Adjustment Schedule Preference. If
it is there, then you need to verify that the price details you have setup
for this customer and item should indeed have been found by the pricing
routine. If you still can't figure it out, feel free to send me screen
prints, offline, and I'll try to help you out.

PS. Say hi to Knassos from me!

Andy

Andy Klee

Klee Associates
J.D. Edwards Certified Professional
Voice: (970) 856-4811
Cel: (203) 223-5216
www.JDETips.com
 
Dear Andy,
Thank you very much for your help.

I would like to inform you that the setup is correct and to prove that I can
tell you
that the unit price in the screen of sales order and in F4211 is illustrated
after the calculation
of adjustments of schedule. This means that the price and adjustments work
properly and the only problem is that the records is not written in F4074.
In order to find out what is happening I setup the same functionality in
Pristine environment and I saw the transactions
in F4074 and everything is OK.
Thank you in advance
Cosmas
 
Pretty unusual problem. I've never seen pricing give the correct unit price
(including adjustments) but not write the F4074s. I'd recommend contacting
the JDE response line and/or looking at the SAR system.

Andy Klee

Klee Associates
J.D. Edwards Certified Professional
Voice: (970) 856-4811
Cel: (203) 223-5216
www.JDETips.com

"JDETips: Unpublished Secrets...Undocumented Features...Creative Solutions"
 
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07A2E.54E26310
Content-Type: text/plain;
charset="iso-8859-1"

Hi Cosmas,

We experienced a similar problem when installing B7332 (Coexistence).
Once the order line is entered, you have to click OK before doing any
pricing history enquiries. We found that once the OK is clicked, the records
are correctly written to F4074. However, if a new order line is entered, and
a pricing history row exit is taken before the order is OK'd, the base price
and adjustments display correctly, but they are not written to the F4074. In
addition, any futher enquiries on pricing history will not display the
adjustments, as they are not on F4074.

I hope this is of some help.

Regards
Tony B.
 
RE: RE: F4074 Missing Records

why didn't you just change the file size constraint???

Gene Hockemeyer
Sunbeam Corporation
Manager EDI and EC Business Development
561 912-4877
[email protected]
 
A bit late in responding, but there is an inherent problem in the way
advance pricing now works in OW B733.
All adjustments are written to a temporary file (F40UI74 from memory). The
key to the file is the computer or server name and a next number. This next
number is restarted every time a user goes into add or change mode in P4210
and increments on each new order created or changed. So order #1 gets key
reference 1, order #2 gets key reference 2 and so on). If each user has a
unique PC address and does not go into multiple sessions, then the key in
the temporary file remains unique. If, as we had, users were pointing to
servers, the address used was shared around the users so the key was often
became shared.
When a user completes the order, the records are written to F4074 and the
records deleted from the temporary file using the key. Thus, if the key is
shared, the records of all users with the same address and order key
reference will be deleted from the temporary file at the same time,
regardless of whether they have completed the order entry.
Even worse, transfer orders invoke purchasing advance pricing which uses the
same file and process. However, in this case, the deletion of records is
controlled only by the PC reference.
We did three things to correct the situation. First, we disabled the
deletion of purchase advance pricing records from the temporary file (a
simple fix apparently). We were not using this functionality anyway so
there was no downside to this.
Second, we changed the next number for the order reference key to a unique
next number derived from the next number file. This meant that all
references were then unique. Again this was a simple intervention.
Third, we built a simple integrity report which we ran hourly which looked
at all F4211 records where SO09 = 1 (advance price flag) but where no F4074
records could be found. Provided we found the errors early enough, we were
able to correct them very easily.
When we called JDE (about 9 months ago) they were aware of the PO deletion
problem but not of the more generic one where multiple users would be able
to delete each others temporary records.

----- Original Message -----
From: "andyklee9" <[email protected]>
To: <[email protected]>
Sent: Saturday, January 06, 2001 1:30 PM
Subject: RE: F4074 Missing Records ~~3458:3459


> The first thing to check is: Did the order pick up the Adjustment
Schedule
> Name? Take the row exit from order entry details to Additional Info. If
it
> is not there, then you didn't set it up in the Billing Instructions of the
> sold to or you did not setup the Price Adjustment Schedule Preference. If
> it is there, then you need to verify that the price details you have setup
> for this customer and item should indeed have been found by the pricing
> routine. If you still can't figure it out, feel free to send me screen
> prints, offline, and I'll try to help you out.
>
> PS. Say hi to Knassos from me!
>
> Andy
>
> Andy Klee
>
> Klee Associates
> J.D. Edwards Certified Professional
> Voice: (970) 856-4811
> Cel: (203) 223-5216
> www.JDETips.com
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=
3459
> *************************************************************
> 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
> *************************************************************
>
>
>
 
Back
Top