blakeh Posted January 31, 2017 Share Posted January 31, 2017 I'll spare everyone the #rant about mass pay, functionality, and the like. Mass pay doesn't work with Xero Sync. I know this now. Is there some type of query I can run against the database to get a list of the mass pay invoices? Some characteristic that they don't have with normal invoices to get a list? Thanks. 0 Quote Link to comment Share on other sites More sharing options...
blakeh Posted April 2, 2017 Author Share Posted April 2, 2017 So, that's obviously a 'no'. How about a suggestion in an future update. Mass Pay invoice numbers get some prefix, suffix, something to denote that the are a special invoice and not for product or service. Or maybe something that marks regular invoices to show they are paid via mass pay. Or maybe WHMCS would just do accounting like other software and understand the concept of a journal entry, or a general ledger that we could easily export to real accounting software instead of dealing with this. bh 0 Quote Link to comment Share on other sites More sharing options...
blakeh Posted April 2, 2017 Author Share Posted April 2, 2017 (edited) Update: there is a way, if you query the invoice items table, and look for 'AddFunds' in the type field, or 'Add Funds' in the description field. This gets you any invoice that was generated that's not related to service. To find mass pay invoices, you search the type field for 'Invoice' or you can also search the description field for the word 'Invoice #' since that only shows up on mass pay invoices. bh Edited April 2, 2017 by blakeh 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.