Search companies

Searches the companies the caller's company does business with — its customers and vendors — plus the one record for its own company, flagged isMyCompany; set isMyCompany when a question hinges on which company is the user's own (e.g. products they vend or sell themselves). For a company's contacts, locations and licenses, use distru-get-company. outstandingBalance is what the company owes. pastDueBalance is the unpaid amount on invoices of delivered or completed sales orders due before today, less unapplied credit; never below 0 or above outstandingBalance. outstandingBalanceThreshold is the company's balance threshold, in dollars, compared with its outstanding balance or, if your company settings choose it, its past due balance: above it Distru shows warnings and sends alerts, and unless your company settings allow orders over it, this company's sales orders can't move past Pending; null uses your company's default threshold. creditBalance is its unapplied credit. qbCustomerId and qbVendorId are its QuickBooks customer and vendor IDs, null when not mapped. qbCustomer and qbVendor are null when mapped but Distru has no current copy of the QuickBooks record. isDeleted means QuickBooks no longer has the record, and active indicates whether the record is active in QuickBooks. An invoice sync re-maps a deleted or missing customer by name, or creates one, but fails on an inactive one. lastOrderDate is the order date of its most recent sales order that wasn't canceled or merged. For who owes money, set hasOutstandingBalance to true and sort by OUTSTANDING_BALANCE descending; for who is late paying, sort by PAST_DUE_BALANCE descending. For customers who haven't ordered since a date, set lastOrderDateBefore to that date. To find companies whose QuickBooks customer or vendor mapping no longer works (one cause of the sync errors in distru-search-quickbooks-activities), set hasBrokenQbCustomer or hasBrokenQbVendor.