Re: XA Physical Inventory

  Dave,

  Since my customer has multiple unit of measures for the same item
  (Each/Dozens/Boxes), we needed a way to ease their entry.  We gave them a
  "pre-PHVENT" data entry file that gives them the ability to enter each UM
  without having to calculate the total "eaches".  By doing this, we also
  calculated the Count Difference prior to posting the file into MAPICS (by
  subtracting the Physical Count Qty from the "Physical Count On Hand at
  time of selection PHYOH").  I finally remembered that this was the key to
  being able to process transactions outside of XA.

  All variance checking is going to be done with this file before moving the
  batch into MAPICS.  By calculating the difference prior to moving the
  batch into XA, MAPICS will use my "difference" instead of using
  calculating it after other transactions have occurred.

  I just tested it and it works "exactly as we designed".

  Thanks...

  Eric

    ----------------------------------------------------------------------

    From:  <davidakemp@xxxxxxxxxxxxx>
    Reply-To:  MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
    To:  MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
    Subject:  Re: [MAPICS-L] XA Physical Inventory
    Date:  Wed, 8 Nov 2006 17:16:15 -0500
    >Eric,
    >
    >The Compare Quanity for cycle count groups can be established in one of
    two ways.  If Cutoff On-Hand is selected, the system captures the
    on-hand balance when the count is activated.  If Entry On-Hand is
    selected, the system captures the on-hand balance when the count is
    actually entered.  If you are having a lot of activity on the item you
    are counting, then you  probably  want  to use the Entry on-hand option
    and immediately enter the count as each item is counted.
    >
    >David Kemp
    >
    > >
    > > From: "Eric Wolf" <eric_a_wolf@xxxxxxxxxxx>
    > > Date: 2006/11/08 Wed PM 04:35:09 EST
    > > To: mapics-l@xxxxxxxxxxxx
    > > Subject: [MAPICS-L] XA Physical Inventory
    > >
    > >    To the list,
    > >    I know that this has been discussed before but could not find the
    exact
    > >    answer for my customer.  Here's the question:
    > >
    > >    When the Physical/Cycle count selection is run (let's say at end
    of year)
    > >    all the records are flagged to be counted and the on hand at
    selection is
    > >    saved.  If the counts are entered after the users start
    processing
    > >    transactions again, then any variance from the PH will cause the
    On Hand
    > >    to be off - is this correct?
    > >
    > >    Isn't this why 3rd party packages were developed?  Since
    preventing the
    > >    users from Shipping, Receiving products until the counts are
    entered is
    > >    not reality, how do I get the system to work for them?
    > >
    > >    They currently are counting over 2500 items on a monthly
    basis.  The
    > >    eventual plan is to use the Cycle count process but we are not
    ready yet.
    > >
    > >    Thanks...
    > >    Eric
    > >
    >
    >      
----------------------------------------------------------------------
    > >
    > >    Stay in touch with old friends and meet new ones with Windows
    Live Spaces
    > > _______________________________________________
    > > 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 http://archive.midrange.com/mapics-l.
    > >
    > >
    >
    >_______________________________________________
    >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 http://archive.midrange.com/mapics-l.
    >

    ----------------------------------------------------------------------

  Use your PC to make calls at very low rates