News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Link between Field Ser...

Microsoft Dynamics GP (Archived)

Link between Field Service calls and SOP?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Is there a database link between Field Service Calls (which are transferred to SOP Invoices) and the SOP Invoices they become?

I've been trying to find a table that says "Open Service Call 123 became SOP Invoice 456"... but can't seem to find one. I've checked SVC00999, SVC30200... and other tables that I figured would show the link, but no dice.

Perhaps I'm missing something... I understand that you can consolidate Service Calls into a single Invoice, and perhaps that extra complexity makes the link difficult to spot.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Link between Field Service calls and SOP?

Try the table SVC00220 and svc30220
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Link between Field Service calls and SOP?

I think I have found it. When GP creates a new Invoice (to which to transfer the Service Call) it populates the associated SOP10200 (Sales Line) columns CONTNBR, CONTLNSEQNBR, CONTSTARTDTE, CONTENDDTE, CONTITEMNBR, CONTSERIALNBR.

It's not a perfect association, because the LineSequenceNumbers don't differentiate between Parts, Labour, Misc or Expenses (and so you have to take an educated guess which table they came from) but it's better than nothing.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans