Deposit NOT POSTED IN VMIS

Product	VMIS
Database Path	production/training/devtest
TDX - Incident	#77003
TDX - Service	[For enhancement / refinement team]

Overview

[describe the nature/purpose of the change]

Technical Notes

Data Query

Technical Review

N/A

Deployment Notes/Instructions

Change requires deployment of VMIS: No
Change Requires deployment of Schema Changes: No
Change Requires deployment of Data Changes: Yes
Change Requires deployment of websites (if yes, please specify): No
Is timing or order of the deployments critical (if yes, please specify)? No

Deployment Data Changes:

-- 2024-12-05 11:45
-- TDX Incident #77003

--#region Declare Variables
declare @receipt_id int
declare @client_id int
declare @invoice_id int
declare @user_id int
declare @total_payments decimal(9,2)
declare @amount_tendered decimal(9,2)
declare @change_returned decimal(9,2)
declare @drawer_id varchar(50)
declare @paid_method varchar(50)
declare @paid_type varchar(50)
declare @ref_no varchar(150)
declare @notes varchar(150)
--#endregion Declare Variables

--#region Variables Needed 
SET @client_id = 
SET @invoice_id = 
SET @user_id = 
SET @total_payments = 
SET @amount_tendered = 
SET @change_returned = 0.00
SET @drawer_id = -- 'Small Animal', 'Large Animal', 'General'
SET @paid_method = 'Credit Card'
SET @paid_type = 'Deposit'
SET @ref_no = '' -- Transaction
SET @notes = ''

--#endregion Set Variables

--#region Deposit Script
-- 1.a. Insert the receipt
exec sp_receipt_insert @receipt_id out, @client_id, @invoice_id, @user_id, @total_payments, @amount_tendered, @change_returned, @drawer_id;

-- select @receipt_id; -- you need this number for step 3.  WRITE IT DOWN!!!

-- 1.b. Insert the receipt detail for the payment.
exec sp_receipt_additem @client_id, @receipt_id, @invoice_id, @user_id, @amount_tendered, @paid_method, @paid_type, @ref_no, @notes;

-- 2. Update the invoice to reflect the new payment.

update invoice set total_payments = total_payments + @total_payments, amount_due = amount_due - @total_payments where id = @invoice_id;

--NO UPDATES TO CLIENT or CLIENT_TRANS because invoice is not closed yet.
--#endregion Deposit Script

Background History:

Usually:

“There was a deposit taken yesterday , however, this payment ran in PayConex (see confirmation below) but did not post to the open invoice “

VMBS Manual