One of the new features of Microsoft Dynamics GP 2013 R2 is the ability to copy information from an Excel Spreadsheet and paste it into a General Ledger entry in GP. For any of you that have used Integration Manager to import General Ledger transactions into GP, you are probably jumping up and down with joy and high-fiving everyone at the office. A process that used to involve preparing your Excel document, saving it as a tab-delimited file, configuring your integration, and then troubleshooting any errors you might receive with your integration has been simplified into preparing an Excel document and simply pasting it into GP. Neat right? The only thing to keep in mind is that your columns have to be ordered in this sequence: Description, Account Number, Debit, and Credit.Read More
In my last blog post, I wrote about what to do if your Cash Account and Checkbook Balance do not tie. I described a process that you could use to find the discrepancies in GP 2010.
In GP 2013, they have added to the Reconcile to GL functionality. Previously this tool only worked for reconciling Payables and Receivables to the GL. Now they have added Bank Reconciliation.
However, before you use this tool, you will first want to verify that everything has been posted through Series Post. You will also want to make sure that there are no outstanding deposits. These are two things you will want to check when your Cash Account and Checkbook do not tie, before you use the Reconcile to GL tool.Read More