Month End Closing Sep 2024

Report Validation, Recon and Journal

[BPNG] Flight Sales Revamp Report CONSIGNMENT | BA : @U060FPE2W1G FA : @UJP9T4FT4

(FSR)(C) 1st Submission 1-10
(FSR)(C) 2nd Submission 11-20
(FSR)(C) 3rd Submission 21 - 25
(FSR)(C) Closing Period 25 - End
(FSR)(C) Recon Sales Report Vs Assign Payment Report

[ERP] Flight Sales Revamp Report PREBUY | BA : @U060FPE2W1G FA : @UJP9T4FT4

(FSR)(P) 1st Submission 1-10
(FSR)(P) 2nd Submission 11-20
(FSR)(P) 3rd Submission 21 - 25
(FSR)(P) Closing Period 25 - End
(FSR)(P) Recon Sales Report Vs Assign Payment Report

[BPNG] Flight Ancillaries Report CONSIGNMENT | BA : @U060FPE2W1G FA : @UJP9T4FT4

(FAR)(C) 1st Submission 1-10
(FAR)(C) 2nd Submission 11-20
(FAR)(C) 3rd Submission 21 - 25
(FAR)(C) Closing Period 21 - End

[BPNG] Flight Refund Report CONSIGNMENT | BA : @U02LJAFSZA5 FA : @U057HS8MH60

(FRR)(C) 1st Submission 1-10
(FRR)(C) 2nd Submission 11-20
(FRR)(C) 3rd Submission 21 - 25
(FRR)(C) Closing Period 21 - End
(FRR)(C) Recon Refund Report Vs Payment To Customer Report

[ERP] Flight Refund Report PREBUY | BA : @U02LJAFSZA5 FA : @U057HS8MH60

(FRR)(P) 1st Submission 1-10
(FRR)(P)2nd Submission 11-20
(FRR)(P)3rd Submission 21 - 25
(FRR)(P)Closing Period 21 - End
(FRR)(P)Recon Refund Report Vs Payment To Customer Report

[BPNG] Ancillaries Refund Report CONSIGNMENT | BA: @U02LJAFSZA5 FA : @U057HS8MH60

(FARR)(C) 1st Submission 1-10
(FARR)(C) 2nd Submission 11-20
(FARR)(C) 3rd Submission 21 - 25
(FARR)(C) Closing Period 21 - End

[ERP] Bailout Report | BA: @U02LJAFSZA5 FA: @U057HS8MH60

(FBR) 1st Submission 1-10
(FBR) 2nd Submission 11-20
(FBR) 3rd Submission 21 - 25
(FBR) Closing Period 21 - End

[ERP] Basic Reschedule To Customer Report | BA: @UDK199SM9 FA: @U057HS8MH60

(BRTC) 1st Submission 1-10
(BRTC) 2nd Submission 11-20
(BRTC) 3rd Submission 21 - 25
(BRTC) Closing Period 21 - End
(BRTC) Recon Reschedule Vs Assign Payment Report

[ERP] Basic Reschedule From Provider Report | BA: @UDK199SM9 FA: @U057HS8MH60

(BRFP) 1st Submission 1-10
(BRFP) 2nd Submission 11-20
(BRFP) 3rd Submission 21 - 25
(BRFP) Closing Period 21 - End

[ERP] Premium Reschedule Report CONSIGNMENT | BA : @UDK199SM9 FA: @U057HS8MH60

(RRTC)(C) 1st Submission 1-10
(RRTC)(C) 2nd Submission 11-20
(RRTC)(C) 3rd Submission 21 - 25
(RRTC)(C) Closing Period 21 - End
(RRTC)(C) Recon Reschedule Vs Assign Payment Report
(RRTC)(C) Recon Reschedule Vs Payment To Customer Report

[ERP] Reschedule Refund To Customer Report PREBUY | BA : @UDK199SM9 FA: @U057HS8MH60

(RRTC)(P) 1st Submission 1-10
(RRTC)(P) 2nd Submission 11-20
(RRTC)(P) 3rd Submission 21 - 25
(RRTC)(P) Closing Period 21 - End
(RRTC)(P) Recon Reschedule Vs Assign Payment Report
(RRTC)(P) Recon Reschedule Vs Payment To Customer Report

[ERP] Reschedule Refund From Provider Report PREBUY | BA : @UDK199SM9 FA: @U057HS8MH60

(RRFP)(P) 1st Submission 1-10
(RRFP)(P) 2nd Submission 11-20
(RRFP)(P) 3rd Submission 21 - 25
(RRFP)(P) Closing Period 21 - End

[Aggr] Price Freeze Sales Report | BA: @U060FPE2W1G FA: @UJP9T4FT4

(PF Sales) 1st Submission 1-10
(PF Sales) 2nd Submission 11-20
(PF Sales) 3rd Submission 21 - 25
(PF Sales) Closing Period 21 - End

[Aggr] Price Freeze Refund Report | BA: @U060FPE2W1G FA: @UJP9T4FT4

(PF Rfnd) 1st Submission 1-10
(PF Rfnd) 2nd Submission 11-20
(PF Rfnd) 3rd Submission 21 - 25
(PF Rfnd) Closing Period 21 - End

[Aggr] Price Freeze NRD Report | BA: @U060FPE2W1G FA: @UJP9T4FT4

(PF NRD) 1st Submission 1-10
(PF NRD) 2nd Submission 11-20
(PF NRD) 3rd Submission 21 - 25
(PF NRD) Closing Period 21 - End

[Aggr] Flight Advance Payment In Report | BA: @U060FPE2W1G FA: @UJP9T4FT4

(Adv Pay In) 1st Submission 1-10
(Adv Pay In) 2nd Submission 11-20
(Adv Pay In) 3rd Submission 21 - 25
(Adv Pay In) Closing Period 21 - End

[Aggr] Flight Advance Payment Out Report | BA: @U060FPE2W1G FA: @UJP9T4FT4

(Adv Pay Out) 1st Submission 1-10
(Adv Pay Out) 2nd Submission 11-20
(Adv Pay Out) 3rd Submission 21 - 25
(Adv Pay Out) Closing Period 21 - End

[Inges] Profit Sharing Report | BA: @U060FPE2W1G FA: @UJP9T4FT4
[Inges] Charges Back Report | BA: @U060FPE2W1G FA: @UJP9T4FT4

Report NON Journal

Flight E-ticket number report | BA: @U060FPE2W1G FA: @UJP9T4FT4
Flight Sales Listing | FA: @UJP9T4FT4 BA: @U02LJAFSZA5

Running Sales Listing
Recon Sales Listing (Need to create this)

Flight Negative Revenue (Detail & Aggregated) | FA: @UJP9T4FT4 BA: @U060FPE2W1G

Running Negative Revenue
Recon Negative Revenue

Flight AR Listing | FA: @U057HS8MH60 BA: @U02LJAFSZA5

Running AR Listing
Recon AR Listing (Need to create this)

Flight AP Listing | FA: @U057HS8MH60 BA: @U060FPE2W1G

Running AP Listing
Recon AP Listing (Need to create this)

Tax Nominative List | BA: @UDK199SM9

Journal Adjustment

Adjustment that impact to listing can use this File

Month End Closing Issue Summary

mec_flight_missing_previousinvoiceid_whensent_to_payment → datadog → https://app.datadoghq.com/incidents/2750
unbalanced_sales_clearing_account → datadog → https://app.datadoghq.com/incidents/2781
difference_on_some_coas_report_fsr_20_and_27 → datadog → https://app.datadoghq.com/incidents/2799
difference_on_some_coas_report_fsr_15_sep_24 → datadog → https://app.datadoghq.com/incidents/2798
billing_amount_total_fare_issuance_fee_on_fl → datadog → https://app.datadoghq.com/incidents/2796
Issue BID not include in QS on 26 Sep 2024 but we have record the journal : 1183879071 and 1183883823
Issue Voyzant for FSR because wrong mapping → datadog → https://app.datadoghq.com/incidents/2808
Issue missing BID IP Trinusa → Incident 2807 Timeline | Datadog (datadoghq.com)
the datadog for onefly and pkfare because there is bug in adjustment after regenerate 1 month → app.datadoghq.com/incidents/2804 and

Outstanding Activity After MEC

Lesson Learn From Current MEC