Some times when you opens the BOM Maintenance form and selects an Item, the above message appears!
If there were no users has the BOM selected in BOM Maintenance Form or in BOM Mass Update then a record must be locked in "BMS10000" table and could be easily deleted.
Hope this helps!
Regards,
--
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
While working on VSToolkit and VSMenus, I had a problem in starting the AddIn form centered in the screen; I tried to change “StartPosition” to Center Screen and Center Parent with no success, the form keep opening in the left top corner of the screen which is very annoying to the end users.
I found that the tool is ignoring the “StartPosition” property and is using the “Location” property instead, but the location cannot be fixed since the screen resolution is changeable.
To workaround this issue I have created the following code segment that gets the screen resolution and set the form boundaries to the screen center
Just add the following code segment to your form load:
Me.SetBounds(Math.Round((Screen.PrimaryScreen.Bounds.Width / 2) - (Me.Width / 2), 0), Math.Round((Screen.PrimaryScreen.Bounds.Height / 2) - (Me.Height / 2), 0), Me.Width, Me.Height)
Hope this helps!
Regards,
--
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
Many of us faced this while installing SP’s without following installation instructions! Number of messages appears upon starting GP, modified forms and reports generate errors and allot of other issues that became well known.
David in his post has draw our attention that those errors due to miss handling the format changes upon upgrade, therefore upgrading GP will probably damage modified forms and reports.
Regards,
--
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
http://mohdaoud.blogspot.com/
Mapping inventory adjustment note to the GL note:
Yet another new issue in Inventory! Here in the Middle East, managers are looking for descriptions for every single transaction, while Inventory Transaction Entry DOES NOT HAVE DESCRIPTION FIELD.
Financial controller is posting GL Transactions that generated by Inventory people, while they are issuing the items by using “Transaction Entry” form --> Adjustment Transaction.
When they create allot of transaction using inventory adjustment form, the financial controller will have a big issue identifying the transaction caused to generate the journal and also the reason of that transaction.
To avoid this miss, I have created a database trigger that links “Transaction Entry” NOTE with the GL Voucher NOTE.
Below is the script I used:
CREATE TRIGGER [UPDATENOTE] ON [dbo].[IV30200]
FOR INSERT, UPDATE
AS
DECLARE @DTAControlNum varchar(500)
DECLARE @JRNENTRY varchar(500)
DECLARE @NOTEINDX varchar(500)
SELECT @DTAControlNum = DOCNUMBR, @NOTEINDX = NOTEINDX From INSERTED
SELECT @JRNENTRY = JRNENTRY From GL10000 WHERE DTAControlNum = @DTAControlNum
UPDATE GL10000 SET NOTEINDX = @NOTEINDX WHERE JRNENTRY = @JRNENTRY
Regards,
--
Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
http://mohdaoud.blogspot.com/
