Accounts Receivable and Accounts Payable Days Outstanding KPI increasing daily

Question Status

Kyle Reierson asked a question on 7 Dec 2012 1:06 PM

We have KPI's setup to display on our home page of Dynamics GP 2010. Right now we are on 11.00.1860 (SP2). Every day I sign into GP and view the Accounts Receivable Days outstanding and Accounts Payable Days Outstanding KPI's they are increasing everyday at an alarming rate. They have been working fine for the last year since they have been deployed but as of the last two months or so they have been ever increasing. Below are a couple screen shots of what I am talking about.


My question is what is happening that could cause something like this to happen? I am not an accountant, after talking with our accountants we are stumped as to why this would keep increasing daily. Any help would be greatly appreciated.


Kyle Reierson responded on 7 Dec 2012 2:01 PM

Ok so 15 minutes after posting this I refreshed my home screen and the KPI was not correct but much closer with the Receivables outstanding KPI showing 100 days to pay.

After doing a little digging I found a SQL Server Agent job called Remove Posted PJOURNALs From All Companies that runs every 30 minutes. The quick and dirty is this job calls a stored procedure which calls another stored procedure which finally executes this statement:

"delete PJOURNAL where REPORT = 1"

I have never been in this PJOURNAL table before but I saw it was still populated with 600 or so rows, all with that REPORT column set to 1. After looking over the stored procedure it looked to me that the next time the job runs all these rows should be removed.

I forced the SQL Server Agent job to execute and all the rows were removed, and it seems the KPI's are displaying correct numbers. Curious as to why these rows weren't getting removed every half hour when the job runs. I guess I will have to take a look at that PJOURNAL table next time the days outstanding starts to increase again.

Anyway, hopefully this will help someone else experiencing this issue or lead to a solution as to why they aren't getting cleared out.


Kyle Reierson responded on 10 Dec 2012 6:40 AM

Just took a look at the KPI's this morning and the Accounts Receivable Days Outstanding is now at 97.1 days. Last period shows 67.1. The PJOURNAL table I posted about last week is empty. The Accounts Payable Days Outstanding KPI is at 53 days with the last period at 25 days. I'm positive these current period numbers are wrong but now I am at a loss as to why they are so far off and seem to be increasing quite a bit each day. i will post back tomorrow to show the daily increase.

Now that I think of it this all started happening right around the time I received some recalc scripts from Microsoft. It was talked about in this thread

Could be purely coincidence but maybe not, figured I would mention that just in case it has anything to do with the issue.