Explanation
This is when Cyrious fails to zero out the BalanceOutstanding in the Order Database
Steps
- NM into customer's machine
- Open SMS and run Payments report for particular time frame
- Make sure Payment shows up on Payments report
- Once verified, open order and check to make sure Totals, tab shows payment and incorrect balance amount
- Once verified, close SMS and open DBBrowser
- Select the GL Database in the View Tables tab
- Filter by OrderID = XXXXX
- Ensure 2 line items per payment are in the GL Table
**If not:**
- Remove the partial payment (only one line item for the payment) from the GL table
- Select the Payment table
- Filter by OrderID = XXXXX
- Remove the corresponding payment line item
- Select the Adjustment table
- Filter by OrderID = XXXXX
- Remove the corresponding payment line item
- Open Cyrious
- Reenter payment
- Close Cyrious
- Open the DBBrowser
- Edit the dates for the payments in the Adjustment, GL, and Payment tables as needed
- Select the Order Database in the View Tables tab
- Filter by OrderID = XXXXX
- Once order record is up, scroll right to the BalanceOutstanding field
- Zero out that field
- Ensure that the TotalPayments field equals the SalesTotal
- Click on the Check Mark button at bottom of screen.
- Reopen SMS and check order to make sure balance outstanding is corrected
You could leave a comment if you were logged in.