The following steps will allow you to submit a request via the Sedona Office application or the SSMS- SQL Studio Manager, to get a list of accounts processed for a specific deposit.
- Find the Deposit_ID number for the respective deposit
- The script example below is the script used to generate the list. You only need to replace the (8607,8608,8609) number with the respective Deposit_ID that identifies the deposit
- You can get as many deposits as you need. You must separate each Depsoit_ID with a comma (,), for multiple deposits.
select cu.Customer_Number,cu.Customer_Name,c.Check_Number,c.Register_Id as Check_Register_ID,i.Invoice_Number,i.Amount as Invoice_Amount,i.Payment,i.Net_Due,i.Payment_Date,i.Type_JSCO,j.Job_Code,
de.Deposit_Id,de.Register_Id as Deposit_Register_ID,de.Description,d.Amount as Deposit_Amount
from AR_Deposit_Check_Detail d
inner join AR_Deposit_Check c on c.Deposit_Check_Id=d.Deposit_Check_Id
inner join AR_Deposit_Batch db on db.Deposit_Batch_Id =c.Deposit_Batch_Id
inner join AR_Deposit de on de.Deposit_Id=db.Deposit_Id
inner join AR_Invoice i on d.Invoice_Id=i.Invoice_Id
inner join AR_Customer cu on cu.Customer_Id =c.Customer_Id
inner join OE_Job j on j.Job_Id=i.Job_Id
where De.Deposit_Id in (8607,8608,8609)