Sage 100

Does anyone know of a good trick to determine which 3rd party is causing an issue?

We have a client that using a software called Bird Dog. This program uses Sage business objects to pull data into another program. Not they way I would have done it, but here we are.

They are getting error messages when we try and use the Sales Order header _bus object. They are not our normal Sage ones, but they allude to the fact, that the data can not be read. 

From working with them today, I know that it is not the data, roles permissions, company access, network permissions, etc. We are able to pull data from all the other objects except this one.

When I rename the links folder, we were successful in pulling the data using their program.
So I assuming that it has to do with a modified SO_SalesOrder_bus program. Now for the tricky part, they have Avatax, Automated Services and Ebiz/Century Business (Credit Card).

What is the most efficient way to figure out which one is causing the error messages. (without uninstalling each of them).

All the programs are working using the GUI interface. It is when we are trying to pull the data with the external business object for Sales Order that we get errors.

Any tips or suggestions, would be appreciated.

Thank you
Michael


#3rd Party
#Business Objects




​​

------------------------------
Michael Davis
Warren Averett Technology Group
------------------------------

Allow External Access checked?

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

Yes sir. Also,  I can view the customer and item business objects
It only seems to be this business object.(SOHeader)

Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group
------------------------------

Original Message:
Sent: 07-27-2022 10:17
From: Wayne Schulz
Subject: 3rd Party Software Conflict

Allow External Access checked?

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

Hi - just a "shot in the dark", as we saw something like this once.

is the Avatax "DLL" registered locally where they are a running the business objects interface from ?

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------

Yes sir. I had the same thought and re-install the Avatax and made sure that it was working. (as best as I can tell)
If I use the Sage GUI interface and go to Avatax company setup, and click on the "a" connection and I get a return prompt of "it is successful."

I am trying to figure out if Avatax is the 3rd party causing the issue or if it is one of the other vendors. I suspect that is Avatax, but just trying to make sure before I spent a lot of time on it. I think all 3 modified the business object.

Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group
------------------------------

Original Message:
Sent: 07-27-2022 10:27
From: Jeff Fiddelman
Subject: 3rd Party Software Conflict

Hi - just a "shot in the dark", as we saw something like this once.

is the Avatax "DLL" registered locally where they are a running the business objects interface from ?

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------

If they are using Sage100 advanced, you may want to try making a "standard mode" shortcut from that PC/Server, and try it that way to see if you learn anything...

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------

Original Message:
Sent: 07-27-2022 11:08
From: Michael Davis
Subject: 3rd Party Software Conflict

Yes sir. I had the same thought and re-install the Avatax and made sure that it was working. (as best as I can tell)
If I use the Sage GUI interface and go to Avatax company setup, and click on the "a" connection and I get a return prompt of "it is successful."

I am trying to figure out if Avatax is the 3rd party causing the issue or if it is one of the other vendors. I suspect that is Avatax, but just trying to make sure before I spent a lot of time on it. I think all 3 modified the business object.

Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group
------------------------------


Original Message:
Sent: 07-27-2022 10:27
From: Jeff Fiddelman
Subject: 3rd Party Software Conflict

Hi - just a "shot in the dark", as we saw something like this once.

is the Avatax "DLL" registered locally where they are a running the business objects interface from ?

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC

Thanks for the tips everyone. I never was was able to figure out the order the 3rd parties went thru. 

Nevertheless, I went back to register the DLL again and included the pause command in the register bat. It was not probably registering even though the program was running great thru the GUI program.

Once I fixed the Avatax DLL registry, the integration program worked great.
Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group
------------------------------

Original Message:
Sent: 07-27-2022 11:40
From: Jeff Fiddelman
Subject: 3rd Party Software Conflict

If they are using Sage100 advanced, you may want to try making a "standard mode" shortcut from that PC/Server, and try it that way to see if you learn anything...

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC
------------------------------


Original Message:
Sent: 07-27-2022 11:08
From: Michael Davis
Subject: 3rd Party Software Conflict

Yes sir. I had the same thought and re-install the Avatax and made sure that it was working. (as best as I can tell)
If I use the Sage GUI interface and go to Avatax company setup, and click on the "a" connection and I get a return prompt of "it is successful."

I am trying to figure out if Avatax is the 3rd party causing the issue or if it is one of the other vendors. I suspect that is Avatax, but just trying to make sure before I spent a lot of time on it. I think all 3 modified the business object.

Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group


Original Message:
Sent: 07-27-2022 10:27
From: Jeff Fiddelman
Subject: 3rd Party Software Conflict

Hi - just a "shot in the dark", as we saw something like this once.

is the Avatax "DLL" registered locally where they are a running the business objects interface from ?

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC

Michael - Glad to hear this is a done deal. BTW, the reason it works fine through the Launcher to being with is because your customer is on Advanced and the AvaTax DLLs / TLBs are registered there on the Sage server, where it's executing from. But if you run "Mas90 style" from a workstation, which is what Jeff was saying, you would've gotten an error in S/O Entry or anything that accessed the S/O Entry business object. Good luck with Bird Dog. I'm working with a customer's offshore developer using BOI who's smart but brand new to Sage 100.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 08-02-2022 08:29
From: Michael Davis
Subject: 3rd Party Software Conflict

Thanks for the tips everyone. I never was was able to figure out the order the 3rd parties went thru.

Nevertheless, I went back to register the DLL again and included the pause command in the register bat. It was not probably registering even though the program was running great thru the GUI program.

Once I fixed the Avatax DLL registry, the integration program worked great.
Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group
------------------------------


Original Message:
Sent: 07-27-2022 11:40
From: Jeff Fiddelman
Subject: 3rd Party Software Conflict

If they are using Sage100 advanced, you may want to try making a "standard mode" shortcut from that PC/Server, and try it that way to see if you learn anything...

Jeff F

------------------------------
Jeff Fiddelman
Exeplex, LLC


Original Message:
Sent: 07-27-2022 11:08
From: Michael Davis
Subject: 3rd Party Software Conflict

Yes sir. I had the same thought and re-install the Avatax and made sure that it was working. (as best as I can tell)
If I use the Sage GUI interface and go to Avatax company setup, and click on the "a" connection and I get a return prompt of "it is successful."

I am trying to figure out if Avatax is the 3rd party causing the issue or if it is one of the other vendors. I suspect that is Avatax, but just trying to make sure before I spent a lot of time on it. I think all 3 modified the business object.

Thank you
Michael

------------------------------
Michael Davis
Warren Averett Technology Group


Original Message:
Sent: 07-27-2022 10:27
From: Jeff Fiddelman
Subject: 3rd Party Software Conflict

Hi - just a "shot in the dark", as we saw something like this once.

is the Avatax "DLL" registered locally where they are a running the business objects interface from ?

Jeff F.

------------------------------
Jeff Fiddelman
Exeplex, LLC

Check SY_ClassEnhancement (take a backup!!!).  You might be able to break each link, developer by developer.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------

Kevin - That's an XLNT way to do it. Instead of renaming the shortcuts in the LINKS folder, which would disable any dev's mods who override the same business object, you can backup, then DFDM edit Sy_ClassEnhancement one record at a time. This effectively disables 1 class override at a time for a particular developer code. Just have to be careful and be ready to revert the edits once done. A training video of sorts is the best way to show this .. one day soon.

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 07-27-2022 11:24
From: Kevin Moyes
Subject: 3rd Party Software Conflict

Check SY_ClassEnhancement (take a backup!!!).  You might be able to break each link, developer by developer.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
------------------------------