• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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.
 

roland_rueegg15

Active Member
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: owner-jdelistml@jdelist.com [mailto:eek:wner-jdelistml@jdelist.com]Im
Auftrag von wsellers
Gesendet: Mittwoch, 7. Februar 2001 14:41
An: jdelistml@jdelist.com
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
*************************************************************
 

Chad_Anderson

Active Member
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
 

wsellers

Active Member
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.
 
Top