Hi. I am having a problem getting my GL balance and my AP Aged Payables report totals to match. No matter what combination I enter, due date, document date, period end date; they will not equal. I searched for help on this board with related questions but as I have no accounts/vendors on hold it does not make a difference. My accountant is wondering if it is a timing issue of when the payables hit the GL. When entering payables for the previous period in the current month I back date the batch date to the month end I am doing, enter the invoice date on the invoice and post. Then, when the system pulls the report, it should be pulling all invoices for that specific period. I cannot eliminate the prepayments as they are included in the GL balance. As there are so many ways to get the same report, is there one that works the best? Also, we work with multiple currencies, does pulling the report in functional currency affect it? As my GL is in functional currency it should be the same.
Thank you for your help. I look forward to figuring this out.