Login
Enter your username and password to login. If you do not have a username you can register one.

Username: 
Password: 
Remember Me



Forgotten Password?

Online
3 members and 48 guests have been online with in the last 10 minutes.

Hot Topic
No posts have caught fire as of yet.

JD Edwards® World™ Discussions >> JD Edwards® World™

Pages: 1
Lindsay1~
member


Reged: 06/04/08
Last on: 10/21/11
Posts: 4
Manual Foregin payment bug?
new       #134175 - 06/05/08 01:09 AM

Hello

We are in A8.1 and it looks like there is some kind of bug when matching a foreign voucher payment. Not always but sometimes the roundings are not correct and the difference of .01 causes problems in the AP to GL integrity. Usually ono or two of the accounts each morning appear in the integrity with a .01 difference relating to the payment.

Anyone know whether there is a SAR out there to fix and if so the SAR number

Many thanks

Lindsay


Post Extras: Print Post   Remind Me!   Notify Moderator  
ccornagg
member


Reged: 12/07/02
Last on: 04/04/14
Posts: 129
Loc: Italy
Re: Manual Foregin payment bug?
new [Re: Lindsay1~]       #134183 - 06/05/08 04:51 AM

Lindsay,

this is not nice at all, but for my understanding it's a "logical bug" /
constraint you are sharing with all other JDE version (E1 8.12 as well ...).
It's a rounding issue within header (F0413) and detail (F0414) JDEdwards did
fix on Account Receivable only by adding a new AAI (see R8 - "Rounding
Account").

Regards, ciao.

Carlo



2008/6/5 Lindsay1~ :




Post Extras: Print Post   Remind Me!   Notify Moderator  
Hahn_Associates
member


Reged: 03/27/01
Last on: 04/09/14
Posts: 38
Re: Manual Foregin payment bug?
new [Re: Lindsay1~]       #134204 - 06/05/08 09:44 AM

I am working on a similar issue although we are on 7.3 Cume11.  After voucher matching the V batch will not post because it is out of balance by .01.  The AP Uninvoiced does not balance to the AP Trade account. &nbs p;    

This line of code in the PO receiving program seems to be the cause
 
C           SUB  $$D F15    SHAREC         ;   ADD 2828186 

I partially applied JDE Paper Fix 4044060 to P4312 and based on my testing so far it has solved the problem.  I am not sure if this is the same a s your situation.  If you do a search on the knowledge garden the list of corrections for FC rounding seems endless.      &nb sp;                     




Post Extras: Print Post   Remind Me!   Notify Moderator  
Lindsay1~
member


Reged: 06/04/08
Last on: 10/21/11
Posts: 4
Re: Manual Foregin payment bug?
new [Re: Lindsay1~]       #134214 - 06/05/08 10:38 AM

Hi - thanks for your replies

My problem is slightly different to what you both describe in that the batch posts no problem. The foreign amount (CA) clears the outstanding amount correctly, AP does not register any open amount but the domestic amount in GL (AA) works it out as .01 more or less which makes the control account out by .01 and consequently the AP to GL integ report.

If I can get no further pointers I guess I will have to trawl the knowledge garden.

Thanks again

Lindsay


Post Extras: Print Post   Remind Me!   Notify Moderator  
Leith
member


Reged: 08/05/04
Last on: 03/19/14
Posts: 34
Loc: UK
Re: Manual Foregin payment bug?
new [Re: Lindsay1~]       #134229 - 06/05/08 04:29 PM

Hi Lindsay

These integrity issues can be very tricky to track down. If the report you are talking about is the AP to GL by offset (P047001) there are quite a few issues that can cause imbalances. I spent quite some time writing an application tracking these down.

If it is the above JDE report, you need to think in terms of the report logic more than the data in the F0902 F0911 F0411 F0414. Essentially try to work out what the report is not including. If you are technical or have someone there that is have a look at the criteria for the exclusions of records marked by the iterations in the S003A subroutine, and see if you can work backwards. From memory the most of the penny balancing issues came from the vouchers not being included when the payment was and vice versa. This happens even though the report uses a join logical.

--------------------
Leith Marar

www.qsoftware.com


Post Extras: Print Post   Remind Me!   Notify Moderator  
ccornagg
member


Reged: 12/07/02
Last on: 04/04/14
Posts: 129
Loc: Italy
Re: Manual Foregin payment bug?
new [Re: Lindsay1~]       #134240 - 06/06/08 03:14 AM

Lindsay,

please have a look at an example into your db and you will realize the
rounding issue you are talking about is linked to how Foreign and Domestic
value are calculated at F0411 and F0414 level.
In other words (excluding PG / F0414 gain-loss transactions): F0411 is going
to open your AP trade account and F0414 is going to close it, thus for
example if you can find 100,00 USD equal to 70,00 EUR in your F0411 record
(see RPACR and RPAG fields), you should be able to find -100,00 USD and
-70,00 EUR in your F0414 record (see RNPFAP and RNPAAP fields) at payment
time, while sometimes you may find -70,01 or -69,99 in your domestic curency
for rounding stuff.

If you don't trust in that: please run P04713 "A/P Payments to Voucher
Integrity with Adjustments" integrity report and you will find each AP
voucher line / AP payment transaction causing your issue.

Hope this helps, ciao.

Carlo


2008/6/5 Lindsay1~ :




Post Extras: Print Post   Remind Me!   Notify Moderator  
Lindsay1~
member


Reged: 06/04/08
Last on: 10/21/11
Posts: 4
Re: Manual Foregin payment bug?
new [Re: ccornagg]       #134249 - 06/06/08 06:13 AM

Brilliant Carlo!!

This is the exact report I need. I've not come across this before and cannot see anything in the help text about what it does.

Do you now what it does in Final mode? Does it adjust the F0414 as well as create the journals from the 4.9999 AAI? Where does the other side of the entry go presumably the creditors control account....

I need to run a test on this but would you believe I dont have access to a test environment!

At the best this report is showing me exactly where my problems are and is saving me HOURS every day.

Thanks!!

Lindsay


Post Extras: Print Post   Remind Me!   Notify Moderator  
ccornagg
member


Reged: 12/07/02
Last on: 04/04/14
Posts: 129
Loc: Italy
Re: Manual Foregin payment bug?
[Re: Lindsay1~]       #134264 - 06/06/08 09:57 AM

Lindsay,

please do NOT run P04713 in final mode: it will update F0414 and it won't
make your accounting department happy ! ;-)

