The account number for actindx xxx needs to be recreated

 This is about a fine GP error message you may receive if you run CheckLinks on the Financial > Account Master.

There are several possible reasons for this error, some of which you may have already found via other references.

My problem with this error, which I've not found a link to, stems from the GL00103 and GL00104 tables.  It seems we had some entries in those two tables with account indexes that were not in the account master.

These represent orphaned allocation accounts and can simply be removed.  Doing so cleared the error messages being report in the Account Master Checklinks.

Hope this helps.

Jet Reports error regarding Repository Connection

 Here's a beauty of a pile of poo I stepped in.  I was trying to update my Jet Services server to the latest version of Jet Reports tools so I could access the Dashboard Builder.

In doing so I uncheck the boxes for Jet Server because, duh!, they were already installed.

WRONG MOVE!

That just uninstalled the Jet Server components.  So bye bye Jet server.

Took a support case for me to realize how big a flip-up this was.  I was trying to access Jet after this goof and, since the Jet Service windows service was no longer present I was focusing on trying to start the Jet Data Manager Server service.

As Jet Support so ably pointed out that service is only used for a "developer" scenario, which I believe is where multiple developers are using Jet at the same time.  Not my cup of tea but, hey!, open a support case.

Meantime I'd try to start the Jet Data Manager Server and received the following:

"The service started and then stopped again.  The reason for this can be that the user <x> has an incorrect repository connection."

Well, truth be told, the reason for this is I'm an idiot!  I had no business trying to start that service.  It should have been disabled and remained that way.

In reality what I needed to do was re-install the Jet Server components and reconfigure things.  After doing that Jet was back up-and-running and I was back in business.

Please be careful and try not to follow my footsteps!

Dynamics GP Smartlist Builder GoTo Payables version

 Been a while hasn't it.

OK first problem to document is when building a Smartlist (Smartlist Builder) in GP for Payables Transactions and wanting to GoTo the Inquiry window (for example) from the Smartlist.

Easy way to do this is base the Smartlist on the Payables Transaction Smartlist.  This provides a Document Status field that will be used as the ASI_Document_Status value in the BuiltIn GoTo.

So the steps again require the use of the Payables Transaction Smartlist as a Table in the Smartlist.  Once that is established and working set up the GoTo as BuiltIn and with Microsoft Dynamics GP as the Product and Payables Transaction as the Smartlist and Go To as Payables Transaction Inquiry add the Document Status, Document Type, Voucher Number and Vendor ID fields as related to the respective Parameter fields.

This will allow the Inquiry window to open regardless of whether the AP transaction is Unposted, Posted or History.