Explanation
This may be due to the way the click of the mouse interacts with Windows and our program
Resolution
- Check order to see where payments are duplicated
- Open DBBrowser
- Filter by OrderID=xxxx in the Adjustment Database
- Modify Filter to “OrderID=xxxx or (OrderId=0 and CustomerID=xxxx)”
- Copy this filter to be used in the following tables:
- Adjustment Database
- GL Database
- Order Database
- Payments Database
- In those tables, remove the duplicated payment entry
- Filter by CustomerId=xxxx in the Customer Database
- Remove or reduce Customer credit appropriately
NOTE: Some tables will have double entries, some won't.
Resolution 2
- Recreate basic order in your SMS
- Open DBBrowser to view your results to guide you through the steps above
You could leave a comment if you were logged in.