A/P subledger does not tie to the GL

(0) Share

Report

Posted on by AWhalen

215

Our A/P subledger is not tying to the GL. I am fairly sure it has something to do with how invoices are matched to purchase order receipts, and creating a large balance in the unvouchered PO receipts account. We use landed costs for freight and duty charges. The freight invoices typically are paid before the purchase order receipt is posted.

Also, the received/not invoiced report shows POs that have been fully matched and closed. Is it possible that some part of the landed cost is causing this to continue to show that the qty shipped and qty matched are not matching?

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Possibilities could be various. Have you tried to run the Reconcile to GL utility for the payable management to have a detailed report of the transactions among General Ledger and Payable Module ?

What version of Dynamics GP are you using, is it GP 2013 ? If not, there is an SQL script that could be used to tie the General Ledger to AP moudle.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
AWhalen 215 on at

Like (0)

Report

We are using GP 2010. I have not tried to run the reconcile to GL utility. I will try that and see what happens.

Thank you.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Keep us updated

Your feedback is highly appreciated,

Was this reply helpful? Yes No
AWhalen 215 on at

Like (0)

Report

I'm guessing this process has never been run before because GP just timed out on me. Should I attempt to cancel this process or let it keep running?

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

I am talking about Microsoft Dynamics GP > Tools > Routines > Financial > Reconcile to GL.

Is this the window you are at ?

Was this reply helpful? Yes No
AWhalen 215 on at

Like (0)

Report

No, I was at the purchase order reconciliation. I will try this. Thank you.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

AP Reconciliation is something different related to matching master balances against transactions amounts.

In case the window is not available in your Dynamics GP, keep us updated to provide an AP-GL reconciliation script.

Was this reply helpful? Yes No
AWhalen 215 on at

Like (0)

Report

This is the first time I have run this in GP. Is there a report that I can view? I hit "process" and didn't see any output.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Before processing the reconciliation, you are supposed to specify the path of the file, at the end of the process the system will generate the reconciliation results on a predefined Excel template to categorize your AP transactions upon three main categories, Unmatched, Potentially matched and Matched Transactions

Was this reply helpful? Yes No
AWhalen 215 on at

Like (0)

Report

I was able to run the reconciliation. I also ran the purchase order reconciliation report, and found a lot of "errors". I am not sure what exactly these errors mean. Is this process necessary for the subledger to tie to the GL?

Thanks!

Was this reply helpful? Yes No

Community site session details

A/P subledger does not tie to the GL

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

A/P subledger does not tie to the GL

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates