Wednesday, September 30, 2020

How to unlock or delete user form in Infor Syteline or Infor CSI

 

How to unlock or delete user form  in Infor Syteline or Infor CSI .

If you are looking for query how to clear or delete user form because when you customer anything but some user did not update new form so you have to check by "select " as below after that "Delete" , Don't forget put the condition ScopeName .


select lockedby,* from forms where name like '%jobreceipt%'

delete forms where ScopeName = 'Montree'

and Also, when you try to do modify from but system found the message Lock by some user so you have check and update "NULL" Value as LockedBy 

select lockedby,* from forms where name like '%jobreceipt%'

update  forms set lockedby =  NULL  where name = 'Final_JobReceipt'


Hope you done .

Wednesday, April 15, 2020

Infor CSI Installation and Database Server Change name after install


If you are facing the same with me . I have duplicate CSI VM to changing VM name for CRP but after change server name we found we can't create customer order online . we have checked because of server name of SQL still the same of live so you have to use my script as below  after that you have to restart SQL Service and try to create customer order line again.

select @@servername

exec sp_dropserver 'Current SERVERName'


exec sp_addserver 'To be SERVERName','local'

select @@servername


Thursday, July 25, 2019

ถ้าคุณกำลังมองหา Software และ ทีมงานทีปรึกษา ด้าน ERP และ Supply Chain ?


Infor Cloud Suite  Industrial (SyteLine)

             ถ้าคุณกำลังมองหา Software ด้าน ERP  และ ทีมงานที่มีประสบการณ์ที่ทำให้ลูกค้า พัฒนาต่อยอดธุระกิจ ได้อย่างต่อเนื่องตลอดระยะเวลา 15 ปี คือเรา KM X TEN Co.,Ltd.   Tel: 097-0574836 , Aree.k@kmmt.co.th






Saturday, June 15, 2019

Infor CSI : Preassign Lot

Infor CSI : Preassign Lot
Preassign Lot Functional  : if you are facing the issue how to record rawmaterial by roll and you want to know this material roll issued to which your production order so that i want to share you one of functional on Infor CSI(SyteLine) that is Preassign Lot for Job Order , Purchase Order .




Preassign Lot  on Job Order:

Preassign Lot on Purchase Order



Issue Material to Job Order : system will recorde Material Lot and Job Lot  that will help you to tracking.


This is one of solution . we can workaround on this function as per your requriement .
Please contract us if you want to get any support : www.kmmt.co.th