Re: SECOND REQUEST - Inventory Count Question

Actually you can run an SQL statement that will list open Cycle Sheets.

With your Library list set, Enter "STRSQL"
Then enter:
SELECT STRC77, PNUM77,PRIN77, CTNO77, ACNO77 FROM INP77
WHERE PNUM77 = 'your-item' and PRIN77 = '0'

This will list the active Cycle Count for the Item.

Clearing the SPGS60 flag will allow you to create a new Cycle Count, but
you may confuse the system with 2 active count sheets and both Cycle
Count adjustments will be processed.

Make sure there are no active Cycle Counts before clearing this flag
(SPGS60) in Inventory or SCIP30 in Warehousing WHP30.

ALSO

If you ever create a Cycle Count and need to remove it but it had been
completed, 
You can select the Update Run, but select "Do Not Generate Adjustments"
This will allow the system to clear the items from the cycle count with
the normal System/21 process.



-----Original Message-----
From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Juan Doe
Sent: Friday, November 21, 2008 3:06 AM
To: System 21 Users
Subject: Re: [SYSTEM21] SECOND REQUEST - Inventory Count Question

Hi Bill

I thought Gary already answered this? It sounds like the SPGS60 flag
(Stocktake in Progress) is set to 'Y' on the INP60 for this Item.

I understand you found this Item on INP54, but with a CTNO54 (Count
Number) that has no record on INP58? If that is the case, something must
have gone wrong, but setting SPSG60 to ' ' (blank) should allow you to
use this Item on another count.

Juan


--- On Thu, 11/20/08, Bill.Geissinger-lN+KUpMK3pIp/+exSnkZrgC/[email protected]
<Bill.Geissinger-lN+KUpMK3pIp/+exSnkZrgC/[email protected]> wrote:

> From: Bill.Geissinger-lN+KUpMK3pIp/+exSnkZrgC/[email protected]
<Bill.Geissinger-lN+KUpMK3pIp/+exSnkZrgC/[email protected]>
> Subject: [SYSTEM21] SECOND REQUEST - Inventory Count Question
> To: system21-Zwy7GipZuJhWk0Htik3J/[email protected]
> Date: Thursday, November 20, 2008, 3:25 PM
> I have a user who's getting the message "Item
> already exists on another 
> active count", when trying to add a item to a count in
> the Maintain Count 
> screen (IN129B).  I took a look at both the count header
> and detail files, 
> INP58 & INP54, for the part in question and have found
> records in the 
> detail file that don't have a corresponding count
> record in the header 
> file.  My thought is this shouldn't be.  Am I correct? 
> How can I take 
> care of this issue so the user can use this part on her
> count?  Any help 
> would be greatly appreciated.
> 
> The information contained in this email, including
> attachments, is confidential and may be legally privileged
> and protected from disclosure by the Electronic
> Communication Act, 18 U.S.C. 2510-2521. It is intended
> solely for the addressee(s), and if the reader is not the
> intended recipient, you are hereby notified that any access,
> use, reproduction, disclosure or dissemination of this
> communication by anyone is strictly prohibited. Any action
> taken or omitted to be taken in reliance on this email is
> prohibited and may be unlawful. Neither Hutchinson Sealing
> Systems Inc., Paulstra CRC, the Hutchinson Group nor any of
> its subsidiaries shall assume legal liability or
> responsibility for any incorrect, misleading or altered
> information contained herein. If you have received this
> message  in error, please notify the sender immediately by
> replying to the email and deleting it from your computer.
> _______________________________________________
> This is the System 21 Users (SYSTEM21) mailing list
> To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/system21
> or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.