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”
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.”
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”