|
I am not sure I understand your question, but are you asking me if there are multiple stock records for the exact same item in the stock file? I do not believe so but I will need to check and verify that. I never thought of that which could explain the duplication if in fact that is the problem. On Wed, 21 Sep 2005 12:12:08 -0500, Andy Renk wrote > Are there multiple records in the stock file for each of the item #'s? > > -----Original Message----- > From: midrange-l-bounces@xxxxxxxxxxxx > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Douglas W. > Palme Sent: Wednesday, September 21, 2005 10:57 AM To: Mid Range > List Subject: duplicate data showing up in logical [heur] > > I have a logical file that is a three way join, line item file, stock > file > and customer master file. The DDS for this file is as follows: > > *************** Beginning of data ************************************* > R PROFIT JFILE(IMPILN00 IMPITM00 > + A IMPICM00) > A J JOIN(IMPILN00 > IMPITM00) A > JFLD(ILNSTK ITMSTK) A J > JOIN(IMPILN00 IMPICM00) A > JFLD(ILNSOLDTO ICMCUST#) A ILNINV# > A ILNSOLDTO > A ICMNAME > A > ILNEPRICE A > ILNINVDATE A > ITMSTK A > ITMCLASS > A ILNEUAVCST > A K ILNSOLDTO > A K ILNINVDATE > A O ITMCLASS COMP(NE 'SPC') > > However we have noticed that we are having some data that is being > duplicated in this file. So I ran an interactive query (using > strsql) to see what it returns. for invoice number "S 01612378" I > am getting 12 records returned. Which some of them are duplicated 3 > times for one line item, 4 for another, and 5 for the final one. > > So I ran it against just the line item PF and it returned the correct > number > of records, 7, with the correct extended price amounts. > > So it would appear that something in the logical is not correct but for > the > life of me I have been unable to figure it out, so any suggestions or > hints > would be appreciated. > > Douglas > > If you bought, it was hauled by a truck - somewhere, sometime. > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) > mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To > subscribe, unsubscribe, or change list options, visit: > http://lists.midrange.com/mailman/listinfo/midrange-l or email: > MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment > to review the archives at http://archive.midrange.com/midrange-l. > > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you are not the intended recipient you are > notified that disclosing, copying, distributing or taking any action > in reliance on the contents of this information is strictly > prohibited. Please note that any views or opinions presented in this > email are solely those of the author and do not necessarily > represent those of the company. > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) > mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To > subscribe, unsubscribe, or change list options, visit: > http://lists.midrange.com/mailman/listinfo/midrange-l or email: > MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment > to review the archives at http://archive.midrange.com/midrange-l. If you bought, it was hauled by a truck - somewhere, sometime.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
