Microsoft Dynamics GP (Archived)

getting errors in fixed assets, GPS Error: 18, SQL Error 512

(0) Share

Report

Posted on by Community Member

I am getting error messages attempting to post Fixed Assets General Ledger Posting.

Can anyone tell me how to resolve these errors please?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Here is a similar post involving a copied company. Manufacturing, WennSoft and Fixed Assets Management ALL have setups, which are maintained outside the Company database, so copying them isn't enough.

community.dynamics.com/.../45004.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am looking for the script Richard mentioned in that link. But no one seems to have it.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

I am not sure if the script Richard referred to in his post was the one mentioned here, but it's a likely scenario:

support.microsoft.com/.../949762

Are you using Manufacturing?

For Fixed Assets, here is the fix - it does not involve the use of SQL:

If you are using Fixed Assets for Microsoft Dynamics GP, the Fixed Assets Company Setup information will not be brought over to the Test Company. To correct this issue, open the Fixed Assets Company Setup window in the Live Company and note the settings. Open the Fixed Assets Company Setup window in the Test Company and enter the same settings as the Live Company. To open the window, use one of the following options:

If you are using WennSoft, WennSoft's customer support site has a document which, changes from version to version, which explains how to fix WennSoft when a company is copied. This one involves SQL.

Was this reply helpful? Yes No
Suggested answer

Thomas Newcomb 1,810 on at

Like (0)

Report

Hi WennSoft!

Thank you for posting screenshots of the errors that you are receiving. Are you receiving these errors in GP2013? If so I do have some steps that you would be able to test going through. Generally we will see these errors you have in the screenshots above. The problem itself deals with the FA49900 table in each Company database, which should only contain information for the Company database the table resides in. Sometimes we will see more than one company record in the FA49900.

You will want to test the steps below in a test company and prior to completing the steps in a live company you will want to make a backup of the live company.

1. Run the following SQL statement to determine the Company ID that should be in the FA49900 for the Company that you see the error in:

select * from DYNAMICS..SY01500

2. From the above results, you can determine the CMPANYID that would be valid for the FA49900 entry for the company seeing this issue. Next, run the following script to view the problem Company’s FA49900:

select * from FA49900

3. If you see more than 1 companies records in the table you would want to remove the invalid company IDs from the FA49900 table leaving only the valid company record id you found in step 1.

Let me know if this helps resolve the issue!

~Thomas Newcomb

-----------------------------------

Dynamics GP Support Engineer

-----------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

WennSoft,

Please have a look on the below link

community.dynamics.com/.../104158.aspx

Was this reply helpful? Yes No