GP Table Reference Updated for GP 2018 plus First ISV Products Added

Microsoft Dynamics GP Table ReferenceI have now fully updated the azurecurve|GP Table Reference for Microsoft Dynamics GP 2018 RTM as well as adding the first few ISV products

A total of six new products have been added during the latest update.

Standard modules added are (I’m not entirely sure why these hadn;t already been added, but assume it is to do with them being more focused to the UK market; certainly DDR is):

  1. Direct Debits & Refunds (8811)
  2. Scheduled Installments (1150)

The added ISV products are:

  1. Advanced Bank Reconciliation (2440) from Nolan Business Solutions
  2. Extender (3107) from eOne Solutions
  3. MIS-AMS Extensions (3459) which is now maintained by Perfect Image, but not generally commercially available.
  4. SmartList Builder (3830) from eOne Solutions

I am going to be adding additional ISV products to the site as well, look for lighter tiles ; if you work for an ISV, or use ISV products, and want the tables added to the GP Table Reference, please get in touch with details of what you want adding.

The Mekorma products are currently on my list of the next ISV products to be added.

Setting Bank Account In ABR To Extract Automatically In Reconcile Bank Transactions

Microsoft Dynamics GPConfiguring Nolan’s Advanced Bank Reconciliation (ABR) to automatically extract transactions when reconciling a bank account is not complicated, but I keep on forgetting where the option is located. That gets a little embarrassing when you tell a client, “yes, you can do that” and then have to spend five minutes looking for the option.

So by writing it down here, I am hoping to be able to commit it to memory.

this option is per bank account and is located on the Bank Account Setup window (Financial >> Setup >> Advanced Bank Reconciliation >> Bank Setup).

Click the Options menu and then select Extract options:

Bank Account Setup

Continue reading “Setting Bank Account In ABR To Extract Automatically In Reconcile Bank Transactions”

Mea Culpa: Fixing A Corrupt Sales Invoice

Microsoft Dynamics GPIn this post I discussed fixing a Sales Invoice which was corrupt and how Microsoft Dynamics GP Check Links couldn’t be used to fix the problem as it only looks at the standard tables but the invoice in question was a recurring invoice created using Nolan Business Solutions’ Advanced Sales Order processing with recurring Invoices. Continue reading “Mea Culpa: Fixing A Corrupt Sales Invoice”

Fixing A Corrupt Sales Invoice

Microsoft Dynamics GPWe received a call from a client yesterday about a problem with a sales invoice.

They’d tried to amend the value, had a problem and then tried to void the transaction (their settings prevented the registered invoice being deleted but something went wrong.

It was at this point that they called the helpdesk to report the following error message;

This document number already exists. Please enter a new document number.

Continue reading “Fixing A Corrupt Sales Invoice”