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
Hi Philippe
FYI it looks like David has found the issue, hopefully he will roll this fix into the next hotfix
Matt
Hi Philippe
I have the issue with SDT build 17 hotfix 2
Matt
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...
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
Hi Philippe
Try disabling SDT in Tools >> Customise >> Customisation Status and try the DUOS again
Matt
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.
Philippe
Do you by any chance have the Support Debugging Tool loaded?
Matt
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
Hi Philippe,
Where in your VBA code do you open the connection to the database?
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156