VBA To Prevent You From Changing List Total.

There are times while working with an excel list that you would like to delete items of a list without changing the total Sum of that list. Example of this situation often occur when you are reconciling an account and you have various positive and negative values that offset each other.  In this small article I will illustrate how you can use Excel and VBA to warn you when your cell deletion has cause the total value of a list to change. Lets take a quick look on how you would tackle this. Continue reading “VBA To Prevent You From Changing List Total.”

Fupload Excel Addin

I work for a university and we implemented an ERP system long ago. The name of the ERP? you may ask. Well at the time we implemented it was called Banner. Now the company was taken over by a company called Datatel. However that’s not what this article is about, lets get down to brass tacks. One of the most functional and useful pieces of software that an accountant can use is Excel. In fact I don’t know an accountant that does not use excel.  Banner system has a very convenient way to load journal entries into the system its called FUPLOAD. If you have a 500 line journal entry would you keyed it in? I hope not. We went live with Banner about 4 years ago and ever since then we have used one of the many FUPLOAD templates floating around. Continue reading “Fupload Excel Addin”

Jcell Library Parsing Excel Files On The web.

Documentation is probably one of the hardest things I have to do. Whether it be code commenting or documenting how I accomplished something. However it is a must do if you like to keep track of things. In this post I like to share with you a library I build with the help of another developer. The name of the library is called JCELL. Its purpose its quite simple. Open excel files on the web with pure JavaScript. No JQUERY  necessary simply one library that does it all. If you want to learn more about the library , how to use it and how to take advantage of it. Go Here.


FRRGRNL How to query periods as rows.Simple Hack

If you ever had to write a query against the grant ledger (FRRGRNL) or even the operating ledger(FGBOPAL) I’m sure you have come across this little challenge. You have to start writing a massive decode statement to make your query get the right column. This can be challenging to say the least or a bit of a pain.

Wouldn’t it be nice if you can just say something like?

Continue reading “FRRGRNL How to query periods as rows.Simple Hack”

JQuery ajax call to vb.net webservice

I’m a fan of all technologies. They all have strengths and off course their weaknesses. In this particular post i like to show how to go about posting to vb.net web service and how to retrieve the info back via JavaScript using the JQUERY library. Let’s get right into the code. I have a simple .net web service for the sake of this little tutorial I’m going to call it testajax. If you don’t know how to add a test service. Let me walk you through this.

Continue reading “JQuery ajax call to vb.net webservice”