VOC support #2586
closed
Re: Booking Rejection and Next Booking Deduction// Booking K25112711373H01
Added by Tracy Tran 3 months ago.
Updated 3 months ago.
Description
Dear Tom,
As per VNAC team, Please support to change the data as below:
Booking K25112711373H01
V Payment: change to Fully Paid
Vendor Balance: change to 0
Files
- Due date set to 12/09/2025
- Status changed from 신규(New) to 완료성공(Resolve)
- Start date set to 12/09/2025
- Status changed from 완료성공(Resolve) to 진행(Doing)
- Status changed from 진행(Doing) to QA test
- Assignee changed from Tom Dong to Tracy Tran
- % Done changed from 0 to 100
- SQL Update for VOC #2586
Request: Change V Payment to Fully Paid, Vendor Balance to 0
Current Status:
| Field |
Before |
| ------- |
-------- |
| V Payment |
VPS01 (Not Paid) |
| Vendor Balance |
0.00 |
SQL:
```sql
UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
LAST_UPDATE_UNO = 10000,
LAST_UPDATE_DATETIME = NOW
WHERE BOOKING_ITEM_CODE = 'K25112711373H01'
AND VENDOR_PAYMENT_STATUS_CODE = 'VPS01';
```
After:
| Field |
After |
| ------- |
------- |
| V Payment |
VPS03 (Fully Paid) |
| Vendor Balance |
0.00 (no change needed) |
Dear Tom,
Sorry, it was my mistake when give you the booking number.
Please support to tp revert the data for booking K25112711373H01 as original .
And change the data for this booking K25092311042H01 as below image.
V Payment: change to Fully Paid
Vendor Balance: change to 0
[2025-12-10 10:21:25] OMH_SUITE> UPDATE BK_BOOKING_HOTEL_ITEM
SET VENDOR_PAYMENT_STATUS_CODE = 'VPS03',
VENDOR_BALANCE_AMOUNT = 0,
LAST_UPDATE_DATETIME = NOW
WHERE BOOKING_ITEM_CODE = 'K25092311042H01'
AND VENDOR_PAYMENT_STATUS_CODE = 'VPS01'
- Status changed from 피드백(Feedback) to QA test
- Assignee changed from Tom Dong to Tracy Tran
I have revert & update, please check
- Status changed from QA test to 완료성공(Resolve)
- Assignee changed from Tracy Tran to Tom Dong
Also available in: Atom
PDF
