Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • 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

  • 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

  • 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...

  • 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

  • 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

    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

    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

    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

  • 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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans