SAP – F.50 Profit Loss Adjustment or Cash Discount Details

profit-and-loss-adjustment-692009-44654-pm-2There are a few things, well maybe more than a few, that SAP asks you to just take on faith.  Running the Classic GL on ECC 6.0 or prior (4.6 c, etc), the Cash Discount calculation (also known as the Profit Loss Adjustments calculation, T-code: F.50) is one of them.

Read the rest of this entry »

Popularity: 11%

C# – SQL Server Foreign Key, Unique constraints

unique_key_constraintI got tripped up today with a particularly nasty Join statement that worked perfectly form 90% of the queries, but was blowing up at times.  The error message was: 

Read the rest of this entry »

Popularity: 11%

C# – Convert String Array to a List (.Net 2.0)

ASP.netSo you’ve got a C# string and you want to convert it to a List<string>.  Lists are one of the most efficient ways of storing…well…lists of things in .Net.  If you’re in .Net 3.0, it’s quite easy to go from a string array to a list by using the .ToList() function.

Read the rest of this entry »

Popularity: 16%

WordPress: Get Category ID for a Category Page

wp-pluginIt shouldn’t be this hard!!  Here is a quick function for getting the Category ID for a WordPress Category Page. Once you get the Category ID, a world of possbilities opens up. You can get the category object and all the info you need related to that Cat.  I can’t believe how hard it was to find this on Google. Ultimately, I had to piece together a couple of different posts to get to this since they weren’t quite right.

Read the rest of this entry »

Popularity: 20%

ASP.NET – Get User Name Under Windows Authentication

ASP.netGetting the authenticated user’s name when using Windows Authentication with ASP.NET is very simple.  I just keep having to go back to Google or dig out an old project to remember it, so here it is:

Read the rest of this entry »

Popularity: 37%

SAP: Functional Areas in Distributions & Assessments

sap_logoSAP allocations, or more precisely, Assessments and Distributions offer a lot of flexibility in their design.  So much so, that you can get lost in the details pretty quickly.  We recently discovered a flaw in our approach to distributing Gross Margin from non-sales profit centers.  The problem was that the distribution did not carry the Functional Area of the original postings.  In fact, it wasn’t carrying a Functional Area at all and was getting the default functional area for revenue accounts, thus skewing a couple of metrics.  Luckily, the fix turned out to be really simple, even if it had to repeated a couple hundred times ;-) . Read the rest of this entry »

Popularity: 22%

PhotoSmash Galleries Plugin turns 1,000

picture-5Even as I sit here trying to fix a thorny problem with PhotoSmash, I popped by the plugin’s page and noticed that it had turned 1,000 downloads on the nose. Let’s hope the next 1,000 downloads have it a bit easier. PhotoSmash is a WordPress photo gallery plugin lets you let your visitors upload images into galleries right inside your posts. It’s sort of a unique feature amongst galleries today, but I’m sure there will be some other excellent implementations on the same theme down the road. Anyway, thanks to all you who’ve tried PhotoSmash. You’re helping me make it better.

Read the rest of this entry »

Popularity: 20%

Supple Forms – Quick Start Guide

This is a quick start guide to get you up and running with Supple Forms as fast as humanly possible. Supple Forms is a CMS plugin for WordPress that lets you add custom data to posts and pages. It is both powerful and simple to use. If you need something like this, it might just be what you’re looking for.

Read the rest of this entry »

Popularity: 24%