RE: COM Picked, Packed or Shipped but not Invoiced

Thanks, Jack.  Records in MBDHREP are definately what I am after but I
probably need to get deeper, down to item level.  
Les

-----Original Message-----
From: mapics-l-bounces+lsilies=wainwrightindustries.com@xxxxxxxxxxxx
[mailto:mapics-l-bounces+lsilies=wainwrightindustries.com@xxxxxxxxxxxx]O
n Behalf Of Jack Roughgarden
Sent: Tuesday, June 01, 2004 12:01 PM
To: MAPICS ERP System Discussion
Subject: RE: COM Picked, Packed or Shipped but not Invoiced


Les...
 
Sounds like you are trying to identify the lag between Shipping and
Accounting departments. I'm not
sure how detailed you want to get but simply a query over MBDHREP where
"Invoice Number" is
"0" may solve your problem.

        -----Original Message----- 
        From: mapics-l-bounces@xxxxxxxxxxxx on behalf of Les Silies 
        Sent: Tue 6/1/2004 12:51 PM 
        To: MAPICS-L@xxxxxxxxxxxx 
        Cc: 
        Subject: COM Picked, Packed or Shipped but not Invoiced
        
        

        I am at XAR4.  My accounting group complains that when in COM we
pick, pack
        or ship an item but have not invoiced the inventory goes into a
black hole.
        In IM the on hand balance decreases but since there has been no
invoice they
        are not yet in AR, thus the "black hole".  Are there any files and
fields I
        can use that identifies pick, pack and/or shipped but not invoiced?
I want
        to create a report accounting can use to reconcile this "black hole"
so they
        can balance inventory month to month.
        
        Thanks in advance,
        
        Les Silies
        Wainwright Industries, Inc
        _______________________________________________
        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.