Feature #3540
Report Payroll Invoice Detail
Added by Mr Ikmal 3 months ago. Updated 22 days ago.
Description
Dear mas azid,
Mohon bantuannya, untuk membuat Report Invoice Detail di menu Payroll Accounting. Detail nya pada excel ini ya mas.
https://hris-ekno.minovais.com/Account/Login
port db: 103.153.60.89
database: MinovaES_Ekno
Terima kasih
Files
Payroll Summary.xlsx (95.5 KB) Payroll Summary.xlsx | Mr Ikmal, 03/25/2025 08:35 AM | ||
Payroll Summary - Update.xlsx (95.1 KB) Payroll Summary - Update.xlsx | Mr Ikmal, 03/26/2025 01:44 PM | ||
Payroll Summary - Update (8 April 2025).xlsx (95.2 KB) Payroll Summary - Update (8 April 2025).xlsx | Mr Ikmal, 04/08/2025 02:19 PM | ||
clipboard-202504141343-hfg5z.png (55.6 KB) clipboard-202504141343-hfg5z.png | Mr Ikmal, 04/14/2025 01:43 PM | ||
Payroll Summary - Update (14 April).xlsx (98.1 KB) Payroll Summary - Update (14 April).xlsx | Mr Ikmal, 04/14/2025 02:07 PM | ||
CYARINVDETAIL (6) - Copy.xlsx (60.4 KB) CYARINVDETAIL (6) - Copy.xlsx | Mr Ikmal, 04/21/2025 03:28 PM | ||
Screenshot 2025-06-10 112155.png (78.7 KB) Screenshot 2025-06-10 112155.png | Mr Ikmal, 06/10/2025 11:22 AM |
Updated by Kezia Pawitra Yulianti 3 months ago
- Due date set to 03/27/2025
- Status changed from New to Assigned
- Priority changed from Normal to Urgent
Updated by M Azid Wahyudi 3 months ago
- Status changed from Assigned to Revise
- Assignee changed from M Azid Wahyudi to Mr Ikmal
dear ikmal , lengkapi table2 apa yang ada di report ini
makasih
Updated by Mr Ikmal 3 months ago
- File Payroll Summary - Update.xlsx Payroll Summary - Update.xlsx added
- Assignee changed from Mr Ikmal to M Azid Wahyudi
Dear mas azid,
Berikut untuk nama2 table nya
Terima kasih
Updated by Mr Ikmal 3 months ago
- File Payroll Summary - Update (8 April 2025).xlsx Payroll Summary - Update (8 April 2025).xlsx added
Dear mas Azid,
Berikut ada tambahan untuk di bagian Invoice Detail yaitu, Management Fee.
Detail nya ada di file Excel berikut ya mas.
Terima kasih.
Updated by M Azid Wahyudi 3 months ago
- Status changed from Revise to QA Test
- Assignee changed from M Azid Wahyudi to Mr Ikmal
dear ikmal , udah bisa di test ya
makasih
Updated by Mr Ikmal 3 months ago
- File clipboard-202504141343-hfg5z.png clipboard-202504141343-hfg5z.png added
- File Payroll Summary - Update (14 April).xlsx Payroll Summary - Update (14 April).xlsx added
- Assignee changed from Mr Ikmal to M Azid Wahyudi
- Priority changed from Urgent to High
Dear mas azid,
Berikut ada yang perlu disesuaikan untuk invoice detail, detail nya yg diberi warna kuning ya mas.
ada tambahan juga di parameter Payroll Invoice Detail yaitu, Created By dan Checked By (free text) yang nantinya digunakan untuk kolom TTD (detail nya juga pada file excel berikut ya mas)
terima kasih
Updated by M Azid Wahyudi 3 months ago
- Status changed from Revise to QA Test
- Assignee changed from M Azid Wahyudi to Mr Ikmal
dear ikmal , coba test
makasih
Updated by Mr Ikmal 2 months ago
- File CYARINVDETAIL (6) - Copy.xlsx CYARINVDETAIL (6) - Copy.xlsx added
- Assignee changed from Mr Ikmal to M Azid Wahyudi
dear mas azid,
Berikut untuk catatan yg perlu di fixing pada report payroll invoice detail berdasarkan feedback user di tgl 17 kemarin, detail nya yg sudah saya rekap pada kolom paling atas dan diberi warna kuning. Ada 2 sheet di dalamnya untuk sheet CYARINVDETAIL itu hasil generate di website saat ini dan sheet Contoh Fixing - ASABA merupakan sheet yg dipakai untuk kebutuhan development.
terima kasih.
Updated by Mr Ikmal about 2 months ago
Berikut yang telah dibuatkan Menu berdasarkan company nya untuk kebutuhan Invoice Detail,
MenuID (di table SMENU, SMENUTXT) dan ReportID (di table PCMEPRPTCATALOG, PCMEPRPTSELECTION)
CYARINVDETAILASABA = PT ASABA
CYARINVDETAILBMT = PT BMT-1
CYARINVDETAILCML = PT Cipta Mapan Logistik (CML)
CYARINVDETAILKMI = PT Kenco Manufactur Indonesia (KMI)
CYARINVDETAILSEC = PT SEC
CYARINVDETAILSJMJBK = PT SJM Jababeka
CYARINVDETAILSJMTGL = PT SJM Tegal
CYARINVDETAILATAKA = PT Ataka
CYARINVDETAILHERROS = PT Herros
CYARINVDETAILKMK = PT KMK
CYARINVDETAILBMTKPR = PT BMT - Koperasi
CYARINVDETAILSUP = PT Sarana Unggul Pratama (SUP)
CYARINVDETAILMETALINDO = PT Metalindo
Kemudian, berikut merupakan template Invoice Detail yang akan digunakan (jadinya akan dipisah per PT) untuk yg di notes pada kolom warna kuning adalah penjelasan nya, jika mau ditanyakan boleh ya mas.
Semua invoice detail yg terdapat pada sheet yg bernama Detail Invoice
https://drive.google.com/drive/folders/18-y65kfquNQF0gwfeTU9dimoU4uA9yb4?usp=sharing
terima kasih,
Updated by M Azid Wahyudi 22 days ago
- Status changed from QA Test to Revise
- Assignee changed from M Azid Wahyudi to Mr Ikmal
dear ikmal , redmine ini jadinya di pisah2 ya close aja yang ini
makasih