ERD / Object Structure

technical results for consultants & developers breadwinner is designed to be enhanced by developers we provide quickbooks desktop, quickbooks online, and quickbooks enterprise data in native and custom salesforce objects you can further add formulas, apex roll ups, workflow, and triggers breadwinner for quickbooks erd breadwinner consists of nine objects, though for most customers, only five objects are used specifically, most customers use breadwinner for their accounts receivable, i e receiving money from their clients this will utilize five breadwinner objects invoice object (which is a perfect copy/slave record of the quickbooks invoice object), which also includes the credit memos from quickbooks line item, a master detail child object of the invoice, reflecting quickbooks invoice and credit memo lines payments, a child of the quickbooks online customer record, reflecting payments and pre payments made by customers payment transactions, a junction object between the payment object and the invoice object, reflecting how payments are allocated to the invoices the quickbooks online company object, which reflects all of the quickbooks customer and vendor records for customers on breadwinner business edition or higher, they may also use the accounts payable objects, which consist of bill/po object, which is the counterpart to the invoice object, except that it reflects either payment (bills) or a request for an invoice (po) bill/po line item object, which reflects line items on the bill or po this is visually displayed as two related lists/sections of the bill/po because quickbooks has two types of line items in accounts payable bill/po payments, a child of the quickbooks online customer record, reflecting payments and pre payments made to vendors bill/po payment transactions, a junction object between the payment object and the bill / po object, reflecting how payments are allocated to the bills none of the objects in salesforce should ever be changed, created, or deleted in salesforce instead, quickbooks customers and vendors can and should be created or edited through our guided invoice creation wizard and invoices, bills, and pos should be created through our guided invoice creation wizard additionally, breadwinner can create quickbooks inventory items based on opportunity products we will create a corresponding quickbooks inventory item in quickbooks based on the opportunity product code we create quickbooks inventory items on demand at the time of invoice creation quickbooks inventory creation happens in the background and is transparent to the end user if you need to bring quickbooks inventory items into salesforce as opportunity products, you can do so as a one time operation from the breadwinner tab once inventory is imported as opportunity products, we strongly recommend using opportunity products as your master data set, rather than quickbooks this is because opportunity products have a more sophisticated structure in salesforce, and also because we can create (if needed) quickbooks inventory items transparently at the time of invoice creation