Sales Order Integrity F4201 -vs- F4211

wsellers

Active Member
Does anyone know of a sales integrity report that will show me where the system has F4211 detail records but without a matching F4201 header record?

OW B733.2 SP10

Walt S.
 
AW: Sales Order Integrity F4201 -vs- F4211

No, but what about the SQL statement:
select sddoco from proddta.f4211
where sddoco not in (select shdoco from proddta.f4201 where shdcto = sddcto
and shkcoo = sdkcoo)

Cheers
Roland.

-----Ursprüngliche Nachricht-----
Von: [email protected] [mailto:eek:[email protected]]Im
Auftrag von wsellers
Gesendet: Mittwoch, 7. Februar 2001 14:41
An: [email protected]
Betreff: Sales Order Integrity F4201 -vs- F4211 ~~0:5185


Does anyone know of a sales integrity report that will show me where the
system has F4211 detail records but without a matching F4201 header record?

OW B733.2 SP10

Walt S.
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=5
185
*************************************************************
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
*************************************************************
 
There wasn't one in B733.1. We had to created a custom report to do that.

Chad Anderson
Generac Portable Products L.L.C.
B733.1 SP 7.1 AS400 Ent NT SQL Deploy
 
We set up a simple query in Access and ran the two tables against each
other. This worked just fine for follow-up and clean-up.
 
Re: AW: Sales Order Integrity F4201 -vs- F4211

Thanks, I'll have our IT staff run an SQL to find the bad records.

Walt S.
 
Back
Top