![]() Select SOPTYPE,SOPNUMBE,ORIGTYPE,DOCDATE,GLPOSTDT, RETUDATE, INVODATE, QUOTEDAT from sop10100 where sopnumbe=’STDINV2265′ SOPTYPE To view the data of the transferred invoice ‘STDINV2265’ in SOP10100, you can do so by running this script: ![]() Select SOPTYPE,SOPNUMBE,ORIGTYPE,DOCDATE,GLPOSTDT, RETUDATE, INVODATE, QUOTEDAT from sop30200 where sopnumbe=’ORDST2240′ SOPTYPE You can confirm this by completing this SQL query: The following query will not generate any results as the order was moved from SOP10100 to SOP30200. To confirm the transfer was successful, we will check in SQL with the query: In this instance I’ll show what happens when you transfer an order to an invoice.Īfter pressing the ‘transfer’ button on the previous window, the order will now become an invoice. SOP10100Īs it goes, sometimes orders may need to be adjusted. I’ve included in the SOP10200 table a few more details on the item involved in the transaction. It should be noted that the fields populating the data are adjustable. ![]() Select SOPTYPE,SOPNUMBE,LNITMSEQ,ITEMNMBR, UNITCOST, UNITPRCE, DROPSHIP from SOP10200 where SOPNUMBE=’ORDST2240′īelow is how the data appears in SQL. The transaction can also be found in the SOP10200 (unposted/work transaction with line details) table by running this script: Select SOPTYPE,SOPNUMBE,ORIGTYPE,DOCDATE,GLPOSTDT from sop10100 where sopnumbe=’ORDST2240′ Once the transaction is saved it can be found in the SOP10100 (unposted/work transaction with headers) table in SQl by running this script: There are other functions available in the SOP module, but these are ones we will focus on in this article. ![]() You can transfer sales documents from one type to another. You can use Sales Order Processing to enter and print quotes, orders, invoices, back orders and returns. Knowing which type the SOP is can be useful when looking up records. First off, we will give a little back information of SOP and what it can be used for.īefore we get too in depth in the Sales Order Processing process, I will list which the SOPTYPES in SQL and their value. We look at how it happens, where does the information go once it’s been processed, and how dates are affected by the various actions in the Sales Order Process. In this blog we go over information pertaining to Sales Order Processing in Dynamics GP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |