R43450 Received Not Vouchered Reconciliation

mjf

Well Known Member
We are having a problem with running R43450, the Received Not Vouchered Reconciliation report. It takes hours to run.
We have around 10 million records in our F43121 file. I suspect that our problem is with data selection. Could somebody out there who is running this report successfully, please let me know what data selection they have in their versions.

Many thanks

Marty
 
We had similar problem. We modified data selection as below:
Match Type EQ 1
Written by EQ *BLANKS
Amount Open NE 0000000000000000
Received Not Vouchered Account NE 0
Account ID NE *ALL
Cheers!!!
Niranjan
mjf wrote:We are having a problem with running R43450, the Received Not Vouchered Reconciliation report. It takes hours to run. We have around 10 million records in our F43121 file. I suspect that our problem is with data selection. Could somebody out there who is running this report successfully, please let me know what data selection they have in their versions.Many thanksMarty
OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=Apps&Number=41191
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World / Xe® and World Applications mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

Niranjan B.BhatiaSystemic Software Solutions (India) Pvt.Ltd. Tel: +91 22 564 7990 / +91 22 599 1246 Cell: +91 98210 57941We Analyze - Explore - Innovate - AchieveVisit: www.systemicsoftware.com or Write to [email protected]



---------------------------------
Get a bigger mailbox -- choose a size that fits your needs.



Tel: +91 22 564 7990 / +91 22 599 1246
Personal E-mail: [email protected]
Web-site: www.systemicsoftware.com
 
We have a very large F43121 and the following criteria allows the report to run quickly.

Type - Match Record Type F43121 = 1
Units - Open Not Equal to Zero
Amount Open Not Equal to Zero
Cost - Landed Cost Not Equal to 3
Business Unit = (Business Unit of the User Choice)
Order Type = OP
 
Thanks Pjoh. I'll give this a go.

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]

OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K






OneWorld: Xe SP16.1
Database: Oracle 8i
Enterprise Server: Compaq Proliant 8500R W2K
 
Back
Top