I found the below article from Microsoft :
Run the following script against the company database:
Select PSTGSTUS, BCHSOURC, VOIDSTTS,TRXSORCE, DEX_ROW_ID from SOP10100 where SOPNUMBE = 'Enter your SOP Document number with issue'
Note the Dex_Row_ID value.
Check values in the following columns for the SOP Document. If any of these values are incorrect, the document may appear as posted.
PSTGSTUS (For an unposted document, it should read "0.")
BCHSOURC (For an unposted document, it should read "Sales Entry.")
VOIDSTTS (For an unposted document, it should read "0.")
TRXSORCE (For an unposted document, it should be blank.)
Run the following scripts against the company database to correct any of the four values from step 6:
Update SOP10100 set PSTGSTUS = '0' where DEX_ROW_ID = 'XXXX'
Update SOP10100 set BCHSOURC = 'Sales Entry' where DEX_ROW_ID = 'XXXX'
Update SOP10100 set VOIDSTTS = '0' where DEX_ROW_ID = 'XXXX'
Update SOP10100 set TRXSORCE = ' ' where DEX_ROW_ID = 'XXXX'
When I ran the 1st script, I got:
PSTGSTUS = 12
BCHSOURC = "Sales Entry"
VOIDSTTS = 0
TRXSORCE = blank
So I ran the 2nd script as stated and have the invoice back in the SOP module as unposted.
My concern is that when I checked the inventory, the invoice was posted sometime in the past and it hit inventory already. RM and GL were not hit.
What should I do next with this unposted invoice?
Thank you,
