Sage 100

Does anyone have a customer successfully running True Commerce on a Citrix server with Avatax? Avatax works fine on the Citrix server with Sage.

@GaryFeldman ?

@KatrinaEddins - Other than changing you name on this site... I know we have True Commerce, but not sure if we have on same server with Avatax.

Gary, I was waiting to see if Katrina responded. So, do you have a client running True Commerce on a Citrix server? If yes, did you have to jump thru any hoops to get the order go from True Commerce into Sage? Does your customer have Avatax. My customer has Avatax and Sage on an application server and then TC is on the 2 Citrix servers. An order will not go from TC into Sage, however a Sage invoice will go back into TC. Bob Pfahnl is having the same issue. We have cases with Sage, but no resolution yet. @BobPfahnl @KatrinaEddins

We have customers running TC in a Citrix environment. No Avatax however. Had a few hiccups initially but they're running smoothly now. Most of the issues we've run into have been on the client side. No issues with the connection between Sage and TC. We've had encounters with their support and recommend getting the matter escalated to a more technical person. We usually contact Ed Feilq. He's great. What issues are you encountering specifically?

When we export the PO within TC to create the Sales Order in Sage the attached 2 scripts flash on the screen and then it indicates the export failed. An invoice from Sage will go into TC fine. I have connected with Avalara and they said it is not their issue as Avatax and Sage are working fine.

I realize what I've mentioned below was presumably covered by Avalara but perhaps not in the way I'm describing. Also I say with complete objectivity and certainty that neither Avalara nor TC know much about their apps in terms of how they integrate with Sage 100 under the hood. Maybe their engineers do but not Support. I need to meet Ed Feliq apparently. Sorry for the length but I hope this helps. I think it will at least get you further. Since you are running Sage 100 Adv or Prem, the **CORRECT WAY** for them to answer the question about whether AvaTax is working fine is to remote into the machine where the actual TC program runs and start up Standard / Mas 90 style. Don't start up the normal way. Then simply go into S/O Entry. If you get an error, boom it means AvaTax DLL is not registered and the TC program will never be able to create the SO. That's how they should have tested with you. I looked at your Word doc showing the screen blips. It shows AvaTax is not registered on the TC machine. Try it like this: 1- Remote into the actual wkstn or server that will run the TC app. There absolutely is a machine where their program is running even if they say otherwise. It might be the server that's running IIS. Regardless, it runs as a BOI app, which means Mas90 style. 2- Create a folder on the that TC machine in the local C: drive called C:\Sage 3- Copy the \mas90\Avatax folder from the Sage server so you have a C:\Sage\Avatax 4- Edit their BAT file and add a line with the word PAUSE then save the file and exit. 5a- In File Explorer, rt-click and Run as Administrator. The PAUSE will pause the BAT file but you get to see if any portion of the DLL / TLB registration failed. If it didn't then woohoo. Press the ""anykey"" to close the command prompt window then start up Sage via Mas90 style and go into S/O Entry again. Once that's good, try TC. 5b- If 5a had an error then try this way to register: * Click Windows key then press X and choose the Administrator command prompt. If you don't see it, type cmd.exe then in the search result rt-click on cmd.exe and choose Run as Administrator. * Then type: CD C:\Sage\Avatax * Once in the folder type: START /B register_for_com.bat (Verify that is correct name of BAT file). * Rinse and repeat rest of 5a

Wow Alnoor! Thank you so much for all of this information. I will try all of this and post the results.

Our client's issue was resolved by manually registering the Avatax.dll on the Citrix server. Our client was experiencing the message ""Module J/C is not on file"" when importing 945s from TC. Along the way, we needed to have .NET Framework v2. and WSE2 installed, but the J/C error wasn't resolved until the DLL was registered. Avatax was working fine inside Sage, mind you, all along.

I believe this is going to work! The Avatax popups are not no longer occurring. There is a required Sage sales order field that True Commerce did not set up properly in their system. I'm waiting for them to correct the setup. I did not have to do step 5b. Am I correct to assume to take the PAUSE off in step 5a, save and exit? @AlnoorCassim

That's great you didn't have to resort to Step 5b. Yes take out the PAUSE from 5a, save, and exit.

Houston, we have success! Thank you @AlnoorCassim @BarbaraGoldstein