Monday, March 25, 2013

Dynamics GP - Form Customization with VBA - Set Required Fields

This is a sample of script used to set multiple fields as required, and also open specific windows that require data.

Private Sub CustomerPONumber_AfterLostFocus()
If CustomerPONumber.Empty = False Then
UserDefined = 1
End If
End Sub

Private Sub CustomerID_AfterLostFocus()
If CustomerID.Empty = False And CustomerName.Enabled = True Then
ExpansionButton4.Value = 1
End If
End Sub

Private Sub CustomerPONumber_BeforeLostFocus(KeepFocus As Boolean, CancelLogic As Boolean)
If CustomerPONumber.Empty = True Then
MsgBox "Please Enter a Customer PO Number"
End If
End Sub

Private Sub ShipToAddress_BeforeLostFocus(KeepFocus As Boolean, CancelLogic As Boolean)
If ShipToAddress.Empty = True Then
MsgBox "Please Enter a Ship To Address"
End If
End Sub

Private Sub Window_AfterOpen()
ShipToAddress.Required = True
CustomerPONumber.Required = True
End Sub

Thursday, March 21, 2013

Free Trackers that work






Monday, March 18, 2013

Dynamics GP SQL View - Basic SOP History

SELECT     dbo.SOP30300.ITEMNMBR, CASE WHEN sop30200.soptype = 4 THEN sop30300.XTNDPRCE * - 1 ELSE sop30300.xtndprce END AS ExtPrice,
                      CASE WHEN sop30200.soptype = 4 THEN sop30300.extdcost * - 1 ELSE sop30300.extdcost END AS ExtCost, dbo.SOP30300.NONINVEN, dbo.SOP30300.SOPTYPE,
                      CASE WHEN sop30200.soptype = 4 THEN sop30300.quantity * - 1 ELSE sop30300.quantity END AS Qty, dbo.SOP30300.UOFM, dbo.SOP30200.GLPOSTDT,
                      dbo.SOP30200.VOIDSTTS, dbo.SOP30200.SLPRSNID AS DocSrID, MONTH(dbo.SOP30200.GLPOSTDT) AS GlPostMth, YEAR(dbo.SOP30200.GLPOSTDT) AS GlPostYr,
                      dbo.SOP30300.SOPNUMBE, DATENAME(MM, dbo.SOP30200.GLPOSTDT) AS GlMonthName, dbo.SOP30300.QTYBSUOM, dbo.SOP30300.SLPRSNID AS LineSrID
FROM         dbo.SOP30200 INNER JOIN
                      dbo.SOP30300 ON dbo.SOP30200.SOPNUMBE = dbo.SOP30300.SOPNUMBE AND dbo.SOP30200.SOPTYPE = dbo.SOP30300.SOPTYPE
WHERE     (dbo.SOP30200.SOPTYPE IN ('3', '4')) AND (YEAR(dbo.SOP30200.GLPOSTDT) >= YEAR(GETDATE()) - 2) AND (dbo.SOP30200.VOIDSTTS = 0) AND
                      (dbo.SOP30300.NONINVEN = 0)

Saturday, March 16, 2013

Dynamics GP Year End Closing Procedures



Close modules in this order:

  1. Inventory
  2. Receivables
  3. Payables
  4. Fixed Assets
  5. General Ledger
The short version of this process is

  • Test the year-end closing in the test company first
    • Tools>Routines>Financial>Year-End Closing>Click Close Year
    • Print Financial Reports
  • Once you’re happy with the reports, close the year in the live company

Windows 7 - There is a problem with your battery so your computer might shut down suddenly

If you get this error on your laptop it means one of two things

  1. Your battery is dying, and it needs to be replaced
  2. Windows 7 cannot properly detect how much power is in the battery

To determine what's wrong, 
  • click start
  • In the box that says "search programs and files", Type in CMD
  • You should see a "cmd.exe" show up in the top of the start menu
  • Right click the cmd icon, run as administrator
  • type in powercfg -energy
  • This will test your battery, and produce a report in C:\Windows\System32\energy-report.html
  • You can open this file in a regular browser or Word
  • If it is able to read the battery, and produce a report, look at the line that says "design capacity" and "last full charge"
    • This will show how much the battery should hold, and how much it's actually holding
    • If you run the test over a few days or weeks, and this number is steadily decreasing over time, it means your battery is dying, and you need a new one eventually 
    • You can always untick the "warn me if my battery needs replacing" if you just want to get rid of the annoying message
  • If it is unable to read the battery and produce a report, then windows is not communicating with the battery. 
    • This is a BIOS issue, and it means that Windows 7 just isn't going to read your battery properly. 
    • You can try updating your BIOS, but it probably won't work. 
    • Long story short, there's nothing you can do about the warning. 
    • in your cmd box, run powercfg -setdcvalueindex SCHEME_CURRENT SUB_BATTERY BATACTIONCRIT 0
    • This will just let windows run until the battery hits 0, regardless of how much power it "thinks" it has
  • Other users recommend charging the battery to full, then letting it run down to below 10%, then recharging it again to "reset" the battery
    • I have not had any personal success with this method
Original article

Other techniques you can try

Tuesday, March 5, 2013

Dynamics GP - "Cannot access this form because the dictionary containing it is not loaded"

This error is caused because GP cannot find the specific form it is trying to open.

This can happen for the following reasons

  • GP cannot access the dictionary due to folder permissions
  • GP cannot access the folder due to no network connection
  • Security setup for Alternate/Modified forms is pointing to a modified form that does not exist in the current dictionary
To resolve this error, go to
  • GP>Tools>Setup>System>Alternate/Modified Forms and Reports
  • Choose the report ID that is giving trouble (Defaultuser by default)
  • Select all Products
  • Select windows (or reports if you are getting the error when opening a report)
  • Expand all of the folders and find the Form / report that is giving trouble
  • Most entries will have "Microsoft Dynamics GP" and "Smartlist" as selectable options
    • One of these options MUST be selected
    • This is how GP knows which form to use
    • The form or report that is giving trouble will have neither one selected, meaning GP does not know which form to use (most likely the form was removed, or you are using a different dictionary, but the security is still pointing to the form that does not exist)
    • Tick "Smartlist"
    • Your form should open properly now

SSRS Sharepoint Trusted Account Error

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser)
      • This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)  


Review steps 2-4 here

Friday, March 1, 2013

Dynamics GP eOne Extender Enterprise - a remove range_operation on table PT_Extender_Palette_Forms failed accessing SQL data

You get this error when attempting to use a detail form

When you click on info, you get

[Microsoft][SQL Native Client][SQL Server]Invalid column name 'PT_Palette_ID'.

[Microsoft][SQL Native Client][SQL Server]Invalid column name 'PT_Palette_ID'.


This error goes away after you have logged in and built all of the extender tables through the extender install window.

Dynamics GP eOne Extender Enterprise - Script '[22009] of form ExtenderActionsObject' not found.


Unhandled script exception:
Script '[22009] of form ExtenderActionsObject' not found.


This error occurs on a new install of Extender Enterprise on GP 10 SP5

When you create a form and attempt to use it, you get this error.

Install the latest version of Extender Enterprise for GP2010 (Even though you are using GP 10)

The most updated version can be found here

If you have already installed the Microsoft Extender, and need to upgrade to the eOne Enterprise Extender, follow the instructions here