I think this should be simple enough - what is this “Payment” transaction?
It says Adjust, but it’s for zero dollars. No one in accounting recalls doing this.
I did some BAQ-digging, and There are 1,642 occurrences of this. Every one says “Zero Bal.” (after 2020) or “Zero Balance Posting Close” (prior to 2021). Most - but definitely not all - are debit memos.
Anyone seen this? What procedure causes it?
Just bumping this. I have a ticket in with support, but I was hoping someone here might be familiar.
I assume this is some perfectly normal process.
I just don’t know what it is (or how to forensically track it down from a dataset with a bunch of zeroes in nearly every reference field).
Couple of thoughts for you - not sure if any of this will help
Do you do multi-currency? Could it be a rounding/re-evaluation entry that occurs in the background?
Do you have a special rounding rule something custom in the Posting Engine rules?
Is there a UserID or anything associated with the AP Payment table rows? Do they correspond with the posting of an AP Invoice group or Payment group - or occur after posting either of these groups?
I agree and after my meeting I’ll check our system. Do you have the BAQ you used? Would speed up us checking.
SELECT * FROM erp.APTran
WHERE TranType='ADJ' AND Description='Zero Bal.'
I have a few too ~2571 rows
Here you go. It’s just where APTran.TranAmt = 0
temp_APAdjZeroBal.baq (10.5 KB)
@MikeGross No, no multi-currency (we don’t even have the module). No custom posting rules in AP.
There is a user column. I didn’t show it to the internet, of course. But I’m not sure what I would do there - it’s the normal accounting names.
Looks like a zero dollar correction invoice will do this. Basically if you are fixing something else in the invoice other than the dollar amount.
When it posts, it posts an APTran (payment) of Zero Balance to close the invoice.
IE: WE created this correction to change a UD field in the AP invoice (do’nt ask why) and it created that Zero dollar AP Tran(for closing it)
It is basically an internal triggering mechanism to “Close” the AP invoice (when it has zero dollars). Epicor didn’t feel like writing a custom “close invoice” routine. So they just apply a zero dollar payment #Clever
Once you stop editing, lol, I will print this and show my AP coworker.
AP is probably the one functional area of Epicor where I know very little (since my coworker is so good at it).
I vaguely understand, but I think she will understand more.
I’m done now 
Thank you, by the way.
I agree with @josecgomez . I too found a whole bunch in one of my companies and they all have a line on the invoice that effectively zeros the payable amount.
I’m not sure why my folks are processing this way, but the transaction appearance did start the same time you indicated. It looks like we have plenty of AP invoices from before then that have the same lines, so it seems Epicor changed this at some point.
How are you searching? By the phrase “Zero Bal.”?
Not sure if you caught my comment in the OP, but they changed the phrasing at some point. It used to be “Zero Balance Posting Close.”
This is the part I don’t get (I think due to my ignorance), but is it doing a write-off of sorts? (That’s an AR term; AP is an “adjustment,” right?)
My point is, it sounds like the effect is unrelated to the cause: I don’t want to touch the money, but it “adjusts” it anyway.
But again, I assume it’s my ignorance. My coworker is busy, so she will have to explain this to me later.
Ah yes - missed that. Correct - 518 entries from the start of our Epicor usage here. Oddly, all but 4 entries are in our UK/NL companies. It must be a process they are doing, and I can’t ask them until tomorrow (if you want me to).
Ok - now that you’ve dragged me into this - I dug deep but haven’t confirmed with any other source.
Pulled a single invoice up that has your criteria, yet the line items do not equal zero. The header is Zero, but the sum(extcost) < 0 (in my case) Most of these are negative but there are a few positives.
Is this a way to ‘close’ the AP invoice because the balance is disputed/credited or otherwise taken care of by another transaction?
The plot thickens!
Support did help me find that there are 3 transactions that show a “Doc” balance when the regular balance is zero. (AP Invoice Tracker must be showing the “Doc” version.) But we never paid the invoice. Also the invoice is marked as OpenPayable = FALSE, which take it off of the AP Aging report (not good either).
Also note that the 3 tran numbers are sequential.
Finally tried this, and I agree. I couldn’t get it to leave a balance, but it does do the “Zero Bal.” transaction.
I won’t ask why you did the change, but may I please ask: why didn’t you use AP Posted Invoice Update instead? I’m assuming it will not allow access to UD fields?
Bingo it only allows access to some fields. But more importantly we have business process (BPMS) that run on Invoice Post that do a bunch of magic we didn’t want to have to recreate.
Perfect, thank you.
@MikeGross I think this explains why you have differences in your divisions.
