Topic Options
#6623 - 01/27/05 01:46 PM Accounts Payable Issues
H and O Offline
Adagio Enthusiast

Registered: 05/06/02
Posts: 20
Loc: Edmonton, AB
1) How is it possible for the accounts payable open payables balance be a different amount from the G/L balance? I have not deleted any batches, as soon as they are retrieved, they are posted.

2) My bank account shows a cheque from A/P but the expense is not showing up in the income statement. I have reviewed my entry, and it looks fine. I have also verified the expense is not keyed to the wrong account.

I think these two items are linked somehow.


Top
#6624 - 01/27/05 03:16 PM Re: Accounts Payable Issues
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11570
Loc: Vancouver, BC Canada
1) How is it possible?
- Well the obvious answer is that some transaction entry that was posted in Payables did not make it over to Ledger. The harder question is why. Use the GL Detail listing or the Financial Reporter drill-down to list the details of the Open Payables GL account to see if you can identify the check or other transaction(s) that is missing (or otherwise making the balance not match). Also check the AP posting journal report as it lists the GL transaction information. Does the data integrity pass for both AP and GL?

2) Expense not in income statement.
- A similar determination; use the GL detail listing report or drill-down for that expense account to see if the detail is actually there. Additionally, view the Vendor Transaction screen and the Applied details of that AP check (cash invoice?). If that batch was posted using Adagio Payables (as opposed to Accpac Plus AP), then the GL account activity will be listed with the transaction. Is the expense account referenced here?


Top
#6625 - 01/30/05 02:01 AM Re: Accounts Payable Issues
Kate Spontak Offline
Adagio Pro

Registered: 03/23/02
Posts: 10
Loc: New Jersey
If the check paid an invoice previously entered (debiting expense and crediting payables), then the "expense" side of the transaction would be debiting the payables account, not an expense account.

Common causes of this error are:
1. A credit note or debit note or adjustment was entered with a distribution to the payables account. This would result in a change in AP, but the transaction would net to zero in GL.
2. An adjustment was entered directly in GL to the payables account.


Top


Moderator:  Softrak Support 
Who's Online
2 registered (smhoon, 1 invisible), 86 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70726 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31