Balance AP differs to Totals in Payable Ledger Tab
Description of the Issue:
There is a discrepancy where a supplier account (00016059) shows an AP balance of -41.59 in the supplier account window.
But when looking at the Payable Ledger Tab it shows a zero balance, which is correct. Tested it with all possible totals and they were all 0.00
Where could the Balance AP Field possibly pull the -41.59 from?
Client:
CCD_Prod_0533040578
Version:
26.12026060801
zendesk:
#391081
-
Does the GL amount balance? I am comparing how we resolve it in receivables where sometimes there are discrepancies between what is in the receivable ledger vs what was actually in the journals (which gets posted to GL accounts).
Can you check whether there is a GL posted field? Maybe that will help identify whether there are transactions that needs to be pulled in to the ledgers. Also, does the customer close period from the correct action on the main menu. Sometimes closing it from the fiscal calendar messes up the balances. If you have a copy of the database, might be worth reopening the GL and payable ledgers up, then close it properly so that it rolls the correct ending balance to the next period.
-
The GL amounts balance – there does not appear to be any imbalances on any of the associated GLs. The only thing that they have noted is that the system is showing a balance of -€41.59 in the ‘Balance – AP Demographics’ field on the main supplier page. However when they check the payables ledger, there is nothing outstanding. There is also nothing owing on the receivables ledger.
Regarding checking whether or not this is GL posted field - how to do that? Client has not noted any imbalances on any related GLs.
The difference looks to be coming from V-7498 / Invoice 131260 which was raised in GBP for £768.19.
In December 2024, they raised a credit note in GBP for £768.19 to cancel this invoice.Please see below the screenshot of the payment batch journal for this. The equivalent € amounts are showing for the invoice and credit note which is where the difference of 41.59 is coming from.
Could the -41.59 balance that is showing on the supplier page possibly be due to the fact that they referenced Everbridge in the Account field for the 41.59 amount (please see items circled in the screenshot below)?
-
Oh, that journal entry might be the issue. I'm pretty sure the system does a tally of the AP demographics amount vs what is on the Supplier control GL account. What is the reason for it to be recorded against the Management Other Expenses? They might need to reverse that amount out. A financial consultant will be best, as we want to understand their business case and how to best reverse it.
Please sign in to leave a comment.
Comments
4 comments
Date Votes