Dynamics GP BOM Export – Part 5

Dynamics GP BOM Export  – Part 5

USE [COMPANYDB]
go
/****** Object:  View [dbo].[BOM5]    Script Date: 09/04/2013 19:37:00 ******/
SET ansi_nulls ON
go
SET quoted_identifier ON
go
CREATE VIEW [dbo].[BOM5]
AS
SELECT TOP (100) PERCENT dbo.bom4.item0,
dbo.bom4.item1,
dbo.bom4.item2,
dbo.bom4.item3,
dbo.bom4.item4,
dbo.bm010115.cpn_i           AS ITEM5,
dbo.bm010115.cpn_i           AS ITEM6,
dbo.bm010115.cpn_i           AS ITEM7,
dbo.bm010115.cpn_i           AS ITEM8,
dbo.bm010115.cpn_i           AS ITEM9,
dbo.bm010115.bomcat_i,
dbo.bm010115.bomname_i,
5                            AS [LEVEL],
dbo.bm010115.effectiveindate_i,
dbo.bm010115.bomtype_i,
dbo.iv00101.stndcost,
dbo.bm010115.backflushitem_i,
dbo.bm010115.locncode,
dbo.bm010115.cpn_i           AS ITEM10,
dbo.bm010115.position_number,
dbo.iv00101.itemdesc,
dbo.bm010115.quantity_i,
dbo.bm010115.uofm,
dbo.bom4.zero,
dbo.bom4.one,
dbo.bom4.two,
dbo.bom4.three,
dbo.bom4.four,
dbo.bm010115.position_number AS five,
dbo.bom4.six,
dbo.bom4.seven,
dbo.bom4.eight,
dbo.bom4.nine,
dbo.bom4.q0,
dbo.bom4.q1,
dbo.bom4.q2,
dbo.bom4.q3,
dbo.bom4.q4,
dbo.bm010115.quantity_i      AS Q5,
dbo.bom4.q6,
dbo.bom4.q7,
dbo.bom4.q8,
dbo.bom4.q9
FROM   dbo.bom4
INNER JOIN dbo.bm010115
ON dbo.bom4.bomname_i = dbo.bm010115.bomname_i
AND dbo.bom4.bomcat_i = dbo.bm010115.bomcat_i
AND dbo.bom4.item4 = dbo.bm010115.ppn_i
INNER JOIN dbo.iv00101
ON dbo.bm010115.cpn_i = dbo.iv00101.itemnmbr
ORDER  BY dbo.bm010115.position_number  

The Picklist could not be built because the BOM is being edited by another user

The Picklist could not be built because the BOM is being edited by another user

This messages occurs when a manufacturing order is created, and the picklist is generated at Dynamics GP.

BOM is being edited by another user

BOM is being edited by another user

 

Resolution:

  1. Identify the user who is holding the lock on the BOM for the item.
  2. The BOM lock records are stored in BMS10000 table at the company database.
  3. Option 1 – Have the user close the BOM for the item.
  4. Option 2 – If the user is  unable to release the lock for what ever reason, take necessary precaution and delete the lock.
  5. DELETE bms10000
    WHERE  ppn_1 = ‘ITEMNUMBR’

Cheers!
Sanjay

 

 

 

Another user is rolling up costs. Try again later.

Another user is rolling up costs. Try again later.

When user attempts to perform the standard cost roll up from Dynamics GP Manufacturing module, the alert message appears and users are not allowed to conduct the roll up.

Another user is rolling up costs

Another user is rolling up costs

The resolution would be to identify the user who is holding the lock on this process to release the lock by closing the standard cost roll up window, but who is the user ?  The following script should list the user using the standard cost roll down in GP

SELECT userid
FROM   pdt.dbo.iciv0400 WITH (nolock)

Cheers!

Sanjay

 

 

 

 

 

 

 

 

 

Create PO (Purchase order) from MO (Manufacturing order) permission

Create PO (Purchase order) from MO (Manufacturing order) permission

“You are not allowed to perform this action.  Contact your system administrator for assistance” message is popped up when user attempts to create a PO from Manufacturing Order/Purchase Order Link.

Create PO

Create PO from Manufacturing Order

Dynamics GP apart from security rolled down by security tasks and security roles, which implement security based on windows or report, manufacturing module also implements process based security.

For resolving the above security violation,  the user had to be allowed to use the Create PO process.

Process security

Process security

 

Access to process security would require the system password.  Process security can be set up based on password or user id.  If the setup is based on user id , add the user to the approved list.

Process security setup

Process security setup

Cheers!
Sanjay

 

 

 

Manufacturing Machine Codes

TSQL Script to list Dynamics GP manufacturing machine codes definitions:

SELECT dbo.mm010032.machineid_i,
dbo.mm010032.machinedesc_i,
GL00105_1.actnumst   AS Mach_Mach_Applied_Acct,
dbo.gl00105.actnumst AS Mach_Fixed_Ohd_Acct,
GL00105_2.actnumst   AS Mach_Variable_Ohd_Acct,
dbo.mm010032.cost_i,
dbo.mm010032.costperpiece_i,
dbo.mm010032.fixamtorpct_i,
dbo.mm010032.fixed_overhead_amount,
dbo.mm010032.fixohdpct_i,
dbo.mm010032.varamtorpct_i,
dbo.mm010032.variable_overhead_amount,
dbo.mm010032.varohdpct_i
FROM   dbo.mm010032
INNER JOIN dbo.gl00105 AS GL00105_1
ON dbo.mm010032.mach_mach_applied_acct = GL00105_1.actindx
INNER JOIN dbo.gl00105
ON dbo.mm010032.mach_fixed_ohd_acct = dbo.gl00105.actindx
INNER JOIN dbo.gl00105 AS GL00105_2
ON dbo.mm010032.mach_variable_ohd_acct = GL00105_2.actindx 

 

Manufacturing Labour Codes

TSQL Script to list Dynamics GP manufacturing labor codes definitions:

SELECT dbo.lc010014.laborcode_i,
dbo.lc010014.changedate_i,
dbo.lc010014.labcodedesc_i,
dbo.lc010014.cost_i,
dbo.lc010014.hourpiece1_i,
dbo.lc010014.fixamtorpct_i,
dbo.lc010014.fixed_overhead_amount,
dbo.lc010014.fixohdpct_i,
dbo.lc010014.varamtorpct_i,
dbo.lc010014.variable_overhead_amount,
dbo.lc010014.varohdpct_i,
dbo.lc010014.uselaborcode,
GL00105_1.actnumst   AS LC_Labor_Applied,
dbo.gl00105.actnumst AS LC_Fixed_Overhead,
GL00105_2.actnumst   AS LC_Variable_Overhead
FROM   dbo.gl00105 AS GL00105_2
INNER JOIN dbo.gl00105
INNER JOIN dbo.lc010014
INNER JOIN dbo.gl00105 AS GL00105_1
ON dbo.lc010014.lc_labor_applied =
GL00105_1.actindx
ON dbo.gl00105.actindx =
dbo.lc010014.lc_fixed_overhead
ON GL00105_2.actindx = dbo.lc010014.lc_variable_overhead