web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / DUOS and VBA problem
Microsoft Dynamics GP (Archived)

DUOS and VBA problem

(0) ShareShare
ReportReport
Posted on by Philippe Simoes 380

I am using a DUOS fields and VBA to store some additionnal information on the customer card (GP 2010, v11.00.2164).  It all works well... until a user switches to another company without closing GP (by clicking the company name in the status bar).   Then the DUOS object is unable to work correctly and still tries to load information about the original company.  We happend to have a few identical customer numbers in both companies and I can confirm that the DUOS object does not change the company.

Is there a solution for this besides asking the users to completely close GP ?

Thanks,

Philippe

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: DUOS and VBA problem

    Hi Philippe,

    Where in your VBA code do you open the connection to the database?

    Kind regards,

    Leslie

  • Philippe Simoes Profile Picture
    Philippe Simoes 380 on at
    RE: DUOS and VBA problem

    Hi Leslie,

    I don't connect manually, I use the DUOS objects in VBA which are supposed to do the work for me.

    ex:

        Dim CustomerCollection As DUOSObjects
        Dim CustomerObject As DUOSObject
        Dim object As String
        
        Set CustomerCollection = DUOSObjectsGet("CustomerCollection")
        object = Trim(CustomerID.Value)
        Set CustomerObject = CustomerCollection.item(object)
        GeoAreaID.Value = CustomerObject.Properties("geo_area")

    Of course in VBA, I could use an ADO connection to read and save information in SY90000 manually (that was my plan B), but the DUOS objects are there for that purpose and I was hoping to fix this bug instead of redoing everything...

    Thanks,

    Philippe

  • Matt Connor Profile Picture
    Matt Connor 65 on at
    RE: DUOS and VBA problem

    Philippe

    Do you by any chance have the Support Debugging Tool loaded?

    Matt

  • Philippe Simoes Profile Picture
    Philippe Simoes 380 on at
    RE: DUOS and VBA problem

    Yes I do have the SDT.

    I just ran a "Manual Logging Mode" and the dexterity log confirms that the DUOSObjects is looking at wrong company.

  • Matt Connor Profile Picture
    Matt Connor 65 on at
    RE: DUOS and VBA problem

    Hi Philippe

    Try disabling SDT in Tools >> Customise >> Customisation Status and try the DUOS again

    Matt

  • Philippe Simoes Profile Picture
    Philippe Simoes 380 on at
    RE: DUOS and VBA problem

    Hi Matt

    When the SDT is disabled, the problem is gone. It appears you found it, thank you.  

    I am using version 11.0 of SDT, do you know if the problem was fixed in the latest version ?

    Thanks,

    Philippe

  • Philippe Simoes Profile Picture
    Philippe Simoes 380 on at
    RE: DUOS and VBA problem

    It's the build 16 of SDT, I meant.  I saw that David Musgrave released a build 17 + hotfixes, but this problems doesn't seems to be part of the fixes...

  • Matt Connor Profile Picture
    Matt Connor 65 on at
    RE: DUOS and VBA problem

    Hi Philippe

    I have the issue with SDT build 17 hotfix 2

    Matt

  • Verified answer
    Matt Connor Profile Picture
    Matt Connor 65 on at
    RE: DUOS and VBA problem

    Hi Philippe

    FYI it looks like David has found the issue, hopefully he will roll this fix into the next hotfix

    Matt

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans