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.”
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”
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”
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.”
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”
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”
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 straightforward. Let me remind you
that the grant ledger is inception to date. Continue reading “how to make FRIGITD with sql.”
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?