การบริหารคลังสินค้าแช่แข็ง COLD STORAGE WAREHOUSE

Infor WMS ช่วยให้การทำงานถูกต้องแม่นยำ สะดวกได้ สนใจติดต่อ KM X TEN

Infor WMS: Query Update UOM and Packey

update wmwhse1.Receiptdetail set PACKKEY = (select PACKKEY from wmwhse1.sku where sku.sku = Receiptdetail.SKU ) where RECEIPTKEY = '0000000011'

update wmwhse1.Receiptdetail set UOM = (select  PACKUOM3 from wmwhse1.sku inner join  wmwhse1.PACK on pack.PACKKEY = sku.PACKKEY where sku.sku = Receiptdetail.SKU ) where RECEIPTKEY = '0000000011'

UPdate default RF Receiving

update wmwhse1.SKU set RFDEFAULTUOM = (select  PACKUOM3  from  wmwhse1.PACK  where pack.PACKKEY = sku.PACKKEY )

by KMxTEN

KMX10: Free QR Code Generator by Google

 

just for developer to do report and print out QR Code

https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl="KMx10"&choe=UTF-8";

By KMx10

KM X TEN : Infor WMS Customize New Report

 I you are facing the problem when you try to editing or adding new parameter and also query  can't modify so you can manual add that below table.

FROM   wmwhse2.PBSRPT_REPORTS_PARAMS

FROM   wmwhse1.PBSRPT_REPORTS

By KM X TEN

Infor WMS Report Customize.

Infor WMS : mixed license plate putaway

Infor WMS supported 1 pallet more than one sku . 

Mixed license plate putaway

To confirm this setting: 1 Select Administration > System Settings 2 Scroll down to the key valueDisAllowDuplicateidsOnRFRcpt. 3 Verify that the value for Prevent receiving duplicate license plates on RF Receipt is OFF.

KMx10 EP3# ไม่รู้ได้ไง ใครคือ Infor ? | Infor SyteLine | Infor WMS

By KM X TEN

Infor WMS Rest API : Connect Enterprise Data

 Infor WMS Rest API : Connect Enterprise Data  : INFOR_ENTERPRISE

for example : GET : http://KMXTEN.Com:81/wmwebservice_rest/INFOR_ENTERPRISE/items/Z001

By KMXTEN Co.,LTD.