Discussion:
SOP50200 table
(too old to reply)
Elaine
2009-05-04 12:49:03 UTC
Permalink
Does anyone know what the SOP50200 table is? Why are records sometimes there
and sometimes not?
Ross
2009-05-04 13:06:03 UTC
Permalink
SOP50200 is the temporary Sales Document Header table.
Post by Elaine
Does anyone know what the SOP50200 table is? Why are records sometimes there
and sometimes not?
Elaine
2009-05-04 13:48:01 UTC
Permalink
Hi Ross,

When are records added and deleted? We use Forms Printer to print invoices.
The report must use this table.

Thanks,
Elaine
Post by Ross
SOP50200 is the temporary Sales Document Header table.
Post by Elaine
Does anyone know what the SOP50200 table is? Why are records sometimes there
and sometimes not?
Ross
2009-05-04 14:30:10 UTC
Permalink
Not really sure how temp tables work - What version of SQL Server are you
using?

I would suggest opening the dbo.SOP50200 table under the sample company and
create/save/post a few invoices to see how the table gets populated with data.

Hope this helps!
Post by Elaine
Hi Ross,
When are records added and deleted? We use Forms Printer to print invoices.
The report must use this table.
Thanks,
Elaine
Post by Ross
SOP50200 is the temporary Sales Document Header table.
Post by Elaine
Does anyone know what the SOP50200 table is? Why are records sometimes there
and sometimes not?
Mariano Gomez
2009-05-04 15:54:01 UTC
Permalink
The SOP_Document_HDR_TEMP table (dbo.SOP50200) gets populated when you
request to print packing slips or picking tickets in GP. Since the SOP
printing engine is relatively complex, this table is also used when managing
different output formats for the various SOP reports generated.

Products like Form Printers would use this table to interface their reports
to GP, since actual SQL Server temp tables are not accessible externally from
other applications.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
Post by Elaine
Does anyone know what the SOP50200 table is? Why are records sometimes there
and sometimes not?
Richard Whaley -- MVP 2006-2008
2009-05-04 17:50:01 UTC
Permalink
Make that ANY SOP transaction document: Pick Ticket, Packing List, Order,
Invoice, Back Order, Return, et cetea

Records are written to the table, the print routines called (either GP or
Forms Printer), the documents printed, and then the records removed from the
table.
--
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at
http://www.AccoladePublications.com
Post by Mariano Gomez
The SOP_Document_HDR_TEMP table (dbo.SOP50200) gets populated when you
request to print packing slips or picking tickets in GP. Since the SOP
printing engine is relatively complex, this table is also used when managing
different output formats for the various SOP reports generated.
Products like Form Printers would use this table to interface their reports
to GP, since actual SQL Server temp tables are not accessible externally from
other applications.
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
Post by Elaine
Does anyone know what the SOP50200 table is? Why are records sometimes there
and sometimes not?
Continue reading on narkive:
Loading...