11/21/2018

Dynamics GP Fixed Assets GL Posting Batch Missing After Depreciation Run

I got a call from a user who was seemingly worried about her monthly depreciation batch went missing from GL posting routine in the Dynamics GP Fixed Assets.

I quickly took her desktop on Teamviewer Quick support and understood the problem she is facing.

Let me explain the issue in detail before I tell you the solution.

Dynamics GP Fixed Assets GL Posting Issue


Issue

The user ran the depreciation routine in Dynamics GP for November month through Dynamics GP | Financial | Routines | Depreciate All Assets.

Till here, all was good. She then proceeded to FA GL posting routine. Dynamics GP | Financial | Routines | GL Posting.

She could not find the batch in GL posting lookup. In other words, the monthly depreciation batch is not accessible for posting.

She then ran the depreciation process again and this time when she went to GL posting window and tried processing, the system threw an error message as below

There are no transactions matching these restrictions. Modify your restrictions and process the batch again


Dynamics GP Fixed Assets Issue


Basically, the system is telling there are no transactions available for GL posting.

Troubleshooting Steps

I went through the preliminary troubleshooting process explained below in sequential order. 

Quickly checked the GL batches (Dynamics GP | Financial | Transactions | Batches) and checked if the fixed assets batch is available for posting. It is not available. 

Checked the FA GL Posting window  (Dynamics GP | Financial | Routines | GL Posting). The batch is not available. 

Checked the Financial Detail (Dynamics GP | Financial | Inquiry | Financial Detail) if the depreciation is updated for November month in the asset books by checking randomly. 

Then generated report "Fixed Assets to GL Reconciliation" to ensure this particular GL batch is available for reconciliation. The batch under issue is showing up in this report. 

Ran query in SQL Management studio for checking records in FA00902 and FA00905. 

These are the preliminary steps taken to diagnose the issue on hand. Now comes the solution that addressed this issue. 

Solution

Make a fresh backup of the company and DYNAMICS databases just in case things go wrong, so we have the latest backup to quickly return to original state. 

Run the query below to check the records again for the batch

 SELECT * FROM FA00902 WHERE GLINTBTCHNUM = 'YOURBATCHHERE'


 SELECT * FROM FA00905 WHERE GLINTBTCHNUM = 'YOURBATCHHERE'  

Delete the records in FA00905 ( Work table)

 DELETE FROM FA00905 WHERE GLINTBTCHNUM = 'YOURBATCHHERE'  

Update the records in FA00902 (GL posting table) to create blank records for GLINTBTCHNUM field in place of the affected batch number.

 UPDATE FA00902 SET GLINTBTCHNUM = '' WHERE GLINTBTCHNUM = 'YOURBATCHHERE'  

What we are doing is deleting the work records for GL posting by deleting the FA00905 table records for the affected table and then updating with blank values for the batch number field in the FA00902 table. Thereafter, we should be good to go to process the GL batch again and we will have the values again.

Now, go to Dynamics GP | Financial | Routines | GL Posting and process a new batch. You'll have the records that were earlier missed posting.

Note: Do not adopt this procedure without the assistance of your systems administrator or partner. A backup of data is mandatory for any SQL operation. 


5/30/2018

Dynamics GP 2016 Workflow Email Notification Error

Dynamics GP Workflow interface has been simplified ever since GP 2013 was launched. The functionality continued to improve on each version release. The ability to setup and configure workflows within native GP interface has reduced several steps in the process.

I got a call this morning from my client who's a happy customer using Dynamics GP workflows extensively in his organization for more than an year ever since I implemented GP for him. The problem is none of the workflow notifications are popping up in users inbox. Strange.

After taking control of his screen through a remote connection, I quickly went with the series of troubleshooting steps.

1. What is the mail server used by client? Office 365.

2. Did the workflow email sender account password change recently? Yes. they did change the password recently. So, I went to Workflow setup window through Microsoft Dynamics GP | Administration | Workflow Setup and have him update the password twice.


3. After saving the record, tried with a test email that didn't work. 

4. I read somewhere for office 365 to use FQDN so tried using domain.onmicrosoft.com. didn't work.

5. I wanted to be sure if SMTP is working fine for Office 365. So opened Powershell and followed below steps

   Type  

$msolcred = get-credential

 that will ask for Office 365 credentials


Send-MailMessage –From user@domain.com –To user@domain.com –Subject “Test Email” –Body “Test SMTP Relay Service” -SmtpServer smtp.office365.com -Credential $msolcred -UseSsl -Port 587

Replace user@domain.com with Office 365 domain email address. 

6. Ensuring the SMTP test delivered successfully a test email, configured with the same settings in Workflow setup. Did it work this time? Yes. 

Good Luck