Method Community

How do I see what date and time the other users have logged into method if I have administrator permission settings? Matt

I have changed the default mobile work order screen to allow price levels (either per item or fixed percentage). The per item cost replaces the rate and is multiplied with the quantity to give the amount. When saving, the item is inserted into the grid but the amount shown is the original item price multiplied by the quantity.

How do I create a sort order for the customers table, that will not conflict with the sort order the the work order. I want the clients to have a sort number instead, does this make sense? How do I do it?

Yes from the invoice screen works fine, but I genereate my invoices from the work order list screen, I select the services that I want to invoice and then I ckick on more actions and invoice selected. And the invoices are genereted but it does not calculate the tax amounts. Please help. Marcelo I also genereted invoices from the stock ...

Hi gbisaga, No you cannot, since you may have deleted records. What you can do however is a simple call where for your fields parameter all you pass in is max(RecordID) and that will give you your max recordid, then you can build your query to get all records. Or you can use count(RecordID) to get the count. Simple C# examples ...

Thank you, Dave - you have definitely been there answering my questions, and I do appreciate it. Can I depend on RecordID to be a count of rows in the table? If I can, I could deal with fetching where "RecordID >= MyLastRecordID and RecordID < MyLastRecordID+1000" - that would be much better than the time-based query I'm doing ...

Absolutely, Dave. Thank you again for your help. 

Hi ImTheirWebGuy, gbisaga, and LaCrews, For any .asmx page you can click the name of the available operations and that will take you into operation specification. This includes a description of the soap envelope, which is what you were asking for ImTheirWebGuy. This is standard. So you can go to ...

Thank you thank you thank you gbisaga! This is EXACTLY what I was looking for! https://www.methodintegration.com/MethodAPI/service.asmx?op=MethodAPISelect_XMLV2

Hey, I'm totally down with a hangout IRL, and I'll keep the beers flowing the enire time (as long as we can talk shop). :D