Overall
Duration From: To:
Number Of Handover
(by ARC status)
Number Of Invoice Acceptance
(by ARC status)
Number Of AR
(by ARC status)
AR Amount
(by ARC Status)
AR Aging - Current & Overdue
(by Invoice Due Date)
Number of Charges & FOC
(by Charge & FOC Status)
Number Of Bank Receipt
(by ARC Status)
Handover
Duration From: To:
Handover (by ARC Branch and Status)
Handover (by Pool and Status)
Handover Doc Checklist Completed
Handover Doc Checklist Completed
By ARC Branch
Jakarta
Open
55
Completed
30
Yogyakarta
Open
30
Completed
15
Surabaya
Open
42
Completed
40
Bandung
Open
23
Completed
30
Medan
Open
41
Completed
32
Semarang
Open
35
Completed
30
Palembang
Open
30
Completed
21
Handover by Open Prority & Task Completed
Handover Priority
By ARC Branch
Jakarta
Open
65
Completed
20
Yogyakarta
Open
30
Completed
15
Surabaya
Open
22
Completed
60
Bandung
Open
43
Completed
20
Medan
Open
41
Completed
32
Semarang
Open
35
Completed
30
Palembang
Open
30
Completed
21
Invoice Acceptance
Duration From: To:
Invoice Acceptance (by ARC Branch)
Invoice Acceptance (by Pool)
Filter By ARC Branch:
Invoice Acceptance (by Assigned Collector)
Invoice Acceptance (by Assigned Branch PIC)
Invoice Acceptance by Open Prority & Task Completed
Filter By ARC Branch:
Invoice Acceptance Priority
By ARC Branch
Jakarta
Open
65
Completed
20
Yogyakarta
Open
30
Completed
15
Surabaya
Open
22
Completed
60
Bandung
Open
43
Completed
20
Medan
Open
41
Completed
32
Semarang
Open
35
Completed
30
Palembang
Open
30
Completed
21
Invoice Acceptance Activity
Filter By ARC Branch:
Filter By Assigned Branch PIC:
AR
Duration From: To:
AR (by ARC Branch)
AR (by Pool)
AR (by Assigned Branch PIC)
Filter By ARC Branch:
AR by Open Prority & Task Completed
Filter By ARC Branch:
AR Priority By ARC Branch
Jakarta
Open
65
Completed
20
Yogyakarta
Open
30
Completed
15
Surabaya
Open
22
Completed
60
Bandung
Open
43
Completed
20
Medan
Open
41
Completed
32
Semarang
Open
35
Completed
30
Palembang
Open
30
Completed
21
Open AR by Charges
AR by LHT Status
AR ARC Status by Amount
Aging in AR by Invoice Acceptance Due Date
Aging in AR by Invoice Acceptance Due Date (with percentage)
Settlement By Berseda
Filter By ARC Branch:
LHT Reference:
Settlement By Finance
Filter By ARC Branch:
LHT Reference:
AR Activity
Filter By ARC Branch:
Filter By Assigned Branch PIC:
AR Forecast Collection
Duration From: To:
Bank Receipt
Duration From: To:
Recogized & unrecognized Bank Receipt by Berseda Status
Recogized & unrecognized Bank Receipt by Finance Status
Charges & FOC
Duration From: To:
Charges by ARC Branch & Status Charges & FOC
Charges by Pool & Status Charges & FOC
Charges by Assigned Branch PIC & Status Charges & FOC
Filter By ARC Branch:
FOC by ARC Branch & Status Charges & FOC
FOC by Pool & Status Charges & FOC
Open Charges by Amount & ARC Branch
Filter By ARC Branch:
Open FOC by Amount & ARC Branch
Filter By ARC Branch:
Change Request
Duration From: To:
Filter By User Role:
All Pending Request

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
All Approved Request

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
All Rejected Request

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
Request Pending Approval by me

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
Request Approved by me

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
Request Rejected by me

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
My Pending Request

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
My Approved Request

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
My Rejected Request

