https://www.high5software.com//mediawiki/index.php?action=history&feed=atom&title=Payment_Syncing 2026-05-04T22:25:45Z Revision history for this page on the wiki MediaWiki 1.35.11 https://www.high5software.com//mediawiki/index.php?title=Payment_Syncing&diff=5064&oldid=prev 2014-05-16T23:06:32Z

<p>Created page with &quot;When a payment is added/modified in QB. &lt;br&gt;&#039;&#039;&#039;ON THE IMPORT FROM QB TO SME&#039;&#039;&#039; &lt;br&gt;1) Links the payment to the matching customer based on payment.custid &lt;br&gt;2) Attempts...&quot;</p> <p><b>New page</b></p><div>When a payment is added/modified in QB.<br /> &lt;br&gt;&#039;&#039;&#039;ON THE IMPORT FROM QB TO SME&#039;&#039;&#039;<br /> &lt;br&gt;1) Links the payment to the matching customer based on payment.custid<br /> &lt;br&gt;2) Attempts to find a match first on the qb.paymentid.<br /> &lt;br&gt;3) If not found, then attempts to match based on the list of invoices/amount applied in SME data.<br /> &lt;br&gt;4) If not found (it creates a new one) then<br /> &lt;br&gt;It pulls in the list of invoices the payment was applied to in qb, matches them up to sme invoices based on invoice.invoiceid, creates payment details used to clear the invoiced.<br /> &lt;br&gt;5) If it IS found, then it attempts to non-destructively maintain the paydetails between the invoice and the payments<br /> &lt;br&gt;<br /> &lt;br&gt;&#039;&#039;&#039;ON THE EXPORT FROM SME TO QB&#039;&#039;&#039;<br /> &lt;br&gt;1) Deletes the original qb payment. No, I CANNOT NOT delete the payment<br /> &lt;br&gt;2) Adds the payment, then applies the payments to the invoices the payments have been applied to in SME.<br /> &lt;br&gt;3) It looks FIRST to the billing company THEN to the customer for the customer id to use on export<br /> &lt;br&gt;<br /> &lt;br&gt;&#039;&#039;&#039;Note #1&#039;&#039;&#039; : when invoices are reexported from SME to QB, the invoice is deleted. This means that in QB, the payment is not applied to the newly recreated invoice.<br /> &lt;br&gt;&#039;&#039;&#039;Note #2&#039;&#039;&#039; : when payments are reexported from SME to QB the payment is deleted, meaning that only the invoices the payment was applied to in SME are applied in QB.<br /> &lt;br&gt;&#039;&#039;&#039;Note #3&#039;&#039;&#039; : it also only exports payments that are flagged to export<br /> &lt;br&gt;It will not export payments that are applied to invoices that are closed in QuickBooks.<br /> &lt;br&gt;It will not export payments for inactive customers.<br /> &lt;br&gt;These are noted in the SQLink logs</div>

Amy