Bob,
We are on ERP Lx 8.3.2, having upgraded from V6.04 a few years ago, so not sure how the handling of cycle counting files may differ from your system. Not sure also if it varies depending if you are doing one-step or two-step cycle counting. But, if you don't get any better ideas, this may give you some thoughts.
We also wanted to be able to query items/locations that had been selected for counting but where no variance was found between expected and actual count. So we added an *AFTER *DELETE trigger program to the ICY file. When the cycle count purge is run and ICY is cleared, the ICY records are added to an overall history file (ICY_HISTRY) and a monthly history file (ICY_MTHLY) which is cleared down every monthend. We can then run queries over these files to see transactions that didn't result in any variance.
Cheers
Tom Molyneux
NOV Mono
MIS Department
Tel. +44 (161) 214 2142
Fax. +44 (161) 214 2344
E:mail Tom.Molyneux@xxxxxxx
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On Behalf Of Hermann, Robert G.
Sent: 10 April 2013 15:21
To: BPCS-L@xxxxxxxxxxxx
Subject: [BPCS-L] A cycle count report question
A user asked the following question:
"Is there a report that captures my cycle count entries where there are no adjustment made to the inventory? I know there is a report the shows all of my+/- transaction but I don't see one listing the ones with zero adjustments."
I don't know of any such report, but then I am not very familiar with BPCS' cycle count system. We are on BPCS 5.1.00, which we century-dated ourselves. Thanks.
Best regards,
Bob Hermann, CertainTeed Corporation
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/bpcs-l.
________________________________
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
midrange.com
