RE: [SYSTEM21] Inventory report

["Kincer, Alan" <akincer@xxxxxxxxx>]

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. 
============================================================================