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
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com/

Advertisements

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
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com/

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
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com/
http://mohdaoud.blogspot.com/

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
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com/
http://mohdaoud.blogspot.com/

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
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com/
http://mohdaoud.blogspot.com/

Copying Reports in Report Writer

By Frank Hamelly

1. Export the SOP Invoice package file using Customization Maintenance.
2. Open the package file using Notepad.
3. Perform a Find/Replace, replacing all the references to ‘WORK’ tables with ‘HIST’ tables. (i.e., replace SOP_HDR_WORK with SOP_HDR_HIST)
4. Change the report name in the file.
5. Save the package file.
6. Import the modified package file back into GP using Customization Maintenance.
7. Voila! Your report is modified.

Regards,

Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com/
http://mohdaoud.blogspot.com/