AP GL vs Open Invoice Report

Doug Collins

Good morning - I am new to BB Financial Edge NXT - It was communicated to me that the AP GL should match the Open Invoice Report. I am unable to get the 2 reports to match. BB Chat said if they don't match to tic-n-tie the reports. Has anyone been able to do this or have worked through this process. Is it even possible? Any help is greatly appreciated. Have a GREAT Friday and weekend!

Kevin Brazell

@Doug Collins
it is. But depending on business rules, data practices, and when the last time the reports were reconciled it can be tougher to do. Check out this KB, outside steps and a link to the reconciliation guide, it also list some reconciling items to be aware of that make it tougher or cause issues reconciling :

Karen Avery

@Doug Collins We had this same issue. Our remedy was to determine if our Open Invoice Report was accurate (this was reconciled with our A/P person). When it was, I simply made an adjusting journal entry to our GL account (for us, A/P Vendors) to reconcile with the Open Invoice Report. We've been reconciling ever since.

Doug Collins

@Karen Avery
Thank you Karen. I will work through the process and am hopeful all will work out in the end.

Have a wonderful weekend!

Doug

Doug Collins

@Kevin Brazell
Thank you Kevin. It seems it has been sometime since last reconciliation. It is going to be a challenge. I will work through the process and am hopeful all will work out in the end.

Have a wonderful weekend!

Doug

Lisa Olscamp

@Doug Collins Ours has never matched. We book adjusting entries also.

Susan Trippe

@Doug Collins
Were you able to reconcile? I always struggle with this report and can seldom get it to reconcile with my general ledger. I'd love to know what you ended up doing.