Inserting Deposit Record into AR_Deposit from backup

To recreate a Deposit Batch record from your backup you can use the script below. Please note that a valid deposit batch is necessary for an AR_Deposit_Check record to show up as a payment on a front end customer account

SET IDENTITY_INSERT AR_Deposit_Batch on

GO

INSERT INTO [dbo].[AR_Deposit_Batch]

           (Deposit_Batch_Id

                  ,[Description]

           ,[Date]

           ,[Tape_Total]

           ,[Entered_Amount]

           ,[Memo]

           ,[Ready_To_Deposit]

           ,[Deposit_Id]

           ,[Check21_Batch]

           ,[Created_By]

           ,[Created_Timestamp])

Select *

from BAK_ARDEPOSTITBATCH

where Deposit_Batch_ID = ''

SET IDENTITY_INSERT AR_Deposit_Batch on

GO