The correct solution on both accounting and db consistency sides is to
update (via SQL) F0411.RPAAP (open amount in domestic currency) to reflect
the 1 cent difference (+ or -).
For sure you will need to update F0411.RPPST to "A" as well.

Regards, ciao.

Carlo


2008/6/6 Lindsay1~ :




Post Extras: Print Post   Remind Me!   Notify Moderator  
Grand
member


Reged: 10/27/08
Last on: 10/17/11
Posts: 9
Re: Manual Foregin payment bug?
new [Re: ccornagg]       #139425 - 10/28/08 05:37 PM

Hi there, i am facing a problem similar to this but the integrity report is actually the R04702A (payments to GL by Batch). however for me i actually ran the P04713 in final mode and it caused the difference to appear on the report.
my problem now is that i cant seem to fix it, i have done a check on the F0911 and F0411 and F0414 tables to compare but they all look to have the same domestic and foreign values.
is there a way this issue can be solved without having to use a thridparty software?

Thanks in advance

Grand


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1


Extra information
0 registered and 1 anonymous users are browsing this forum.

Moderator:  ekempter, Christian Audet, jdecnc, Sef 

Print Thread

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Thread views: 4079

Rate this thread

Jump to

JDELIST Support | Privacy statement JDELIST.com

*
UBB.threads™ 6.4.1

 .: IIP 5.4.5 by David Lozier ©2003 :. 
Distributed by ThreadsDev.com

The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither
endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.

This page best viewed with Netscape 4 or Microsoft Explorer 4 or above in 800 x 600 resolution.