Project

General

Profile

Feature #3946

Autofill SKU ketika Create Material Master Data

Added by haykal haykal 23 days ago. Updated 19 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
10/09/2025
Due date:
% Done:

0%

Estimated time:

Description

Dear Mbak Yomma,

Ingin didevelop fitur autofill mirip seperti yang Mbak Yomma pernah buat di redmine #3722. Bedanya kalau dulu adalah autofill Product Name, sekarang adalah autofill SKU.

Jadi untuk field SKU di Material Master Data (field ExternalID di tabel PMDMAT0001) ingin otomatis terisi apabila user mengisikan field Category, SubCategory, Model, Artwork, Edition, Color, Size

Dengan format sebagai berikut: "KodeInisialCategoryKodeInisialSubCategory-Model-Artwork-Edition-Color-Size"

Contoh
Category: Add-ons
SubCategory: Scarf
Model: AMA
Artwork: 22003
Edition: OX
Color: NI
Size: LL

Maka hasil SKU yang terbentuk adalah: AV-AMA-22003-OX-NI-LL

Tolong dibuat seperti itu ya.

Notes: Untk Kode Inisial Category dan SubCategory bisa refer ke tabel CPCMFILOSUBCATEGORY

Menu Path: Logistic & Service > Master Data > Material Master Data
Port: https://tulisan-dev.minovais.com/
DB: MinovaES_Tulisan_Dev (103.153.60.89)

Terimakasih.


Files

Parameter SKU.xlsx (12.2 KB) Parameter SKU.xlsx Tri Rizqiaty, 10/10/2025 03:49 PM
Size belum terbaca.png (20.5 KB) Size belum terbaca.png haykal haykal, 10/10/2025 04:30 PM
Size.js (1.28 KB) Size.js Tri Rizqiaty, 10/13/2025 10:47 AM
#1

Updated by Tri Rizqiaty 22 days ago

Fixing :

Update table SDATATABLEFIELD - SelectFunction sesuai excel terlampir

#2

Updated by Tri Rizqiaty 22 days ago

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

Updated by haykal haykal 22 days ago

Mbak Yomma, kyknya yang Sizenya blm kebaca deh. (Blm keauto)

Contoh seperti di foto yang aku attach ini field Size nya sudah aku isi namun tidak kedetect di field SKU.

Tolong diperbaiki ya.

(Contoh bisa dilihat MaterialID 00000122, disitu field Size terisi; namun tidak tertampil di SKU nya)

Terimakasih.

#4

Updated by Tri Rizqiaty 19 days ago

  • File Size.js Size.js added
  • Status changed from Revise to QA Test
  • Assignee changed from Tri Rizqiaty to haykal haykal

Fixing :

Update table SDATATABLEFIELD - Field Size - SelectFunction sesuai file terlampir

#5

Updated by haykal haykal 19 days ago

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

Udh Ok Mbak.

Minta tolong di-deploy ke Prod ya...

Menu Path: Logistic & Service > Master Data > Material Master Data
Port: https://tulisan.minovais.com/
DB: MinovaES_Tulisan_Prod (103.153.60.89)

Terimakasih.

#6

Updated by Tri Rizqiaty 19 days ago

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

Updated by haykal haykal 19 days ago

  • Status changed from QA Test to Closed

Also available in: Atom PDF