3.1 Payment Reversal being stopped by a 'Profit Stars profile not linked' Error
Problem
We are trying to reverse a payment for a bad check but are getting an error that says 'Profit Stars profile not linked or missing information.' We don't Profit Stars (or even know what it is!).
Is there a way around this?
Solution
Yes, this is a pesky little problem but it's solvable with a little help from your friend, DBEdit. You need to access the SAReceiptPayment table, find the receipt, and then use InLine Editing to clear out the SpecialLinkID field. Save your changes, and then try the Payment Reversal again. You'll need to call Support for an Access Code into DBEdit.
Here are some detailed steps:
- Go to DBEdit. In the standard VSI design, this is under Misc Management on the main Management menu.
- Call VSI Support. We'll give you an Access Code. Enter that and click Validate.
- In the Select Table to View field, start typing "SARec...." Use the type ahead feature and select "SAReceiptPayment."
- In the Query field, enter "ReceiptNumber='<x>'" where x is the receipt number. Be sure to include the single quotation marks around the receipt number. For Example: ReceiptNumber='1017'
- Click View. The receipt will show up in the Raw Table Editor DataGrid.
- Click the Stylus icon to enable InLine Editing on the DataGrid. Scroll right until you find the SpecialLinkID field.
- Delete whatever's in that field, so it reads '0' when you're done.
- Close InLine Editing and click Close on the Raw Table Editor.
- Exit back to the main menu, and go run the Payment Reversal again.