Monday, January 26, 2009

BOM Maintenance "Record is Locked, View Only?"

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/

Sunday, January 25, 2009

Starting the Dynamics GP AddIn form centered in the screen

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/

Saturday, January 17, 2009

GP 10.0 Service Packs May Damage Modified Forms and Reports

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/

Thursday, January 15, 2009

Inventory Adjustment Description

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/

Sunday, January 4, 2009

Using credit cards to pay vendors in Dynamics GP

By Victoria Yudin

As usual! Victoria just came up with a new workaround for Credit Card Tracking, personally I liked the way she used, check her post below:

http://victoriayudin.com/2009/01/04/using-credit-cards-to-pay-vendors-in-dynamics-gp/

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/

Related Posts:

Related Posts with Thumbnails