Support #1821: [TM to Payroll] - CPO PKS - PT BIA - Redmine

Support #1821

[TM to Payroll] - CPO PKS

Added by Fiona Avangeline Jonathan almost 2 years ago. Updated over 1 year ago.

Status:

User Test

Priority:

Immediate

Assignee:

fernando sergio rumbayan

Start date:

11/23/2022

Due date:

01/09/2023 (about 21 months late)

% Done:

0%

Estimated time:

Description

Dear Mba Yomma,

Mohon dibantu untuk dibuatkan TM to Payroll dengan kondisi
1. Membaca MD CUSPYDATACPO
2. Tabel tarif CTARIFCPO untuk masing-masing tipe CPO dengan field TipeCPO dan FieldName
Perhitungan akan menjumlahkan data di MD dan dikalikan dengan tarif sesuai mapping.

Contoh CPO PKS 1 untuk menghitung figure C_PKS1
CPORett x Tarif (CTARIFCPO) dengan mapping FieldName CPORett
berlaku untuk C_PKS2 dan C_PKS3
Untuk C_TotalPKS menggabungkan C_PKS1 + C_PKS2 + C_PKS3

Figure:

C_PKS1
C_PKS2
C_PKS3
C_TotalPKS

Terima kasih.

Port: http://remote.minovais.com:31137/

Files

03.21 Log Tangker_CPO PKS 1.xlsx (53.1 KB) 03.21 Log Tangker_CPO PKS 1.xlsx		Fiona Avangeline Jonathan, 11/24/2022 03:40 PM
CBIATMTOPYCPOTARIF.sql (1014 Bytes) CBIATMTOPYCPOTARIF.sql		Tri Rizqiaty, 11/30/2022 05:09 PM
MinovaIS.MinovaES.Implementation.BIA.Business.TMToPYVar1.dll (10.5 KB) MinovaIS.MinovaES.Implementation.BIA.Business.TMToPYVar1.dll		Tri Rizqiaty, 11/30/2022 05:09 PM
CBIATMTOPYCPOTARIF_20230106.sql (2.06 KB) CBIATMTOPYCPOTARIF_20230106.sql		Tri Rizqiaty, 01/06/2023 09:53 AM

Related issues

#1

Updated by Fiona Avangeline Jonathan almost 2 years ago

Copied from Support #1819: [TM to Payroll] - Pinalti/Denda added

#2

Updated by Fiona Avangeline Jonathan almost 2 years ago

Description updated (diff)
Status changed from New to Assigned

#3

Updated by Fiona Avangeline Jonathan almost 2 years ago

Description updated (diff)

#4

Updated by Fiona Avangeline Jonathan almost 2 years ago

File 03.21 Log Tangker_CPO PKS 1.xlsx 03.21 Log Tangker_CPO PKS 1.xlsx added

#5

Updated by Fiona Avangeline Jonathan almost 2 years ago

Description updated (diff)

#6

Updated by Tri Rizqiaty almost 2 years ago

File CBIATMTOPYCPOTARIF.sql CBIATMTOPYCPOTARIF.sql added
File MinovaIS.MinovaES.Implementation.BIA.Business.TMToPYVar1.dll MinovaIS.MinovaES.Implementation.BIA.Business.TMToPYVar1.dll added
Status changed from Assigned to Developing

Fixing :

1. Update API1\bin & API2\bin : MinovaIS.MinovaES.Implementation.BIA.Business.TMToPYVar1.dll
2. Execute SP : CBIATMTOPYCPOTARIF.sql

#7

Updated by Tri Rizqiaty almost 2 years ago

Status changed from Developing to QA Test
Assignee changed from Tri Rizqiaty to fernando sergio rumbayan

#8

Updated by fernando sergio rumbayan over 1 year ago

Status changed from QA Test to Revise
Assignee changed from fernando sergio rumbayan to Tri Rizqiaty

Mbaa yomaa,

Mbaa yom tolongg..

1.Ada Perubahan di Tarif CPO Table CTARIFCPO
2. Untuk menghitungnya tidak dari CPO PKS Rett tetapi yg di pakai PKS1 Tersus, PKS2 Tersus , PKS3 Tersus

Trimaa kasih..

#9

Updated by Kezia Pawitra Yulianti over 1 year ago

Due date set to 01/09/2023
Priority changed from Urgent to Immediate

#10

Updated by Tri Rizqiaty over 1 year ago

File CBIATMTOPYCPOTARIF_20230106.sql CBIATMTOPYCPOTARIF_20230106.sql added
Status changed from Revise to User Test
Assignee changed from Tri Rizqiaty to fernando sergio rumbayan

Fixing :

Update store procedure : CBIATMTOPYCPOTARIF.sql (file terlampir)

#11

Updated by Fiona Avangeline Jonathan over 1 year ago

Status changed from User Test to Closed

#12

Updated by Fiona Avangeline Jonathan over 1 year ago

Status changed from Closed to User Test

Also available in: Atom PDF