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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Service Call Invoice m...
Microsoft Dynamics SL (Archived)

Service Call Invoice missing Service Calls for selection

(0) ShareShare
ReportReport
Posted on by Community Member

Once a service call has been entered into Invoice Entry our users then pull it up with the Service Call Invoice report in Service Maintenance. They hit 'Print Preview' then 'View Selections' which generates a look-up of service calls that can be batched and invoiced.

The problem we have is a large number of service calls that were entered in Invoice Entry and are not available for selection in Service Call Invoice to be batched.

I have looked in the smServCall table and the SC_ID06 field has a number entered, but if I look in smInvBatch for that batch number, a batch created by a different user is all I see.

I also pulled up smInvDetail and ran the SC_ID06 value against the ID_ID06 field in this table and got no results.

So far, all I can tell is that none of these service calls generated invoices and were somehow assigned to the same batch number as a different user.

Any help would be greatly appreciated.

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at

    Hi Jason,

    There are a couple things I can think of that may prevent these service calls from showing when you print the invoices.  Please see the following:

    -- Just to confirm, the invoices you are wanting to print - is the balance greater than 0.00?

    -- The print preview should be using a select statement similar to the following:

    SELECT * FROM smServCall WHERE InvoiceFlag = 0 AND InvoiceStatus IN (''O'',''P'') AND InvoiceHandling = ''A''

    Knowing this, if you review the smservcall records where servicecallid = the service call ids you're attempting to print the invoices for, do the invoiceflag, invoicestatus and invoicehandling flags meet the above criteria? If not, how are they different?

  • Community Member Profile Picture
    Community Member on at

    Since I posted my initial request, I had found that the field 'RI_ID' in the smServCall table, there were values that I saw of 0, 3, and 10. Once I changed this value to 0 I was able to select the invoices for printing with no problem.

    I will say that I'm having the same problem again, but the value in this RI_ID field is 11.

    Can you please tell me what this field is and what the different values mean?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans