Issue with AP Invoices – Misc Charges Not Hitting Desired GL Account

Epicor ERP 10
,
1

Hi guys,

I’m encountering an issue with AP invoices where miscellaneous charges in the line are not hitting the desired GL account.

I reviewed this KB, but the answer doesn’t seem sufficient. Has there been any progress on this issue since 2019?
https://epiccare.epicor.com/epiccare?id=epiccare_kb_article&sys_id=36c72792db5b23806a0493b7f496196b&table=kb_knowledge&searchTerm=AP%20Invoice%20Misc%20Charges%20inline%20Posting%20to%20Wrong%20Account

image
image833×218 21.8 KB

From my understanding:

  • If you enter the misc charge at the invoice header, it will hit the GL control associated with the misc charge.
  • If entered at the line level, it is treated as a cost and hits the Clearing Account.

Why Epicor has been designed like that?

Thanks, Adam

2

It may be working as designed, but I’d be guessing this could be tweaked by modifying the GL Transaction type for AP Invoice…

Take a look at the Posting Engine Technical reference.

You may want to grab a few expressos before you start :slight_smile:

1 Like
3

That screen is so confusing! I’m almost too scared to open it.

4

Use Classic… I have struggled to use the Kinetic one.

After a bit of time it makes sense.

Just don’t go an try to modify the COSandWIP one on your first try… That thing is a beast!

as far as testing AP invoices… I think you will find that doing the edit report and having the PE Log viewer enabled may show you the simulation, it definately works this way for COSandWIP when you run the Inventory/WIP rec report, saves you having run the capture cos and wip to post then create new transaction… sorry rambling.

5

To view which GL’s are connected to a misc code, go here…

General Ledger > Setup > GL Control Code

image
image1184×753 37.5 KB

in the drop list choose your GL control Type.

6

According to Epiccare, It is working as designed. If you expense the freight at the header level then it goes to freight gl control. If you allocate it at the line level it is because you want the expense to be included in the line cost

7

You have selected Accounting with Inventory receipt flagged as Yes. Which means at the time of GRN it is Dr Stock and Cr Clearing account. Hence, at the time of Invoicing it is adjusting Clearing account to zero. If you want to handle it differently then un-tick the Receipt flag at Company Configuration.
KR

8

Thanks for the note, I truned off the flag in Comp.Conf and tried agian but stil hitted the Accrued Liabilties and not the desired GL account for this misc. charge!
Am I doing some thing wrong?

9

Suggest to open ticket with Epicor support.

1 Like
10

Were you operating on the same invoice after you updated the flag. Before logging the ticket, try creating a new invoice with the flag enabled. If it still doesn’t work then do the ticket.

1 Like