40

Handover
10
Invoice Acceptance
20
AR
5
Bank Receipt
5
On Hold
Filter By ARC Branch:
All On Hold
Handover
On Hold
1
Invoice Acceptance
On Hold
3
AR
On Hold
2
Bank Receipt
On Hold
4
Priority List
Duration From: To:
All Priority
Handover
Open
1
Completed
1
Invoice Acceptance
Open
1
Completed
0
AR
Open
2
Completed
0
Bank Receipt
Open
3
Completed
0
My Priority
Handover
Open
1
Completed
1
Invoice Acceptance
Open
1
Completed
0
AR
Open
0
Completed
0
Bank Receipt
Open
0
Completed
0
 
Invoice Number
Invoice Date
Invoice Account
Invoice Name
Sales/Service Order
AR ID
ARC Status
Doc Handover Date
Handed over Doc
Checklist Complete
Doc Handover Remark
Days Lapsed From Doc Handover Date
Doc Handover Date Created Datetime
Invoice Local Name
Invoice Amount (incl. tax)
Invoice Acceptance Date
Invoice Acceptance Due Date
Aging from invoice Acceptance Due Date
Invoice Acceptance Remark
Invoice Acceptance Date Created Datetime
Invoice Acceptance Date Modified Datetime
Invoice Acceptance Date Modified By
Invoice Due Date
Payment Schedule
Payment Term
Payment Term Description
Aging From Invoice Due Date
Customer Account
Customer Name
Cust. Info Account
Cust. Info Name
Cust. Reference
Delivery Name/End User Name
Sales Tax Group
Sales Responsible Name
Original invoice number
Settlement Voucher
Customer PO
Country Tax Invoice Number
Pool
ARC Branch
Assigned Branch PIC
Assigned Branch Collector
Related Branch PIC
Related Branch Collector
Last Activity Remark
Last Modified By
Invoice Created By
Invoice Created Date
Priority Mark
Priority Instruction
Priority Task Completed
Priority Created Date
Priority Assign Person
Change Status
Manual Change Status Log
D365 Failed Message
D365 Sync Status
PIC Handover
Invoice Type
  AR-UG90007395-1-ID UG90007395 Open BHB03 PT. BALIKPAPAN DAMAI HUSADA PT. BALIKPAPAN DAMAI HUSADA 1,000,000.00 26/8/2023 27/9/2023 -7 days 25/8/2023 26/9/2023 7 days Activity Remarks 1 -25/8/2023
Activity Remarks 2 -26/8/2023
Activity Remarks 3 -28/8/2023
28/8/2023 28/8/2023 James AR Activity Remarks 1 -25/8/2023
AR Activity Remarks 2 -26/8/2023
AR Activity Remarks 3 -28/8/2023
AR Activity Remarks 3 -28/8/2023 - - 500,000.00 0.00 0.00 500,000.00 Open 0.00 500,000.00 Open 0.00 500,000.00 Open
- - - - - 1,000.00 600.00 600.00 400.00 012/JKT/23-Charges
014/JKT/23-Charges
20/7/2023 030 30 days 30%DP,70%4M - - Payment Journal No - BHB03 PT. BALIKPAPAN DAMAI HUSADA BHB03 PT. BALIKPAPAN DAMAI HUSADA Some Cust. Reference... QT006915-3 SO90010325 - Lee - - 13445/MT/Q 010.008.23.85669059 Jakarta James Riyanti 17/7/2023  
Meet Jasmine
Meet Hendra
12/8/2023 Riyanti - - - - Open 1/7/2023 1/8/2023 Riyanti
  AR-UG90007395-2-ID UG90007395 Open BHB03 PT. BALIKPAPAN DAMAI HUSADA PT. BALIKPAPAN DAMAI HUSADA 1,000,000.00 26/8/2023 27/9/2023 -7 days 27/9/2023 28/10/2023 7 days Activity Remarks 1 -25/8/2023
Activity Remarks 2 -26/8/2023
Activity Remarks 3 -28/8/2023
28/8/2023 28/8/2023 James AR Activity Remarks 1 -25/8/2023
AR Activity Remarks 2 -26/8/2023
AR Activity Remarks 3 -28/8/2023
AR Activity Remarks 3 -28/8/2023 - - 500,000.00 0.00 0.00 500,000.00 Open 0.00 500,000.00 Open 0.00 500,000.00 Open
- - - - - 1,000.00 600.00 600.00 400.00 - 20/7/2023 030 30 days 30%DP,70%4M - - - No - BHB03 PT. BALIKPAPAN DAMAI HUSADA BHB03 PT. BALIKPAPAN DAMAI HUSADA Some Cust. Reference... QT006915-3 SO90010325 - Lee - - 13445/MT/Q 010.008.23.85669059 Jakarta James Riyanti 17/7/2023   - - - - - - - Open 1/7/2023 1/8/2023 Riyanti
 
Invoice Number
AR ID
ARC Status
Invoice Acceptance Date
Invoice Date
Sales/Service Order
Invoice Amount (incl. tax)
Invoice Name
Invoice Local Name
Customer PO
Country Tax Invoice Number
Invoice Acceptance Remark
Pool
ARC Branch
Assigned Branch PIC
Assigned Branch Collector
Related Branch PIC
Related Branch Collector
Invoice Account
AR Amount
Invoice Due Date
Payment Schedule
Payment Term
Payment Term Description
Aging From Invoice Due Date
Doc Handover Date
Doc Handover Date Created Datetime
Handed over Doc
Days Lapsed From Doc Handover Date
Customer Account
Customer Name
Cust. Info Account
Cust. Info Name
Cust. Reference
Delivery Name/End User Name
Sales Tax Group
Sales Responsible Name
Original invoice number
Settlement Voucher
Last Activity Remark
Last Modified By
Invoice Created By
Invoice Created Date
Priority Mark
Priority Instruction
Priority Task Completed
Priority Created Date
Priority Assign Person
Change Status
Manual Change Status Log
D365 Failed Message
D365 Sync Status
AR Match Status
Invoice Acceptance Due Date
Aging from invoice Acceptance Due Date
Invoice Acceptance Date Created Datetime
Invoice Acceptance Date Modified Datetime
Invoice Acceptance Date Modified By
  UG90007394 AR-UG90007394-1-ID In Progress 17/7/2023 SO90010325 1,000,000.00 PT. BALIKPAPAN DAMAI HUSADA PT. BALIKPAPAN DAMAI HUSADA 13445/MT/Q 010.008.23.85669059 Activity Remarks 1 -25/7/2023
Activity Remarks 2 -26/7/2023
Activity Remarks 3 -28/7/2023
Jakarta John
Johnny
Jerry
Jamie
Jason
Jeff
Julian
BHB03 500,000.00 16/8/2023 30%DP,70%4M 030 30 days 7 days 18/7/2023 18/7/2023 Checklist 1 days BHB03 PT. BALIKPAPAN DAMAI HUSADA BHB03 PT. BALIKPAPAN DAMAI HUSADA Cust. Reference QT006915-3 - Lee - - Activity Remarks 3 -28/7/2023 Jimmy Riyanti 17/7/2023  
Meet Jasmine
Meet Hendra
12/8/2023 Riyanti - - - - Open - - - - -
 
AR ID
Invoice Number
ARC Status
Invoice Account
Invoice Name
Invoice Local Name
Invoice Amount (incl. tax)
Invoice Date
Invoice Due Date
Aging From Invoice Due Date
Invoice Acceptance Date
Invoice Acceptance Due Date
Aging from invoice Acceptance Due Date
Invoice Acceptance Remark
Invoice Acceptance Date Created Datetime
Invoice Acceptance Date Modified Datetime
Invoice Acceptance Date Modified By
AR Activity Remark
Latest AR Activity
Customer Feedback Remark
Notes
AR Balance
Balance Calculation
Settled Amount (Berseda)
Balance (Berseda)
Berseda Status
Settled Amount (SOM)
Balance (SOM)
SOM Status
Settled Amount (Finance)
Balance (Finance)
Finance Status
Charges & FOC
Estimate C & FOC Remarks
VAT
Witholding Tax 22
Witholding Tax 23
Bank Charges
Denda
Rounding
Zakat
Tax Proof Submission
SSP Tax Realization
SSP Reference
Customer Payment Date
Customer Payment Amount
Date Confirmed By Berseda
Date of LHT
Date of Settlement
Total Estimated Charges
Total Submitted Charges
Total Settled Charges & FOC
Balance Charges
All LHT Number
Doc Handover Date
Payment Term
Payment Term Description
Payment Schedule
Payment Matching Remark
Payment Journal Voucher
Payment Posted Status
Payment Posted Date
Customer Account
Customer Name
Cust. Info Account
Cust. Info Name
Cust. Reference
Delivery Name/End User Name
Sales/Service Order
Sales Tax Group
Sales Responsible Name
Original Invoice Number
Settlement Voucher
Customer PO
Country Tax Invoice Number
Pool
ARC Branch
Assigned Branch PIC
Assigned Branch Collector
AR Created By
AR Created Datetime
Priority Mark
Priority Instruction
Priority Task Completed
Priority Created Date
Priority Assign Person
Change Status
Manual Change Status Log
D365 Failed Message
D365 Sync Status
AR Match Status
  AR-UG90007395-1-ID UG90007395 Open BHB03 PT. BALIKPAPAN DAMAI HUSADA PT. BALIKPAPAN DAMAI HUSADA 1,000,000.00 26/8/2023 27/9/2023 -7 days 25/8/2023 26/9/2023 7 days Activity Remarks 1 -25/8/2023
Activity Remarks 2 -26/8/2023
Activity Remarks 3 -28/8/2023
28/8/2023 28/8/2023 James AR Activity Remarks 1 -25/8/2023
AR Activity Remarks 2 -26/8/2023
AR Activity Remarks 3 -28/8/2023
AR Activity Remarks 3 -28/8/2023 - - 500,000.00 0.00 0.00 500,000.00 Open 0.00 500,000.00 Open 0.00 500,000.00 Open
- - - - - 1,000.00 600.00 600.00 400.00 012/JKT/23-Charges
014/JKT/23-Charges
20/7/2023 030 30 days 30%DP,70%4M - Payment Journal No - BHB03 PT. BALIKPAPAN DAMAI HUSADA BHB03 PT. BALIKPAPAN DAMAI HUSADA Some Cust. Reference... QT006915-3 SO90010325 - Lee - - 13445/MT/Q 010.008.23.85669059 Jakarta James Riyanti 17/7/2023  
Meet Jasmine
Meet Hendra
12/8/2023 Riyanti - - - - Open
  AR-UG90007402-1-ID UG90007402 Closed BHB03 PT. BALIKPAPAN DAMAI HUSADA PT. BALIKPAPAN DAMAI HUSADA 10,000.00 26/8/2023 27/9/2023 -7 days 27/9/2023 28/5/2023 7 days Activity Remarks 1 -25/5/2023
Activity Remarks 2 -26/5/2023
Activity Remarks 3 -28/5/2023
28/8/2023 28/8/2023 James AR Activity Remarks 1 -23/5/2023
AR Activity Remarks 2 -1/6/2023
AR Activity Remarks 2 -1/6/2023 - - 0.00 5,000.00 5,000.00 0.00 Matched 5,000.00 0.00 Matched 5,000.00 0.00 Completed
23/5/2023
1/6/2023
2,000
3,000
23/5/2023
1/6/2023
25/5/2023
3/6/2023
28/5/2023
5/6/2023
- - - - 012/JKT/23-Trade
014/JKT/23-Trade
20/5/2023 030 30 days 30%DP,70%4M - Payment Journal Yes 28/5/2023
5/6/2023
BHB03 PT. BALIKPAPAN DAMAI HUSADA BHB03 PT. BALIKPAPAN DAMAI HUSADA Some Cust. Reference... QT006915-3 SO90010325 - Lee - - 13445/MT/Q 010.008.23.85669059 Jakarta James Riyanti 17/7/2023  
Meet Jasmine
Meet Hendra
12/8/2023 Riyanti - - - - Matched
 
Bank Receipt ID
Bank Internal References
ARC Status
IdsMed Bank Account
IdsMed Bank Account Name
Bank Account Number
Bank Receipt Date
Bank Reference
Bank Receipt Amount
Total Settled
Total Balance
Balance Calculation
Settled Amount (Berseda)
Balance (Berseda)
Berseda Status
Settled Amount (SOM)
Balance (SOM)
SOM Status
Settled Amount (Finance)
Balance (Finance)
Finance Status
Recognized Times
Settlement Date
Unapplied Finance
Unapplied Finance Amount
Journal Batch Number
Unapplied Voucher
Unapplied Journal Trans Date
Unapplied Journal Create Date
Unapplied Journal Posted
Unapplied Journal Post Date
D365 Bank Receipt Status
ARC Branch
Assigned Branch PIC
Recognition PIC
Change Status
Manual Change Status Log
Priority Mark
Priority Task Completed
Priority Assign Person
Priority Created Date
D365 Sync Status
D365 Failed Message
All LHT Number
Remark From SOM
Payment Matching Remark
  BR001 202108CSI0000003001 Open MDR-JKT BANK MANDIRI (IDR) - KCP JAKARTA S.Parman 1170006224927 19/8/2021 PT RAGAMSEHAT MULTIFITA - 031 5,000.00 0.00 5,000.00 5,000.00 0.00 5,000.00 Open 0.00 5,000.00 Open 0.00 5,000.00 Open 0 -   0.00 - - - -   - Open - Rejected by Berseda HQ Can't be change to On Hold     Riyanti 19/8/2023 - - - -
  BR002 202108CSI0000003011 On Hold MDR-JKT BANK MANDIRI (IDR) - KCP JAKARTA S.Parman 1170006224927 19/8/2021 PT RAGAMSEHAT MULTIFITA - 031 5,000.00 0.00 5,000.00 5,000.00 0.00 5,000.00 Open 0.00 5,000.00 Open 0.00 5,000.00 Open 0 -   0.00 - - - -   - Open - Approved by Berseda HQ -     Riyanti 19/8/2023 - - - -
  BR003 202108CSI0000003002 Open MDR-JKT BANK MANDIRI (IDR) - KCP JAKARTA S.Parman 1170006224927 19/8/2021 PT RAGAMSEHAT MULTIFITA - 031 4,000.00 0.00 4,000.00 4,000.00 0.00 4,000.00 Open 0.00 4,000.00 Open 0.00 4,000.00 Open 0 -   0.00   Open - Approved by Berseda HQ -     Riyanti 19/8/2023 - - - -
D365 Sync Status
Filter By ARC Branch:
Invoice Acceptance Date

6

Bank Receipt Unapplied Status

12

ARC LHT D365 Sync Status

9

Charges LHT D365 Sync Status

9

FOC LHT D365 Sync Status

9

Payment Recognition Unmatch Request

9

Charges & FOC Unmatch Request

9

Follow up Un-match
Duration From: To:
Filter By ARC Branch:
LHT Status: Cancel Request (by Berseda)

6

Trade
1
Non Trade
2
Charges
2
LHT Status: Cancelled (by Berseda)

6

Trade
1
Non Trade
2
Charges
2
LHT Status: Cancel Request (by SOM)

6

Trade
1
Non Trade
1
Charges
2
FOC
3
LHT Status: Cancelled (by Finance)

6

Trade
1
Non Trade
1
Charges
2
FOC
3
James
[email protected]