Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
gptip42day - Reconcile
GP provides a way to 'Reconcile' summary and detail data within the application. Each module has its own Reconcile utility. For instance, Tools>Utilities>Financial>Reconcile opens the Reconcile Financial Information window.
* click image to enlarge
Now, this Reconcile is not for reconciling a GL account to the subledger, i.e., Accounts Receivable to the AR Trial Balance. This Reconcile forces financial summary information, such…
Weekly Dynamic: Reconcile ACH Batches
Mariano Gomez had a great piece of advice
on the Newsgroup regarding ACH batches and Bank Rec so I decided to formalize it and turn this into a Weekly Dynamic.
Many companies submit an ACH file to their bank to pay vendors. The bank will often process the transaction as a lump sum debited from…
AP to GL Reconcile Problem in Dynamics GP 10
Dynamics GP 10 introduced new, Excel based, functionality to reconcile AP to the GL (Dynamics GP-Tools-Routines-Financial-Reconcile to GL). Unfortunately, this doesn't seem to work correctly if there are outstanding transactions paid by credit card.
When you pay an AP transaction with a credit card, there's no GL affect, the liability within the AP subledger is simply moved from the original…
Reconcile to GL Tool in Dynamics GP v10
Dynamics GP Best Practices for Accounts Payable Management –in Microsoft Dynamics GP - One challenge many companies face is their ability to reconcile their A/P sub-ledgers to the G/L. Causes can be as simple as journal entries being posted directly to the A/P account or…
Reconcile Your Financial Accounts
What does reconcile function in financials utilities do? Frank explained the feature in this…
Reconcile Bank Statement directly with GL
Can it be just possible? The standard GP functionality reconciles the bank statement against the Checkbook Register. So, How can it be possible to reconcile a bank statement directly with General ledger open transactions? Same question came to my mind when i was writing the scope for a large Client whose business process demanded a Reconciliation module that actually reconciles the bank statement against the GL transactions in Dynamics GP. The client said they also need the reconciliation to provide complete reconciliation history. Then came the Advanced Bank Reconciliation…
How to setup all modules to be 100% reconciled to GL?
I am sure that most of our GP clients asks this question, when you do not have "Post Through GL" checked, the system will create your GL voucher in GL Transaction Entry window upon posting any kind of transactions in the module windows, and if this voucher got deleted for any reason, you will have variances between the module…
Dynamics GP E-Reconcile
My colleague Amy Walsh has coverage of the electronic reconcile functionality in Dynamics…
How to Reconcile RM to GL when you have multiple RM control accounts
This situation presents us with a unique set of circumstances as you can not restrict the Receivables aged trial balance by account. It can be restricted by payment priority and class so with some forethought and planning you could have debtor classes set up that use a specific control account or something similar along the lines of payment priority. If you have not done this or you think some transactions may have been miss posted then using smartlists would be your next best thing.
In Smartlists you can create a report for the receivables transactions based on the system date range and then create a report for GL (account transactions) for the system date range. This way, you can compare when the information was physically entered in the system (even with a different document date between modules). If one of the modules has the transaction posted and the other is missing, you can determine if the transactions were posted with a different date in GL than in receivables.
Within smartlists, open up the receivables transaction option. Add the column Posted Date. This column stores the date from your computer of when the document was physically entered in receivables. Even if the document date was for the previous year,…
Reconcile to GL