web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Service and Contracts ...
Microsoft Dynamics GP (Archived)

Service and Contracts Billing - When is Transfer to SOP Complete

(1) ShareShare
ReportReport
Posted on by MikeBrennan

I have a customer using the Field Services Module to Create Invoices From Services and Contracts.  I am trying to identify where in the Tables I can see that GP has completed transferring to The invoice, so that I can then Pick up the Data From SOP10100 etc.  I don't want to get the data until I am sure all Header and line information has been transferred.

*This post is locked for comments

I have the same question (0)
  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    where is my reply? :)

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    If I have understand your question correctly, you are looking for event at which invoice completely created in SOP from service module. What exactly you want to do at this point? The event could be identify with dexterity .

    when sales invoice get created from service module, you can get its contract detail from SOP1200 table.

    select CONTNBR,CONTLNSEQNBR,CONTSTARTDTE,CONTITEMNBR,* from sop10200

  • MikeBrennan Profile Picture
    MikeBrennan on at

    I'm trying to Do a Calculation after the Invoice is Created in SOP.

    For Contract invoices I think I can run something like

    select * from svc00603 where SOPNUMBE in (select  sopnumbe from sop10100 where SOPNUMBE like 'rcnt%' and DOCDATE >= '01-01-2016') and POSTED = 1

    what I can't find is an equivalent for SVC invoices.

    I was thinking and Equivalent in SVC00215 but that does not seem to be returning what I want

    select * from svc00215 where SOPNUMBE in (select  sopnumbe from sop10100 where SOPNUMBE like 'SVC%' and DOCDATE >= '01-01-2016') and POSTED = 1

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,009 User Group Leader on at

    How you are doing it, I mean how you are running your calculation once invoice get created in SOP? are you using any SQL trigger on any table? Or doing it on dexterity?

    because maybe at the moment you do your calculations, sales invoice haven't completely create in SOP tables and that's why your query is not giving any result.

    btw history table is SVC00605.

    I don't know what field values you need for your calculation. check if you can get help from history table?

    select * from SVC00603 svc inner join SOP10100 sop on

    svc.SOPNUMBE=sop.SOPNUMBE

    and svc.SOPTYPE=sop.SOPTYPE

    where svc.POSTED=1

    and sop.DOCDATE>= '01-01-2016'

    You can apply update trigger on SVC00603 and if SOPNUMBE and SOP Type gets updated will call your calculations script.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans