Re-adding an old Tender Type

It's because all of the links are by ID. ID is an autogenerated internal number that does not appear in any of the RMS interface screens. The old MC Tender had a different ID than the new one, since these are never reused.

It would be possible to reassign the new tender ID to the existing transactions using a SQL statement.

Glenn Adams Tiber Creek C> Thanks to an Accountant who setup my GL accounts incorrect, I need to

there are a few steps to take first: "Select ID,Description from Tender" will give you the list of all your current tenders - and give you the new ID that you will need.

If you know one of the transactions you need to change, you can do a "select TenderID from TenderEntry where TransactionNumber=x" to find the offending tenderid, then a "update tenderentry set tenderid=NEWID where tenderID=OFFENDINGTENDERID"

HOWEVER - Make sure you back up your database first!! And, if at all possible, try it on a different system other than production first. Also, I would do the same with the accounting system before your first transfer.

Thanks for the information, but there are quite a few transaction numbers and I do not know all of them.

When I ran the first query, id 10 was miss> there are a few steps to take first:

Ok, my mistake. The query changed 14 transactions. But, when I export the files, the mastercard transactions still do not show up. I did run the reindex in administrator.

What else can I do?

"Bill Fry" wrote: