If your inventory is tagged with barcodes you have a great advantage. We
have barcodes and enough scanners to do a full physical with few manual
tags. Here is what we do:
1. Create a set of bar-coded serial tags.
2. Create a file to hold inventory header records (whse/part/loc) and
detailed records (if you have lots -whse/part/loc/serial)
3. Create a program to load your slqnty into the custom inventory header
(this will hold your initial on hands as well as counted during
physical). Your detail file will be empty to start with
4. The scanning process is as follows: 
        Enter location to scan 
        Scan serial number (this keeps you from scanning the same tote
multiple times and makes auditors happy)
        Stick serial number to tote/container to be counted
        Scan inventory tag (in my case the tag has the qty already)
        Verify information (change qty if necessary), process and move
to the next tote
   The scan process will update the count qty on the header file and
will record the detail serial information on the detail inventory file  
5. After scan counts are completed we run variance reports using the
header. We use the detail to help troubleshoot variances. 
6. Once variances are checked we load the header file to the off line
load PHVENT and process the regular steps for Mapics inventory.

Good luck!

Josue Najera

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of LeLeux@xxxxxxxxxxxx
Sent: Tuesday, August 15, 2006 7:09 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] Complete Physical Inventory

Hi group!

Due to acquisition we're facing a complete physical inventory that will
shutdown our factory for at least a couple days.

I was curious if anyone had developed a procedure to make the process
more efficient, the most harrowing aspect to me is creating a mechanism
that facilitates the people/paper based counting side and getting the
info uploaded before the factory starts moving parts gain.

Any comments or tips would be appreciated.

If preferred you may contact direct: leleux@xxxxxxxxxxxx

This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 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.