A while back, a long-time client of mine told me about an issue they were having that they couldn't explain. No problem, I said, let me have a look.

I come from the school of "everything has a reason, things don't just happen by themselves". Well….

The issue

On Receivings Trx Entry, the COGS account is defaulting to a GL account they don't want to be the default. They want it to default to nothing in this particular case, so the Payables clerk has to view and edit the distributions to the appropriate place.

Troubleshooting

I ran through the usual checks. Project Accounting and GL accounts are a mystery to many people, and at times, can be quite confusing to figure out where something comes from. I always tell people that because this module is so configurable for a wide variety of uses, it almost inundates users with too many choices.

Having worked with PA for many years, I figured this would be a 15-minute fix. Scroll through the various places to find the source and voila, there would be the answer.

I'm still stumped.

What I found

First I looked at the Project and the Project Budget window. They were using the cost category "AP" in this case, a PM cost category, non-inventory.

The Project Budget maintenance window with the AP cost category is highlighted.
The Project Budget maintenance window with the AP cost category is highlighted.

Next, I opened the Budget Accounts window, from the Budget Detail window, to view the sources for this cost category on this project. COGS comes from the Project Accounts, in this case.

The Budget Accounts window, where the COGS account comes from in this particular configuration.
The Budget Accounts window is where the COGS account comes from in this particular configuration.

So, next, I open the Project Accounts window. I select "Purchases/Material" as the transaction type, and find no default accounts here for COGS. That's exactly what should be there if they want to have to type it in each time.

The Project Accounts window, for Purchases/Material, also shows no default account for COGS.
The Project Accounts window, for Purchases/Material, also shows no default account for COGS.

Now I'm scratching my head a little. Everything appears to be configured as I would expect, based on what they want to happen. So, the next place to check is to look at the default company-level Project Posting Accounts to see if there is a default there. It wouldn't be the first time someone has put an account there, that no one expected! Except, it's also empty for "PM" COGS (and everything else in this case).

The Conclusion

I prefer happy endings! 😄

I'm still stumped and the client is too. It seems to only happen occasionally, that an account defaults in (this project/CC combination is one of the situations). It makes no sense, and I know things don't just happen without a reason so every once in a while, I look somewhere else to see if I can figure this one out.

I've ruled out default accounts from a vendor (no purchases account set up); it's not inventory so there is no default coming from an item; beyond that, there are not that many more places to check. The sources are many, but once Dynamics GP is configured for where a certain project/cc source is, it doesn't change without someone changing it!

Here's what happens if a user types in a Receivings for this Project/CC combination: GL account 508501 appears from (seemingly) nowhere!

An example of a Receivings Transaction Entry to test the results I'm seeing.
An example of a Receivings Transaction Entry to test the results I'm seeing.
The Purchasing Distribution Entry for the test transaction with the odd account defaulting from who-knows-where.
The Purchasing Distribution Entry for the test transaction with the odd account defaulting from who-knows-where.