DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
eayala68 6/29/2016 3:08:54 PM

bach damage in gp 10

I have a batch of sales that have bills and when I try to open them said that the document was historical. to consult with sql query invoices are all in SOP10100 And SOP10200.
Apparently during the posting process the connection to the server is interrupted, that damage the loye and then changed to a new batch bills, but you can not count and I need to post the batch.

anyone has any idea that can help me?

 

 

Performing the SQL queries that attached discover that the invoices are in the GL10000 tables, GL10001 but are not on the table GL20000, transactions in the SOP10100 table has the PSTGSTUS = 14 field and field TRXSORCE = SLSTE00010061. 
I have two questions:
1. There is some additional table where you should look.
2. I can delete the damaged invoices batch of GL10000 tables, GL10001; update PSTGSTUS = 0 field and field TRXSORCE = ''  and make a new posting?

Version: GP 10
Section: Dynamics GP