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
Occasionally in Dynamics GP you will need to void an Accounts Receivable transaction. Voiding a transaction in Accounts Receivable differs from voiding an Accounts Payable transaction in that there is only one place to go to in AR: Posted Transactions. To get to this window go to: Sales > Transactions > Posted Transactions.
In the Receivables Posted Transaction Maintenance window, enter or select the customer for the transaction you wish to void. Then you will want to select the Document Type of the transaction you wish to void. Options include Sales / Invoices, Debit Memos, Finance Charges, Service / Repairs, Credit Memo, Returns, Payments. Once you select the type you can click the looking glass next the Number to select the transaction.Read More
Sometimes a transaction in Dynamics GP needs to be voided. This can happen when an invoice is entered in error or incorrectly, or check was lost or destroyed and needs to be reprinted. In order to correct an invoice, you need to void the incorrect transaction, and re-enter it correctly.
If an invoice has been paid, or a payment applied to it, you will need to void the payment before you can void the invoice. To void a payment in Dynamics GP, go to Purchasing > Transactions > Void Historical Transactions. In the Void Historical Payables Transactions window, enter or select the vendor for the payment you want to void. Then mark the check box in the void column next to the transaction you wish to void. Then click the Void button.Read More
Every so often I come across a client that has been using Microsoft Dynamics GP since the early Great Plains Accounting days. They have done things the old way for so long, they are not aware that there are better options available in the system for completing their daily tasks.
A recent example of this occurred with a client that was using Sales Order Processing. To return inventory, they would select an SOP Type as Return, select the customer, enter the returned items, verify the quantities and price, etc.Read More