× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



This is awesome! I'm creating the requisite results fields. Any
recommendations on how to compute the overall quantity variance? Will
averaging the percentage field do this or do I need to do another percentage
on the difference between the sums of all QTEM77 & QTEA77?

Thanks again Joe!

Alan

-----Original Message-----
From: Joe Roesch [mailto:jroesch@xxxxxxxxxxxxxxx] 
Sent: Friday, January 23, 2004 5:56 PM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] Inventory report

Query....

JOIN:
Field             Test     Field 
CONO58            EQ       CONO77
STRC58            EQ       STRC77
CTNO58            EQ       CTNO77
CONO77            EQ       CONO60
STRC77            EQ       STRC60
PNUM77            EQ       PNUM60

SELECT:
        STAT58            EQ     '3'      


-----Original Message-----
From: Kincer, Alan [mailto:akincer@xxxxxxxxx] 
Sent: Friday, January 23, 2004 5:51 PM
To: System 21 Users
Subject: RE: [SYSTEM21] Inventory report

Can this be tied together in query or does it require rpg program?

-----Original Message-----
From: Joe Roesch [mailto:jroesch@xxxxxxxxxxxxxxx] 
Sent: Friday, January 23, 2004 5:20 PM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] Inventory report


Key Files:
        INP58 - Count data (STRC58, PERN58, STAT58 = 3) 
        INP77 - Count Quantity Details (Recorded QTEM77 & Counted QTEA77) 
        INP60 - Cost per unit

This can be done best at "today's" standard, latest cost, etc from INP60.
As always, you will need to scrutinize your own data for anomalies specific
to your company.  


Best of Luck


-----Original Message-----
From: Kincer, Alan [mailto:akincer@xxxxxxxxx] 
Sent: Friday, January 23, 2004 4:55 PM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Inventory report

When counts are created and closed in /INS menu, two reports are generated.
One is a count details showing qtys/values/variances etc. The other is a
movements report for all the inventory adjustments.

 

I would like to print a comprehensive report (such as the first one I
mentioned) that lets the user enter a range of counts (i.e. counts 200-230)
which for us typically represent a complete inventory. I would like to be
able to distill this into a report that will show the variance for this
entire inventory instead of the individual variance summaries. Can this be
done?

 

What table are looked at when this report is printed at the end of each
count?

 

Thanks everybody.

 

Alan 

 



=== [ KI (USA) Corporation - http://www.kiusa.com ]
====================================== 
Tel. 859.986.1420  --  Fax. 859.986.1485 
This e-mail, including any attachments, contains information from KI (USA)
Corporation that may be confidential or privileged. Mail is intended only
for those to whom it is addressed. If you are not the intended recipient do
not copy, distribute, or take any action in reliance on the contents of this
message. 
If you have received this e-mail in error notify the sender immediately then
delete or destroy all electronic and hard copies of this communication,
including attachments. 
KI (USA) Corporation's anti-virus system checks for known viruses. However
you are advised to run your own virus check before opening any attachments
received. KI (USA) Corporation will not accept any liability once an e-mail
and/or any attachment is received. 
Views expressed in the e-mail are those of the author and not necessarily
those of KI (USA) Corporation. 
============================================================================


_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.




=== [ KI (USA) Corporation - http://www.kiusa.com ]
====================================== 
Tel. 859.986.1420  --  Fax. 859.986.1485 
This e-mail, including any attachments, contains information from KI (USA)
Corporation that may be confidential or privileged. Mail is intended only
for those to whom it is addressed. If you are not the intended recipient do
not copy, distribute, or take any action in reliance on the contents of this
message. 
If you have received this e-mail in error notify the sender immediately then
delete or destroy all electronic and hard copies of this communication,
including attachments. 
KI (USA) Corporation's anti-virus system checks for known viruses. However
you are advised to run your own virus check before opening any attachments
received. KI (USA) Corporation will not accept any liability once an e-mail
and/or any attachment is received. 
Views expressed in the e-mail are those of the author and not necessarily
those of KI (USA) Corporation. 
============================================================================


_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


=== [ KI (USA) Corporation - http://www.kiusa.com ]
====================================== 
Tel. 859.986.1420  --  Fax. 859.986.1485 
This e-mail, including any attachments, contains information from KI (USA)
Corporation that may be confidential or privileged. Mail is intended only
for those to whom it is addressed. If you are not the intended recipient do
not copy, distribute, or take any action in reliance on the contents of this
message. 
If you have received this e-mail in error notify the sender immediately then
delete or destroy all electronic and hard copies of this communication,
including attachments. 
KI (USA) Corporation's anti-virus system checks for known viruses. However
you are advised to run your own virus check before opening any attachments
received. KI (USA) Corporation will not accept any liability once an e-mail
and/or any attachment is received. 
Views expressed in the e-mail are those of the author and not necessarily
those of KI (USA) Corporation. 
============================================================================



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.