RE: COM Picked, Packed or Shipped but not Invoiced

Thanks, Jack.  Just what the Doctor ordered.  On my first build of the query
I got all my "black hole" items.  Accounting is now happy and so am I.

Les

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Hendricks, Ted
Sent: Tuesday, June 01, 2004 12:11 PM
To: 'MAPICS ERP System Discussion'
Subject: 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.



_______________________________________________
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.