EDI Vouchering

mic_78

Member
Hi Everyone,

We have been facing a problem on PO Vouchering process. But the vouchering here is not manual, done by EDI process using webmethods. When the supplier sends the invoice, webMethods will be populating the records in F47041 and F47042. Once the record comes in these EDI tables, the standard program R470412 is run and it does the vouching process. Many a times, what we see is, for a partail PO receipt line ( eg: Line no 8 in PO, received twice, one for 8 and one for 2, against the original order quantity of 10), system fails to insert a PV line for the second receipt line (qty 2) into F43121 but has updated the AP and GL tables properly for both the receipts. The question here is , why it is failing to insert a PV line in F43121 and hence these lines are being captured in our reconcilliation report and creates lot of noise.

Would be great, if someone could throw some light on this.

Thanks,
Mic

JDE OneWorld Xe, SP 22 on Windows 2000.
 
You need two F47042 records in your case, 1 for each received line with
the proper quantity received and add the value of F43121-PRNLIN to the
F47042-SZURAB field. The EDI 810 documentation from World is more complete
then the same for Xe and works in E1.

Guy Robert




mic_78 <[email protected]>
Sent by: [email protected]
03/28/2007 04:30 AM
Please respond to
JD Edwards® EnterpriseOne Applications <[email protected]>


To
[email protected]
cc

Subject
EDI Vouchering






Hi Everyone,

We have been facing a problem on PO Vouchering process. But the vouchering
here is not manual, done by EDI process using webmethods. When the
supplier sends the invoice, webMethods will be populating the records in
F47041 and F47042. Once the record comes in these EDI tables, the standard
program R470412 is run and it does the vouching process. Many a times,
what we see is, for a partail PO receipt line ( eg: Line no 8 in PO,
received twice, one for 8 and one for 2, against the original order
quantity of 10), system fails to insert a PV line for the second receipt
line (qty 2) into F43121 but has updated the AP and GL tables properly for
both the receipts. The question here is , why it is failing to insert a PV
line in F43121 and hence these lines are being captured in our
reconcilliation report and creates lot of noise.

Would be great, if someone could throw some light on this.

Thanks,
Mic

JDE OneWorl! d Xe, SP 22 on Windows 2000.
 
Some questions

Are there two lines coming or one?

Is the tolerance check turned on?

The R470412 takes the NLIN(part of the key in 43121) from the user number (URAB) field of the 47072. Unless you go through the code you will not find this. This atleast is the case in 8.10. check whether this could be populated somehow and then two PV's will be generated.

let me have the answers for the above.
 
Thanks for the replies.

Ok. We have a custom program running before the actual EDI run ( R470412 ), the custom program populates NLIN from F43121 in the URAB fielf of F47042. The problem here is, sometimes it all works fine as the way it is expected to behave, sometimes not...

Coding part is fine, and the most interesting thing here is, except inserting records in F43121 for a PV, it populates AP and GL perfectly for the missing line in F43121. This looks tricky as it has shut the door for us to reprocess the records as it has updated AP and GL perfectly.

Thanks,
Mic
 
Hi,

Answers to your questions:

1. We don't have tolerance check turned on. But does it make any difference, coz I am not sure we have so many countries up and live, not really sure about the setups in each country...but please let me know if this makes any difference.

2. We have two lines coming into the EDI table if there are two receipts against a line no.

Hope I have made it clear, awaiting your comments.

Thanks,
Mic
 
Back
Top