1. Run a Select * from FA40200 and note the CURRFISCALYR of the books.
2. From SQL studio, update the FA40200 table and set the CURRFISCALYR to the year that the asset was retired in.
3. Go back into GP and undo the retirement. Interface the transactions to the GL and delete or post them as necessary.
4. Go back to SQL studio and update the FA40200 to set the CURRFISCALYR to what is was before you updated it the first time.
Voila.
I am a Dynamics GP Consultant with over 14 years Implementation Experience. This is my memory. Everything I learn from my everyday interactions with Dynamics will be posted here as my lesson learnt. My contribution to the world!
Thursday, 9 March 2017
Wednesday, 8 March 2017
Unable to connect to GP
When testing ODBC connectivity the following error is obtained.
[Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Resolution:
Start the SQL Browser service
Turn off firewall.
[Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Resolution:
Start the SQL Browser service
Turn off firewall.
Subscribe to:
Posts (Atom)