Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jabman
Starting Member
3 Posts |
 Posted - 2010-11-11 : 14:34:00
|
| I'm trying to correct an error that was somehow made during a payment posting session and it seems the only way to correct that is by making the correction through a SQL command. I'll try to explain the best I can in detail as to what specifically I'm trying to accomplish but please understand I do not know allot about SQL.During a payment posting session there was a payment posted and normally each payment has it's own batch id number, in this one case a payment posted but for two different customers using the same batch id number. I have tried to back the payment out using the program's "backout payment" option but I get an error message that says "Invalid Debt Id" for this customer. The two customers have different debt id numbers so I'm not sure how this could have happened, but I believe I can correct this if I know the correct SQL command. The field name is PMTB-ID and the table is PMT. Again, I'm not familiar enough with SQL to know what the exact command is, is there someone that can give me some assistance to help me correct an error that was somehow made during a payment posting session. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Posting error