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