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@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx
<Bill.Geissinger@xxxxxxxxxxxxxxxxx> wrote:

From: Bill.Geissinger@xxxxxxxxxxxxxxxxx

<Bill.Geissinger@xxxxxxxxxxxxxxxxx>

Subject: [SYSTEM21] SECOND REQUEST - Inventory Count Question
To: system21@xxxxxxxxxxxx
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@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.