The Reconcile vendor credits report (Operations > Reports > Accounting > Reconcile vendor credits) will provide the date and value of a return to vendor (RTV) transaction in SOS Inventory in comparison to the corresponding vendor credit in QuickBooks.
This report can highlight situations in which SOS Inventory created a vendor credit in QuickBooks and a user changed or deleted a vendor credit in QuickBooks. Such actions create a mismatch between the valuation in SOS Inventory and the asset account in QuickBooks.
To run the report:
Blue highlights. Blue highlights indicate that SOS Inventory did not post a transaction to QuickBooks for the corresponding transaction.
Go to the Returns to vendors list (Operations > Purchases > Returns to vendors) and edit the return to vendor transaction to save and sync.
You may also click on Add to queue in the Re-sync column in the Reconcile vendor credits report. This will add the RTV transaction to the Sync queue and attempt to clear the error.
Green highlights. Green highlights indicate that the line item on the transaction cannot be found on the vendor credit posted to QuickBooks. This can occur if the line item was removed from the vendor credit in QuickBooks, or if the item name has changed.
If the name has changed, this can be ignored.
If not due to a name change, go to the Returns to Vendors list and edit the RTV to save and sync.
You may also click on Add to queue in the Re-sync column in the Reconcile vendor credits report. This will add the RTV transaction to the Sync queue and attempt to clear the error.
Red highlights. Red highlights indicate that the value of the line item on the RTV transaction was changed in QuickBooks after SOS Inventory posted the RTV to QuickBooks. When a red highlight is observed, it is important to note the Item and Acct Value information.
On returns to vendors (RTVs), the item that is removed from inventory will affect the asset account and the accounts payable account, according to the valuation method you have chosen in SOS Inventory. This value may or may not be the same as the amount of credit the vendor provides. If this is the case, it is recommended that you add a second line to the vendor credit to account for the difference in the valuation-method-derived value of the RTV and the amount of actual credit given by the vendor. SOS Inventory has a procedure for you to use to correct the value difference within QuickBooks Online. For more information, see Vendor credit memo value difference correction.
If the vendor credit in QuickBooks was edited in error, you may click on Add to queue in the Re-sync column in the Reconcile vendor credits report. This will add the RTV transaction to the Sync queue and attempt to clear the error.