Project

General

Profile

Bug #3299

Error Upload Jurnal

Added by haykal haykal 3 months ago. Updated 28 days ago.

Status:
QA Test
Priority:
High
Assignee:
haykal haykal
Start date:
12/16/2024
Due date:
12/19/2024 (about 3 months late)
% Done:

0%

Estimated time:

Description

Dear Mbak Yomma,

Ketika saya coba upload, muncul pesan error template is in not correct format (seperti di foto yang saya attach di bawah). Padahal di Excelnya kolom-kolomnya sudah saya samakan dengan yang ada di tabel PTRFINANCEHEAD. Untuk file Excelnya juga saya lampirkan.

Tolong bantu dicek ya.

Menu Path: Financial Accounting > General Process > Upload Jurnal
Port: https://easy-dev.minovais.com/
DB: MinovaES_Easy_Dev (103.153.60.89)

Terimakasih.

Files

Error Upload Jurnal.PNG (23.2 KB) Error Upload Jurnal.PNG haykal haykal, 12/16/2024 05:10 PM
TestingUploadJurnal1.xlsx (13.3 KB) TestingUploadJurnal1.xlsx haykal haykal, 12/16/2024 05:11 PM
MinovaIS.MinovaES.Business.Upload.dll (31.5 KB) MinovaIS.MinovaES.Business.Upload.dll Tri Rizqiaty, 02/12/2025 04:21 PM
TemplateUploadJournalfromEasyDev now.xlsx (12.3 KB) TemplateUploadJournalfromEasyDev now.xlsx haykal haykal, 02/13/2025 12:11 PM
clipboard-202502141029-qrodp.png (1.82 KB) clipboard-202502141029-qrodp.png Tri Rizqiaty, 02/14/2025 10:29 AM
UploadJurnal (1).xlsx (11.2 KB) UploadJurnal (1).xlsx UploadJurnal Tulisan haykal haykal, 02/19/2025 06:41 PM
Finance Item masih kosong.png (13.1 KB) Finance Item masih kosong.png haykal haykal, 02/20/2025 03:27 PM
UploadJurnalTulisan Test.xlsx (13.1 KB) UploadJurnalTulisan Test.xlsx File Upload haykal haykal, 02/20/2025 03:27 PM
UploadJurnal260225.xlsx (14.1 KB) UploadJurnal260225.xlsx haykal haykal, 02/26/2025 06:36 PM
#1

Updated by Kezia Pawitra Yulianti 3 months ago

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

Updated by Tri Rizqiaty about 1 month ago

  • Status changed from Assigned to Developing

Fixing : update permisiion IIS di folder UI

#3

Updated by Tri Rizqiaty about 1 month ago

  • Status changed from Developing to QA Test
  • Assignee changed from Tri Rizqiaty to haykal haykal
#4

Updated by haykal haykal about 1 month ago

  • Status changed from QA Test to Revise
  • Assignee changed from haykal haykal to Tri Rizqiaty

Untuk Simulate sudah bisa, tapi kalau untk Execute blm smooth. Ada case error, terinput berulang, dan bagian Itemnya tidak muncul / tidak sesuai.

#5

Updated by Tri Rizqiaty about 1 month ago

Fixing :

Update folder API2/bin : MinovaIS.MinovaES.Business.Upload.dll

#6

Updated by haykal haykal about 1 month ago

Untk Simulate dan Executenya sudah success Mbak.

Tapi kata Bapak kl nemu case yg ketika Download Template format Excelnya tidak sesuai dengan tabel fisiknya boleh diraise issuenya ke Developer. Jadi ketika aku Download Template di menu Upload Jurnal format Excelnya tidak sesuai dan menyebabkan error Template is in not correct format ketika diupload. (Aku lampirkan template Excelnya juga)

(Jadi kalau yg success kmrn itu karena aku ngubah-ngubah sendiri urutan kolomnya secara manual)

#7

Updated by Tri Rizqiaty about 1 month ago

Fixing :

Update template default di UI\extended : UploadJurnal.xlsx

Notes :
1. Buat template yg benar sesuai client, krn bs saja berbeda di setiap client (nama file harus UploadJurnal.xlsx)
2. Lalu kirimkan template yg benar ke Developer/CS untuk diupdate di server

#8

Updated by haykal haykal about 1 month ago

Dear Mbak Yomma, ini ya utk template Upload Jurnal Tulisan

Minta tolong di-deploy ke Tulisan-Dev dulu ya Mbak...

port: https://tulisan-dev.minovais.com/
db: MinovaES_Tulisan_Dev (89)

Terimakasih.

#9

Updated by Tri Rizqiaty about 1 month ago

  • Status changed from Deploy to QA Test
  • Assignee changed from Tri Rizqiaty to haykal haykal

Done, di Tulisan Dev

#10

Updated by haykal haykal about 1 month ago

Dear Mbak Yomma,

Upload sudah sukses, masuk ke menu GL; tapi di bagian Finance Item nya masih kosong seperti di foto yang aku attach.

#11

Updated by Tri Rizqiaty about 1 month ago

  • Status changed from Revise to QA Test
  • Assignee changed from Tri Rizqiaty to haykal haykal

Fixing :

Update folder API2/bin : MinovaIS.MinovaES.Business.Upload.dll (file dr folder EasyDev)

#12

Updated by haykal haykal about 1 month ago

  • Status changed from QA Test to Deploy
  • Assignee changed from haykal haykal to Tri Rizqiaty

Dear Mbak Yomma, di Tulisan-Dev aku test sudah ok.

Minta tolong di-deploy ke Tulisan Prod ya...

Port: https://tulisan.minovais.com/
DB: MinovaES_Tulisan_Prod (103.153.60.89)

Untk templatenya sama persis dengan yang di Tulisan-Dev. Dan yg di Tulisan Prod juga blm pernah ditest sebelumnya.

Terimakasih.

#13

Updated by haykal haykal 28 days ago

Dear Mbak Yomma,

Engine Simulate yg di Tulisan Prod tlg dibenerin ya. Soalnya user Simulate success-success saja padahal harusnya tidak karena banyak errornya (pengisiannya masih salah). Dan itu baru ketahuan pada saat Execute

Tolong disolve ya Mbak, ini aku lampirin juga file Excelnya yg usernya upload.

Terimakasih.

#14

Updated by Tri Rizqiaty 28 days ago

  • Status changed from Revise to QA Test
  • Assignee changed from Tri Rizqiaty to haykal haykal

Template Upload Jurnal:

1. Jangan dibuat general harus text, jika decimal/number tlg dikasih petik
2. Jangan ada field kosong, kalau string/varchar diisi NULL, kalau decimal/number diisi 0
3. DocNo selalu dimulai dari 0, jangan ngacak, karena akan berpengaruh diproses looping

Jadi tolong dibenerin dulu templatenya.

Also available in: Atom PDF