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