Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Saturday, May 20, 2017

Manufacturing Order - Finished Product Details Report



The following report provides the details of the finished product manufactured in Dynamics GP using the MO Entry, it provides the following details:
  • Manufacturing Order No.
  • Item Number
  • Item Description
  • Item Class
  • Item Class Description
  • Routing Name
  • MO Starting Quantity
  • MO Ending Quantity
  • Document Date
  • Inventory Document Number
  • Unit of Measurement
  • Extended Cost
  • GL Journal Entry Number



CREATE VIEW [dbo].[GPEssentials_vW_MOFinishedProduct]
AS
SELECT  L.MANUFACTUREORDER_I ,
        L.ITEMNMBR ,
        L.ItemDescription ,
        L.ItemClassCode ,
        L.ItemClassDescription ,
        L.ROUTINGNAME_I AS RoutingName ,
        L.ENDQTY_I AS EndingQuantity ,
        L.STARTQTY_I AS StartQuantity ,
        D.DOCDATE AS DocumentDate ,
        D.DOCNUMBR AS IV_DocumentNumber ,
        D.LOCNCODE AS LocationCode ,
        D.UOFM AS UnitOFMeasurement ,
        D.TRXQTYInBase AS IV_QuantityInBase ,
        D.EXTDCOST AS ExtendedCost ,
        D.JRNENTRY AS GL_JournalEntry
FROM    ( SELECT    MANUFACTUREORDER_I ,
                    A.ITEMNMBR ,
                    RTRIM(LTRIM(B.ITEMDESC)) AS ItemDescription ,
                    RTRIM(LTRIM(B.ITMCLSCD)) AS ItemClassCode ,
                    RTRIM(LTRIM(C.ITMCLSDC)) AS ItemClassDescription ,
                    ROUTINGNAME_I ,
                    ENDQTY_I ,
                    STARTQTY_I
            FROM      [WO010032] AS A
                    LEFT OUTER JOIN IV00101 AS B ON A.ITEMNMBR = B.ITEMNMBR
                    LEFT OUTER JOIN IV40400 AS C ON B.ITMCLSCD = C.ITMCLSCD
        ) AS L
        LEFT OUTER JOIN ( SELECT    ITEMNMBR ,
                                    DOCDATE ,
                                    DOCNUMBR ,
                                    LOCNCODE ,
                                    UOFM ,
                                    SUM(TRXQTYInBase) AS TRXQTYInBase ,
                                    SUM(EXTDCOST) AS EXTDCOST ,
                                    SRCRFRNCNMBR ,
                                    JRNENTRY
                            FROM      [SEE30303]
                            GROUP BY  ITEMNMBR ,
                                    DOCDATE ,
                                    DOCNUMBR ,
                                    LOCNCODE ,
                                    UOFM ,
                                    SRCRFRNCNMBR ,
                                    JRNENTRY
                        ) AS D ON L.MANUFACTUREORDER_I = D.SRCRFRNCNMBR
                                    AND L.ITEMNMBR = D.ITEMNMBR;

GO


Best Regards, 
Mahmoud M. AlSaadi

1 comment:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete