This is when Cyrious fails to zero out the BalanceOutstanding in the Order Database

  1. NM into customer's machine
  2. Open SMS and run Payments report for particular time frame
  3. Make sure Payment shows up on Payments report
  4. Once verified, open order and check to make sure Totals, tab shows payment and incorrect balance amount
  5. Once verified, close SMS and open DBBrowser
  6. Select the GL Database in the View Tables tab
  7. Filter by OrderID = XXXXX
  8. Ensure 2 line items per payment are in the GL Table

**If not:**

  1. Remove the partial payment (only one line item for the payment) from the GL table
  2. Select the Payment table
  3. Filter by OrderID = XXXXX
  4. Remove the corresponding payment line item
  5. Select the Adjustment table
  6. Filter by OrderID = XXXXX
  7. Remove the corresponding payment line item
  8. Open Cyrious
  9. Reenter payment
  10. Close Cyrious
  11. Open the DBBrowser
  12. Edit the dates for the payments in the Adjustment, GL, and Payment tables as needed
  13. Select the Order Database in the View Tables tab
  14. Filter by OrderID = XXXXX
  15. Once order record is up, scroll right to the BalanceOutstanding field
  16. Zero out that field
  17. Ensure that the TotalPayments field equals the SalesTotal
  18. Click on the Check Mark button at bottom of screen.
  19. Reopen SMS and check order to make sure balance outstanding is corrected
You could leave a comment if you were logged in.