Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
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

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables