Our organization wanted to use iBO to put event registration orders entered on the web into our system. However, we hit one big stumbling block. Apparently, the iBO CRegistration class supports only fully paid registrations. Many of our customers opt to be invoiced rather than to pay on line. Therefore, we can't use iBO.
Has anyone encountered this problem? If so, how did you address it?
Thanks
What we do normally, When
What we do normally,
When some one doesn't want to pay online. You can accept purchase order number.
In order save registration you need to pass dummy card details to Payments object.
once it is done. you can run the following script to remove the payment entry from batch and transaction table.
you need to pass batch number, order number and PO to run this script
update Orders
set ORDER_DATE=GETDATE(), TOTAL_PAYMENTS = 0, BALANCE = TOTAL_CHARGES, LINE_TOTAL = TOTAL_CHARGES, OTHER_PAY = 0, PAY_NUMBER = '',
CREDIT_CARD_EXPIRES = '', AUTHORIZE = '', CREDIT_CARD_NAME = '', ENCRYPT_PAY_NUMBER = '', PAY_TYPE = '', CUSTOMER_REFERENCE = @PONumber
where ORDER_NUMBER = @OrderNumber
-- zero invoice payment
update Invoice
set INVOICE_DATE=GETDATE(), CREDITS = 0, BALANCE = CHARGES
where REFERENCE_NUM = @invoice_num and BT_ID = @id
-- update the trans payments to AR
update Trans
set TRANSACTION_TYPE = 'AR', PSEUDO_ACCOUNT = @org_code + '-MEETING-AR', PAYMENT_TYPE = '', CC_NUMBER = '', CC_EXPIRE = '',
CC_AUTHORIZE = '', CC_NAME = ''
where INVOICE_REFERENCE_NUM = @invoice_num and TRANSACTION_TYPE = 'PAY'
-- balance batch payments
update Batch
set TRANS_CASH = TRANS_CASH - @total_charges, CONTROL_CASH = CONTROL_CASH - @total_charges
where BATCH_NUM = @batch_num