I have some clients who use the Bill of Materials and assemblies within the Inventory series rather than the Manufacturing series and full MRP; their processes are not so complex that they need this level of MRP functionality. To make it easy to link an assembly to a sales order, the assemblies are created with the same ID as the order (one of the clients has a high level of automation added via customisations to automatically create the assembly from the order).
I’ve created a script to return this information on more than one occasion, so finally decided to post it here so I can easily find it.
CREATE VIEW uv_AZRCRV_SalesOrdersToBeAssembled AS
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
CASE WHEN LEFT(RTRIM(SOP102.SOPNUMBE),3) = 'ORD' THEN
CASE WHEN (SELECT COUNT(SOPNUMBE) FROM SOP10200 SOP102I WHERE SOP102I.SOPNUMBE = SOP102.SOPNUMBE) > 1 THEN
'_' + CAST(SOP102.LNITMSEQ/13684 AS VARCHAR(2))
END AS 'Assembly'
,FORMAT(GETDATE(), 'yyyyMMdd') AS 'Batch Number'
,RTRIM(SOP102.ITEMNMBR) AS 'Item Number'
,CASE WHEN SOP102.UOFM = 'EACH' THEN
CAST(CAST(SOP102.QUANTITY AS DECIMAL(10,0)) AS VARCHAR(10))
CAST(CAST(SOP102.QUANTITY*10000 AS DECIMAL(10,0)) AS VARCHAR(10))
END AS 'Quantity'
,SOP102.UOFM AS 'UofM'
,SOP101.BACHNUMB AS 'Sales Batch'
SOP10200 SOP102 WITH (NOLOCK)
SOP10100 SOP101 WITH (NOLOCK)
SOP101.SOPNUMBE = SOP102.SOPNUMBE
SOP101.SOPTYPE = SOP102.SOPTYPE
BM00101 BM101 WITH (NOLOCK)
BM101.ITEMNMBR = SOP102.ITEMNMBR
BM101.Bill_Status = 1
BM10200 BM102 WITH (NOLOCK)
ON BM102.TRX_ID = RTRIM(SUBSTRING(SOP102.SOPNUMBE,4,LEN(SOP102.SOPNUMBE)-3))
BM30200 BM302 WITH (NOLOCK)
ON BM302.TRX_ID = RTRIM(SUBSTRING(SOP102.SOPNUMBE,4,LEN(SOP102.SOPNUMBE)-3))
SOP102.SOPTYPE = 2
BM102.TRX_ID IS NULL
BM302.TRX_ID IS NULL
GRANT SELECT ON uv_AZRCRV_SalesOrdersToBeAssembled TO DYNGRP
A few days ago, Errol Schoenfish on the Inside Microsoft Dynamics GP
blog announced the forthcoming Microsoft Dynamics GP 2013 SP2
(or H2 as he named it) for Q4 of the 2013 calendar year.
The part of the announcement which surprised me was the announcement that there would be a “Feature of the Day” starting in September; I thought that, usually, “Feature of the Day” only occurred for major releases and not service packs. Let me say though: this is not a complaint!
In SP2 the Web Client will see the see releases for the Project, Manufacturing and Field Service series as well as the expansion of ISV Extensibility to allow Visual Studio forms to be presented in the Web Client in the same way as Dexterity forms.
Document Attach will be extended to allow attachments to be included in emails and to allow documents attached to cards to be rolled down to the transactions. So a terms and conditions file attached to a customer record could be rolled down to the sales invoices and attached to the email.
One really nice feature is the ability in SmartList to hide the navigation tree; here’s hoping this is a button on the toolbar to quickly expand and shrink the nav pane.
For full details of the announcment check the original blog post.
Microsoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog
The sixty fifth feature they’ve announced is Create Equipment From Manufacturing.
You can now automatically create equipment records from Manufacturing Order Receiving’s and from Manufacturing Quick Orders. You can also decide whether you want to create equipment records from non-serialized items on manufacturing orders as well;
Continue reading “MDGP 2013 Feature of the Day: Create Equipment From Manufacturing”