A/P Control Account

When my A/P account was first set up, it was set up as an APO or OL instead of an A/P. What can I do?

If there has not been ANY activity coded to this account (beginning balance, journal voucher's, corrections, and so on) then you can delete the account and set it up again using Maintain>Chart of Accounts Codes. If there is activity to the account, it cannot be deleted or changed. A new Accounts Payable G/L account must be created (make sure it is an "A/P" type) for use with the Accounts Payable module.

I run an A/P report and the report's balance does not match my G/L balance for my A/P account. What is wrong?

First, make sure you are running a Detailed Accounts Payable Ledger, instead of an Aged Payables Ledger. The Aged Payables Ledger seldom matches the Accounts Payable G/L balance because of timing issues related to aging date, due date, and invoice date being different.

Next, examine the effective dates of the A/P invoices and payments involved. Regardless of the invoice date, check date, or document date, the invoice or payment posts to the General Ledger on the effective date. If you are comparing the two reports and information is missing from one of them, try expanding the date range to see if it posted with a different effective date. Data integrity checks can be run to verify that the A/P subledger ties to the G/L (Organization>Data Integrity Checks).