Dynamics Community Forum Thread Details

Voided Sales Transactions in both SOP10100/SOP10200 and SOP30200/SOP30300

Hello! Yesterday, I was voiding invoices with zero line item quantities and of course zero DOCAMNT. We have a navigation pane for invoices that are "void candidates" and that's where I was voiding the invoices. After voiding the last invoice, I had to leave my workstation for something. When I came back I clicked the "Exit" to close GP but it did not close. We connect to GP using RDP so I connected to the SQL server where GP is and terminated my RDP session hoping that when I go back to my workstation and re-login to GP I am able to delete my GP login but no, I wasn't able to log back in to GP. So I asked my co-admin to clear any entry with my name from sy00800/sy00801. After that, I was able to log back in to GP with no problem.

My problem this morning is that when I try to void an invoice, I get the pop-up that says "Your previous transaction-level posting session has not finished processing. Please allow time for it to finish. If you believe it has failed, log out of Microsoft Dynamics GP and log back in to recover transactions.". Well, I logged off and back in and opened the Batch Recovery screen. You know, the batch for voiding of invoices (which has the user's name as the batch number) does not show up on the batch recovery! So I created a sql query to display invoice records with my name as the BACHNUMB and VOIDSTTS<>0 and with yesterday's GLPOSTDT. I queried both the SOP10100/SOP10200 and SOP30200/SOP30300. Identical records show up on both (except for except for millisecond deference in DEX_ROW_TS! These invoices are ZERO amount and ZERO line item quantities!

In SY00500, there is an record there with my name, with BCHSOURC of "Sales Void", and GLPOSTDT of "1900-01-01 00:00:00.000".

Is it safe to delete these invoices from the SOP10100/SOP10200 and delete th SY00500 record using SQL? Note that the "Sales Batch Entry" screen does not show a batch with my name and when I try to create a batch with my name, GP does not accept it because my name is in lowercase!

Thanks in advance.

Carlos

Quick Links

Leaderboard