Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Service Call Managemen...
Microsoft Dynamics GP (Archived)

Service Call Management - Service Calls database help

(0) ShareShare
ReportReport
Posted on by lleemon 180

 A new user which doesn't know a lot about the GP application but can code in asp.net.   We would like to implement a process via the web (browser) that will add a new entry for the Service Call Management - Service Calls section.  This process will just fill in very few fields, mostly the required fields.  This is what I believe are the required fields:

Form name (db field name)
Call Number (CALLNBR)
Customer ID (CUSTNMBR)
Call Status (SRVSTAT)
Entry (ENTDTE/ENTTME)

 I believe the main table is SVC00200.  Are other fields populated?  

Does anyone know the names of associated tables?

How is the CALLNBR generated?  Can we call a stored procedure that will return the next number value to use?

Is there a document that gives the tables/fields/stored procedures for the Service Call Management - Service Calls form.

 

Thanks for any advice.

Using following:
Microsoft Dynamics GP Professional 10.00.1193
Dexterity 10.0.320.0
SmartList 10.00.1165

*This post is locked for comments

  • lleemon Profile Picture
    lleemon 180 on at
    Re: Re: Service Call Management - Service Calls database help

     Hi Matt,

     How do you go about setting up GP Web Services?  Anything that makes it easier we are for.

     

    Thanks.

  • mattlandis Profile Picture
    mattlandis 385 on at
    Re: Service Call Management - Service Calls database help

    You really ought to look at GP Web Services. This takes care of all business logic. There is no cost per user to consume web services and it will do a lot of under the hood business logic for you.

    matt

  • U079310 Profile Picture
    U079310 405 on at
    Re: Service Call Management - Service Calls database help

    Possibly I could help with your Service Call issues.  Please email me directly at rhhunt@charter.net

     Rick

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Service Call Management - Service Calls database help

    I think you're on right path. The stored procedure that executes to select the next call number when you click New in Service Call Entry Window is dbo.SVC_New_Call_Number.

    I'm not sure on SVC_Create_Service_Call.

    Good Luck 

     

     

  • lleemon Profile Picture
    lleemon 180 on at
    Re: Re: Service Call Management - Service Calls database help

     Janakiram - Thank you very much.  Very valuable info.

    Do you know the function when you click the 'New' button in Service Call Entry/Update is clicked?  

    It appears that I can pass the next ID as follows:

    [TRAIN].[dbo].[SVC_New_Call_Number] 12345

     This will add one to CALLNBR in SVC00999, question now is, in the 'New' button, is there a sp that queries SVC00999 and gets that id? Just wondering if it's safe in our process to 1) pull latest CALLNBR from SVC00999 and then pass to sp SVC_New_Call_Number and then user new CALLNBR and insert rows  in SVC00200, SVC00203 and SVC00201?

     I also found the following: SVC_Create_Service_Call

     

     Thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Service Call Management - Service Calls database help

    In Service Call Management, A Call Number is generated when you click to open a New Record. Call Number is an Alphanumeric value assigned to each service document. This is selected when the New button in Service Call Entry/Update is clicked and the next number is stored in SVC00999 table. You can find this record in Service Setup window.

    In addition to the fields you're looking to capture, You might also need to add TechID that get selected into the Service Call Entry window. TechID lies in SVC00100 table and this record will not default when you select the customer ID so is the case to update the TechID.

    The dependent tables for SVC00200 are mainly SVC00203 (Service Call Line Detail) SVC00201 (Service Call Analysis Codes) and SVC00100(Technician Master) . There are various other tables however these tables are important only if you are using any Service extensions like Contract Administration, Preventive Maintenance and so on.

    Hope this helps! 

     

     

     

     

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans