Tuesday, October 02, 2012

Tech Tuesday - New Excel Template (Again)

Hey everyone, I have some great news from our services manager Chris Dew involving our Excel templates again. I made a post a while back on them but we held off on releasing anything until we were able to add a couple more features to it that we think everyone will really be able to make use of:


We are very excited to finally release our new Excel GL Templates for SmartConnect! We had three major goals for this release:
  1. Remove the reliance on SOAP
  2. Prevent Data Entry errors
  3. Configurable without coding

The past templates have had a reliance on the Microsoft SOAP SDK that was used for calling the SmartConnect webservice from VBA. Microsoft has discontinued this support a long time ago and with this new release we can now simplify the install process of the templates to just copying the Excel sheet where you need on the network. This also allows us to support 64-bit environments for Office.

One of the largest uses of the Excel templates is copying data from other sheets. Excel will often display only two decimal places but behind the scenes there could be 15 decimal places and oftentimes rounding errors would occur in larger journal entries. We have added logic to handle that rounding for you so copy and paste away!

I think my favorite new feature to report is the easy configuration of the new template. You can now dynamically change the amount of rows without changing any of the code. Also, we locked the totaling row for the debits and credits so you can always see the balance. This was one of the most common customizations we did for our partners and customers and now you won’t need us anymore!

We have locked down the code in the template to ensure the delivery of the solution. Additionally, we updated the documentation for the template. If you would like to add some additional functionality to the template please feel free to contact me (chris.dew@eonesolutions.com) and our services team can help you design a custom template.

As always, we welcome your feedback. We have plans to roll out a lot of these changes to the other 11 templates available today (over the next couple of months) and may release a generic template that is unlocked as well. Please let us know if you have additional ideas for new templates or features.

Thanks,

Chris Dew

8 comments:

BrianG said...

Where can we download it from? When I access the download section it has 20.11.0.1 from March.
Thanks!

myDiscGolf.com said...

Brian,

We replace that download with the new template. It is the correct one.

Thanks,
Chris

BrianG said...

Looks pretty good. I like the easier way to increase the number of rows and the archive path :)


Packers Movers said...

thanks for this I like it
http://www.packersandmoversthane.com/ packers and movers thane

http://www.packersandmoversandheri.com/ packers and movers in andheri

http://www.packersandmoverskharghar.com/ packers and movers kharghar

http://www.packersmoverskalyan.com/ packers and movers kalyan

http://www.packersmoverspowai.com/ packers and movers powai

http://www.packersmoverskandivali.com/ packers and movers kandivali


http://www.packersmoversvashi.com/ packers and movers vashi

http://www.packersmoversborivali.com/ packers and movers borivali

http://www.packersmoversinmumbai.com/ packers and movers in mumbai

http://www.moversandpackersbangalore.com/ packers and movers bangalore

Alex zender said...

This blog is very cool!

excel templates and help
excel templates

NEERAJA B said...

Thank you somuch for sharing this information
packers and movers in thane

NEERAJA B said...

Thank you somuch for sharing this information
packers and movers in thane

Amarjeet Verma said...

Thanks for giving good information I Really like your information

Packers and movers kharadi pune |
Packers and movers hadapsar pune |
Packers and movers magarpatta city pune |
Packers and movers pimple saudagar pune |
Packers and movers hinjewadi pune |
Packers and movers viman nagar vimannagar pune |
Packers and movers wakad pune |
Packers and movers shivaji nagar pune |
Packers and movers aundh pune |
Packers and movers lonavala pune |
Packers and movers south east india packers and movers |
Packers and movers kothrud pune |
Packers and movers pashan pune |
Packers and movers pune |
Packers and movers pune |
Car transportation service in pune |
Bike transportation service in pune |
Car transportation service in mumbai |
Bike transportation service in mumbai |
Packers and movers pune |
Packers and movers pune |
Dsl Express Packers and movers pune |
Dsl Express Packers and movers mumbai |
Tirupati Balaji Packers and Movers Mumbai |
Tirupati Balaji Packers and Movers Pune |
Tirupati Balaji Packers and Movers Thane |
Free India Website Link Submission Directory, Submit url free