ACCTivate!, How Did We Help

Web Orders and ACCTivate!

As you may or may not know ACCTivate! integrates with a handful of shopping carts, but there are so many choices and sites out there that it just can’t have a direct integration for them all. We were contacted by a rather new ACCTivate! user that is currently utilizing one of the unsupported sites; however, they may be moving to a supported site in the next 6 to 9 months.

The Problem: The customer didn’t want to keep hand keying in their Web Orders while on their current system; but they also didn’t want to spend too much on a solution to eliminate manual entry because of the plan to migrate to a supported site down the road.

How Did We Help: After some discussion we learned that the customer could either download a poorly formatted text file or a nicely laid out XML file. We suggested writing a small custom program that would take the XML file and convert it into a comma separated value (.csv) file that could be used with the Sales Order Import feature in ACCTivate!. The customer chose to go with the custom program option so we moved forward with that plan. Now the customer has a custom program that reads an XML file into the program and outputs a perfectly formatted .csv file which they use to import their Web Orders into ACCTivate! via the Sales Order Import function. This has done away with the manual entry work they were doing and has saved time as well as eliminated human error. It is not as automated as the Web Order module that ACCTivate! has, but it was a quick and rather inexpensive interim solution while they decide if and when they will make a shopping cart change.

Uncategorized

ACCTivate! Custom Reporting

We have been supporting ACCTivate! for some time now and we have been doing quite a bit of custom reporting work for users all over the country. ACCTivate! comes with quite a few canned reports but of course they don’t have it all. Different businesses have different needs and even in the same industry people want to see their data differently.

We have created custom sales reports,  product re-order reports, special order fulfillment reports, a wide range of inventory reports and more. We have even had opportunities to create custom applications that interact with the ACCTivate! database. We plan on adding “How We Helped” posts here on our blog when we complete projects that others may benefit from. These posts will include a brief overview of the “problem” and our solution.

We will also be adding “How We Helped” posts for QuickBooks® related projects that you may find since QuickBooks® is one of the products that takes care of all of the accounting for ACCTivate!