RE: COM Picked, Packed or Shipped but not Invoiced

We have a query over MBDHREP, MBDDREP, ITEMASA, MBC6REP.

Join is:

 Field             Test     Field          
T01.DHCVNB        EQ       T02.DDCVNB     
T01.DHK4NB        EQ       T02.DDK4NB     
T02.DDAITX        EQ       T03.ITNBR      
T01.DHCVNB        EQ       T04.C6CVNB     
T01.DHDCCD        EQ       T04.C6DCCD     
T01.DHDCCD        EQ       T04.C6DCCD    
T01.DHAENB        EQ       T05.DEAENB    
T01.DHCANB        EQ       T05.DECANB    
T01.DHB9CD        EQ       T05.DEB9CD    

Selection is:

DHIVNB            GT     0   
DHGGNB            EQ     0   
DHINST            NE     '99'

We like to make certain that all shipments are invoiced at monthend.

-----Original Message-----
From: mapics-l-bounces+ted.hendricks=flukebiomedical.com@xxxxxxxxxxxx
[mailto:mapics-l-bounces+ted.hendricks=flukebiomedical.com@xxxxxxxxxxxx] On
Behalf Of Jack Roughgarden
Sent: Tuesday, June 01, 2004 10:01 AM
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.