GL on PO Release not coming from Part or Part Class

A bit of help here. We have GL accounts associated to a Part and Part Class.

When a buyer creates a new PO the PO Release GL account is not the one set at the part. It is the one set in company configuration.

Is there a setting that needs to be enabled for the logic to use the Part or Part Class GL account?

I have been told that this is one of the things that hasn’t been working since we were on version 9.

There would need to be a little review of your setup. If you are able, please send your GL Control Setup and Part Class with GL Control Tab

Anything I’m missing?

Company config

Part Entry

PO Entry

Thanks,

I assume that clicking “Get Default” don’t change it?
Also, can you screenshot the Account List view?

correct on the Get Default nothing.

Where is the account list view?

Nevermind. There is only one Account Context for Part. Sorry for that rabbit hole.
On the PO Line there is a Class field. Is it possible the Class is overriding this value?

Not being a finance “guru”, I typically play with the GL Control Codes to see where the value comes from.
I also offer that the “Suspense” account actually be made up of many accounts (like in your case 01-5006## where the ## is 00-99). That makes it easier to find the source and what is driving the result.

Also, I would want to test the result when a receipt is made to see if the COS/WIP is hitting the correct account (despite what is shown on the PO Release).

Here is the account list for the GL control on the AP account

this is where the 01-999000- is coming from.

Wow. That shouldn’t doing it…
I would want to get support on that.

1 Like

If you try a PO marked as “Inventory” with that part does it choose the inventory account? I think @Jason_Woods is right, I would get support involved. They may be able to shed some light on what’s happening.

1 Like
  1. Any posting rule modifications?
  2. Looks like this is reproduceable, otherwise I’d warn that it does not update when things change (as opposed to an inventory part)
  3. Have you tried the PE Log Viewer? You can see the breadcrumbs there…
1 Like

4 Likes

Here is the issue we are having with the GL Account matrix.

We have non stock parts in Epicor that we want to go to a GL account. We just don’t want the whole Part Class to go to that GL Account as we could have multiple GL Accounts within a part class.

How do folks get around this?

Do the Non stock go to the one GL while the stocked ones go to the other (in the same Part Class)?

That is correct. There are multiple GL account locations within the Part Class

The only thing I can think of is to develop a BPM that looks at that logic and changes the GL Account on the release when it is saved.

Darn.

Out of box Epicor is so close…

Yeah, once you click the “Other” on the PO line, it changes the rules.

They typically create mutiple Part Classes. :weary:

1 Like

Oh, that’s right! Wow you’d think I’d remember that:

Oh, and this was the kicker:

We are buying this part into a different accounting bucket than we are issuing it from

I bet we are still getting burned by that. Oh wow.