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”
Post Json to Asp.net Page and Create PDF
I was in a pickle not to long ago and i wanted to simply take my html table and create a pdf out of it. In this first tutorial ill show you how to take the JSON and posted to a web page. Then from there you would be able to read that JSON using a nifty library called JSON.net . Continue reading “Post Json to Asp.net Page and Create PDF”
posting to a closed period without opening the period.
Recently i came upon a situation where a user was able to post to period 1 while there we were on period 12. This seemed odd to me however it happen and now , Continue reading “posting to a closed period without opening the period.”
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.
Getting started with ODP.net and .Net Web Services
ODP.net is oracle’s data provider for .net. I have been using it now for almost 3 year and I absolutely enjoy how tightly integrated it is with Microsoft. Yes you can use Microsoft’s oracle data provider but you will not get all the bell and whistles that you will get with ODP.net. Continue reading “Getting started with ODP.net and .Net Web Services”
Insert excel Data Into oracle database using OO4O
Have you ever had a need to take and excel spreadsheet and load its data into an oracle table. I must say I had this very need a few years back and came upon a small DLL that saved my butt.Welcome to my OO4O tutorial. There is going to be a prerequisite to this tutorial. Continue reading “Insert excel Data Into oracle database using OO4O”
how to make FRIGITD with sql.
Often times you want to replicate a form query with plain ol sql. In this little example ill show you how to do just this very thing with FRRIGITD. The sql is pretty straight foward. Let me remind you
that the grant ledger is inception to date. Continue reading “how to make FRIGITD with sql.”
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.