Void Historical Transactions

(0) Share

Report

Posted on by PBoor

We just installed GP 2015 and are trying to void a wire.

When we go Purchasing>Void Historical Transactions and enter a Vendor ID the application spins. When I go to SQL Server, the task is sleeping with no CPU or I/O. The Accounting group reports that it does not do the same for Vendors with Checks. We are using GP 2015. The Accounting area did say this was slow in the 2010 version. Any reason why the SQL SPID would stay sleeping without CPU or I/O? The Client continues to wait.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

I would perform a backup and while no one is in GP run check links on the purchasing series. I suspect corrupt data.

Was this reply helpful? Yes No
PBoor 70 on at

Like (0)

Report

Well it looks like another SPID session was running and getting info back. As we continue to investigate, is there any reason why the data to return on this screen would take minutes to an hour? is there maintenance or an index tweak that would help? We are attempting to void a wire and are in a wait on the Void Historical Payables Transaction screen.

Was this reply helpful? Yes No
PBoor 70 on at

Like (0)

Report

Richard are you familiar with the screen? It appears to be locked and awaiting a long running query. I am waiting for the screen to unlock so I can change the calendar dates and void the payment. Is this always a case of corrupt data or are there other tweaks?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

With everyone out of GP run this script in GP:

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_SESSION

SELECT * FROM TEMPDB..DEX_LOCK

If any records are returned run these

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_SESSION

DELETE TEMPDB..DEX_LOCK

Then perform a backup and run check links in GP against the purchasing series. It sounds like some corruption has followed you since GP 2010. Let me know if this helps and if it does not let me know the size of your company database.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

By the way, it also wouldn't hurt to stop and start SQL. When was the last time the server was restarted?

Was this reply helpful? Yes No
PBoor 70 on at

Like (0)

Report

I was able to get back to this. There are not alot of options when querying from the Void Historical screen. When you enter the VendorID it spins and spins.

When looking at the SQL Trace

exec TLI.dbo.zDP_CM20200N_3 25,'WIRES-TCFL ','CASH ',4,265055,'WIRES-TCFL','CASH',3,'WIRES-TCFL','CASH',4

Continues to get called again and again and again. I ran the check links against the Payables which did not resolve this issue. Are there any obvious indexes missed? is there a trick to query or filter to reduce the run time? the size of the DB is 145 Gig

Was this reply helpful? Yes No

Join the conversation

Community site session details

Void Historical Transactions

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Void Historical Transactions

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates