Project

General

Profile

Feature #2785

Fitur Upload & Download COA, Wage Type Definition, dan Initial Balance

Added by haykal haykal 8 months ago. Updated 4 days ago.

Status:
QA Test
Priority:
Normal
Assignee:
haykal haykal
Start date:
06/06/2024
Due date:
06/12/2024 (about 7 months late)
% Done:

0%

Estimated time:
Spent time:
15.50 h

Description

Dear Azid,

Untuk tabel parameter-parameter yang ada di Customization ingin dibuatkan fitur upload. Yang ingin dibuatkan fitur upload nama menu Customization, tabelnya, beserta MenuID untuk uploadnya adalah sebagai berikut:

-Wage Type Definition (Tabel PHRPYCU0300) [MenuID: PY06]
-Mapping Coa To Gl Account (Tabel PCMFILOCOAGL) [MenuID: UPLOADCOA]
-Account Balance (Saldo) (Tabel PTRFICOMPACCBALANCE) [MenuID: UPLOADINITBALANCE]

Port: http://easy.minovais.com:31146/
DB: MinovaES_Easy (di 66)

Terimakasih.

Files

Contoh Data WT Definition, COA, Initial Balance.xlsx (18.1 KB) Contoh Data WT Definition, COA, Initial Balance.xlsx haykal haykal, 06/18/2024 03:20 PM
Upload COA Error.png (19.2 KB) Upload COA Error.png Screenshot haykal haykal, 06/27/2024 02:00 PM
PCMFILOCOAGL Template.xlsx (14.5 KB) PCMFILOCOAGL Template.xlsx Template Upload COA yang sudah diisikan haykal haykal, 06/27/2024 02:01 PM
clipboard-202406271506-hqvdy.png (103 KB) clipboard-202406271506-hqvdy.png M Azid Wahyudi, 06/27/2024 03:06 PM
Upload COA Header perbaikan.png (12.4 KB) Upload COA Header perbaikan.png haykal haykal, 08/29/2024 04:07 PM
Upload Initial Balance Header perbaikan.png (13.5 KB) Upload Initial Balance Header perbaikan.png haykal haykal, 08/29/2024 04:07 PM
Upload WT Definition Header perbaikan.png (14.7 KB) Upload WT Definition Header perbaikan.png haykal haykal, 08/29/2024 04:07 PM
PTRFICOMPACCBALANCE test easy-dev.xlsx (8.96 KB) PTRFICOMPACCBALANCE test easy-dev.xlsx haykal haykal, 01/15/2025 04:51 PM
clipboard-202501171039-pfeze.png (22 KB) clipboard-202501171039-pfeze.png M Azid Wahyudi, 01/17/2025 10:39 AM
#1

Updated by Kezia Pawitra Yulianti 7 months ago

  • Due date set to 06/12/2024
  • Status changed from New to Assigned
  • Priority changed from Normal to Urgent
#2

Updated by jihad .... 7 months ago

  • Subject changed from Fitur Upload COA, Wage Type Definition, dan Initial Balance to Fitur Upload & Download COA, Wage Type Definition, dan Initial Balance

Mas Azid, ingin ditambahkan fitur menu download COA, download wage type definition dan download initial balance

-Wage Type Definition: PY06DOWNLOAD
-Mapping Coa To Gl Account: DOWNLOADCOA
-Account Balance (Saldo): DOWNLOADINITBALANCE

Terima kasih.

#4

Updated by M Azid Wahyudi 7 months ago

dear hykal , untuk Initial Balance kan itu hasil generate IDnya pasti ada tablenya lastID terakhir dimana coba untuk yang Initial Balance diskusi dulu untuk uploadnya

makasih

#5

Updated by M Azid Wahyudi 7 months ago

package :

UI :
Pages
C:\Webserver\Easy\UI\Pages
uploadCOA.html
uploadCOA.js
uploadInitialBalance.html
uploadInitialBalance.js
uploadWageType.html
uploadWageType.js

View :
C:\Webserver\Easy\UI\app\view\masterdata
ViewUploadCOA.js
ViewUploadInitialBalance.js
ViewUploadWageType.js

Controller :
C:\Webserver\Easy\UI\app\controller\masterdata
CtrlUploadCOA.js
CtrlUploadInitialBalance.js
CtrlUploadWageType.js

smenu :
PY06
UPLOADCOA
UPLOADINITBALANCE

SP :
DELUPLOAD
DELUPLOADBLC

DLL :
MinovaIS.MinovaES.Data.Element

#6

Updated by M Azid Wahyudi 7 months ago

  • Status changed from Assigned to QA Test
  • Assignee changed from M Azid Wahyudi to haykal haykal

dear haykal , udah bisa di test ya

update package :
SP:
DELUPLOADSELECTBLC

makasih

#7

Updated by haykal haykal 7 months ago

Upload COA masih error.

Screenshot error sama template Excel yang gua isikan sudah di-attach

#8

Updated by M Azid Wahyudi 7 months ago

dear haykal , udah bisa di test ya

makasih

#9

Updated by haykal haykal 5 months ago

Jid, ada perbaikan sedikit.

Untuk judul headernya tolong disesuain sama nama menunya ya... (fotonya gua attach di bawah yang dikotakmerahin)

Atau Personal Administration nya diganti jadi Financial Accounting juga gapapa

#10

Updated by Regina Tasya 5 months ago

  • Status changed from QA Test to Revise
#11

Updated by M Azid Wahyudi 5 months ago

  • Status changed from Revise to QA Test
  • Assignee changed from M Azid Wahyudi to haykal haykal

dear haykal , udah bisa di test ya

jangan lupa clear cache

makasih

#12

Updated by Regina Tasya 5 months ago

  • Status changed from QA Test to Closed
#13

Updated by haykal haykal about 1 month ago

  • Project changed from MinovaEasy to TULISAN
#14

Updated by haykal haykal 27 days ago

  • Status changed from Closed to Deploy
  • Assignee changed from haykal haykal to M Azid Wahyudi

Jid, yg Upload Initial Balance dan Upload COA minta tolong di-deploy ke TULISAN ya...

SMENU:
UPLOADCOA
UPLOADINITBALANCE

Menu Path: Financial Accounting > Upload
Port: https://tulisan.minovais.com/
DB: MinovaES_Tulisan_Prod (103.153.60.89)

Terimakasih.

#15

Updated by haykal haykal 27 days ago

  • Status changed from Deploy to Revise

Jid, ternyata perlu ada Simulate nya juga.

'Kan saat ini adanya Execute doang, ingin ditambahkan Simulate juga.

Untuk validasi Simulatenya yang validasi standar saja; seperti:
-Format template harus sesuai
-Tipe data harus sesuai (jadi misalkan untuk field yang numeric harus diisi dengan angka, tidak boleh huruf)
-Untuk kolom yang isinya adalah pilihan combobox, tolong divalidasi apabila yang diinput adalah diluar pilihan combobox maka tidak bisa.
-Length/panjang dari isian field

Terimakasih.

#16

Updated by M Azid Wahyudi 6 days ago

  • Status changed from Revise to QA Test
  • Assignee changed from M Azid Wahyudi to haykal haykal

dear haykal , udah bisa di test ya

note : untuk coaGL ini beda ya soalnya harus sama kaya mba yomma bikin jadi ada logic tambahan

package :
ui(view)
dll(data.element)

makasih

#17

Updated by haykal haykal 5 days ago

Jid ini file Excelnya Initial Balance

#18

Updated by M Azid Wahyudi 4 days ago

  • Status changed from Revise to QA Test
  • Assignee changed from M Azid Wahyudi to haykal haykal

dear haykal , udah bisa di test ya semuanya

package :
api1 & api 2(MinovaIS.MinovaES.Data.Element)
SP : PFILOGENGLACCOUNTCOMPUPLOAD

terima kasih

Also available in: Atom PDF