Dynamics GP 10.0 Fixed Assets Import Error: FAINDEX Not Found

Table of Contents

Hitting a Snag with Dynamics GP 10.0 Fixed Assets Import? Let’s Fix That FAINDEX Error!¶

image just illustration

So, you’re trying to import your fixed asset data into Microsoft Dynamics GP 10.0 using the eConnect adapter, and BAM! You’re hit with the dreaded “Unable to obtain the next FAINDEX” error. Frustrating, right? Don’t worry, you’re not alone. This is a known issue, and thankfully, it’s got a pretty straightforward fix. Let’s dive in and get those assets imported!

Decoding the FAINDEX Error¶

This error pops up when the eConnect adapter is searching for specific values within the system tables, and those tables happen to be empty. It’s like trying to find a specific book in a library that has no books on the shelves yet. Adding a more complex stored procedure to handle this might seem like a solution, but it could actually lead to locking and blocking issues down the road – which is even more of a headache.

The Symptom: Stalled Integration¶

You’ll know you’ve encountered this issue when, during the integration process, you see this error message:

Microsoft.Dynamics.GP.eConnect: Number = 6625 Stored procedure taCreateAssetID : Description = unable to obtain the next FAINDEX.

This essentially means the system can’t assign a unique identifier (the FAINDEX) to your new assets because it doesn’t have a starting point.

The Root Cause: Empty Tables¶

The core problem lies in the fact that the relevant tables in your Dynamics GP system are empty. The eConnect adapter needs existing data in these tables to determine the next available FAINDEX. When the tables are empty, it simply doesn’t know where to start counting.

The Solution: A Manual Kickstart¶

The fix is surprisingly simple. You need to manually enter one asset, complete with both general and asset book information, directly into Microsoft Dynamics GP. This “seed” asset gives the system the information it needs to generate the next FAINDEX.

Here’s a step-by-step guide:

1. Open Microsoft Dynamics GP.
2. Navigate to the Fixed Assets module.
3. Manually enter the information for one asset. Make sure you fill out both the general asset details and the asset book information.
4. Save the asset.

That’s it! This manual entry creates the necessary foundation in the system tables.

Running the Integration Again¶

Once you’ve manually saved that single asset, you can try running your eConnect integration again. The adapter should now be able to find the next FAINDEX and import your remaining assets without a hitch.

Why this Works¶

By manually creating an asset, you populate the previously empty tables with the necessary data. This gives the eConnect adapter a reference point to generate the subsequent FAINDEX values for all your other assets. Think of it like priming a pump - you need to add a little water first to get the flow going.

Important Disclaimer¶

It’s important to note that the information provided here is intended as a helpful guide. While we strive for accuracy, things can change, and software can behave in unexpected ways.

What if the Problem Persists?¶

If you’ve tried this solution and you’re still encountering the FAINDEX error, it might be time to reach out to Microsoft Support or a qualified Dynamics GP consultant. They can help diagnose any underlying issues and get your integration back on track.

image just illustration

Key Takeaways¶

• The “Unable to obtain the next FAINDEX” error occurs when importing fixed assets into Dynamics GP 10.0 using eConnect.
• It’s caused by empty system tables that the eConnect adapter relies on.
• The solution is to manually enter and save one asset with both general and asset book information.
• After this, retry the eConnect integration.

We hope this guide helps you conquer that pesky FAINDEX error and get your fixed assets imported smoothly! We’d love to hear your thoughts and experiences. Did this solution work for you? Do you have any other tips or tricks to share? Leave a comment below and let’s keep the conversation going! Come back and visit us again if you encounter other Dynamics GP hurdles - we’re here to help!