I stumbled across an awesome utility add-in for excel that will save you tons of time doing mundane little formulas and formattings to your data. The folks over at ASAP Utilities have created this wonderful tool and it’s completely free for the taking. There must be over 100 functions in this add-in, here’s a few […]
WordPress: How to add a To-do List
I have searched the net for a WordPress plug-in that would allow me to add a todo list to a WordPress blog, but to no avail. My options were to write my own or keep searching. What I really wanted was a to-do list like the available for Google personalized homepages. This ultimately led me […]
SAP: CO03 – Analyzing Production Orders
In our wholesale distribution company, we have limited use for Production Orders, whereas a manufacturer might use them all the time. We do use Production Orders for assembling kits from various inventory items. This is a brief description of the process from a FICO perspective and how you might analyze the transaction history. Process Overview […]
SAP: How to emulate hierarchies outside of SAP
Applies to: R3 4.6c (which means it probably applies to all of 4.6) If you’ve ever needed to build something outside of SAP that uses the SAP’s account set, profit center set, or functional area set hierarchies, it can be a big task. Ideally, you could use some sort of BAPI or remote hook into […]
SAP: FICO – Copy an old journal entry (post with reference)
SAP makes it easy to create and post a Journal Entry that you can base off of a previously posted document. If you don’t need to set up a full blown Recurring Entry(or you don’t have access to FBD1 – Recurring document), you can easily copy a previously posted document in FB50. SAP gives you […]
Definition: nee – indicates a former name
nee – From French, originally indicating a woman’s maiden name…ne is a conjugation of naitre (to be born). Nee is also commonly used to indicate prior names of things…e.g. Coke Classic, nee Coca-Cola. See the wiki article.
Excel: Turn a Column into a Row and Vice Versa
Just got a call today from an accountant wondering how to turn a column of data into a row. If you don’t know, you’ll love it…so simple: Highlight the cells you want to flip the orientation on Ctrl-C to copy (or copy button…whatever you like) Click Edit/Paste Special (might have to expand your Edit menu […]
